PHP MySQL oxirgi ID’ni olish
Oxirgi kiritilgan yozuvning identifikatorini oling
Agar AUTO_INCREMENT maydoni bo‘lgan jadvalda INSERT yoki UPDATE bajarsak, biz
insert_id xususiyati (MySQLi) bilan oxirgi kiritilgan/yangilangan yozuvning identifikatorini darhol oling yoki
lastInsertId() usuli (PDO).
"Mening mehmonlarim" jadvalidagi "id" ustuni AUTO_INCREMENT maydonidir.
Quyidagi misollar oldingi sahifadagi misollarga tengdir (PHP Insert Data Into MySQL), bundan tashqari biz oxirgi kiritilgan yozuvning identifikatorini olish uchun bitta kod qatorini qo‘shdik. Shuningdek, biz oxirgi kiritilgan identifikatorni takrorlaymiz:
Misol - MySQLi obyektga yo‘naltirilgan
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
if ($conn->query($sql) === TRUE) {
$last_id = $conn->insert_id;
echo "New record created successfully. Last inserted ID is: " . $last_id;
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>
Misol - MySQLi protsessual
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
if (mysqli_query($conn, $sql)) {
$last_id = mysqli_insert_id($conn);
echo "New record created successfully. Last inserted ID is: " . $last_id;
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>
Misol - PDO
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
die("Could not connect. " . $e->getMessage());
}
try {
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
$conn->exec($sql);
$last_id = $conn->lastInsertId();
echo "New record created successfully. Last inserted ID is: " . $last_id;
} catch(PDOException $e) {
echo $sql . "<br>" . $e->getMessage();
}
$conn = null;
?>
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!