/
class.stbase.php
59 lines (48 loc) · 1.31 KB
/
class.stbase.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<?php
/*
* @autor Martynuk Andrew <j-map@mail.ru>
*/
use PDO;
class Base
{
private $host = 'localhost';
private $base = 'имя базы данных';
private $user = 'пользователь ДБ';
private $pass = 'пароль';
private static $pdo;
public function prepare($q)
{
if(!(self::$pdo instanceof PDO))
{
$options = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC];
self::$pdo = new PDO("mysql:host=$this->host;dbname=$this->base;charset=UTF8", $this->user, $this->pass, $options);
}
return self::$pdo->prepare($q);
}
public function getresult($stm, $arr)
{
if($stm instanceof \PDOStatement){
$stm->execute($arr);
return $stm->fetchAll();
} else{
return FALSE;
}
}
public function sel($q, $arr = [])
{
$stm = $this->prepare($q);
return $this->getresult($stm, $arr);
}
public function ins($q, $arr)
{
$stm = $this->prepare($q);
$stm->execute($arr);
return self::$pdo->lastInsertId();
}
public function upd($q, $arr)
{
$stm = $this->prepare($q);
$stm->execute($arr);
}
}