Доделал наконец то класс, вывожу результат вывода статического метода help
Functions list of db_con class
static function getInstance();
Create Singleton of the class
private function __construct();
Set's cache directory(place), and the cache extensions for file and variables cache
private function __clone();
Prevent object cloning
public function init_conn($db_uname,$db_pass,$db_name,$db_host='localhost',$db_cs='utf8',$special_escape ='x@x');
Initiates the connection variables
public function open_conn();
Open the connection
public function close_conn();
Kills and then closes the connection
public function get_sp_esc();
Get the CS from the class
public function set_sp_esc($value);
Sets the SC to the class
public function escape($thequery);
Escapes before do the query, using the special escape symbol you decide to use
public function do_query($thequery,$escape=0);
Do specified query, if escape is 1, it will use the escape function to do mysqli_real_escape
public function reset_bind();
Reset the types and params containers
public function var_bind(&$type,&$param);
Prepare the types and parameters, accepting varsiables one by one, adding them to array for func bind_params
public function ar_bind(&$type,&$param);
Prepare the types and parameters, accepting array
public function do_prepare($thequery);
Prepare the statement using ->prepare();
public function bind_params();
Bind the parameters with the function bind_param, before you use it, use ar_bin or var_bind functions, and of course after do_prepare
public function execute();
Executes the prepared statement with the binded parameters if there is...
public static function fetch_it($theresult,$type);
Fetch the result of a query, $type can be 'assoc', 'object', 'row', 'array' .
public function fetch_result($theresult);
Fetch the result with assoc method, for development purposes!
Usage Examples:
1. DEFINE('SC','x@x');
$db=db_con::getInstance();
$db->init_conn('root','lqsym','db1','localhost','utf8',SC);
$data=$db->do_query("INSERT INTO test (message) VALUES('".SC."".str_shuffle("abcdefghijklmnopqrstuvwxyz0123456789")."".SC."')",1);
$db->close_conn();
echo $db->reqs_num;
2.$db=db_con::getInstance();
$db->init_conn('root','lqsym','db1');
$db->do_prepare("INSERT INTO test (message,message2,message3,message4) VALUES(?,?,?,?)");
$db->reset_bind();
$types=array('s','s','s');
$vars=array('message1','message2','message3');
$db->ar_bind($types,$vars);
$onemore_t='s';
$onemore_v='cool';
$db->var_bind($onemore_t,$onemore_v);
$db->bind_params();
$db->execute();
$db->close_conn(); |
)
Мега!
