/**
* @package Database Class
* @author injection (mail:injection.mail@gmail.com)
* @version 1.0
*/
@ini_set( \'display_errors\',0 );
class DataBase{
 private $mDb_host,$mAb_user,$mAb_pwd,$mConn_No;
 function DataBase( $Conn_Obj ){
 $this->connectDb( $Conn_Obj );
 }
 function connectDb( $Conn_Obj ){
 $this->mDb_host = $Conn_Obj->host;
 $this->mAd_name = $Conn_Obj->user;
 $this->mAd_pwd = $Conn_Obj->pwd;
 $this->mConn_No = mysql_connect( $this->mDb_host, $this->mAd_name, $this->mAd_pwd );
 }
 function selectDb( $Conn_Obj ){
 $this->mDb_name = $Conn_Obj->dbname;
 mysql_select_db( $this->mDb_name );
 }
}
/**
* @package Making Sqls Class exetends Database Class
* @author injection (mail:injection.mail@gmail.com)
* @version 1.0
*/
class MakeSql extends DataBase{
 private $mSql;
 function MakeSql( $type,$arr_colum_list, $arr_sql_choice ){
 $this->MakeSqlType( $arr_colum_list, $arr_sql_choice );
 }
 //switch make list
 function MakeSqlType( $type, $arr_colum_list, $arr_sql_choice ){
 switch( $type ){
 case \'insert\':
 return $this->makeInsert( $arr_colum_list, $arr_sql_choice );
 case \'select\':
 return $this->makeSelect( $arr_colum_list, $arr_sql_choice );
 case \'update\':
 return $this->makeUpdate( $arr_colum_list, $arr_sql_choice );
 case \'delete\':
 return $this->makeDelete( $arr_colum_list, $arr_sql_choice );
 }
 }
 //make insert
 function makeInsert( $arr_colum_list,$arr_sql_choice ){
 $colum_key = array_keys( $arr_colum_list );
 $colum_value = array_values( $arr_colum_list );
 $this->mSql = \"INSERT INTO \".$arr_sql_choice[\"tbl_name\"].\"( \".join( \',\' , $colum_key ).\" ) VALUES( \'\".join( \"\',\'\" , $colum_value ).\"\')\";
 return $this->mSql;
 }
 //making select
 function makeSelect( $arr_colum_list = \'*\' , $arr_sql_choice ){
 $colum_value = array_keys( $arr_colum_list );
 foreach( $arr_sql_choice as $sql_key => $sql_value ){
 if( strcmp( $sql_key, \'tbl_name\' ) == 0 ){
 if( strcmp($arr_colum_list, \'*\' ) !== 0 )
  $this->mSql = \"SELECT \".join( \',\' , $colum_value ).\" FROM \".$sql_value;
 else
  $this->mSql = \"SELECT * FROM \".$sql_value;
 }
 else
 if( strcmp( $sql_value, \'\' ) !== 0 )
  if(strcmp( $sql_key, \'WHERE\' ) === 0 && strcmp( $sql_value, \'colum\' ) === 0 ){
  foreach($arr_colum_list As $colum_key => $colum_value )
  $this->mSql .= \"$colum_key = \'$colum_value\' AND \";
  $this->mSql = rtrim( $this->mSql, \" AND \" );
  }
  else
  $this->mSql .= \" $sql_key \".$sql_value;
 }
 return $this->mSql; 
 }
 //making update 
 function makeUpdate( $arr_colum_list, $arr_sql_choice ){
 $this->mSql = \"UPDATE \".$arr_sql_choice[\'tbl_name\'].\" SET \";
 foreach( $arr_colum_list as $colum_key => $colum_value )
 $this->mSql .= \"$colum_key = \'$colum_value\',\";
 $this->mSql = rtrim( $this->mSql , \',\');
 foreach( $arr_sql_choice as $sql_key => $sql_value ){
 if( strcmp( $sql_value, \'\' ) !== 0 && strcmp( $sql_key, \'tbl_name\' ) !==0 && strcmp( $sql_key, \'ORDER BY\' ) !== 0 )
  $this->mSql .= \" $sql_key \".$sql_value;
 }
 return $this->mSql;
 }
 //making delete
 function makeDelete( $arr_colum_list, $arr_sql_choice ){
 $this->mSql = \"DELETE FROM \".$arr_sql_choice[\'tbl_name\'];
 foreach( $arr_sql_choice as $sql_key => $sql_value ){
 if( strcmp( $sql_key, \'tbl_name\' ) !== 0 && strcmp( $sql_value, \'\' ) !== 0 ){
 $this->mSql .= \" $sql_key \".$sql_value;
 }
 }
 return $this->mSql;
 }
}