本文整理汇总了PHP中mysql_free_result函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_free_result函数的具体用法?PHP mysql_free_result怎么用?PHP mysql_free_result使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_free_result函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: select
/**
* 功能:数据库查询函数
* 参数:¥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;
}
开发者ID:dalinhuang,项目名称:cst-gko100,代码行数:35,代码来源:db.inc.php
示例2: __destruct
public function __destruct()
{
if (is_resource($this->_result))
{
mysql_free_result($this->_result);
}
}
开发者ID:nasumi,项目名称:fuel,代码行数:7,代码来源:result.php
示例3: _icl_ts_mysqldump
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;
}
开发者ID:nuevomediagroup,项目名称:nmg-code,代码行数:32,代码来源:functions-troubleshooting.php
示例4: get_taxes
public static function get_taxes($zip)
{
$server = 'db.Zip2Tax.com';
$username = 'z2t_link';
$password = 'H^2p6~r';
$database = 'zip2tax';
$connection = mysql_connect($server, $username, $password, 0, 65536);
if (!$connection) {
return;
}
$selected = mysql_select_db($database, $connection);
if (!$selected) {
return;
}
$username = 'sample';
$password = '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);
}
开发者ID:helpfulrobot,项目名称:sunnysideup-ecommerce-tax,代码行数:31,代码来源:Zip2Tax.php
示例5: dbQuery
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;
}
开发者ID:neodude,项目名称:worldcubeassociation.org,代码行数:34,代码来源:_database.php
示例6: login
function login($clave)
{
$sqllogin = "SELECT idalumno, numcontrol,nombre FROM talumnos WHERE numcontrol = '" . $_POST["numcontrol"] . "'";
$qConsulta = mysql_query($sqllogin);
if ($fila = mysql_fetch_object($qConsulta)) {
$idalumno = $fila->idalumno;
mysql_free_result($qConsulta);
$sqllogin = "SELECT idexamen FROM texamenes WHERE claveexamen = '" . $_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);
}
}
开发者ID:pelao88,项目名称:evaluaciones,代码行数:31,代码来源:model_exam.php
示例7: free
function free()
{
if ($this->_handle) {
mysql_free_result($this->_handle);
}
$this->_handle = null;
}
开发者ID:fchaose,项目名称:qeephp,代码行数:7,代码来源:mysql.php
示例8: consulta
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);
}
开发者ID:lenonr,项目名称:dev_bootstrap,代码行数:32,代码来源:consulta_usuarios.php
示例9: show_platforms
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);
}
}
}
开发者ID:nicolas17,项目名称:boincgit-test,代码行数:29,代码来源:get_project_config.php
示例10: konsultar
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;
}
}
开发者ID:rommelxcastro,项目名称:CRI-Online-Sales---Admin,代码行数:28,代码来源:header.php
示例11: processQuery
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;
}
开发者ID:pontifechs,项目名称:management,代码行数:28,代码来源:DBService.php
示例12: alertnoticias_consultar
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;
}
}
开发者ID:rommelxcastro,项目名称:CRI-Online-Sales---Admin,代码行数:25,代码来源:alert_noticias.php
示例13: query
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);
}
}
}
开发者ID:honeynatividad,项目名称:mircatu,代码行数:28,代码来源:mysql.php
示例14: getCacheNote
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;
}
开发者ID:kirstenko,项目名称:oc-server3,代码行数:7,代码来源:Handler.php
示例15: query
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;
}
}
开发者ID:ahmedkato,项目名称:openshift-opencart,代码行数:26,代码来源:sqlite.php
示例16: phantrang
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>";
}
}
}
开发者ID:hieunhan1,项目名称:all-website3,代码行数:32,代码来源:layout.php
示例17: select
/**
* 功能:数据库查询函数
* 参数:$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;
}
开发者ID:BGCX261,项目名称:zlskytakeorder-svn-to-git,代码行数:38,代码来源:db.inc.php
示例18: execute
/**
*
* @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;
}
开发者ID:rajnishp,项目名称:bjs,代码行数:39,代码来源:QueryExecutor.class.php
示例19: getInsert
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 = 'SELECT score FROM ' . $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);
}
开发者ID:queridoamigo,项目名称:querido-amigo,代码行数:29,代码来源:functions.php
示例20: authenticate
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;
}
开发者ID:jasmith152,项目名称:long_shot_arm,代码行数:28,代码来源:login.php
注:本文中的mysql_free_result函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论