Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Insert data to MySql DB and display if insertion is success or failure

Tags:

php

mysql

I am inserting data to a MySQL DB, In case if the insertion fails i need to give an appropriate error message indicating so. According to my code below i will be Echo-ing the message Inserted if the insertion was success or failure.

What i want to do is to echo the Inserted message only when the data insertion is a success, and return fail if it fails. How can i modify my code to do so ?

<?php

mysql_connect("localhost", "root", "123") or die(mysql_error());
mysql_select_db("swm_database") or die(mysql_error());

mysql_query("INSERT INTO PEOPLE (NAME ) VALUES ('COLE')")or die(mysql_error()); 

echo "Inserted";
?>
like image 646
Sharon Watinsan Avatar asked Jul 25 '12 12:07

Sharon Watinsan


1 Answers

$result = mysql_query("INSERT INTO PEOPLE (NAME ) VALUES ('COLE')"));
if($result)
{
echo "Success";

}
else
{
echo "Error";

}
like image 105
Kode Plus Avatar answered Oct 20 '22 20:10

Kode Plus