MySQL

最新推荐文章于 2022-04-08 10:28:57 发布

紫颖梦忆

最新推荐文章于 2022-04-08 10:28:57 发布

阅读量270

点赞数

分类专栏：随笔

本文链接：https://blog.csdn.net/jiaqingge/article/details/53391748

版权

随笔专栏收录该内容

44 篇文章 0 订阅

订阅专栏

<?php

//1.链接数据库mysql

$con = mysqli_connect("localhost","root","","eleven");

if($con){

echo "服务器链接成功!";

}else{

echo "链接失败!";

exit();//出口,代码停止往下执行;

}

//2.选择数据库(老版本)

// mysqli_select_db("eleven");

//2.1 设置编码格式

mysqli_query($con,"set names utf8");

//3.编写sql语句

$sql = "SELECT * FROM users";

//4.执行sql语句

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

//5.输出

// $row = mysqli_fetch_row($result);

// print_r($row);

// $row = mysqli_fetch_row($result);

// print_r($row);

//5.1 以索引数组输出

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

// print_r($row);

// }

echo "<hr>";

//5.2 以关联数组输出

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

// print_r($row);

// }

//5.3 以对象形式输出

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

// print_r($row);

// }

//5.4 以索引和关联数组输出

while($row = mysqli_fetch_array($result)){

print_r($row);

}

//6.关闭数据库

mysqli_close($con);

<?php

//1.链接数据库mysql

$con = mysqli_connect("localhost","root","","eleven");

if($con){

echo "服务器链接成功!";

}else{

echo "链接失败!";

exit();//出口,代码停止往下执行;

}

//2.选择数据库(老版本)

// mysqli_select_db("eleven");

//2.1 设置编码格式

mysqli_query($con,"set names utf8");

//3.编写sql语句

// $sql = "SELECT * FROM users";

// $sql = "SELECT id,userName FROM users";

// $sql = "SELECT count(id) FROM users";//查询数据库里的总条数

// $sql = "SELECT * FROM users WHERE id>2";

// $sql = "SELECT * FROM users WHERE id>1 AND id<3";

// $sql = "SELECT * FROM users LIMIT 2,3";//从第3条查三条数据

//排序

$sql = "SELECT * FROM users ORDER BY userName DESC,id DESC";

//插入数据

// $sql = "INSERT INTO users(id,userName,password) VALUES(NULL,'小黄','789123'),(NULL,'HAHA','111222')";

//更新数据

// $sql = "UPDATE users SET userName='杨婷' WHERE id=7";

//删除数据

// $sql = "DELETE FROM users WHERE id=2";

//4.执行sql语句

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

// var_dump($result);

//5.输出

//5.3 以对象形式输出

while($row = mysqli_fetch_object($result)){

print_r($row);

}

echo "<hr>";

//返回查询的记录数

// echo mysqli_num_rows($result);

//获取数据库insert后的id

$ids = mysqli_insert_id($con);

var_dump($ids);

//影响的记录数

$nums = mysqli_affected_rows($con);

var_dump($nums);

//6.关闭数据库

mysqli_close($con);

<?php

$con = mysqli_connect("localhost","root","","eleven");

if($con){

echo "链接成功";

}else{

echo "链接失败";

exit();

}

mysqli_query($con,"set names utf8");

$sql = "SELECT * FROM users";

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

<!DOCYYPE html>

<html>

<head>

</head>

<body>

<tr>

</tr>

<?php

while($row = mysqli_fetch_object($result)){

echo "<tr>";

echo "<td>".$row->id."</td>";

echo "<td>".$row->userName."</td>";

echo "<td>".$row->password."</td>";

echo "</tr>";

}

</table>

</body>

</html>

紫颖梦忆

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
MySQL

//1.链接数据库mysql$con =mysqli_connect("localhost","root","","eleven");if($con){echo"服务器链接成功!";}else{echo"链接失败!";exit();//出口,代码停止往下执行;}//2.选择数据库(老版本)// mysqli_select_db("eleven")
复制链接

扫一扫

专栏目录