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

Question

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

i want to check insert success or not

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);

score 1 · Accepted Answer · edited May 23 '17 at 10:26

1

Simply:

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

From the docs on mysql_query:

For ... INSERT ... mysql_query() returns TRUE on success or FALSE on error.

More importantly though, read this: Why shouldn't I use mysql_* functions in PHP?

edited May 23 '17 at 10:26

Community

1
1

answered Jun 25 '14 at 05:34

Mark Miller

7,442
2
16
22

score 0 · Answer 2 · answered Jun 25 '14 at 05:40

$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;

Shail Paras · Answer 3 · 2014-06-25T05:46:59.510

According to mysql_insert_id. it returns new generated id on successful insert.

Check here :

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;

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

3 Answers3