database='ptymc';
else
$this->database=$_SESSION['sesDbname'];
}else
$this->database=$db;
///if(empty($db))
// $this->database='civil_cvc';
//else
// $this->database=$db;
//echo '
'.$this->database; exit;
//$_SESSION['sesDbname']='dika';
//echo $_SESSION['sesDbname'].'
';
//$_SESSION['sesDbname']='civil_ccvc';
$this->host = 'localhost';
$this->user = 'root';
$this->password = 'admin';
//$this->database=$this->database;
$this->link_con = mysql_connect($this->host, $this->user, $this->password) or die("Can't connect to server! ");
mysql_select_db($this->database, $this->link_con);
mysql_query ("SET NAMES 'tis620' ",$this->link_con);
}
function select_db($db){
$this->database=$db;
mysql_select_db($this->database, $this->link_con);
}
function send_cmd($query)
{
$prog=$_SERVER['PHP_SELF'];
$arr=explode('/', $prog);
//echo $query;
$this->select_db($this->database);
$this->sqlquery = "/*".$arr[sizeof($arr)-1]."*/".$query;
$msc=microtime(true);
$this->result = mysql_query("/*".$arr[sizeof($arr)-1]." ".date("H:i:s")." ".$_SESSION['sesUserName']."*/".$query, $this->link_con);
$msc=microtime(true)-$msc;
$this->ERRNO = mysql_errno();
$this->ERROR = mysql_error();
if($this->ERROR){
//echo __FILE__." at Line ".__LINE__;
echo $this->sqlquery."
";
echo $this->ERROR;
}
if(preg_match('/insert /i',$this->sqlquery) || preg_match('/delete /i',$this->sqlquery)|| preg_match('/update /i',$this->sqlquery)){
if($this->get_id())
return $this->get_id();
else
return $this->result;
}else{
$this->count = mysql_num_rows($this->result);
}
return $this->count;
}
function get_id ()
{
return mysql_insert_id($this->link_con);
}
function get_data()
{
return mysql_fetch_row($this->result);
}
function data_seek($torow)
{
return mysql_data_seek($this->result, $torow);
}
function get_column()
{
return mysql_fetch_field($this->result);
}
function num_columns()
{
return mysql_num_fields($this->result);
}
function column_name($index)
{
return mysql_field_name($this->result, $index);
}
function num_rows()
{
return $this->count;
}
function show_error()
{
echo $this->sqlquery . "
\n" . mysql_errno() . ":" . mysql_error();
}
function free_result()
{
mysql_free_result($this->result);
}
function close()
{
mysql_close($this->link_con);
}
function getdata_array(){
return mysql_fetch_array($this->result);
}
// ======= Stop method of class ===========
} // end of class
?>