php 操作数据库,php操作数据库

//测试原生链接数据库

$servername = "localhost";

$userename = "ceshi";

$password = "ceshiceshi";

$dbname = "test";

//创建链接

$con = mysqli_connect($servername,$userename,$password,$dbname);

if (!$con){

echo mysqli_connect_error();

}

// /*******插入一个数据****************/

// $sql = "insert into `ceshibiao` (username,password) values ('aaa','bbb')";

// if (mysqli_query($con,$sql)) {

// echo '新纪录插入成功';

// }else{

// echo mysqli_error($con);

// }

//插入多条数据 /*******插入多条数据****************/

// $sql = "insert into `ceshibiao` (username,password) values ('a1a1','b1b1');";

// $sql .= "insert into `ceshibiao` (username,password) values ('a2a2a2','b2b2b2');";

// $sql .= "insert into `ceshibiao` (username,password) values ('a3a3a3','b3b3b3')";

// if (mysqli_multi_query($con,$sql)) {

// echo '新纪录插入成功';

// }else{

// echo mysqli_error($con);

// }

//读取数据 /*********** 读取多条数据 *********/

// $sql = "select id,username,password from `ceshibiao`";

// $result = mysqli_query($con,$sql);

// echo mysqli_num_rows($result); //查询数量

// while ($row = mysqli_fetch_assoc($result)) {

// var_dump($row['username']);

// }

//读取数据 /*********** 查询一条数据 *********/

$sql = "select id,username,password from `ceshibiao` where id=1";

$result = mysqli_query($con,$sql);

//$row = mysqli_fetch_assoc($result);//["id"]=> string(1) "1" ["username"]=> string(4) "1111" ["password"]=> string(4) "2222" }

//$row = mysqli_fetch_row($result);//{ [0]=> string(1) "1" [1]=> string(4) "1111" [2]=> string(4) "2222" }

var_dump($row);

echo '链接成功';

mysqli_close($con);