(PHP 4, PHP 5)
mysql_affected_rows — 取锟斤拷前一锟斤拷 MySQL 锟斤拷锟斤拷锟斤拷影锟斤拷募锟铰硷拷锟斤拷锟�
锟斤拷锟斤拷展锟斤拷 PHP 5.5.0 锟斤拷锟窖凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 PHP 7.0.0 锟斤拷始锟斤拷锟狡筹拷锟斤拷应使锟斤拷 MySQLi 锟斤拷 PDO_MySQL 锟斤拷展锟斤拷锟芥换之锟斤拷锟轿硷拷 MySQL锟斤拷选锟斤拷 API 指锟斤拷锟皆硷拷锟斤拷锟� FAQ 锟斤拷锟斤拷取锟斤拷锟斤拷锟斤拷息锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷校锟�
$link_identifier = NULL
] ) : int
取锟斤拷锟斤拷锟揭伙拷锟斤拷锟� link_identifier 锟斤拷锟斤拷锟斤拷
INSERT锟斤拷UPDATE 锟斤拷 DELETE 锟斤拷询锟斤拷影锟斤拷募锟铰硷拷锟斤拷锟斤拷锟�
link_identifierMySQL
锟斤拷锟接★拷锟界不指锟斤拷锟斤拷锟接憋拷识锟斤拷锟斤拷使锟斤拷锟斤拷 mysql_connect()
锟斤拷锟斤拷蚩锟斤拷锟斤拷印锟斤拷锟斤拷没锟斤拷锟揭碉拷锟斤拷锟斤拷锟接ｏ拷锟结尝锟皆诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
mysql_connect()
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷没锟斤拷锟揭碉拷锟斤拷锟接伙拷锟睫凤拷锟斤拷锟斤拷锟斤拷锟接ｏ拷锟斤拷锟斤拷锟斤拷锟�
E_WARNING 锟斤拷锟斤拷拇锟斤拷锟�
执锟叫成癸拷锟津返伙拷锟斤拷影锟斤拷锟斤拷械锟斤拷锟侥匡拷锟斤拷锟斤拷锟斤拷锟揭伙拷尾锟窖э拷艿幕锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟� -1锟斤拷
锟斤拷锟斤拷锟斤拷一锟轿诧拷锟斤拷锟斤拷没锟斤拷锟轿猴拷锟斤拷锟斤拷锟斤拷WHERE锟斤拷锟斤拷 DELETE 锟斤拷询锟斤拷锟节憋拷锟斤拷锟斤拷锟叫的硷拷录锟斤拷锟结被删锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷值锟斤拷 4.1.2 锟斤拷之前锟斤拷为 0锟斤拷
锟斤拷使锟斤拷 UPDATE 锟斤拷询锟斤拷MySQL 锟斤拷锟结将原值锟斤拷锟斤拷值一锟斤拷锟斤拷锟叫革拷锟铰★拷锟斤拷锟斤拷使锟斤拷 mysql_affected_rows() 锟斤拷锟斤拷锟斤拷锟斤拷值锟斤拷一锟斤拷锟斤拷锟角诧拷询锟斤拷锟斤拷锟斤拷锟斤拷锟较的硷拷录锟斤拷锟斤拷只锟斤拷锟斤拷锟斤拷锟斤拷锟睫改的硷拷录锟斤拷锟脚会被锟斤拷锟截★拷
REPLACE 锟斤拷锟斤拷锟斤拷锟缴撅拷锟斤拷锟斤拷锟斤拷锟酵拷锟斤拷锟斤拷募锟铰硷拷锟饺伙拷锟斤拷锟斤拷一锟斤拷锟铰硷拷录锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟截碉拷锟角憋拷删锟斤拷锟侥硷拷录锟斤拷锟斤拷锟较憋拷锟斤拷锟斤拷募锟铰硷拷锟斤拷锟�
"INSERT ... ON DUPLICATE KEY UPDATE" 锟斤拷锟斤拷锟斤拷锟斤拷牟锟窖拷锟斤拷锟街达拷锟斤拷锟揭伙拷锟� INSERT 锟斤拷锟截碉拷值锟斤拷锟斤拷 1锟斤拷锟斤拷锟斤拷嵌锟斤拷丫锟斤拷锟斤拷诘募锟铰贾达拷锟揭伙拷锟� UPDATE 锟斤拷锟斤拷锟斤拷 2锟斤拷
Example #1 mysql_affected_rows() 锟斤拷锟斤拷
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('mydb');
/* 锟斤拷锟斤拷锟斤拷锟截憋拷删锟斤拷锟斤拷录锟斤拷准确锟斤拷目 */
mysql_query('DELETE FROM mytable WHERE id < 10');
printf("Records deleted: %d\n", mysql_affected_rows());
/* 锟斤拷锟节凤拷锟斤拷值锟斤拷 WHERE 锟接句，应锟斤拷锟斤拷 0 */
mysql_query('DELETE FROM mytable WHERE 0');
printf("Records deleted: %d\n", mysql_affected_rows());
?>
锟斤拷锟斤拷锟斤拷锟教碉拷锟斤拷锟斤拷锟斤拷锟斤拷冢锟�
Records deleted: 10 Records deleted: 0
Example #2 使锟斤拷锟斤拷锟斤拷锟斤拷锟� mysql_affected_rows() 锟斤拷锟斤拷
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('mydb');
/* Update records */
mysql_query("UPDATE mytable SET used=1 WHERE id < 10");
printf ("Updated records: %d\n", mysql_affected_rows());
mysql_query("COMMIT");
?>
锟斤拷锟斤拷锟斤拷锟教碉拷锟斤拷锟斤拷锟斤拷锟斤拷冢锟�
Updated Records: 10
Note: 锟斤拷锟斤拷锟斤拷
锟斤拷锟绞癸拷锟斤拷锟斤拷锟斤拷锟絫ransactions锟斤拷锟斤拷锟斤拷要锟斤拷 INSERT锟斤拷UPDATE 锟斤拷 DELETE 锟斤拷询锟斤拷锟斤拷锟� mysql_affected_rows() 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 COMMIT 锟斤拷锟斤拷之锟斤拷
Note: SELECT 锟斤拷锟�
要锟斤拷取 SELECT 锟斤拷锟斤拷锟截碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 mysql_num_rows()锟斤拷
Note: Cascaded 锟斤拷锟�
mysql_affected_rows() does not count rows affected implicitly through the use of ON DELETE CASCADE and/or ON UPDATE CASCADE in foreign key constraints.