PHP MySQL ma’lumot yangilash
MySQL jadvalidagi ma’lumotlarni yangilash
SQL UPDATE operatori jadvaldagi mavjud yozuvlarni yangilash uchun ishlatiladi:
UPDATE table_name
SET column1 = value, column2 = value2,...
WHERE some_column = some_value
QAYD: WHERE bandi qaysi yozuv(lar)ni yangilanishi kerakligini belgilaydi. Agar siz WHERE bandini o‘tkazib yuborsangiz, barcha yozuvlar yangilanadi!
SQL haqida ko‘proq ma’lumot olish uchun bizning SQL qo‘llanmamizga tashrif buyuring.
MySQLi yordamida ma’lumotlarni yangilang
"Mening mehmonlarim" jadvaliga qarang:
| id | firstname | lastname | reg_date | |
|---|---|---|---|---|
| 1 | John | Doe | john@example.com | 2024-10-22 14:26:15 |
| 2 | Mary | Moe | mary@example.com | 2024-10-23 10:22:30 |
Quyidagi misollar "Mening mehmonlarim" jadvalidagi id = 2 yozuvini yangilaydi:
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 to update a record
$sql = "UPDATE MyGuests SET lastname='Doe' WHERE id=2";
if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $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 to update a record
$sql = "UPDATE MyGuests SET lastname='Doe' WHERE id=2";
if (mysqli_query($conn, $sql)) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . mysqli_error($conn);
}
mysqli_close($conn);
?>
PDO yordamida ma’lumotlarni yangilash
Quyidagi misollar "Mening mehmonlarim" jadvalidagi id = 2 yozuvini yangilaydi:
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 to update a record
$sql = "UPDATE MyGuests SET lastname='Doe' WHERE id=2";
// execute the query
$conn->execute();
echo "Record updated successfully";
} catch(PDOException $e) {
echo "Error updating record: " .$sql . "<br>" . $e->getMessage();
}
$conn = null;
?>
Yozuv yangilangandan so‘ng, jadval quyidagicha ko‘rinadi:
| id | firstname | lastname | reg_date | |
|---|---|---|---|---|
| 1 | John | Doe | john@example.com | 2024-10-22 14:26:15 |
| 2 | Mary | Doe | mary@example.com | 2024-10-23 10:22:30 |
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!