VERİ TABANI BAĞLANMA
<?php
try{
$pdo = new PDO("mysql: host=localhost;dbname=kayit","root","");
}catch(PDOExeption $e){
echo $e->getMessage();
}
/*hata gösterme*/
if ($pdo->query("select * from uyeler order by")) {
//
}else{
$hata = $pdo->errorInfo();
echo $hata[2];
}
?>
VERİ EKLEME
<?php
try{
$pdo = new PDO("mysql: host=localhost;dbname=kayit","root","");
}catch(PDOExeption $e){
echo $e->getMessage();
}
/*Veri Ekleme*/
//$pdo->exec("insert into uyeler set adi='ercument',soyadi='ali',sifre='12145',mail='eee'");
/*Güncelleme*/
//$pdo->exec("update uyeler set adi='ercument',soyadi='aliss',sifre='12145',mail='eee' where id='18'");
/*Silme Tekli*/
//$pdo->exec("delete from uyeler where id='1'");
/*Silme Çoklu*/
//$pdo->exec("delete from uyeler where id IN (1,2,3,4,5)");
?>
VERİ ÇEKME
<?php
$pdo = new PDO("mysql: host=localhost;dbname=kayit","root","");
/*Tekli Çekme*/
//$al = $pdo->query("select * from uyeler where id='8'")->fetch();
//echo $al['adi'];
/*Çoklu Çekme*/
foreach ($pdo->query("select * from uyeler") as $value) {
echo $value['adi'],"<br/>";
}
?>
GÜVENLİ VERİ ÇEKME
<?php
$pdo = new PDO("mysql: host=localhost;dbname=kayit","root","");
$query = $pdo->prepare("insert into uyeler(adi,soyadi,sifre,mail)values(?,?,?,?)");
$query->execute(array("rrr","got","fff","çiş"));
?>
PDO LEFT JOİN
<?php
include "init.php";
$cek = $db->query("
SELECT makale.id, makale.title, AVG(makale_say.reyting) as reyting
FROM makale
LEFT JOIN makale_say
ON makale.id = makale_say.makale
GROUP BY makale.id
",PDO::FETCH_OBJ);
?>
PDO LEFT JOİN TEKLİ
<?php
include "init.php";
if (isset($_GET['id'])) {
$id = $_GET['id'];
$query = $db->query("
SELECT makale.id, makale.title, AVG(makale_say.reyting) as reyting
FROM makale
LEFT JOIN makale_say
ON makale.id = makale_say.makale
WHERE makale.id= '$id'
")->fetch(PDO::FETCH_OBJ);
}
?>
Hiç yorum yok:
Yorum Gönder