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_insert_id  


mysqli_insert_id

(PHP 5)

mysqli_insert_id

(no version information, might be only in CVS)

mysqli->insert_id -- Retourne l'identifiant automatiquement généré par la dernière requête

Description

Style procédural

int mysqli_insert_id ( mysqli link )

Style orienté objet (méthode)

class mysqli {

int insert_id

}

La fonction mysqli_insert_id() retourne l'identifiant généré par une requête sur une table avec une colonne possédant l'attribut AUTO_INCREMENT. Si la dernière requête n'était ni un INSERT, ni un UPDATE ou que la table modifiée ne possède pas de colonne avec l'attribut AUTO_INCREMENT, cette fonction retournera zéro.

Note : Exécuter une commande INSERT ou UPDATE utilisant la fonction LAST_INSERT_ID() modifiera aussi la valeur retournée par la fonction mysqli_insert_id().

Liste de paramètres

link

Style procédural uniquement : Un identifiant de lien retourné par la fonction mysqli_connect() ou par la fonction mysqli_init()

Valeurs de retour

La valeur du champ AUTO_INCREMENT modifiée par la dernière requête. Retourne zéro s'il n'y a pas eu de requête sur la connexion ou si la dernière requête n'a pas modifié la valeur de l'AUTO_INCREMENT.

Note : Si le nombre est plus grand que la valeur maximale d'un entier, mysqli_insert_id() retournera une chaîne le représentant.

Exemples

Exemple 1. Style orienté objet

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

/* Vérification de la connexion */
if (mysqli_connect_errno()) {
    
printf("Échec de la connexion : %s\n", mysqli_connect_error());
    exit();
}

$mysqli->query("CREATE TABLE myCity LIKE City");

$query = "INSERT INTO myCity VALUES (NULL, 'Stuttgart', 'DEU', 'Stuttgart', 617000)";
$mysqli->query($query);

printf ("Le nouvel enregistrement a l'id : %d.\n", $mysqli->insert_id);

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

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

Exemple 2. Style procédural

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

/* Vérification de la connexion */
if (mysqli_connect_errno()) {
    
printf("Échec de la connexion : %s\n", mysqli_connect_error());
    exit();
}

mysqli_query($link, "CREATE TABLE myCity LIKE City");

$query = "INSERT INTO myCity VALUES (NULL, 'Stuttgart', 'DEU', 'Stuttgart', 617000)";
mysqli_query($link, $query);

printf ("Le nouvel enregistrement a l'id : %d.\n", mysqli_insert_id($link));

/* Suppression de la table myCity */
mysqli_query($link, "DROP TABLE myCity");

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

L'exemple ci-dessus va afficher :

Le nouvel enregistrement a l'id : 1.

    Annonces       
 

 Retour au chapitre Php

 

Top
 

Ajouter JungleKey.fr à votre Explorateur

 
 

About Us | © 2007 JungleKey




iBlack | Mobile | Wiki | Ajouter ce moteur
.