note 60669 added to function.mysqli-error

Hi, you can also use the new mysqli_sql_exception to catch sql errors. Example: <?php //set up $mysqli_instance here.. $Select = "SELECT xyz FROM mytable "; try { $res = $mysqli_instance->query($Select); }catch (mysqli_sql_exception $e) { print "Error Code <br>".$e->getCode(); print "Error Message <br>".$e->getMessage(); print "Strack Trace <br>".nl2br($e->getTraceAsString()); } ?> Will print out something like Error Code: 0 Error Message No index used in query/prepared statement select sess_value from frame_sessions where sess_name = '5b85upjqkitjsostvs6g9rkul1' Strack Trace: #0 G:\classfiles\lib5\database.php(214): mysqli->query('select sess_val...') #1 G:\classfiles\lib5\Session.php(52): database->getString('select sess_val...') #2 [internal function]: sess_read('5b85upjqkitjsos...') #3 G:\classfiles\includes.php(50): session_start() #4 G:\tests\all_tests.php(4): include('G:\data\WorkSit...') #5 {main} ---- Manual Page -- http://www.php.net/manual/en/function.mysqli-error.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+60669 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+60669&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+60669&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+60669&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+60669&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+60669&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+60669&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+60669&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+60669&report=yes Search -- http://master.php.net/manage/user-notes.php