دورة mysql للمبتدئين الدرس الثالت
1- حذف مستخدم باستعمال ل id ديالو
//index.php
<?php
$host = 'localhost';
$user = 'root';
$password = '';
$db = 'php_course';
//open connection
$con = new mysqli($host,$user,$password,$db);
$sql = "DELETE FROM users WHERE id = 3";
if ($con->query($sql) === TRUE) {
echo "utilisateur supprimé";
} else {
echo "Erreur : " . $con->error;
}
if($con->connect_error){
die('erreur de connexion');
}
//close connection
$con->close();
?>
2- حذف جميع المستخدمين من قاعدة البيانات
//index.php
<?php
$host = 'localhost';
$user = 'root';
$password = '';
$db = 'php_course';
//open connection
$con = new mysqli($host,$user,$password,$db);
$sql = "DELETE FROM users";
if ($con->query($sql) === TRUE) {
echo "utilisateurs supprimés";
} else {
echo "Erreur : " . $con->error;
}
if($con->connect_error){
die('erreur de connexion');
}
//close connection
$con->close();
?>
3- تعديل اسم المستخدم باستعمال ل id
//index.php
<?php
$host = 'localhost';
$user = 'root';
$password = '';
$db = 'php_course';
//open connection
$con = new mysqli($host,$user,$password,$db);
$sql = "UPDATE users SET nom = 'alaoui' WHERE id = 7";
if ($con->query($sql) === TRUE) {
echo "utilisateur modifié";
} else {
echo "Erreur : " . $con->error;
}
if($con->connect_error){
die('erreur de connexion');
}
//close connection
$con->close();
?>
4- تعديل مجموعة من القيم
//index.php
<?php
$host = 'localhost';
$user = 'root';
$password = '';
$db = 'php_course';
//open connection
$con = new mysqli($host,$user,$password,$db);
$sql = "UPDATE users SET nom = 'alaoui',prenom = 'ahlame', email = 'ahlame@email.com' WHERE id = 1";
if ($con->query($sql) === TRUE) {
echo "utilisateur modifié";
} else {
echo "Erreur : " . $con->error;
}
if($con->connect_error){
die('erreur de connexion');
}
//close connection
$con->close();
?>