我如何添加一条消息"$ user_id已删除"?或“找不到$ user_id?" [英] How would I add a message that says "$user_id Deleted" or "$user_id not found?"

问题描述

如何添加显示已删除$ user_id"或未找到$ user_id"的消息?

How would I add a message that says "$user_id Deleted" or "$user_id not found?"

  <?php

  $con=mysql_connect("localhost","root","");

  if(!$con) {
      die('could not connect:'.mysql_error());
  }

  mysql_select_db("final?orgdocs", $con);

  $user_id = $_POST["user_id"];

  $result = mysql_query("delete from account where user_id='$user_id' ");


  ?>

推荐答案

<?php

$con = mysql_connect("localhost", "root", "");

if (!$con) {
    die('could not connect:'  .mysql_error());
}

mysql_select_db("final?orgdocs", $con);

$user_id = (int)$_POST["user_id"];

$result = mysql_query("delete from account where user_id=$user_id");

$affected_rows = mysql_affected_rows();

if ($affected_rows) {
    echo "User ID '$user_id' deleted";
} else {
    echo "User ID '$user_id' not found";
}

?>

这篇关于我如何添加一条消息"$ user_id已删除"?或“找不到$ user_id?"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！