PHP MySQL删除记录

PHP mysql_query()函数用于删除表中的记录。从PHP 5.5开始, 不推荐使用mysql_query()函数。现在建议使用两种替代方法之一。

  • mysqli_query()
  • PDO :: __ query()
PHP MySQLi删除记录示例【PHP MySQL删除记录】例子
< ?php $host = 'localhost:3306'; $user = ''; $pass = ''; $dbname = 'test'; $conn = mysqli_connect($host, $user, $pass, $dbname); if(!$conn){ die('Could not connect: '.mysqli_connect_error()); } echo 'Connected successfully< br/> '; $id=2; $sql = "delete from emp4 where id=$id"; if(mysqli_query($conn, $sql)){ echo "Record deleted successfully"; }else{ echo "Could not deleted record: ". mysqli_error($conn); }mysqli_close($conn); ?>

输出
Connected successfully Record deleted successfully

    推荐阅读