Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- error_reporting(E_ALL | E_STRICT);
- ini_set('display_errors', TRUE);
- ini_set('display_startup_errors', TRUE);
- class DB
- {
- // объявление свойства
- protected $host = 'localhost';
- protected $db = 'dfgdfgdfgdfg'; // имя базы
- protected $charset = 'utf8';
- protected $user = 'dfgdfgdfg'; // имя юзера
- protected $pass = 'dfgdfgdfg'; // пароль юзера
- public function __construct() {
- $dsn = "mysql:host=$this->host;dbname=$this->db;charset=$this->charset";
- $opt = array(
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
- );
- $this->DBconnect = new PDO($dsn, $this->user, $this->pass, $opt);
- }
- // проверка на наличие e-mail в базе 0 - нет, иначе да
- public function checkDoubleMail($table, $column, $email) {
- // Проверим есть ли такой юзер
- $auth = $this->DBconnect->prepare('SELECT COUNT(*) FROM `'.$table.'` WHERE `'.$column.'`=:mail');
- $auth->bindParam(':'.$column, $email, PDO::PARAM_STR);
- $auth->execute();
- $Count = $auth->fetchAll();
- return intval(implode('', $Count[0]));
- }
- }
- class Validator
- {
- private $DBconnect = null;
- public function __construct($db) {
- $this->DBconnect = $db;
- }
- public function checkUnique($table, $column, $email)
- {
- $auth = $this->DBconnect->prepare('SELECT COUNT(*) FROM `'.$table.'` WHERE `'.$column.'`=:mail');
- $auth->bindParam(':'.$column, $email, PDO::PARAM_STR);
- $auth->execute();
- $Count = $auth->fetchAll();
- return intval(implode('', $Count[0]));
- }
- }
- $obj = new DB();
- echo '<pre>'; var_dump($obj); echo '</pre>';
- $val = new Validator($obj);
- $check = $val->checkUnique('users', 'mail', 'mail@yandex.ru');
- echo '<pre>'; var_dump($check); echo '</pre>';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement