Comunitatea PHP Romania
 

 
mysqli_error
Manual PHP
ÎnapoiÎnainte

mysqli_error

(PHP 5)

mysqli_error -- Returns a string description of the last error

Description

Procedural style:

string mysqli_error ( object link)

Object oriented style (property)

class mysqli {

string error

}

The mysqli_error() function is identical to the corresponding mysqli_errno() function in every way, except instead of returning an integer error code the mysqli_error() function will return a string representation of the last error to occur for the database connection represented by the link parameter. If no error has occured, this function will return an empty string.

Return values

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

See also

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

Example

Exemplu 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();
?>

Exemplu 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);
?>

The above examples would produce the following output: 

Errormessage: Unknown system variable 'a'
ÎnapoiAcasãÎnainte
mysqli_errnoSusmysqli_escape_string

Ultimele discutii in forum RSS Forum

Ultimele articole Ultimele articole

Membri recenti

Laurentziu2_ex Laurentziu2_ex
cornel_sie cornel_sie
Micha Micha
g.leko g.leko
brotacel brotacel
mimihai mimihai
Cristy94 Cristy94
Matrix Matrix
dantrif2001 dantrif2001
geo2087 geo2087

Top membri

Pirahna Pirahna
la birou		carco carco
Bucuresti
Birkoff Birkoff
Bucuresti		mihaitha mihaitha
Sibiu
Mascka Mascka
Braila		gabysolomon gabysolomon
Bacau
whooper whooper
Toronto ON		raul_ raul_
dechim dechim
Drobeta Turnu Severin		Amenthes Amenthes

Newsletter


Email:
 inscriere
 renuntare
 
 Arhiva newsletter

Parteneriat
Copyright © 2001-2008 PHP Romania Add PHPRomania to Google Add PHPRomania to Del.icio.us Add PHPRomania to Stumbleupon Add PHPRomania to Yahoo! Add PHPRomania to Digg Add PHPRomania to Blink The eBay Song | Mortgages | Free Credit Report | Credit Report | Buy PSP
Ads: Partener Way2Web Nework: gazduire web | inregistrare domenii | web design | imobiliare | web hosting
Powered by Simplis