Rapide Advanced Adulte
 
 Web|Image|Shop|Video|News|Wmx|Mobile|Wiki|Ajouter ce moteur

     Manuel PHP     
Partager
 
 
Partager
Partager

 

Table :

.mysqli affected rows
.mysqli autocommit
.mysqli bind param
.mysqli stmt bind param()
.mysqli bind result
.mysqli stmt bind result()
.mysqli change user
.mysqli character set name
.mysqli client encoding
.mysqli character set name()
.mysqli close
.mysqli commit
.mysqli connect errno
.mysqli connect error
.mysqli connect
.mysqli data seek
.mysqli debug
.mysqli disable reads from master
.mysqli disable rpl parse
.mysqli dump debug info
.mysqli embedded server end
.mysqli embedded server start
.mysqli enable reads from master
.mysqli enable rpl parse
.mysqli errno
.mysqli error
.mysqli escape string
.mysqli real escape string()
.mysqli execute
.mysqli stmt execute()
.mysqli fetch array
.mysqli fetch assoc
.mysqli fetch field direct
.mysqli fetch field
.mysqli fetch fields
.mysqli fetch lengths
.mysqli fetch object
.mysqli fetch row
.mysqli fetch
.mysqli stmt fetch()
.mysqli field count
.mysqli field seek
.mysqli field tell
.mysqli free result
.mysqli get charset
.mysqli get client info
.mysqli get client version
.mysqli get host info
.mysqli get metadata
.mysqli stmt result metadata()
.mysqli get proto info
.mysqli get server info
.mysqli get server version
.mysqli get warnings
.mysqli info
.mysqli init
.mysqli insert id
.mysqli kill
.mysqli master query
.mysqli more results
.mysqli multi query
.mysqli next result
.mysqli num fields
.mysqli num rows
.mysqli options
.mysqli param count
.mysqli stmt param count()
.mysqli ping
.mysqli prepare
.mysqli query
.mysqli real connect
.mysqli real escape string
.mysqli real query
.mysqli report
.mysqli rollback
.mysqli rpl parse enabled
.mysqli rpl probe
.mysqli rpl query type
.mysqli select db
.mysqli send long data
.mysqli stmt send long data()
.mysqli send query
.mysqli server end
.mysqli server init
.mysqli set charset
.mysqli set local infile default
.mysqli set local infile handler
.mysqli set opt
.mysqli options()
.mysqli slave query
.mysqli sqlstate
.mysqli ssl set
.mysqli stat
.mysqli stmt affected rows
.mysqli stmt attr get
.mysqli stmt attr set
.mysqli stmt bind param
.mysqli stmt bind result
.mysqli stmt close
.mysqli stmt data seek
.mysqli stmt errno
.mysqli stmt error
.mysqli stmt execute
.mysqli stmt fetch
.mysqli stmt field count
.mysqli stmt free result
.mysqli stmt get warnings
.mysqli stmt init
.mysqli stmt insert id
.mysqli stmt num rows
.mysqli stmt param count
.mysqli stmt prepare
.mysqli stmt reset
.mysqli stmt result metadata
.mysqli stmt send long data
.mysqli stmt sqlstate
.mysqli stmt store result
.mysqli store result
.mysqli thread id
.mysqli thread safe
.mysqli use result
.mysqli warning count
 
   

  mysqli_stmt_error  


mysqli_stmt_error

(PHP 5)

mysqli_stmt_error

(no version information, might be only in CVS)

mysqli_stmt->error -- Retourne une description de la dernière erreur de traitement

Description

Style procédural

string mysqli_stmt_error ( mysqli_stmt stmt )

Style orienté objet (méthode)

class mysqli_stmt {

string error

}

Pour le traitement spécifié par stmt, mysqli_stmt_error() retourne une chaîne de caractères représentant le message d'erreur le plus récent appelé par une fonction de traitement, qu'elle ait réussi ou échoué.

Valeurs de retour

Une chaîne de caractères décrivant l'erreur. Une chaîne vide si aucune erreur n'est survenue.

Exemples

Exemple 1. Style orienté objet

<?php
/* Ouverture d'une connexion */
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* Vérification de la connexion */
if (mysqli_connect_errno()) {
    
printf("Echec de la connexion : %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)) {

    
/* Effacement de la table */
    
$mysqli->query("DROP TABLE myCountry");

    
/* Exécution de la requête */
    
$stmt->execute();

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

    
/* Fermeture du traitement */
    
$stmt->close();
}

/* Fermeture de la connexion */
$mysqli->close();
?>

Exemple 2. Style procédural

<?php
/* Ouverture de la connexion */
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

/* Vérification de la connexion */
if (mysqli_connect_errno()) {
    
printf("Echec de la connexion : %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)) {

    
/* Effacement de la table */
    
mysqli_query($link, "DROP TABLE myCountry");

    
/* Exécution de la requête */
    
mysqli_stmt_execute($stmt);

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

    
/* close statement */
    
mysqli_stmt_close($stmt);
}

/* Fermeture de la connexion */
mysqli_close($link);
?>

L'exemple ci-dessus va afficher :

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

    Annonces       
 

 Retour au chapitre Php

 

Top
 

Ajouter JungleKey.fr à votre Explorateur

 
 

About Us | © 2007 JungleKey




iBlack | Mobile | Wiki | Ajouter ce moteur
.