PHP 5.6.0 released

Die MySQLi Fehlerbehandlungs-Klasse

(PHP 5)

Einf├╝hrung

Die MySQLi Fehlerbehandlungs-Klasse

Klassenbeschreibung

mysqli_sql_exception extends RuntimeException {
/* Eigenschaften */
protected string $sqlstate ;
/* Geerbte Eigenschaften */
protected string $message ;
protected int $code ;
protected string $file ;
protected int $line ;
}

Eigenschaften

sqlstate

Der SQL-Status mit dem Fehler.

add a note add a note

User Contributed Notes 2 notes

up
1
dronebraindeveloper at gmail dot com
1 year 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();
}
?>
up
-1
polyanin at gmail dot com
6 months ago
$driver = new mysqli_driver();
        $driver->report_mode = MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT;
To Top