'); document.write('//ClsDatabase_DB
'); document.write('// $db=new ClsDatabase_db();$db->ClsDatabase_conn();
'); document.write(' class ClsDatabase__db{
'); document.write('    function ClsDatabase_conn($dbname="##database_name##"){
'); document.write('       mysql_connect ("localhost", "##username##", "##password##") or die (\'I cannot connect to the database because: \' . mysql_error());
'); document.write(' mysql_select_db ($dbname);
'); document.write('    }
'); document.write('    function ClsDatabase_query($query){
'); document.write('       $query = @mysql_query($query) or die(mysql_error());
'); document.write('       return $query;
'); document.write('    }
'); document.write('    function ClsDatabase_rs($query) {
'); document.write('       $query = @mysql_fetch_array($query);
'); document.write('       return $query;
'); document.write('    }
'); document.write(' function auto_id($tbl,$field,$strCondition="") {
'); document.write(' //GET THE MAXIMUM auto id of a table
'); document.write(' $strCondition=$strCondition=="" ? "" : "where $strCondition";
'); document.write(' $sql="Select MAX($field) as maxseq from $tbl $strCondition";
'); document.write(' $rowsMAX = mysql_fetch_array(mysql_query($sql));
'); document.write('    return $rowsMAX[\'maxseq\'] + 1;
'); document.write(' }
'); document.write(' function insert($table,$arrFieldValues,$debug=0)
'); document.write(' {
'); document.write(' /*
'); document.write(' INSERT record into database $table
'); document.write(' Example:
'); document.write(' $arrFieldValues=array("id" => 1, // leaving blank if this an auto increment field
'); document.write('    "user_fname" => "John",   //(or $_POST["user_fname"])
'); document.write('    "user_lname" => "Doe");
'); document.write(' insert("users",$arrFieldValues);
'); document.write(' If debug is set to 1, sql statement will be display
'); document.write(' */
'); document.write(' $arrFields=array_keys($arrFieldValues);
'); document.write(' $arrValues=array_values($arrFieldValues);
'); document.write(' $escVals=array();
'); document.write(' foreach ($arrValues as $val)
'); document.write(' {
'); document.write(' if(!is_numeric($val)) $val="\'".mysql_escape_string($val)."\'";
'); document.write(' $escVals[]=$val;
'); document.write(' }
'); document.write(' $sql="INSERT INTO $table (".join(\', \',$arrFields).") VALUES(".join(\', \',$escVals).")";
'); document.write(' if($debug) echo $sql;
'); document.write(' mysql_query($sql);
'); document.write(' return mysql_insert_id();
'); document.write(' }
'); document.write('
'); document.write(' function update($table,$arrFieldValues,$arrConditions,$debug=0)
'); document.write(' {
'); document.write(' /*
'); document.write(' UPDATE record into database $table
'); document.write(' Example:
'); document.write(' $arrFieldValues=array("id" => 1, // leaving blank if this an auto increment field
'); document.write('    "user_fname" => "John",   //(or $_POST["user_fname"])
'); document.write('    "user_lname" => "Doe");
'); document.write(' $arrConditions=array("user_lname" => "Doe");
'); document.write(' update("users",$arrFieldValues,$arrConditions);
'); document.write(' */
'); document.write(' $arrUpdates=array();
'); document.write(' foreach ($arrFieldValues as $field => $val)
'); document.write(' {
'); document.write(' if(!is_numeric($val)) $val="\'".mysql_escape_string($val)."\'";
'); document.write(' $arrUpdates[]= "$field = $val";
'); document.write(' }
'); document.write(' $arrWhere=array();
'); document.write(' foreach ($arrConditions as $field => $val){
'); document.write(' if(!is_numeric($val)) $val="\'".mysql_escape_string($val)."\'";
'); document.write(' $arrWhere[]= "$field = $val";
'); document.write(' }
'); document.write(' $sql="UPDATE $table SET ".join(\', \',$arrUpdates)." WHERE ".join(\' AND \',$arrWhere);
'); document.write(' if($debug) echo $sql;
'); document.write(' return mysql_query($sql);
'); document.write(' }
'); document.write('
'); document.write(' function delete($table,$arrConditions)
'); document.write(' {
'); document.write('
'); document.write(' $arrWhere=array();
'); document.write(' foreach ($arrConditions as $field => $val)
'); document.write(' {
'); document.write(' if(!is_numeric($val)) $val="\'".mysql_escape_string($val)."\'";
'); document.write(' $arrWhere[]= "$field = $val";
'); document.write(' }
'); document.write('    $sql="DELETE FROM $table WHERE ".join(\' AND \',$arrWhere);
'); document.write(' $hRes=mysql_query($sql);
'); document.write(' return mysql_affected_rows($hRes);
'); document.write(' }
'); document.write('
'); document.write('
'); document.write(' function boolDuplicate($table,$arrConditions)
'); document.write(' {
'); document.write(' //CHECK for duplicate record with the same conditions
'); document.write(' $arrWhere=array();
'); document.write(' foreach ($arrConditions as $field => $val)
'); document.write(' {
'); document.write(' if(!is_numeric($val)) $val="\'".mysql_escape_string($val)."\'";
'); document.write(' $arrWhere[]= "$field = $val";
'); document.write(' }
'); document.write(' $sql="SELECT * FROM $table WHERE ".join(\' AND \',$arrWhere);
'); document.write(' $hRes=mysql_query($sql);
'); document.write(' if(mysql_num_rows(mysql_query($sql))>0)
'); document.write(' return 1;
'); document.write(' else
'); document.write(' return 0;
'); document.write(' }
'); document.write(' function getOne($tbl,$field,$strCondition="",$debug=0)
'); document.write(' {
'); document.write(' // GET data for a single record
'); document.write(' // EXAMPLE: getOne("users","user_fname","id=1")
'); document.write(' $strCondition=$strCondition=="" ? "" : "where $strCondition";
'); document.write(' $sql="Select $field as fieldReturn from $tbl $strCondition";
'); document.write(' if($debug) echo $sql;
'); document.write(' $rowsReturn = mysql_fetch_array(mysql_query($sql));
'); document.write('    return $rowsReturn["fieldReturn"];
'); document.write(' }
'); document.write('    function getAllRows($sql,$debug=0)
'); document.write('    {
'); document.write('    //GET ALL RECORDS based on the $sql statement, return an array
'); document.write('       if($debug) echo $sql;
'); document.write('       $result=mysql_query($sql);
'); document.write(' while($rows = mysql_fetch_array($result))
'); document.write(' $rowsReturn[]=$rows;
'); document.write(' return $rowsReturn;
'); document.write('    }
'); document.write('
'); document.write('    function getRow($sql,$debug=0)
'); document.write('    {
'); document.write('    //GET 1 Record base on the $sql statment
'); document.write('       if($debug) echo $sql;
'); document.write(' return mysql_fetch_array(mysql_query($sql));
'); document.write('    }
'); document.write(' function getArray($tbl,$field,$strCondition="",$delimeter="#",$debug=0)
'); document.write(' {
'); document.write(' //GET a concatenate string with the delimeter
'); document.write(' // EXAMPLE: getArray("users","user_fname","",",") => John,Mary
'); document.write(' $strCondition=$strCondition=="" ? "" : "where $strCondition";
'); document.write(' $sql="Select $field as fieldReturn from $tbl $strCondition ORDER BY $field";
'); document.write(' if($debug) echo $sql;
'); document.write(' $result=mysql_query($sql);
'); document.write(' while($rowsReturn = mysql_fetch_array($result)) $lstReturn.=$rowsReturn["fieldReturn"].$delimeter;
'); document.write('    return "#".$lstReturn;
'); document.write(' }
'); document.write(' function ClsDatabase_die(){ mysql_close(); }
'); document.write('}
'); document.write('