PHP Veritabani Examples

Example #1

File: kisiEkle.php Project: GULSENCIMEN/projeler

<?php

require_once 'Genel/ClassVeritabaniMysqli.php';
require_once 'Genel/ClassIstisnaVeritabani.php';
try {
    $veritabani = new Veritabani();
} catch (DBException $e) {
    echo $e->hataGoruntule();
    exit(1);
}
try {
    $alanlarDegerler = array("kullanici_adi" => "'{$_POST['username']}'", "kullanici_sifre" => "'{$_POST['sifre']}'", "email" => "'{$_POST['mail']}'");
    $veritabani->insert("kisiler", $alanlarDegerler);
} catch (Exception $e) {
    echo $e->getMessage();
} catch (DBException $e) {
    echo $e->hataGoruntule();
}
if ($result) {
    $data = array('sonuc' => '1');
} else {
    $data = array('sonuc' => '0');
}
?>

Example #2

File: Dogrula.php Project: GULSENCIMEN/projeler

<?php

require_once 'Genel/ClassVeritabaniMysqli.php';
require_once 'Genel/ClassIstisnaVeritabani.php';
session_start();
try {
    $veritabani = new Veritabani();
} catch (DBException $e) {
    echo $e->hataGoruntule();
    exit(1);
}
try {
    $alanlar = "kisi_id";
    $tabloAdi = "kisiler";
    $usr = mysql_real_escape_string(htmlspecialchars($_POST['userName1']));
    $sfr = mysql_real_escape_string(htmlspecialchars($_POST['sifre1']));
    $kosul = "kullanici_adi = '{$usr}' and kullanici_sifre='{$sfr}'";
    $_SESSION['name'] = $_POST['userName1'];
    $result = $veritabani->select($alanlar, $tabloAdi, $kosul);
} catch (Exception $e) {
    echo $e->getMessage();
} catch (DBException $e) {
    echo $e->hataGoruntule();
}
if (mysqli_num_rows($result) != 0 && ($_SESSION['name'] == 'ygmr' || $_SESSION['name'] == 'glsn')) {
    $data = array('sonuc' => '1');
} elseif (mysqli_num_rows($result) != 0) {
    $data = array('sonuc' => '2');
} else {
    $data = array('sonuc' => '0');
}

Example #3

File: UserController.php Project: TalehFarzaliey/PHP-OOP-MVC-Login

 public function __construct()
 {
     $this->conn = parent::__construct();
 }