/** * 功能:数据库查询函数 * 参数:¥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; } }