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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
<?php
/**
* Mysqli Database Implementation
* @package Database
*/
class DB_Mysql_Driver extends DB
{
/**
* Mysqli database connection object
* @var mysqli
* @access public
* @link http://php.net/manual/en/class.mysqli.php
*/
public $conn;
/**
* Type of the database, mysql.
* @var string
* @access public
*/
public $db_type = 'mysql';
/**
* Initializes database connection
*
* @param string $config Name of the connection to initialize
* @return void
* @access public
*/
public function __construct($config)
{
$this->conn = mysqli_connect(
Config::get("database.{$config}.host", 'localhost'), Config::get("database.{$config}.user", ''), Config::get("database.{$config}.password", ''), Config::get("database.{$config}.db")
);
$this->conn->set_charset("utf8");
}
/**
* Gets column names for the specified table
*
* @param string $table Name of the table to get columns from
* @return array Array of column names
* @throw Exception if table doesn't exist
* @access public
*/
public function list_columns($table)
{
$columns = array();
$table_desc = $this->execute("DESCRIBE `$table`");
Debug::log($table_desc);
if (!$table_desc->valid())
{
throw new Exception("Table '{$table}' doesn't exist");
}
foreach ($table_desc as $column)
{
$columns[] = $column->Field;
}
return $columns;
}
/**
* Builds a new Query implementation
*
* @param string $type Query type. Available types: select,update,insert,delete,count
* @return Query_Mysql_Driver Returns a Mysqli implementation of a Query.
* @access public
* @see Query_Database
*/
public function build_query($type)
{
return new Query_Mysql_Driver($this, $type);
}
/**
* Gets the id of the last inserted row.
*
* @return mixed Row id
* @access public
*/
public function get_insert_id()
{
return $this->conn->insert_id;
}
/**
* Executes a prepared statement query
*
* @param string $query A prepared statement query
* @param array $params Parameters for the query
* @return Result_Mysql_Driver Mysqli implementation of a database result
* @access public
* @throws Exception If the query resulted in an error
* @see Database_Result
*/
public function execute($query, $params = array())
{
$cursor = $this->conn->prepare($query);
if (!$cursor)
{
throw new Exception("Database error: {$this->conn->error} \n in query:\n{$query}");
}
$types = '';
$bind = array();
$refs = array();
if (!empty($params))
{
foreach ($params as $key => $param)
{
$refs[$key] = is_array($param) ? $param[0] : $param;
$bind[] = &$refs[$key];
$types .= is_array($param) ? $param[1] : 's';
}
array_unshift($bind, $types);
call_user_func_array(array($cursor, 'bind_param'), $bind);
}
$cursor->execute();
$res = $cursor->get_result();
return new Result_Mysql_Driver($res);
}
}
|
