CMS AP-Fusion - движок для вашего сайта

mysqli_stmt_error

(PHP 5)

mysqli_stmt_error

(no version information, might be only in CVS)

mysqli_stmt->error -- Returns a string description for last statement error

Description

Процедурный стиль:

string mysqli_stmt_error ( mysqli_stmt stmt )

Объектно-ориентированный стиль (property):

class mysqli_stmt {
string error
}

For the statement specified by stmt, mysqli_stmt_error() returns a containing the error message for the most recently invoked statement function that can succeed or fail.

Возвращаемые значения

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

Примеры

Пример 1. Объектно-ориентированный стиль


<?php


/* Open a connection */


$mysqli 
= new 
mysqli
(
"localhost"
, 
"my_user"
, 
"my_password"
, 
"world"
);




/* check connection */ 


if (
mysqli_connect_errno
()) {

    
printf
(
"Connect failed: %s\n"
, 
mysqli_connect_error
());

    exit();

}




$mysqli
->
query
(
"CREATE TABLE myCountry LIKE Country"
);


$mysqli
->
query
(
"INSERT INTO myCountry SELECT * FROM Country"
);






$query 
= 
"SELECT Name, Code FROM myCountry ORDER BY Name"
;

if (
$stmt 
= 
$mysqli
->
prepare
(
$query
)) {



    
/* drop table */

    
$mysqli
->
query
(
"DROP TABLE myCountry"
);



    
/* execute query */

    
$stmt
->
execute
();



    
printf
(
"Error: %s.\n"
, 
$stmt
->
error
);



    
/* close statement */

    
$stmt
->
close
();

}




/* close connection */


$mysqli
->
close
();


?>

Пример 2. Процедурный стиль


<?php


/* Open a connection */


$link 
= 
mysqli_connect
(
"localhost"
, 
"my_user"
, 
"my_password"
, 
"world"
);




/* check connection */ 


if (
mysqli_connect_errno
()) {

    
printf
(
"Connect failed: %s\n"
, 
mysqli_connect_error
());

    exit();

}




mysqli_query
(
$link
, 
"CREATE TABLE myCountry LIKE Country"
);


mysqli_query
(
$link
, 
"INSERT INTO myCountry SELECT * FROM Country"
);






$query 
= 
"SELECT Name, Code FROM myCountry ORDER BY Name"
;

if (
$stmt 
= 
mysqli_prepare
(
$link
, 
$query
)) {



    
/* drop table */

    
mysqli_query
(
$link
, 
"DROP TABLE myCountry"
);



    
/* execute query */

    
mysqli_stmt_execute
(
$stmt
);



    
printf
(
"Error: %s.\n"
, 
mysqli_stmt_error
(
$stmt
));



    
/* close statement */

    
mysqli_stmt_close
(
$stmt
);

}




/* close connection */


mysqli_close
(
$link
);


?>

Результат выполнения данного примера:

Error: Table 'world.myCountry' doesn't exist.

Все функции PHP:

mysqli_stmt_error

Description

Возвращаемые значения

Смотрите также

Примеры