PHP MySQL ma’lumot o‘chirish
MySQL jadvalidan ma’lumotlarni o‘chirish
SQL DELETE operatori jadvaldagi yozuvlarni o‘chirish uchun ishlatiladi:
DELETE FROM table_name
WHERE some_column = some_value
DIQQAT: WHERE bandi qaysi yozuv(lar)ni o‘chirish kerakligini belgilaydi. Agar siz WHERE bandini o‘tkazib yuborsangiz, barcha yozuvlar o‘chiriladi!
SQL haqida ko‘proq ma’lumot olish uchun bizning SQL qo‘llanmamizga tashrif buyuring.
MySQLi yordamida ma’lumotlarni o‘chirish
"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 |
| 3 | Julie | Dooley | julie@example.com | 2024-10-26 10:48:23 |
Quyidagi misollar "MyGuests" jadvalidagi id=3 bo‘lgan yozuvni o‘chiradi:
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 delete a record
$sql = "DELETE FROM MyGuests WHERE id=3";
if ($conn->query($sql) === TRUE) {
echo "Record deleted successfully";
} else {
echo "Error deleting 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 delete a record
$sql = "DELETE FROM MyGuests WHERE id=3";
if (mysqli_query($conn, $sql)) {
echo "Record deleted successfully";
} else {
echo "Error deleting record: " . mysqli_error($conn);
}
mysqli_close($conn);
?>
PDO yordamida ma’lumotlarni o‘chirish
Quyidagi misollar "MyGuests" jadvalidagi id=3 bo‘lgan yozuvni o‘chiradi:
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 delete a record
$sql = "DELETE FROM MyGuests WHERE id=3";
$conn->exec($sql);
echo "Record deleted successfully";
} catch(PDOException $e) {
echo "Error deleting record: " .$sql . "<br>" . $e->getMessage();
}
$conn = null;
?>
Yozuv o‘chirilgandan 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 | Moe | mary@example.com | 2024-10-23 10:22:30 |
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!