如何检查插入成功与否，当我使用这个代码 - How to check insert success or not When i using this code?

How to check insert success or not When i using this code?

使用此代码时如何检查插入是否成功?

i要检查插入是否成功

if success echo "success";else echo "error";

$link = mysql_connect($host, $user, $pass);
$sql = mysql_query("INSERT INTO `transaction` (txnid, pro_name, price, status) 
           VALUES (
                    '".$data['txn_id']."' ,
                    '".$data['pro_name']."' ,
                    '".$data['price']."' ,
                    '$status'
                  )", $link);
return mysql_insert_id($link);

简体:

if (!$sql) echo 'error';
else echo 'success';

From docs on mysql_query:

……插入……mysql_query()成功返回TRUE，错误返回FALSE。

更重要的是，阅读这个:为什么我不应该't在PHP中使用mysql_*函数?

$link = mysql_connect($host, $user, $pass);
$sql = mysql_query("INSERT INTO `transaction` (txnid, pro_name, price, status) 
           VALUES (
                    '".$data['txn_id']."' ,
                    '".$data['pro_name']."' ,
                    '".$data['price']."' ,
                    '$status'
                  )", $link);
//------------Changes----------------
$inserted_id = mysql_insert_id($link);
if(mysql_errno() != 0){ 
   echo "error";
else
   echo "success";
return $inserted_id;

根据mysql_insert_id。如果插入成功，它将返回新生成的id。

查看此处:

mysql_insert_id

 $link = mysql_connect($host, $user, $pass);
 $sql = mysql_query("INSERT INTO `transaction` (txnid, pro_name, price, status) 
           VALUES (
                    '".$data['txn_id']."' ,
                    '".$data['pro_name']."' ,
                    '".$data['price']."' ,
                    '$status'
                  )", $link);
$lastInsertedId = mysql_insert_id($link);
if (empty($lastInsertedId)) 
   $return = 'error';
else 
   $return = $lastInsertedId;
return $return;