PHP, check if a record was inserted via MySQL...

[morestar]

So basically I'm trying to determine of a record was actually inserted into my database with the insert statement in MySQL.

My code is as follows:

$sQuery = "INSERT INTO `$database`.`Users` 
(`User` ,`Email` ,`Email_verified`)
VALUES (NULL , '$sEmail', '0')";
mysql_query($sQuery);

From here I would like to send an email to the new member but before I do I need to know for sure that the record was inserted.

I have already setup checks before this step, that makes sure everything is totally ok before the insert but I would like it as a last precaution.

If anyone knows the proper syntax to check if a record was inserted into the MySQL database that would be great. I'm still going to search the net and find it...if I do I will post it here...

[Uncle Dog]

if (mysql_query($sQuery))
{
echo "Record inserted";
}
else
{
echo "Error inserting record: " . mysql_error();
}

[morestar]

Thank you UD, once I get the fricken mail to send, I'll add in the insert check...

thanks again man...

[morestar]

Yep it worked! I can't believe how long it actually takes to write a perfectly error proof registration form...

I added javascript validation and then had to write server side validation in case the javascript is turned off or not working for the user...added a little ajax to check if the username exists - in real time...

whew...that's done...

Thanks Uncle Dog...

[danlefree]

You might want to try variable assignment instead of wrapping the mysql_query() call in an if/else statement (things can get tricky otherwise).

$flag_inserted = mysql_query($sQuery);

if ( $flag_inserted ) {

  // Success handling
  // . . .

} else {

  // Error handling
  // . . .

} 

(Then you can chain multiple conditions)

In the future you may want to look at the Return Values section of the PHP manual for functions you are using.

[morestar]

Ya I looked at the link you provided before I posted here...I couldn't quite figure out the syntax or way of coding it with those examples...

Now what do you mean by chaining multiple conditions?

[morestar]

Ya I did as you mentioned..

$result=mysql_query($sQuery);
   if($result){
     /// do this
   } else {
    dothat();
}

[wige]

Another (tricky) way to do it is to get the insert id of the newly created record, assuming you are entering a new row into the database. This can be used in two ways - to confirm that the row was created successfully, and to perform additional work on the entry or to link other tables to the new entry. The function, run after the insert query, is mysql_insert_id(), which will return 0 if no new id was created. You can get more info and some samples here: PHP: mysql_insert_id - Manual

Another good method, which I often use, is to simply test if an error has been set. If the error id is 0, the previous command executed correctly, otherwise call the error handler... if (mysql_errno()) echo mysql_error;

[danlefree]

Now what do you mean by chaining multiple conditions?

There may be some cases where multiple queries must succeed (or other conditions must be met) before you perform an action - for example, if your form requires that the user be inserted and a registration e-mail be sent, you might want to cancel the user insert if there is a problem sending the e-mail.

(The mail() command will return FALSE on error as well)

[morestar]

Very well wige and danlefree, thank you for your advice(s). I'm noticing that my php coding skills aren't nearly as advanced as some of the code I'm seeing out there...after I launch this new site I just might get a more experienced someone to take a peek at the code and optimize it as much as possible.

the sign up form is done except now I have to code to prevent sql injection...

wish me luck!