1.面向过程的操作
(1).连接数据库
@$db = mysqli_connect('localhost','root','*******','books');//books是数据库名;@是为了抑制错误弹出,不是必须的
(2)判断是否连接成功
if(mysqli_connect_errno()){
echo 'Error: Could not connect to database.Please try again later.';
exit;
}
//可以在不断开连接的情况下,更改数据库目标。例如,mysqli_select_db($db,'smpdb');
(3)执行查询语句
$query = "select * from books where ".$searchtype." like '%".$searchterm."%'";
$result = mysqli_query($db,$query);
(4)统计结果集的行数
$num_results = mysqli_num_rows($result);
(5)把行记录格式化为关联数据
for($i=0; $i<$num_results; $i++){
//$row = $result->mysqli_fetch_assoc();
$row = mysqli_fetch_assoc($result);
echo "<p><strong>".($i+1)." Title:";
echo htmlspecialchars(stripslashes($row['title']));
echo "</strong><br />";
}
(6)释放结果集资源
mysqli_free_result($result);
(7)关闭数据库
mysqli_close($db);
2.面向对象的操作
(1)连接数据库
@$db = new mysqli('localhost','root','190913z','books');
(2)判断是否连接成功
if($db->connect_errno){
echo 'Error: Could not connect to database.Please try again later.';
exit;
}
//可以在不断开连接的情况下,更改数据库目标。例如,$db->select_db('smpdb');
(3)执行查询语句
$query = "select * from books where ".$searchtype." like '%".$searchterm."%'";
$result = $db->query($query);
(4)统计结果集的行数
$num_results = $result->num_rows;
(5)把行记录格式化为关联数据
for($i=0; $i<$num_results; $i++){
$row = $result->fetch_assoc();
echo "<p><strong>".($i+1)." Title:";
echo htmlspecialchars(stripslashes($row['title']));
echo "</strong><br />";
}
(6)释放结果集资源
$result->free();
(7)关闭数据库
$db->close();