بسم الله الرحمن الرحيم
كلاس اتعامل مع قاعدة بيانات بسيط
كود PHP:
<?php
/**
* ##############################################
* ##برمجة محمدهلال ##
* ##جميع الحقوق محفوظة لي محمدهلال ##
* ## mohamedhelal ##
* ##all rights to mohamedhelal ##
* ##email:mohamed_helal123456@hotmail.com ##
* ##############################################
*/
class dbclass{
protected $host =FALSE;
protected $username =FALSE;
protected $password =FALSE;
protected $dbname =FALSE;
protected $PCON =FALSE;
protected $RESULTID =FALSE;
function __construct($host,$username,$pass,$db,$pco=false){
$this->host =$host;
$this->username =$username;
$this->password =$pass;
$this->dbname =$db;
$this->PCON =$pco;
$this->__conected();
$this->__contentdb();
}
function __conected(){
if($this->PCON===true){
@mysql_pconnect($this->host,$this->username,$this->password)or die("ERROR Mysql Conected To Server");
}else{
@mysql_connect($this->host,$this->username,$this->password)or die("ERROR Mysql Conected To Server");
}
}
function __contentdb(){
@mysql_select_db($this->dbname)or die("ERROR Can not fount db");
}
function sql_read($sql){
$this->RESULTID=@mysql_query($sql);
return $this;
}
function sql_write($sql){
$this->RESULTID=@mysql_query($sql);
return $this;
}
function num_rows(){
return @mysql_num_rows($this->RESULTID);
}
function row_array(){
return @mysql_fetch_assoc($this->RESULTID);
}
function result_array(){
$rows=array();
foreach($this->row_array() as $row){
$rows[]=$row;
}
return $rows;
}
function affected_rows(){
return @mysql_affected_rows();
}
function insert_id(){
return @mysql_insert_id();
}
function free_result(){
@mysql_free_result($this->RESULTID);
}
}
?>
اخوكم محمد هلال