写法一:最简单的写法header('Content-type:text/html; charset=utf8');
//连接数据库
$pdo = new PDO('mysql:dbname=test','root','root');
$sql = "DELETE FROM user WHERE id=3";
//方式一
if($pdo->exec($sql)==1){
echo '
删除成功
';}else{
echo '
删除失败
';}
写法二:使用try catchheader('Content-type:text/html; charset=utf8');
//连接数据库
$pdo = new PDO('mysql:dbname=test','root','root');
$sql = "DELETE FROM user WHERE id=3";
try{
if($pdo->exec($sql)==1){
echo '
删除成功
';}else{
echo '
没有数据被删除
';}
}catch(PDOException $e){
echo '
删除失败'.$e->getMessage().'
';}
写法三:先查询,再删除header('Content-type:text/html; charset=utf8');
$pdo = new PDO('mysql:dbname=test','root','root');
$sqlr = "SELECT id,name,email FROM user WHERE id=37";
$pdo_stmt = $pdo->query($sqlr);
if($pdo_stmt->rowCount()==1){
$row = $pdo_stmt->fetch();
$sqld = "DELETE FROM user WHERE id='{$row['id']}'";
if($pdo->exec($sqld)==1){
echo '
删除成功
';}else{
echo '
没有数据被删除
';}
}else{
echo '
没有找到数据,删除失败
';}