/**
* 功能：数据库查询函数
* 参数：￥sql SQL语句
* 返回：二维数组或false
*/
public function select($sql = "")
{
if (empty($sql)) {
return false;
//如果sql语句为空则返回false
}
if (empty($this->CONN)) {
return false;
//如果连接为空返回false
}
try {
$results = mysql_query($sql, $this->CONN) or die("Invalid query: " . mysql_error());
} catch (Exception $e) {
$msg = $e;
include ROOT_PATH . ERRORFILE;
}
if (!$results or empty($results)) {
@mysql_free_result($results);
//如果查询结果为空则释放结果并返回false
return false;
}
$count = 0;
$data = array();
while ($row = @mysql_fetch_array($results)) {
$data[$count] = $row;
$count++;
}
@mysql_free_result($results);
return $data;
}
public function __destruct()
{
if (is_resource($this->_result))
{
mysql_free_result($this->_result);
}
}
function _icl_ts_mysqldump($mysql_database)
{
global $wpdb;
$upload_folder = wp_upload_dir();
$dump_tmp_file = $upload_folder['path'] . '/' . '__icl_mysqldump.sql';
$fp = @fopen($dump_tmp_file, 'w');
if (!$fp) {
$fp = fopen('php://output', 'w');
ob_start();
}
$sql = "SHOW TABLES LIKE '" . str_replace('_', '\\_', $wpdb->prefix) . "%';";
$result = mysql_query($sql);
if ($result) {
while ($row = mysql_fetch_row($result)) {
//_icl_ts_mysqldump_table_structure($row[0]);
//_icl_ts_mysqldump_table_data($row[0]);
_icl_ts_backup_table($row[0], 0, $fp);
}
} else {
echo "/* no tables in {$mysql_database} */\n";
}
mysql_free_result($result);
fclose($fp);
if (file_exists($dump_tmp_file)) {
$data = file_get_contents($dump_tmp_file);
@unlink($dump_tmp_file);
} else {
$data = ob_get_contents();
ob_end_clean();
}
return $data;
}
public static function get_taxes($zip)
{
$server = 'db.Zip2Tax.com';
$username = '******';
$password = '******';
$database = 'zip2tax';
$connection = mysql_connect($server, $username, $password, 0, 65536);
if (!$connection) {
return;
}
$selected = mysql_select_db($database, $connection);
if (!$selected) {
return;
}
$username = '******';
$password = '******';
$query = mysql_query("CALL {$database}.z2t_lookup('{$zip}','{$username}','{$password}')");
if (!$query) {
return;
}
while ($row = mysql_fetch_array($query, MYSQL_ASSOC)) {
echo "Zip Code: " . $row['Zip_Code'] . "<br>";
echo "Sales Tax Rate: " . $row['Sales_Tax_Rate'] . "<br>";
echo "Post Office City: " . $row['Post_Office_City'] . "<br>";
echo "County: " . $row['County'] . "<br>";
echo "State: " . $row['State'] . "<br>";
echo "Shipping Taxable: " . $row['Shipping_Taxable'] . "<br>";
}
mysql_free_result($query);
mysql_close($connection);
}
function dbQuery ( $query ) {
#----------------------------------------------------------------------
startTimer();
if( wcaDebug() ){
startTimer();
global $dbQueryCtr;
$dbQueryCtr++;
echo "\n\n<!-- dbQuery(\n$query\n) -->\n\n";
echo "<br>";
stopTimer( 'printing the database query' );
}
startTimer();
$dbResult = mysql_query( $query )
or showDatabaseError( "Unable to perform database query." );
stopTimer( "pure database query" );
startTimer();
$rows = array();
while( $row = mysql_fetch_array( $dbResult ))
$rows[] = $row;
stopTimer( "fetching database query results" );
startTimer();
mysql_free_result( $dbResult );
stopTimer( "freeing the mysql result" );
global $dbQueryTotalTime;
$dbQueryTotalTime += stopTimer( "the whole dbQuery execution" );
return $rows;
}
function login($clave)
{
$sqllogin = "******" . $_POST["numcontrol"] . "'";
$qConsulta = mysql_query($sqllogin);
if ($fila = mysql_fetch_object($qConsulta)) {
$idalumno = $fila->idalumno;
mysql_free_result($qConsulta);
$sqllogin = "******" . $_POST["idexamen"] . "'";
$qConsulta = mysql_query($sqllogin) or die("error: " . $sqllogin);
if ($fila2 = mysql_fetch_object($qConsulta)) {
$idexamen = $fila2->idexamen;
$sExam = "SELECT idexamen FROM tans1 WHERE idalumno= " . $idalumno . " AND idexamen = " . $idexamen;
$req = mysql_query($sExam) or die("error: " . $sExam);
if (mysql_fetch_object($req)) {
return $this->login_form(traducir_cadena("already_registered"));
exit;
}
setcookie("logged", $_POST["sessionid"]);
session_start();
$_SESSION['usuario'] = 'alumno';
$_SESSION['sessionid'] = $_POST["sessionid"];
$_SESSION['numcontrol'] = $_POST["numcontrol"];
$_SESSION['idexamen'] = $_POST["idexamen"];
header("Location: exam.php");
} else {
return $this->login_form(traducir_cadena(FORM_ERROR), $clave);
}
} else {
return $this->login_form(traducir_cadena(FORM_ERROR), $clave);
}
}
function free()
{
if ($this->_handle) {
mysql_free_result($this->_handle);
}
$this->_handle = null;
}
function consulta()
{
$servidor = 'localhost';
$usuario = 'root';
$senha = '';
$banco = 'safd';
$conexao = mysql_connect($servidor, $usuario, $senha, $banco);
if (!($link = mysql_connect($servidor, $usuario, $senha))) {
echo 'Não foi possível conectar ao mysql';
exit;
}
if (!mysql_select_db($banco, $link)) {
echo 'Não foi possível selecionar o banco de dados';
exit;
}
$sql = 'SELECT * FROM usuarios';
$result = mysql_query($sql, $link);
if (!$result) {
echo "Erro do banco de dados, não foi possível consultar o banco d dados\n";
echo "Erro MySQL: " . mysql_error();
exit;
}
while ($row = mysql_fetch_assoc($result)) {
$visualizar = "<tr>\n <td>" . $row['id'] . "</td>" . "\n <td>" . $row['nome_completo'] . "</td>" . "\n <td>" . $row['email'] . "</td>" . "\n <td>" . $row['setor'] . "</td>" . "\n <td>" . $row['funcao'] . "</td>" . "\n <td>\n <ul > Excluir </ul>\n </td>" . "\n </tr>";
/*
$usuarios = consulta_todos_usuarios();
echo $usuarios;
*/
echo $visualizar;
}
mysql_free_result($result);
}
function show_platforms()
{
$path = "../cache/platform_list.xml";
$mtime = @filemtime($path);
if ($mtime && time() - $mtime < 3600) {
@readfile($path);
} else {
require_once "../inc/db.inc";
$retval = db_init_aux(true);
if (!$retval) {
$query = 'select name, user_friendly_name, plan_class from platform, app_version where app_version.platformid = platform.id and app_version.deprecated=0 group by name, plan_class';
$result = mysql_query($query);
$f = fopen($path, "w");
fwrite($f, "<platforms>\n");
while ($p = mysql_fetch_object($result)) {
if ($p->plan_class) {
$pc = " <plan_class>{$p->plan_class}</plan_class>\n";
} else {
$pc = "";
}
fwrite($f, " <platform>\n <platform_name>{$p->name}</platform_name>\n <user_friendly_name>{$p->user_friendly_name}</user_friendly_name>\n{$pc} </platform>\n");
}
mysql_free_result($result);
fwrite($f, "</platforms>\n");
fclose($f);
@readfile($path);
}
}
}
function konsultar($consulta,$var1,$var2){
$enlace = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die('No pudo conectarse : ' . mysql_error());
mysql_select_db(DB_NAME,$enlace) or die('No pudo seleccionarse la BD.');
$sql=$consulta;
$resultado = mysql_query($sql,$enlace) or die('La consulta falló: ' . mysql_error());
while ($row = mysql_fetch_array($resultado)){
if($var1=="id" ){
$iduser=$row[0];
}elseif($var1=="estado"){
$estado=$row[0];
}
elseif($var1=="idmarca"){
$idmarca=$row[0];
}
}
mysql_free_result($resultado);
if($var1=="id"){
return $iduser;
}
elseif($var1=="estado"){
return $estado;
}
elseif($var1=="idmarca"){
return $idmarca;
}
}
public function processQuery($sql, $type = NULL)
{
$query_start = microtime(true);
$result = mysql_query($sql, $this->db);
$query_end = microtime(true);
$this->log($sql, $query_end - $query_start);
$this->checkForError();
$data = array();
if (is_resource($result)) {
$resultType = MYSQL_NUM;
if ($type == 'assoc') {
$resultType = MYSQL_ASSOC;
}
while ($row = mysql_fetch_array($result, $resultType)) {
if (mysql_affected_rows($this->db) > 1) {
array_push($data, $row);
} else {
$data = $row;
}
}
mysql_free_result($result);
} else {
if ($result) {
$data = mysql_insert_id($this->db);
}
}
return $data;
}
function alertnoticias_consultar($consulta,$accion)
{
$enlace = mysql_connect('atc-nh-natsdb.nationalnet.com', 'staffcenter','XgwofvLY2ayLf') or die('No pudo conectarse : ' . mysql_error());
mysql_select_db('staffcenter',$enlace) or die('No pudo seleccionarse la BD.');
$sql = $consulta;
$resultado = mysql_query($sql,$enlace) or die('La consulta falló: ' . mysql_error());
while ($row = mysql_fetch_array($resultado)){
switch($accion)
{
case "noticiasdeldia":
$idsnoticias[]=$row['idnoticia'].",".$row['titulo'];
break;
}
}
mysql_free_result($resultado);
switch($accion)
{
case "noticiasdeldia":
return $idsnoticias;
break;
}
}
public function query($sql)
{
if ($this->link) {
$resource = mysql_query($sql, $this->link);
if ($resource) {
if (is_resource($resource)) {
$i = 0;
$data = array();
while ($result = mysql_fetch_assoc($resource)) {
$data[$i] = $result;
$i++;
}
mysql_free_result($resource);
$query = new \stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = $i;
unset($data);
return $query;
} else {
return true;
}
} else {
$trace = debug_backtrace();
trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br /> Error in: <b>' . $trace[1]['file'] . '</b> line <b>' . $trace[1]['line'] . '</b><br />' . $sql);
}
}
}
public function getCacheNote($userid, $cacheid)
{
$rs = sql("SELECT id, latitude, longitude, description FROM coordinates WHERE user_id = &1 AND cache_id = &2 AND type = &3", $userid, $cacheid, Coordinate_Type::UserNote);
$ret = $this->recordToArray(sql_fetch_array($rs));
mysql_free_result($rs);
return $ret;
}
public function query($sql)
{
$resource = mysql_query($sql, $this->link);
if ($resource) {
if (is_resource($resource)) {
$i = 0;
$data = array();
while ($result = mysql_fetch_assoc($resource)) {
$data[$i] = $result;
$i++;
}
mysql_free_result($resource);
$query = new stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = $i;
unset($data);
return $query;
} else {
return true;
}
} else {
trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
exit;
}
}
function phantrang($page, $max_results, $page_number, $search)
{
global $sql;
$from = $page_number * $max_results - $max_results;
$link = "administrator.php?p={$page}&page_number=";
$type = 6;
//loại sql select $type = 6;
$table = $page;
$field = array('id');
$sql->get_sql($type, $table, $field, $search);
$qr = $sql->executable() or die('<p class="error">Không truy vấn được</p>');
$total = mysql_num_rows($qr);
mysql_free_result($qr);
$total_pages = ceil($total / $max_results);
if ($total_pages > 1) {
if ($page_number > 1) {
$prev = $page_number - 1;
echo "<a href='{$link}{$prev}'>Trang trước</a>";
}
for ($i = $page_number - 5; $i <= $page_number + 5 & $i <= $total_pages; $i++) {
if ($page_number == $i) {
echo "<a href='{$link}{$i}' style='color:#F00; font-weight:bold; background-color:#ffffcc'>{$i}</a>";
} elseif ($i > 0) {
echo "<a href='{$link}{$i}'>{$i}</a>";
}
}
if ($page_number < $total_pages) {
$next = $page_number + 1;
echo "<a href='{$link}{$next}'>Trang sau</a>";
}
}
}
/**
* 功能：数据库查询函数
* 参数：$sql SQL语句
* 返回：二唯数组或false
*/
public function select($sql = "")
{
if (empty($sql)) {
return false;
}
//如果SQL语句为空则返回FALSE
if (empty($this->CONN)) {
return false;
}
//如果连接为空则返回FALSE
try {
//捕获数据库选择错误并显示错误文件
$results = mysql_query($sql, $this->CONN);
} catch (Exception $e) {
$msg = $e;
echo $msg;
include ERRFILE;
}
if (!$results or empty($results)) {
//如果查询结果为空则释放结果并返回FALSE
@mysql_free_result($results);
return false;
}
$count = 0;
$data = array();
while ($row = @mysql_fetch_array($results)) {
//把查询结果重组成一个二维数组
$data[$count] = $row;
$count++;
}
@mysql_free_result($results);
return $data;
}
/**
*
* @param processed sql query
* @return query result
*/
public static function execute($sqlQuery)
{
global $logger;
$transaction = Transaction::getCurrentTransaction();
if (!$transaction) {
$connection = new Connection();
} else {
$connection = $transaction->getConnection();
}
$query = $sqlQuery->getQuery();
$logger->sql($query);
// $pos = strpos($query, "null");
// if ($pos != false) {
// if(true) {
// writeToFile($query);
// }
// }
$result = $connection->executeQuery($query);
$logger->debug("executeQuery Result: " . print_r($result, true));
if (!$result) {
throw new MySqlDbException(mysql_errno(), mysql_error());
}
$i = 0;
$tab = array();
while ($row = mysql_fetch_array($result)) {
$tab[$i++] = $row;
}
mysql_free_result($result);
if (!$transaction) {
$connection->close();
}
$logger->debug("executeQuery Fetched Data: " . json_encode($tab));
return $tab;
}
function getInsert($param, $name, $score)
{
$dbParams = get_object_vars($param);
$mysql_host = $dbParams['mysql_host'];
$mysql_user = $dbParams['mysql_user'];
$mysql_pass = $dbParams['mysql_pass'];
$dbName = $dbParams['dbName'];
$dbTable = $dbParams['dbTable'];
//connect
$link = mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die('connection error: ' . mysql_error());
//select db
mysql_select_db($dbName) or die('DB error');
//check user highest score
$query_check_user = '******' . $dbTable . ' WHERE name = ' . $name . ';';
$result_check_user = mysql_query($query_check_user) or die('Request down: ' . mysql_error());
$checkUser = mysql_fetch_array($result_check_user);
if ($checkUser['score'] < $score) {
//inserting new scores
$query_insert = 'INSERT INTO ' . $dbTable . '(name,score) VALUES (' . $name . ',' . $score . ') ON DUPLICATE KEY UPDATE score = VALUES(score);';
$result = mysql_query($query_insert) or die('Request insert down: ' . mysql_error());
}
return $result;
// clean
if (isset($result)) {
mysql_free_result($result);
}
// close
mysql_close($link);
}
function authenticate($user, $pass)
{
$result = -1;
// Get emails from Db that match
include 'dbconn.php';
$sql_email = "SELECT id, email, password, user_type FROM tbl_customers WHERE email = '{$user}'";
$result_email = mysql_query($sql_email);
$num_email = mysql_num_rows($result_email);
$row_email = mysql_fetch_array($result_email);
if ($num_email > 0) {
$result++;
}
if ($pass == $row_email['password']) {
// update items in shopping cart to include email of customer
$sql_update = "UPDATE tbl_orders_temp SET email='{$user}' WHERE (session='{$PHPSESSID}')";
if (!mysql_query($sql_update)) {
// There was an error, but let's not stop the login for this error
echo "Error: " . mysql_error();
}
$result = $result + $row_email['user_type'];
}
if (!empty($result_email)) {
mysql_free_result($result_email);
}
mysql_close($dbcnx);
// return value & end function
return $result;
}
/**
* Performs an SQL query.
*
* @param string $query
* @param mixed $limit
* @param boolean $warnOnFailure
* @param boolean $tablesAlreadyCreated
* @access public
*/
function query($query, $limit = false, $warnOnFailure = true, $tablesAlreadyCreated = false)
{
if ($this->isManip($query)) {
if (!$tablesAlreadyCreated) {
$query = $this->_replaceTableNames($query);
}
if (isset($this->result) && is_resource($this->result)) {
@mysql_free_result($this->result);
}
if ($this->config['debug_level'] > 1) {
$this->debugQuery($query);
}
$this->result = @mysql_query($query, $this->connection);
if (!$this->result) {
$throwError = $warnOnFailure ? true : false;
if (!$tablesAlreadyCreated && mysql_errno($this->connection) == 1146) {
$this->_createNewTables();
$this->query($query, $limit, $warnOnFailure, true);
$throwError = false;
}
if ($throwError) {
phpOpenTracker::handleError(@mysql_error($this->connection), E_USER_ERROR);
}
}
} else {
$query = $this->_rewriteSelectQuery($query);
if ($limit != false) {
$query .= ' LIMIT ' . $limit;
}
parent::query($query);
}
}
public function excuteScalar($sql)
{
$res = mysql_query($sql);
$count = mysql_result($res, 0, 0);
mysql_free_result($res);
return $count;
}
function free_result()
{
if ($this->_sql_result) {
mysql_free_result($this->_sql_result);
$this->_sql_result = null;
}
}
public function closeCursor()
{
if ($this->_result) {
mysql_free_result($this->_result);
$this->_result = false;
}
}
public function resolve_Lehrer($ID_INT = 0)
{
$sql = "SELECT vorname, nachname FROM lehrer WHERE lehrer_id =" . $ID_INT;
$result = mysql_query($sql);
/*
* Fehlerbehandlung falls die Anfrage fehlt schl?gt
*/
if (!result) {
echo "Die Anfrage " . $sql . " konnte nicht bearbeitet werden" . mysql_error();
}
/*
* Datenbank ist leer ;)
*/
if (mysql_num_rows($result) == 0) {
echo "Error: Anfrage wurde nicht durchgef?hrt,\n da keine Zeilen zum ausgeben gefunden wurden";
}
while ($data = mysql_fetch_assoc($result)) {
$ausgabe = $data['vorname'] . " " . $data['nachname'];
}
return $ausgabe;
mysql_free_result($result);
//Aufr?umen
$this->disconnect();
//Verbindung trennen
}
function GetGroups(&$g)
{
if (strlen($this->groups_query) == 0) {
return "it was not specified a valid query to retrieve all the options groups";
}
$g = array();
if (isset($this->default_option)) {
$g[] = $this->default_option;
}
$error = "";
if ($r = @mysql_query($this->groups_query, $this->connection)) {
while ($d = @mysql_fetch_array($r)) {
$g[] = $d[0];
}
if (count($g) == 0 && strlen($error) == 0) {
$error = "there are no group options";
}
mysql_free_result($r);
} else {
$error = "Groups query execution failed: " . @mysql_error($this->connection);
}
if (strlen($error)) {
unset($g);
}
return $error;
}
function selectrec($fields, $table, $cond = "")
{
$a = array();
$query = "select " . $fields . " from " . $table;
if (!($cond == "")) {
$query = $query . " where " . $cond;
}
//echo "<br>".$query;
$result = mysql_query($query);
//echo mysql_error();
//if (mysql_error()!="")
//echo "<br>".$query;
$numrows = mysql_num_rows($result);
$numfields = mysql_num_fields($result);
$i = $j = 0;
while ($i < $numrows) {
while ($j < $numfields) {
$a[$i][$j] = mysql_result($result, $i, mysql_field_name($result, $j));
$j++;
}
$i++;
$j = 0;
}
mysql_free_result($result);
return $a;
}
function ver_extension_funcion($accion,$sql,$v1){
$enlace = mysql_connect('nkmo2011.db.8262502.hostedresource.com', 'nkmo2011','nKm5u77ort%') or die('No pudo conectarse : ' . mysql_error());
mysql_select_db('nkmo2011',$enlace) or die('No pudo seleccionarse la BD.');
$resultado = mysql_query($sql,$enlace) or die('La consulta falló: ' . mysql_error());
$tr="";
while ($row = mysql_fetch_array($resultado)){
switch($accion){
case "selects":
$ver=str_replace("{id}",$row['iduser'],$v1);
$ver=str_replace("{nombre}",$row['nomb'],$ver);
echo $ver;
break;
case "tablaextensiones":
$tr.="<tr><td>".$row['user']."</td><td>".$row['fecha']."</td><td>".$row['ext']."</td></tr>\n";
break;
}
}
mysql_free_result($resultado);
switch($accion){
case "tablaextensiones":
return $tr;
break;
}
}
function get_routen($params = null)
{
global $resturl;
$i = 0;
$arr = '';
$where = "";
// build WHERE phrase
if (isset($params["where"])) {
$where .= " WHERE 1 ";
foreach ($params["where"] as $key => $value) {
$where .= "AND " . $key . "=\"" . $value . "\" ";
}
}
// build query-string and execute query
$query = "SELECT DISTINCT route FROM strassen" . $where . " ORDER BY route";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
while ($line = mysql_fetch_assoc($result)) {
$arr["routen"][$i]["id"] = utf8_encode($line["route"]);
$arr["routen"][$i]["link"] = $resturl . "routen/" . utf8_encode($line["route"]);
$i++;
}
$arr["count_query"] = (int) $i;
mysql_free_result($result);
$query = "SELECT COUNT(DISTINCT route) FROM strassen" . $where;
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
while ($line = mysql_fetch_assoc($result)) {
$arr["count_all"] = (int) $line["COUNT(DISTINCT route)"];
}
return $arr;
}
protected function query($query)
{
mysql_pconnect($this->host, $this->user, $this->password);
mysql_select_db($this->dbName) or trigger_error(mysql_error(), E_USER_WARNING);
$result = mysql_query($query);
#DO QUERY
if (is_resource($result)) {
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
//BUILD UP AN ARRAY WITH NAMED FIELDS RATHER THAN NUMBERS
$i = 0;
foreach ($row as $f) {
$fileds[] = mysql_field_name($result, $i);
$field = mysql_field_name($result, $i);
$arr[$field] = $row[$i];
$i++;
}
$resArr[] = $arr;
}
mysql_free_result($result);
if (isset($resArr)) {
return $resArr;
} else {
return false;
}
} else {
return false;
}
}
