downloads | documentation | faq | getting help | mailing lists | licenses | wiki | reporting bugs | php.net sites | conferences | my php.net

search for in the

Aliases and deprecated Mysqli Functions> <mysqli_warning::next
[edit] Last updated: Fri, 26 Apr 2013

view this page in

The mysqli_sql_exception class

(PHP 5)

Introduction

The mysqli exception handling class.

Class synopsis

mysqli_sql_exception extends RuntimeException {
/* Properties */
protected $code ;
protected $sqlstate ;
}

Properties

message

The error message.

file

The file with the error.

line

The line with the error.

code

The code causing the error.

sqlstate

The sql state with the error.



add a note add a note User Contributed Notes mysqli_sql_exception - [1 notes]
up
0
dronebraindeveloper at gmail dot com
4 months ago
Quick note on how to setup and use mysqli_sql_exceptions properly

<?php
define
("MYSQL_CONN_ERROR", "Unable to connect to database.");

// Ensure reporting is setup correctly
mysqli_report(MYSQLI_REPORT_STRICT);

// Connect function for database access
function connect($usr,$pw,$db,$host) {
   try {
     
$mysqli = new mysqli($host,$usr,$pw,$db);
     
$connected = true;
   } catch (
mysqli_sql_exception $e) {
      throw
$e;
   }
}

try {
 
connect('username','password','database','host');
  echo
'Connected to database';
} catch (
Exception $e) {
  echo
$e->errorMessage();
}
?>

 
show source | credits | stats | sitemap | contact | advertising | mirror sites