Manuel PHP
   |
|
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_affected_rowsmysqli_affected_rows(PHP 5) mysqli_affected_rows(no version information, might be only in CVS) mysqli->affected_rows -- Retourne le nombre de lignes affectées par la dernière opération MySQLDescriptionStyle procédural int mysqli_affected_rows ( mysqli link )Style orienté objet (méthode) class mysqli {int affected_rows }
Retourne le nombre de lignes affectées par la dernière requête
INSERT, UPDATE,
REPLACE ou DELETE
associée au paramètre Cette fonction ne fonctionne que pour les requêtes qui modifient une table. Pour connaître le nombre de lignes retournées par une requête SELECT, utilisez la fonction mysqli_num_rows(). Liste de paramètres
Valeurs de retourUn entier plus grand que zéro indique le nombre de lignes affectées ou recherchées. Zéro indique qu'aucun enregistrement n'a été modifié par une requête du type UPDATE, aucune ligne ne correspond à la clause WHERE dans la requête ou bien qu'aucune requête n'a été exécutée. -1 indique que la requête a retourné une erreur.
Exemples
L'exemple ci-dessus va afficher :
|
Web
Ajouter ce moteur
