PHP connects to MySQL to perform add, delete, modify and query operations

This article mainly introduces the method of PHP connecting to MySQL to perform add, delete, modify and query operations. It has a very good reference value. Let’s take a look at it with the editor.

Not much to say Please look at the code:

# ， ，

# Fetch_all () Back to all arrays

# FETCH_ROW ()

# FETCH_ASSOC () Return to the associated array

FETCH_OBJECT () Return to the object

# FETCH_ARAY () The array of arrays returned has both indexes and associated

steals Delete, add, and modify operations

<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td>代号</td>
<td>姓名</td>
<td>性别</td>
<td>民族</td>
<td>生日</td>
</tr>
<?php
1.造一个mysqli对象,造连接对象
$db = new MySQLi("localhost","用户名","密码","数据库名");
2.准备一条SQL语句
$sql = "select * from info";
3.执行SQL语句,如果是查询语句，成功返回结果集对象
$reslut = $db->query($sql);
4.判断返回是否执行成功
if($reslut)
{
while($attr = $reslut->fetch_row())
{
echo "<tr>
<td>{$attr[0]}</td>
<td>{$attr[1]}</td>
<td>{$attr[2]}</td>
<td>{$attr[3]}</td>
<td>{$attr[4]}</td>
</tr>";
}
}
?>
</table>

For more articles related to PHP connecting to MySQL for add, delete, modify, and check operations, please pay attention to the PHP Chinese website!