public function &query($sql)
{
if ($this->echo_sql) {
echo $sql;
}
$this->reset_vars();
if ($this->connected === false) {
$this->_debug_info('database connection has not been established!');
return false;
}
global $g_db_log_file;
if ($g_db_log_file) {
$f_start = get_microtime();
}
$this->_qresult = mysql_query($sql, $this->_db);
if ($g_db_log_file) {
$f_length = get_microtime() - $f_start;
$str = chr(13) . chr(10) . now() . " " . $_SERVER['SCRIPT_NAME'] . " execute sql: ({$f_length}ms)" . $sql;
write_to_file($g_db_log_file, $str);
}
if ($this->_qresult === FALSE) {
$this->_debug_info('fail to query db!' . $this->get_error() . ";query string = " . $sql);
write_log('fail to execute sql!' . $this->get_error() . ";query string = " . $sql);
return FALSE;
} else {
//get the recrod count
$this->record_count = mysql_num_rows($this->_qresult);
if ($this->_move_first() === false) {
return $data_set;
}
do {
$item = new database_row_item_class($this);
$item->load_from_dataset();
$this->data_set[] = $item;
} while ($this->_move_next());
return $this->data_set;
}
}
public function &query($sql)
{
if ($this->echo_sql) {
echo $sql;
}
$this->reset_vars();
if ($this->connected === false) {
$this->_debug_info('database connection has not been established!');
return false;
}
global $g_db_log_file;
if ($g_db_log_file) {
$f_start = get_microtime();
}
$this->_qresult = sqlsrv_query($this->_db, $sql);
if ($g_db_log_file) {
$f_length = get_microtime() - $f_start;
$str = chr(13) . chr(10) . now() . " " . $_SERVER['SCRIPT_NAME'] . " execute sql: ({$f_length}ms)" . $sql;
write_to_file($g_db_log_file, $str);
}
if ($this->_qresult === FALSE) {
$this->_debug_info('fail to query db!' . $this->get_error() . ";query string = " . $sql);
return FALSE;
} else {
//get the recrod count
$this->record_count = 0;
while ($this->_aresult = sqlsrv_fetch_array($this->_qresult, SQLSRV_FETCH_ASSOC)) {
$item = new database_row_item_class($this);
$item->load_from_dataset($this->_db);
$this->record_count++;
$this->data_set[] = $item;
}
sqlsrv_free_stmt($this->_qresult);
return $this->data_set;
}
}
