Php pdo เมื่อแทรกหมายเลข
รหัสตัวอย่าง
pdo สุดท้ายระบุตัว
Beware of lastInsertId() when working with transactions in mysql. The following code returns 0 instead of the insert id.
<?php
try {
$dbh = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
$stmt = $dbh->prepare("INSERT IGNORE INTO test (name, email) VALUES(?,?)");
try {
$dbh->beginTransaction();
$tmt->execute( array('user', '[email protected]'));
$dbh->commit();
print $dbh->lastInsertId();
} catch(PDOExecption $e) {
$dbh->rollback();
print "Error!: " . $e->getMessage() . "</br>";
}
} catch( PDOExecption $e ) {
print "Error!: " . $e->getMessage() . "</br>";
}
?>
When no exception is thrown, lastInsertId returns 0. However, if lastInsertId is called before calling commit, the right id is returned.
php pdo เมื่อแทรกหมายเลข
$stmt = $db->prepare("...");
$stmt->execute();
$id = $db->lastInsertId();หน้าคล้ายกัน
คล้ายกันหน้ากับตัวอย่าง
ในภาษาอื่นๆ
หน้านี้อยู่ในภาษาอื่นๆ
empty row
Русский
..................................................................................................................
English
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
中文
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................
Балгарскі
..................................................................................................................
Íslensk
..................................................................................................................
ดังอยู่ในนี้หมวดหมู่
ดังหน้ากับตัวอย่างอยู่ในหมวดหมู่
empty row