Je suis en tain de apprendre le php/MySql, mais je souhaite passer de MySql a MySqli, j'ai crée un petit projet avec une structure de code php/MySql, mais je ces vraiment pas comment convertir cette structure de code MySql en MySqli et gardez la structure actuel, je vous donne la structure de connexion et si vous pourriez me aider SVP.
email: [email protected]
Merci D'avance a vous tousse
Structure de code php/MySql de connexion:
<?php
class Dbase{
private $_host = "localhost";
private $_user = "root";
private $_password = "password";
private $_name = "dbname";
private $_conndb = FALSE;
public $_last_query = NULL;
public $_affected_rows = 0;
public $_insert_keys = array();
public $_insert_values = array();
public $_update_sets = array();
public $_id;
public function __construct(){
$this->connect();
}
private function connect(){
$this->_conndb = mysql_connect($this->_host,$this->_user,$this->_password);
if(!$this->_conndb){
die("Database connection failed:<br />".mysql_error());
}else{
$_select = mysql_select_db($this->_name,$this->_conndb);
if(!$_select){
die("Database selection failed:<br />".mysql_error());
}
}
mysql_set_charset("UTF-8", $this->_conndb);
}
public function close(){
if(!mysql_close($this->_conndb)){
die("Closing connection failed.");
}
}
public function escape($value){
if(function_exists("mysql_real_escape_string")){
if(get_magic_quotes_gpc()){
$value = stripslashes($value);
}
$value = mysql_real_escape_string($value);
}else{
if(!get_magic_quotes_gpc()){
$value = addslashes($value);
}
}
return $value;
}
public function query($sql){
$this->_last_query = $sql;
$result = mysql_query($sql, $this->_conndb);
$this->displayQuery($result);
return $result;
}
public function displayQuery($result){
if(!$result){
$output = "Database query failed: ".mysql_error()."<br />";
$output .= "Last SQL query was: ".$this->_last_query;
die($output);
}else{
$this->_affected_rows = mysql_affected_rows($this->_conndb);
}
}
public function fetchAll($sql){
$result = $this->query($sql);
$out = array();
while($row = mysql_fetch_assoc($result)){
$out[] = $row;
}
mysql_free_result($result);
return $out;
}
public function fetchOne($sql){
$out = $this->fetchAll($sql);
return array_shift($out);
}
public function lastId(){
return mysql_insert_id($this->_conndb);
}
}
