دورة mysql للمبتدئين الدرس السادس
1- إسترجاع المستخدمين من قاعدة البيانات
//index.php
<?php
//connect to database using PDO
$host = 'localhost';
$user = 'root';
$password = '';
$db = 'php_course';
try{
$con = new PDO("mysql:host=$host;dbname=$db",$user,$password);
$con->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$query = $con->prepare('SELECT * FROM users');
$query->execute();
$query->setFetchMode(PDO::FETCH_ASSOC);
foreach($query->fetchAll() as $user){
echo $user['nom'].'<br/>';
}
}catch(PDOException $e){
//$conn->rollback();
echo 'erreur '.$e->getMessage();
}
//close connection
$con = null;
?>
2- حذف مستخدم باستعمال ل ID ديالو
//index.php
<?php
//connect to database using PDO
$host = 'localhost';
$user = 'root';
$password = '';
$db = 'php_course';
try{
$con = new PDO("mysql:host=$host;dbname=$db",$user,$password);
$con->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
// $query = $con->prepare('SELECT * FROM users');
// $query->execute();
// $query->setFetchMode(PDO::FETCH_ASSOC);
// foreach($query->fetchAll() as $user){
// echo $user['nom'].'<br/>';
// }
$sql = "DELETE FROM users WHERE id = 3";
$con->exec($sql);
echo 'utilisateur supprimé';
}catch(PDOException $e){
//$conn->rollback();
echo 'erreur '.$e->getMessage();
}
//close connection
$con = null;
?>
3- تعديل اسم المستخدم باستعمال ل ID
//index.php
<?php
//connect to database using PDO
$host = 'localhost';
$user = 'root';
$password = '';
$db = 'php_course';
try{
$con = new PDO("mysql:host=$host;dbname=$db",$user,$password);
$con->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
// $query = $con->prepare('SELECT * FROM users');
// $query->execute();
// $query->setFetchMode(PDO::FETCH_ASSOC);
// foreach($query->fetchAll() as $user){
// echo $user['nom'].'<br/>';
// }
// $sql = "DELETE FROM users WHERE id = 3";
// $con->exec($sql);
// echo 'utilisateur supprimé';
$sql = "UPDATE users SET nom='fathi' WHERE id = 1";
$con->exec($sql);
echo 'utilisateur modifié';
}catch(PDOException $e){
//$conn->rollback();
echo 'erreur '.$e->getMessage();
}
//close connection
$con = null;
?>
4- استخدام LIMIT لحصر عدد القيم المسترجعة
//index.php
<?php
//connect to database using PDO
$host = 'localhost';
$user = 'root';
$password = '';
$db = 'php_course';
try{
$con = new PDO("mysql:host=$host;dbname=$db",$user,$password);
$con->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
// $query = $con->prepare('SELECT * FROM users');
// $query->execute();
// $query->setFetchMode(PDO::FETCH_ASSOC);
// foreach($query->fetchAll() as $user){
// echo $user['nom'].'<br/>';
// }
// $sql = "DELETE FROM users WHERE id = 3";
// $con->exec($sql);
// echo 'utilisateur supprimé';
// $sql = "UPDATE users SET nom='fathi' WHERE id = 1";
// $con->exec($sql);
// echo 'utilisateur modifié';
$query = $con->prepare('SELECT * FROM users LIMIT 3');
$query->execute();
$query->setFetchMode(PDO::FETCH_ASSOC);
foreach($query->fetchAll() as $user){
echo $user['nom'].'<br/>';
}
}catch(PDOException $e){
//$conn->rollback();
echo 'erreur '.$e->getMessage();
}
//close connection
$con = null;
?>