Notes

<?php

class DBConnect
{
public $db = null;
private $lastData = null;
function __construct($host,$dbname,$username,$passwd){
$this->connect($host,$dbname,$username,$passwd);
}

private function connect($host,$dbname,$username,$passwd){
$options = array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8");
try{
$this->db = new PDO("mysql" . ':host=' . $host . ';dbname=' . $dbname, $username, $passwd, $options);
}catch (PDOException $e){
echo 'Hata: ' . $e->getMessage();
}
}



protected function exec($sql){
try{
$this->db->exec($sql);
return true;

}catch(PDOException $e)
{
return false;
}
}



public function kategorilistesi(){
try{
$dbSelect = $this->db->prepare("SELECT * FROM kategoriler");
$dbSelect->execute();
$data=$dbSelect->fetchAll(PDO::FETCH_ASSOC);
return $data;

}catch(PDOException $e){
return null;
}
}
public function urunlerlistesi(){
try{
$dbSelect = $this->db->prepare("SELECT * FROM urunler");
$dbSelect->execute();
$data=$dbSelect->fetchAll(PDO::FETCH_ASSOC);
return $data;

}catch(PDOException $e){
return null;
}
}
public function musterilistesi(){
try{
$dbSelect = $this->db->prepare("SELECT * FROM musteriler");
$dbSelect->execute();
$data=$dbSelect->fetchAll(PDO::FETCH_ASSOC);
return $data;

}catch(PDOException $e){
return null;
}
}

public function kargolistesi(){
try{
$dbSelect = $this->db->prepare("SELECT * FROM kargo");
$dbSelect->execute();
$data=$dbSelect->fetchAll(PDO::FETCH_ASSOC);
return $data;

}catch(PDOException $e){
return null;
}
}
public function satislistesi(){
try{
$dbSelect = $this->db->prepare("SELECT * FROM satislar");
$dbSelect->execute();
$data=$dbSelect->fetchAll(PDO::FETCH_ASSOC);
return $data;

}catch(PDOException $e){
return null;
}
}

public function uyekayit($ad,$kullanici_adi,$eposta,$sifre){
$ekle = $this->exec("INSERT INTO musteriler (ad,k_ad,mail,sifre) VALUES ('$ad','$kullanici_adi','$eposta','$sifre')");
if($ekle){
return true;
}else{
return false;
}

}

public function fiyatdegistir($id,$fiyat){
$sql = $this->exec("UPDATE urunler SET fiyat='$fiyat' WHERE id='$id'");
if($sql){
return true;
}else{
return false;
}
}

public function disconnect(){
$this->db = null;
}

}
$db = new DBConnect("hostname","dbname","username","password");
$db->fiyatdegistir(1,500);
$db->uyekayit("semih gök","semih123","[email protected]","123123");
$db->urunlerlistesi();
$db->kargolistesi();
$db->musterilistesi();
$db->kategorilistesi();
$db->satislistesi();
$db->disconnect();