PHP Try and Catch for SQL Insert

Question

I have a page on my website (high traffic) that does an insert on every page load.

I am curious of the fastest and safest way to (catch an error) and continue if the system is not able to do the insert into MySQL. Should I use try/catch or die or something else. I want to make sure the insert happens but if for some reason it can't I want the page to continue to load anyway.

... $db = mysql_select_db('mobile', $conn); mysql_query("INSERT INTO redirects SET ua_string = '$ua_string'") or die('Error #10'); mysql_close($conn); ... 

Answer 1

Checking the documentation shows that its returns false on an error. So use the return status rather than or die(). It will return false if it fails, which you can log (or whatever you want to do) and then continue.

$rv = mysql_query("INSERT INTO redirects SET ua_string = '$ua_string'"); if ( $rv === false ){      //handle the error here } //page continues loading 

Answer 2

This can do the trick,

function createLog($data){      $file = "Your path/incompletejobs.txt";     $fh = fopen($file, 'a') or die("can't open file");     fwrite($fh,$data);     fclose($fh); } $qry="INSERT INTO redirects SET ua_string = '$ua_string'"    $result=mysql_query($qry); if(!$result){     createLog(mysql_error()); }