1.php连接数据库与基本操作配置
(1)php创建数据库【连接】
语法:Object mysqli_connect("域名","DB账号","DB密码","DB库名")
例子:$con = mysqli_connect('localhost','root','','frankdb');
(2)向DB中插入数据时包含中文出现乱码的解决方案
语法:mysqli_query($con,"set names utf8");
说明:设置成功会返回1,根据实际情况并不一定必须保存返回结果。
(3)设置client端和server端保持字符编码一致
语法:mysqli_query($con,"set character_set_client=utf8");
mysqli_query($con,"set character_set_results=utf8");
(4)执行sql语句
语法:$结果 = $DB连接->query(sql语句);
例子:var_dump($result = $con->query($sql));
2.使用sql语句基本【模板】
a.建立连接
b.判断是否连接
c.设置编码
d.创建sql语句
e执行结果条数
g.拼凑结果
h.json化返回
<?php
//a.sql 查询语句
无条件查询,即直接写1即可
//$sql='select * from 哪张表 where 条件';
有条件查询,在where后面写出查询条件,如果多个条件需要用and 或or 来连接。
//$sql="select stuName from stud where stuScore='100' and stuGender='female'";
//$sql="select stuName from stud where stuScore='100' or stuGender='female'";
$con=mysqli_connect('localhost','root','','studb')
if($con){
echo'<pre>';
echo'数据库连接成功,等待指令...';
mysqli_query($con,'set names utf8');
mysqli_query($con,'set character_set_client=utf8');
mysqli_query($con,'set character_set_results=utf8');
$sql="select * from stud where 1";
$result=$con->query($sql);
if($result>num_rows>0){
$info=[];
for($i=0;$row=$result->fet_assoc();$i++){
$info[$i]=$row;
}
echo json_encode($info);
}
}else{
echo'<pre>';
echo'数据连接失败,请重新连接‘;
}
b.插入语句(添加语句)
两种写法:(1)$sql="insert into 表名(字段1,字段2,...) values(值1,值2,...)";
(2)$sql='insert into 表名('值1’,'值2',...)";
$con=mysqli_connect('localhost','root','','studb');
if($icon){
echo'<pre>';
echo'数据库连接成功,等待指令...';
mysqli_query($con, 'set names utf8');
mysqli_query($con, 'set character_set_client=utf8');
mysqli_query($con, 'set character_set_result=utf8');
$sql="insert into stud stuName,stuGender,stuAge,stuNum,stuScore)values('lucy','female','14','123456789','90')";
$sql="insert into stud values('lucy','female','14','123456789','90')";
$result=$con->query($sql);
if($result){
echo'添加成功';
}else{
echo'添加失败';
}
(1)php创建数据库【连接】
语法:Object mysqli_connect("域名","DB账号","DB密码","DB库名")
例子:$con = mysqli_connect('localhost','root','','frankdb');
(2)向DB中插入数据时包含中文出现乱码的解决方案
语法:mysqli_query($con,"set names utf8");
说明:设置成功会返回1,根据实际情况并不一定必须保存返回结果。
(3)设置client端和server端保持字符编码一致
语法:mysqli_query($con,"set character_set_client=utf8");
mysqli_query($con,"set character_set_results=utf8");
(4)执行sql语句
语法:$结果 = $DB连接->query(sql语句);
例子:var_dump($result = $con->query($sql));
2.使用sql语句基本【模板】
a.建立连接
b.判断是否连接
c.设置编码
d.创建sql语句
e执行结果条数
g.拼凑结果
h.json化返回
<?php
//a.sql 查询语句
无条件查询,即直接写1即可
//$sql='select * from 哪张表 where 条件';
有条件查询,在where后面写出查询条件,如果多个条件需要用and 或or 来连接。
//$sql="select stuName from stud where stuScore='100' and stuGender='female'";
//$sql="select stuName from stud where stuScore='100' or stuGender='female'";
$con=mysqli_connect('localhost','root','','studb')
if($con){
echo'<pre>';
echo'数据库连接成功,等待指令...';
mysqli_query($con,'set names utf8');
mysqli_query($con,'set character_set_client=utf8');
mysqli_query($con,'set character_set_results=utf8');
$sql="select * from stud where 1";
$result=$con->query($sql);
if($result>num_rows>0){
$info=[];
for($i=0;$row=$result->fet_assoc();$i++){
$info[$i]=$row;
}
echo json_encode($info);
}
}else{
echo'<pre>';
echo'数据连接失败,请重新连接‘;
}
b.插入语句(添加语句)
两种写法:(1)$sql="insert into 表名(字段1,字段2,...) values(值1,值2,...)";
(2)$sql='insert into 表名('值1’,'值2',...)";
$con=mysqli_connect('localhost','root','','studb');
if($icon){
echo'<pre>';
echo'数据库连接成功,等待指令...';
mysqli_query($con, 'set names utf8');
mysqli_query($con, 'set character_set_client=utf8');
mysqli_query($con, 'set character_set_result=utf8');
$sql="insert into stud stuName,stuGender,stuAge,stuNum,stuScore)values('lucy','female','14','123456789','90')";
$sql="insert into stud values('lucy','female','14','123456789','90')";
$result=$con->query($sql);
if($result){
echo'添加成功';
}else{
echo'添加失败';
}