PHP Handbuch
Zurück |  | Weiter

# mysqli_error

(PHP 5)

mysqli_error -- Returns a string description of the last error

## Beschreibung

Procedural style:

string mysqli_error ( mysqli link )

Object oriented style (property)

class mysqli {
string error
}

Returns the last error message for the most recent MySQLi function call that can succeed or fail.

## Parameter Liste

`link`

  Procedural style only: A link identifier returned by mysqli_connect() or mysqli_init()

## Rückgabewerte

A string that describes the error. An empty string if no error occurred.

## Beispiele

Beispiel 1. Object oriented style
`<?php $mysqli = new mysqli("localhost", "my_user", "my_password", "world"); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } if (!$mysqli->query("SET a=1")) { printf("Errormessage: %s\n", $mysqli->error); } /* close connection */ $mysqli->close(); ?>`

Beispiel 2. Procedural style
`<?php $link = mysqli_connect("localhost", "my_user", "my_password", "world"); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } if (!mysqli_query($link, "SET a=1")) { printf("Errormessage: %s\n", mysqli_error($link)); } /* close connection */ mysqli_close($link); ?>`

Das oben gezeigte Beispiel erzeugt folgende Ausgabe:

    Errormessage: Unknown system variable 'a'

## Siehe auch

mysqli_connect_errno()
mysqli_connect_error()
mysqli_errno()
mysqli_sqlstate()

Zurück | Zum Anfang | Weiter
mysqli_errno | Nach oben | mysqli_escape_string