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

Question

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     lt  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     gt

User · Answer

Check  http   php net manual en function mysql-affected-rows php

User · Answer

After INSERT query you can use ROW COUNT   to check for successful insert operation as   SELECT IF ROW COUNT     1    Insert Success    Insert Failed   As status

User · Answer

result   mysql query  INSERT INTO PEOPLE  NAME   VALUES   COLE       if  result    echo  Success      else   echo  Error

User · Answer

if  mysql query  INSERT INTO PEOPLE  NAME   VALUES   COLE    or die mysql error         echo  Success     else     echo  Fail        Although since you have or die mysql error    it will show the mysql error   on the screen when it fails  You should probably remove that if it isnt the desired result

User · Answer

According to the book PHP and MySQL for Dynamic Web Sites  4th edition   Example    r   mysqli query  dbc   q     For simple queries like INSERT  UPDATE  DELETE  etc   which do not return records   the  r variable   short for result   will be either TRUE or FALSE  depending upon whether the query executed successfully   Keep in mind that    executed successfully    means that it ran without error  it doesn   t mean that the query   s execution necessarily had the desired result  you   ll need to test for that   Then how to test   While the mysqli num rows   function will return the number of rows generated by a SELECT query  mysqli affected rows   returns the number of rows affected by an INSERT  UPDATE  or DELETE query  It   s used like so    num   mysqli affected rows  dbc     Unlike mysqli num rows    the one argument the function takes is the database connection   dbc   not the results of the previous query   r

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

Examples related to php

Examples related to mysql