CRUD vs Func

zero50x

Sep 24th, 2015

178

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

PHP 2.17 KB | None | 0 0

raw download clone embed print report

<?php
**************************************************
********************** CRUD **********************
**************************************************
class MyDB{
private $db = null;
private $result = null;
public function __construct($host, $user, $password, $base, $port = null, $charset = 'utf8')
{
$this->db = new mysqli($host, $user, $password, $base, $port);
$this->db->set_charset($charset);
}
public function query($query)
{
if(!$this->db)
return false;
if(is_object($this->result))
$this->result->free();
$this->result = $this->db->query($query);
if($this->db->errno)
die("mysqli error #".$this->db->errno.": ".$this->db->error);
if(is_object($this->result)){
while($row = $this->result->fetch_assoc())
$data[] = $row;
return $data;
}
else if($this->result == FALSE)
return false;
else return $this->db->affected_rows;
}
}
//Используем так:
$db = new MyDB("localhost", "user", "pass", "db");
$data = $db->query("SELECT * FROM `0_unique`");
print_r($data);
**************************************************
********************** FUNC **********************
**************************************************
function dbselect($query){
//Подключаюсь к БД
$link = mysqli_connect("localhost", 'user', 'pass', 'db') or die('Ошибка соединения: ' . mysqli_connect_error());
mysqli_set_charset($link, 'utf8');
//Запрос SLECT
$res = mysqli_query($link, "$query");
if($res) {
$myres = array();
while($row = mysqli_fetch_assoc($res)) { $myres[] = $row; }
}
return $myres;
}
$query = "SELECT * FROM `0_unique`";
$result = dbselect($query);
print_r($result);
?>

Add Comment

Please, Sign In to add comment