下面代码是删除数据表tb_book中记录的部分代码,请将下面的语句补充完整。 $conn = mysqli_connect("localhost", "root", "111", "db____book"); $sqlstr1 = " tb_book where id = ".$_GET['id']; $result = if($result){ echo "<script>alert('删除成功');</sc
时间: 2024-02-01 16:03:07 浏览: 27
可以使用以下代码删除数据表tb_book中指定id的记录:
```
$conn = mysqli_connect("localhost", "root", "111", "db_book");
$sqlstr1 = "DELETE FROM tb_book WHERE id = ".$_GET['id'];
$result = mysqli_query($conn, $sqlstr1);
if($result){
echo "<script>alert('删除成功');</script>";
} else {
echo "<script>alert('删除失败');</script>";
}
```
其中,$conn是数据库连接对象;$sqlstr1是删除记录的SQL语句,使用DELETE FROM语句删除指定id的记录;$_GET['id']是从URL参数中获取的待删除记录的id值;$result是执行SQL语句的结果。
在执行完SQL语句后,根据结果判断是否删除成功,并弹出相应的提示框。
相关问题
下面代码是删除数据表tb_book中记录的部分代码,请将下面的语句补充完整。$con
n = mysqli_connect("localhost","my_user","my_password","my_db");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "DELETE FROM tb_book WHERE book_id=1";
if (mysqli_query($conn, $sql)) {
echo "Record deleted successfully";
} else {
echo "Error deleting record: " . mysqli_error($conn);
}
mysqli_close($conn);
下面代码是查询数据表tb_book中记录的部分代码,请将下面的语句补充完整。 mysqli_query($conn,"set names utf8"); $result=mysqli_query($conn, ____); while($myrow=____){ echo $myrow[2]."<br />"; }
可以使用以下语句查询数据表tb_book中记录:
```mysqli_query($conn, "SELECT * FROM tb_book");```
补充完整的代码如下:
```
mysqli_query($conn, "set names utf8");
$result = mysqli_query($conn, "SELECT * FROM tb_book");
while($myrow = mysqli_fetch_array($result)){
echo $myrow[2]."<br />";
}
```