本文整理汇总了PHP中mysqli_free_result函数的典型用法代码示例。如果您正苦于以下问题:PHP mysqli_free_result函数的具体用法?PHP mysqli_free_result怎么用?PHP mysqli_free_result使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysqli_free_result函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: execute_multi
function execute_multi($link, $arr_sqls, &$error)
{
$sqls = implode(';', $arr_sqls) . ';';
if (mysqli_multi_query($link, $sqls)) {
$data = array();
$i = 0;
//计数
do {
if ($result = mysqli_store_result($link)) {
$data[$i] = mysqli_fetch_all($result);
mysqli_free_result($result);
} else {
$data[$i] = null;
}
$i++;
if (!mysqli_more_results($link)) {
break;
}
} while (mysqli_next_result($link));
if ($i == count($arr_sqls)) {
return $data;
} else {
$error = "sql语句执行失败:<br /> 数组下标为{$i}的语句:{$arr_sqls[$i]}执行错误<br /> 错误原因:" . mysqli_error($link);
return false;
}
} else {
$error = '执行失败!请检查首条语句是否正确!<br />可能的错误原因:' . mysqli_error($link);
return false;
}
}
开发者ID:sakuraliu,项目名称:bbs,代码行数:30,代码来源:mysql.inc.php
示例2: processQuery
public function processQuery($sql, $type = NULL)
{
$result = mysqli_query($this->db, $sql);
$this->checkForError();
$data = array();
if ($result instanceof mysqli_result) {
$resultType = MYSQLI_NUM;
if ($type == 'assoc') {
$resultType = MYSQLI_ASSOC;
}
while ($row = mysqli_fetch_array($result, $resultType)) {
if (mysqli_affected_rows($this->db) > 1) {
array_push($data, $row);
} else {
$data = $row;
}
}
mysqli_free_result($result);
} else {
if ($result) {
$data = mysqli_insert_id($this->db);
}
}
return $data;
}
开发者ID:veggiematts,项目名称:usage,代码行数:25,代码来源:DBService.php
示例3: iimysqli_stmt_get_result
public static function iimysqli_stmt_get_result($stmt)
{
/** EXPLANATION:
* We are creating a fake "result" structure to enable us to have
* source-level equivalent syntax to a query executed via
* mysqli_query().
*
* $stmt = mysqli_prepare($conn, "");
* mysqli_bind_param($stmt, "types", ...);
*
* $param1 = 0;
* $param2 = 'foo';
* $param3 = 'bar';
* mysqli_execute($stmt);
* $result _mysqli_stmt_get_result($stmt);
* [ $arr = _mysqli_result_fetch_array($result);
* || $assoc = _mysqli_result_fetch_assoc($result); ]
* mysqli_stmt_close($stmt);
* mysqli_close($conn);
*
* At the source level, there is no difference between this and mysqlnd.
**/
$metadata = mysqli_stmt_result_metadata($stmt);
$ret = new iimysqli_result();
if (!$ret) {
return NULL;
}
$ret->nCols = mysqli_num_fields($metadata);
$ret->columns = $metadata->fetch_fields();
$ret->stmt = $stmt;
mysqli_free_result($metadata);
return $ret;
}
开发者ID:senioroman4uk,项目名称:Simple-PHP-MVC,代码行数:33,代码来源:iimysqli_result.php
示例4: execute
public function execute()
{
$collect = array();
$link_count = count($this->links);
$processed = 0;
do {
$links = $errors = $reject = array();
foreach ($this->links as $link) {
$links[] = $errors[] = $reject[] = $link;
}
if (!mysqli_poll($links, $errors, $reject, 0, 1000)) {
continue;
}
for ($i = 0; $i < $link_count; $i++) {
$link = $this->links[$i];
if (mysqli_errno($link)) {
throw new \RuntimeException(mysqli_error($link), mysqli_errno($link));
}
if ($result = $link->reap_async_query()) {
if (is_object($result)) {
$temp = array();
while (($row = $result->fetch_assoc()) && ($temp[] = $row)) {
}
$collect[$i] = $temp;
mysqli_free_result($result);
} else {
$collect[$i] = $result;
}
}
$processed++;
}
} while ($processed < $link_count);
return $collect;
}
开发者ID:xxoxx,项目名称:async-mysql-php,代码行数:34,代码来源:Async.php
示例5: delete
public function delete($id)
{
$id = mysqli_real_escape_string($this->connection, $id);
$query = "DELETE FROM posts WHERE id = '{$id}'";
$result = mysqli_query($this->connection, $query);
mysqli_free_result($result);
}
开发者ID:marina-bard,项目名称:blog-php,代码行数:7,代码来源:databasehandler.php
示例6: editPage
function editPage($id)
{
include_once 'login.php';
include_once 'database_conn.php';
include_once 'showEventFunction.php';
$pageHeader = "Event Edit Page";
$sql = "SELECT * FROM te_events WHERE eventID = {$id}";
$rslt = mysqli_query($conn, $sql) or die(mysqli_error($conn));
// error message return if return empty result
$row = mysqli_fetch_row($rslt);
$venues = getFromDb($conn, "SELECT * FROM te_venue");
$categories = getFromDb($conn, "SELECT * FROM te_category");
$output = "<h1>{$pageHeader}</h1>";
$i = 1;
$output .= "<form id=\"editForm\" action=\"handleEditPage.php\" method=\"post\">";
$output .= "<table border=0 >";
$output .= createRowData("Title", createTextField("title", $row[$i++]));
$output .= createRowData("Description", createTextArea("desc", $row[$i++], 5, 40));
$output .= createRowData("Venue Name", createCombobox("venue", $row[$i++], $venues));
$output .= createRowData("Category", createCombobox("category", $row[$i++], $categories));
$output .= createRowData("Start Time", createDate("startTime", $row[$i++]));
$output .= createRowData("End Time", createDate("endTime", $row[$i++]));
$output .= createRowData("Price", createTextField("price", $row[$i++]));
$output .= "<tr><td><input type=\"submit\" name=\"submit\" value=\"Submit\"></td></tr>";
$output .= "<input type=\"hidden\" name=\"e_id\" value=\"{$id}\">";
$output .= "</table></form>";
mysqli_free_result($rslt);
mysqli_close($conn);
return $output;
}
开发者ID:lowjiayou,项目名称:YearTwoWebOne,代码行数:30,代码来源:editPage.php
示例7: free
private function free()
{
if ($this->queryID) {
mysqli_free_result($this->queryID);
$this->queryID = null;
}
}
开发者ID:beelibrary820145,项目名称:tanxiongfeng,代码行数:7,代码来源:Mysqli.class.php
示例8: getUserData
function getUserData($phoneNumber)
{
$sql = "SELECT * FROM `nicdata` WHERE `phoneNumber`='" . $phoneNumber . "'";
$conn = new mysqli(constant("SERVER_NAME_NIC"), constant("DB_USER_NIC"), constant("DB_PASSWORD_NIC"), constant("DB_NAME_NIC"));
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$result = mysqli_query($conn, $sql);
$json = "";
if (!$result) {
die("Invalid query: " . mysqli_error($conn));
} else {
$rows = array();
while ($row = $result->fetch_assoc()) {
$rows[] = $row;
}
/* $rows = mysqli_fetch_all($result, MYSQLI_ASSOC); */
$json = json_encode($rows);
//This function returns the JSON representation of a value on success or FALSE on failure.
}
mysqli_free_result($result);
//The mysqli_free_result() function frees the memory associated with the result
$conn->close();
$dejson = json_decode($json);
$_SESSION["GET_USERNAME"] = $dejson[0]->{'userName'};
$_SESSION["GET_FIRSTNAME"] = $dejson[0]->{'firstName'};
$_SESSION["GET_LASTNAME"] = $dejson[0]->{'lastName'};
$_SESSION["GET_STAFFID"] = $dejson[0]->{'staffId'};
$_SESSION["GET_DESIGNATION"] = $dejson[0]->{'designation'};
$_SESSION["GET_EMAILID"] = $dejson[0]->{'email_Id'};
$_SESSION["GET_PHONE"] = $dejson[0]->{'phoneNumber'};
return $json;
}
开发者ID:nagyist,项目名称:Samarthya,代码行数:33,代码来源:dal.nicportal.php
示例9: comprobarPosicion
function comprobarPosicion($LOGIN, $COLUMNA, $FILA, $TAMANYO, $ANGULO)
{
global $link, $DIVISIONES;
if ($ANGULO == 0 && $COLUMNA + $TAMANYO > $DIVISIONES || $ANGULO == -90 && $FILA - $TAMANYO < 1) {
return false;
}
$mysql = 'select * from barco where LOGIN="' . $LOGIN . '"';
if ($res = mysqli_query($link, $mysql)) {
while ($row = mysqli_fetch_assoc($res)) {
for ($i = 0; $i < $TAMANYO; $i++) {
$C = $COLUMNA;
$F = $FILA;
if ($ANGULO == 0) {
$C = $C + $i;
} else {
$F = $F - $i;
}
if ($row['ANGULO'] == 0 && $C >= $row['COLUMNA'] - 1 && $C <= $row['COLUMNA'] + $row['TAMANYO'] && $F <= $row['FILA'] + 1 && $F >= $row['FILA'] - 1 || $row['ANGULO'] == -90 && $F <= $row['FILA'] + 1 && $F >= $row['FILA'] - $row['TAMANYO'] && $C >= $row['COLUMNA'] - 1 && $C <= $row['COLUMNA'] + 1) {
return false;
}
}
// for($i=0;$i<$TAMANYO;$i++)
}
mysqli_free_result($res);
}
return true;
}
开发者ID:4nk1r4,项目名称:Melibea,代码行数:27,代码来源:juego.php
示例10: Decider
function Decider($dname, $dmail)
{
$name = $dname;
$mail = strtolower($dmail);
//connect to the database
$con = mysqli_connect("eu-cdbr-azure-west-a.cloudapp.net", "b8592f1b44ff9a", "fecb2128", "TeamProject");
$name = mysqli_real_escape_string($con, $name);
if (mysqli_connect_errno()) {
return "f";
}
$query = "SELECT Email FROM Subscriber WHERE Email='" . $mail . "'";
$result = mysqli_query($con, $query);
if (mysqli_num_rows($result) > 0) {
$result = Unsub($mail);
} else {
if (empty($mail)) {
$result = Unsub($name);
} else {
$result = Subscribe($name, $mail);
}
}
// Free result set
mysqli_free_result($result);
mysqli_close($con);
return $result;
}
开发者ID:alexandroskou,项目名称:Repository1,代码行数:26,代码来源:SubDecide.php
示例11: execute
/**
* Wykonaniew zapytania do bazy
*
* @param sqlQuery obiekt typu SqlQuery
* @return wynik zapytania
*/
public static function execute($sqlQuery)
{
$transaction = Transaction::getCurrentTransaction();
if (!$transaction) {
$connection = new Connection();
} else {
$connection = $transaction->getConnection();
}
$query = $sqlQuery->getQuery();
// $pos = strpos($query, "null");
// if ($pos != false) {
// if(true) {
// writeToFile($query);
// }
// }
$result = $connection->executeQuery($query);
if (!$result) {
throw new Exception("SQL Error: -->" . $query . "<--" . mysql_error());
}
$i = 0;
$tab = array();
while ($row = mysqli_fetch_array($result)) {
$tab[$i++] = $row;
}
mysqli_free_result($result);
if (!$transaction) {
$connection->close();
}
return $tab;
}
开发者ID:Entrax643,项目名称:School,代码行数:36,代码来源:QueryExecutor.class.php
示例12: hisdb_hasDoctorAccount
function hisdb_hasDoctorAccount($dbConn, $doctorid)
{
$recordSet = mysqli_query($dbConn, 'SELECT LoginUserID ' . 'FROM Doctor ' . 'WHERE DoctorID = \'' . $doctorid . '\';');
$record = mysqli_fetch_array($recordSet, MYSQLI_ASSOC);
mysqli_free_result($recordSet);
return $record['LoginUserID'];
}
开发者ID:krikienoid,项目名称:hisdb,代码行数:7,代码来源:common.php
示例13: dbReadRow
function dbReadRow($sql)
{
$result = dbGetQueryResult($sql);
$row = mysqli_fetch_array($result);
mysqli_free_result($result);
return $row;
}
开发者ID:holgerl,项目名称:Slidifier,代码行数:7,代码来源:io.php
示例14: get_data
function get_data($sql, $db = NULL)
{
if ($db == NULL) {
$db = db();
}
$GLOBALS['LP_LAST_SQL'] = $sql;
$data = array();
$i = 0;
$result = mysqli_query($db, $sql);
if (mysqli_errno($db) != 0) {
echo mysqli_error($db) . ' ' . $sql;
}
while ($Array = mysqli_fetch_array($result, MYSQL_ASSOC)) {
$data[$i++] = $Array;
}
if (mysqli_errno($db) != 0) {
echo mysqli_error($db) . ' ' . $sql;
}
mysqli_free_result($result);
if (count($data) > 0) {
return $data;
} else {
return false;
}
}
开发者ID:jfojfo,项目名称:LazyREST,代码行数:25,代码来源:mysqli.function.php
示例15: getCorreoIntegrantes
function getCorreoIntegrantes($fechaInicio, $fechaFin)
{
include '../Conexion.php';
$ConexionBD = new Conexion();
$database = $ConexionBD::conectarBD();
if ($database->connect_errno) {
$data = NULL;
} else {
$sqlSelect = ' SELECT intCorreo';
$sqlFrom = ' FROM integrantes ';
$sqlWhere = ' WHERE intActivo = TRUE ';
$sqlOrder = ' ORDER BY intCorreo;';
$consulta = $sqlSelect . $sqlFrom . $sqlWhere . $sqlOrder;
if ($result = $database->query($consulta)) {
if ($result->num_rows > 0) {
$i = 0;
while ($row = mysqli_fetch_array($result, MYSQL_BOTH)) {
$intCorreo = $row['intCorreo'];
$data[] = array('intCorreo' => $intCorreo);
$i++;
}
// return $data
mysqli_free_result($resultado);
} else {
$data = NULL;
}
$result->close();
}
$ConexionBD::desconectarDB($database);
}
// echo $fechaFin;
return $data;
}
开发者ID:vvvhh,项目名称:not,代码行数:33,代码来源:getCorreosIntegrantes.php
示例16: release_resource
protected function release_resource()
{
if (is_resource($this->_result)) {
mysqli_free_result($this->_result);
}
$this->_result = null;
}
开发者ID:xiaodin1,项目名称:myqee,代码行数:7,代码来源:result.class.php
示例17: pagination
/**
*
* @param string $where
* @return array 返回数据库查询后的数组:
*/
function pagination($where, $conn, $tbl_name)
{
require_once 'class/Config_commodity.php';
require_once 'class/DBpagination.php';
require_once 'class/DBcount.php';
require_once 'class/Info_user.php';
require_once 'class/Config_user.php';
require_once 'Include_picture.php';
//2.向数据库查询符合条件数,以计算显示分页数目
$dbcount = new DBcount($tbl_name, $where);
$retval = $dbcount->excute($conn);
$row = mysqli_fetch_array($retval, MYSQLI_NUM);
$count = 1 + (int) (($row ? $row[0] : 0) / SIZE_EACH_PAGE);
//3.计算当前页码;
$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
$page = $page > $count ? $count : $page;
//4. 查询当前页的数据
$choosed_fields = array(Config_commodity::table_name . '.' . Config_commodity::description, Config_commodity::table_name . '.' . Config_commodity::id, Config_commodity::table_name . '.' . Config_commodity::publisher, Config_commodity::table_name . '.' . Config_commodity::title, Config_commodity::table_name . '.' . Config_commodity::price, Config_commodity::table_name . '.' . Config_commodity::release_date, Config_commodity::table_name . '.' . Config_commodity::praise, Config_commodity::table_name . '.' . Config_commodity::leave_message_time, Config_commodity::table_name . '.' . Config_commodity::id);
$DBpagination = new DBpagination($tbl_name, $where, $page, SIZE_EACH_PAGE, $choosed_fields);
$reval = $DBpagination->excute($conn);
//逐个配置 array 三级关联数组 供界面使用
$array = array();
while (($temp_database_row_array = mysqli_fetch_array($reval, MYSQLI_ASSOC)) != null) {
$userinfo = Info_user::get_user_info_by_id($conn, $temp_database_row_array[Config_commodity::publisher]);
$array[] = array('imgs' => get_commodity_pic($conn, $temp_database_row_array[Config_commodity::id]), 'description' => $temp_database_row_array[Config_commodity::description], 'title' => $temp_database_row_array[Config_commodity::title], 'price' => $temp_database_row_array[Config_commodity::price], 'url' => 'upload/default.jpg', 'name' => $userinfo[Config_user::log_name], 'time' => get_time($temp_database_row_array[Config_commodity::release_date]), 'star_numbers' => $temp_database_row_array[Config_commodity::praise], 'message_numbers' => $temp_database_row_array[Config_commodity::leave_message_time], 'id' => $temp_database_row_array[Config_commodity::id]);
}
//5.释放资源
mysqli_free_result($reval);
return array('page' => $page, 'array' => $array);
}
开发者ID:DaiDanRui,项目名称:LinHang,代码行数:35,代码来源:Include_commodity_browse.php
示例18: LoadGraph
public function LoadGraph($id)
{
$tableid = $id;
if ($id > 12) {
$id = $id % 12;
}
$query = "select date, OilLevel{$id}, OilAlarmLevel{$id}, GasLevel{$id}, GasAlarmLevel{$id} from detector{$tableid}";
if ($result = mysqli_query($this->link, $query)) {
$fp = fopen("datafiles/detector{$tableid}.csv", "w");
/* fetch associative array */
while ($row = mysqli_fetch_row($result)) {
if ($row[1] > 100) {
$row[1] = 100;
}
if ($row[2] > 100) {
$row[2] = 100;
}
if ($row[3] > 100) {
$row[3] = 100;
}
if ($row[4] > 100) {
$row[4] = 100;
}
fwrite($fp, implode(',', $row) . "\n");
}
/* free result set */
mysqli_free_result($result);
// echo json_encode(array("demo"=>$returnArray));
}
}
开发者ID:vishwakarma09,项目名称:bimpra.tk,代码行数:30,代码来源:Csvgraph.php
示例19: detailuser
function detailuser($conn, $iduser)
{
$query = mysqli_query($conn, "SELECT * FROM tb_user WHERE level <> 'Administrator' AND id = {$iduser}") or die(mysqli_error());
$detail = mysqli_fetch_row($query);
return $detail;
mysqli_free_result($query);
}
开发者ID:nfitriana,项目名称:mrp-system,代码行数:7,代码来源:tambah-user-exe.php
示例20: getAttribute
public function getAttribute($attribute, &$source = null, $func = 'PDO::getAttribute', &$last_error = null)
{
if ($source == null) {
$source =& $this->driver_options;
}
switch ($attribute) {
case PDO::ATTR_AUTOCOMMIT:
$result = mysqli_query($this->link, 'SELECT @@AUTOCOMMIT', MYSQLI_USE_RESULT);
if (!$result) {
$this->set_driver_error(null, PDO::ERRMODE_EXCEPTION, $func);
}
$row = mysqli_fetch_row($result);
mysqli_free_result($result);
return intval($row[0]);
break;
case PDO::ATTR_CLIENT_VERSION:
return mysqli_get_client_info();
break;
case PDO::ATTR_CONNECTION_STATUS:
return mysqli_get_host_info($this->link);
break;
case PDO::ATTR_SERVER_INFO:
return mysqli_stat($this->link);
break;
case PDO::ATTR_SERVER_VERSION:
return mysqli_get_server_info($this->link);
break;
default:
return parent::getAttribute($attribute, $source, $func, $last_error);
break;
}
}
开发者ID:Deepab23,项目名称:clinic,代码行数:32,代码来源:mysqli.php
注:本文中的mysqli_free_result函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论