mysqli_connect()连接数据库
mysqli_select_db()选择库;
mysqli_query()操作语句
mysql_fetch_array()循环执行语句
例子:
<?php
$conn=mysqli_connect("localhost","php","");
mysqli_select_db($conn,"php");
//mysqli_query($conn,"set names utf8");
//$sql="insert into php.php values(2,'jcy',88,15);";
//$sql="insert into php.php values((2,'jcy',88,15)),(3,'dmy',77,15),(1,'wyd',97,16),(4,'zhx',75,15))";
//mysqli_query($conn,$sql);
$result = mysqli_query($conn,"select * from php");
echo "<table border='1'>
<tr>
<th>id</th>
<th>name</th>
<th>score</th>
<th>grade</th>
</tr>";
while($row=mysqli_fetch_array($result)){
echo "<tr>";
echo "<td>".$row['id']."</td>";
echo "<td>".$row['name']."</td>";
echo "<td>".$row['score']."</td>";
echo "<td>".$row['grade']."</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($conn);
?>
结果: