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;
}
}
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;
}
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;
}
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;
}
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);
}
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;
}
private function free()
{
if ($this->queryID) {
mysqli_free_result($this->queryID);
$this->queryID = null;
}
}
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;
}
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="******"';
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;
}
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;
}
/**
* 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;
}
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'];
}
function dbReadRow($sql)
{
$result = dbGetQueryResult($sql);
$row = mysqli_fetch_array($result);
mysqli_free_result($result);
return $row;
}
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;
}
}
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;
}
protected function release_resource()
{
if (is_resource($this->_result)) {
mysqli_free_result($this->_result);
}
$this->_result = null;
}
/**
*
* @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);
}
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));
}
}
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);
}
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;
}
}
function navigation($subject_array, $page_array)
{
$output = '<ul class="subjects">';
$subject_set = find_all_subjects();
while ($subject = mysqli_fetch_assoc($subject_set)) {
$output .= "<li ";
if ($subject_array && $subject_array['id'] == $subject['id']) {
$output .= "class='selected' ";
}
$output .= "> ";
$output .= "<a href='manage_content.php?subject=" . urlencode($subject['id']) . "'> " . htmlentities($subject['menu_name']) . "</a>";
$pages_set = find_pages_for_subject($subject['id']);
$output .= "<ul class='pages'>";
while ($page = mysqli_fetch_assoc($pages_set)) {
$output .= "<li ";
if ($page_array && $page_array['id'] == $page['id']) {
$output .= "class='selected'";
}
$output .= "> ";
$output .= "<a href='manage_content.php?page=" . urlencode($page['id']) . "'> " . htmlentities($page['menu_name']) . " </a></li> ";
}
$output .= "</ul>\n </li>";
}
mysqli_free_result($subject_set);
mysqli_free_result($pages_set);
$output .= '</ul>';
return $output;
}
function findRow($offset, $link, $id, $label)
{
$sql = sprintf("SELECT id, label FROM test_mysqli_stmt_bind_param_references_table_1 WHERE id = '%d' AND label = '%s'", $id, $label);
if (!($res = mysqli_query($link, $sql))) {
printf("[%03d + 1] %s failed, [%d] %s\n", $offset, $sql, mysqli_errno($link), mysqli_error($link));
return false;
}
if (!($row = mysqli_fetch_assoc($res))) {
printf("[%03d + 2] fetch for %s failed, [%d] %s\n", $offset, $sql, mysqli_errno($link), mysqli_error($link));
return false;
}
mysqli_free_result($res);
if ($row['id'] != $id) {
printf("[%03d + 3] Expecting %s/%s got %s/%s\n", $offset, gettype($id), $id, gettype($row['id']), $row['id']);
return false;
}
if ($row['label'] != $label) {
printf("[%03d + 4] Expecting %s/%s got %s/%s\n", $offset, gettype($label), $label, gettype($row['label']), $row['label']);
return false;
}
$sql = sprintf("DELETE FROM test_mysqli_stmt_bind_param_references_table_1 WHERE id = '%d' AND label = '%s'", $id, $label);
if (!mysqli_query($link, $sql)) {
printf("[%03d + 5] %s failed, [%d] %s\n", $offset, $sql, mysqli_errno($link), mysqli_error($link));
return false;
}
return true;
}
function check_login($dbc, $username = '', $pass = '')
{
$errors = array();
// Check the username
if (empty($username)) {
$errors[] = 'Не сте въвели потребителско име.';
} else {
$u = mysqli_real_escape_string($dbc, trim($username));
}
// Check the password
if (empty($pass)) {
$errors[] = 'Не сте въвели парола.';
} else {
$p = mysqli_real_escape_string($dbc, trim($pass));
}
// Check if a user exists
if (empty($errors)) {
$q = "SELECT u1, u2, is_client FROM users WHERE u1='{$u}'";
$r = @mysqli_query($dbc, $q);
if ($r) {
if (mysqli_num_rows($r) === 0) {
$errors[] = 'Такъв потребител не съществува.';
} else {
$row = mysqli_fetch_array($r, MYSQLI_ASSOC);
if (password_verify($p, $row['u2'])) {
mysqli_free_result($r);
return array(true, $row);
} else {
$errors[] = 'Потребителското име или паролата са грешни.';
}
}
}
}
return array(false, $errors);
}
function getGraphData($users_UserID, $type, $start_date, $end_date)
{
// Global variables provided by config.php for DB connection.
global $con, $host, $user, $password, $db;
if (mysqli_connect_errno()) {
die('Could not connect: ' . mysqli_connect_error());
}
//Initialize index variable.
$index = 0;
$start_date = new DateTime($start_date);
$end_date = new DateTime($end_date);
while ($start_date <= $end_date) {
$query = "SELECT * FROM sensors WHERE users_UserID = '" . $users_UserID . "' AND Type = '" . $type . "' AND Date >= '" . $start_date->format("Y-m-d") . ' 00:00:00' . "' AND Date <= '" . $start_date->format("Y-m-d") . ' 23:59:59' . "'";
if ($result = mysqli_query($con, $query)) {
$rowcount = mysqli_num_rows($result);
if ($rowcount == 0) {
// No Data for this date -- So fill with 0.
$graphdata[$index] = 0;
} else {
while ($rows = mysqli_fetch_array($result)) {
// Insert Data into array.
$graphdata[$index] = $rows['Data'];
}
}
mysqli_free_result($result);
} else {
die('Error:' . mysqli_error($con));
}
//Increment Start Date
$start_date->modify('+1 day');
//Increment index variable.
$index++;
}
return $graphdata;
}
function execSP($sql)
{
$this->connMySQL();
$this->sql = $sql;
$i = 0;
$result_ = null;
if (mysqli_multi_query($this->conn, $this->sql)) {
do {
if ($this->resultado = mysqli_store_result($this->conn)) {
while ($row = mysqli_fetch_array($this->resultado)) {
$result_ = $row;
}
mysqli_free_result($this->resultado);
}
$i++;
} while (mysqli_next_result($this->conn));
mysqli_close($this->conn);
} else {
echo mysqli_error($this->conn);
$this->closeConnMySQL();
exit;
}
$this->closeConnMySQL();
return $result_;
}
function onSQLReady($db_sock)
{
$db_res = $this->busy_pool[$db_sock];
$mysqli = $db_res['mysqli'];
$fd = $db_res['fd'];
echo __METHOD__ . ": client_sock={$fd}|db_sock={$db_sock}\n";
if ($result = $mysqli->reap_async_query()) {
$ret = var_export($result->fetch_all(MYSQLI_ASSOC), true) . "\n";
//var_dump($ret);
$this->serv->send($fd, $ret);
if (is_object($result)) {
mysqli_free_result($result);
}
} else {
$this->serv->send($fd, sprintf("MySQLi Error: %s\n", mysqli_error($mysqli)));
}
//release mysqli object
$this->idle_pool[] = $db_res;
unset($this->busy_pool[$db_sock]);
//这里可以取出一个等待请求
if (count($this->wait_queue) > 0) {
$idle_n = count($this->idle_pool);
for ($i = 0; $i < $idle_n; $i++) {
$req = array_shift($this->wait_queue);
$this->doQuery($req['fd'], $req['sql']);
}
}
}
function onSQLReady($db_sock)
{
$task = $this->work_pool[$db_sock];
/**
* @var \mysqli
*/
$mysqli = $task['mysql']['object'];
$callback = $task['callback'];
if ($result = $mysqli->reap_async_query()) {
call_user_func($callback, $mysqli, $result);
if (is_object($result)) {
mysqli_free_result($result);
}
} else {
echo "MySQLi Error: " . mysqli_error($mysqli) . "\n";
}
//release mysqli object
$this->idle_pool[] = $task['mysql'];
unset($this->work_pool[$db_sock]);
//fetch a request from wait queue.
if (count($this->wait_queue) > 0) {
$idle_n = count($this->idle_pool);
for ($i = 0; $i < $idle_n; $i++) {
$new_task = array_shift($this->wait_queue);
$this->doQuery($new_task['sql'], $new_task['callback']);
}
}
}
function check_bans($ip, &$reason = '')
{
global $INSTALLER09, $mc1;
$key = 'bans:::' . $ip;
if (($ban = $mc1->get_value($key)) === false) {
$nip = ip2long($ip);
$ban_sql = sql_query('SELECT comment FROM bans WHERE (first <= ' . $nip . ' AND last >= ' . $nip . ') LIMIT 1');
if (mysqli_num_rows($ban_sql)) {
$comment = mysqli_fetch_row($ban_sql);
$reason = 'Manual Ban (' . $comment[0] . ')';
$mc1->cache_value($key, $reason, 86400);
// 86400 // banned
return true;
}
mysqli_free_result($ban_sql) || is_object($ban_sql) && get_class($ban_sql) == "mysqli_result" ? true : false;
$mc1->cache_value($key, 0, 86400);
// 86400 // not banned
return false;
} elseif (!$ban) {
return false;
} else {
$reason = $ban;
return true;
}
}
public function free_result($q_id)
{
if ($q_id == "") {
$q_id = $this->q_id;
}
mysqli_free_result($q_id);
}
function read_data_from_database()
{
require 'serverconf.php';
$link = mysqli_connect($adresserwera, $nazwauzyt, $haslo, $nazwabd);
$zapytanie = "SELECT * FROM `order` WHERE 1";
$wynik_zapytania = mysqli_query($link, $zapytanie);
echo mysqli_connect_error();
echo "<center><table>";
echo "<tr><th>Data zamówienia</th><th>Imię</th><th>Nazwisko</th><th>Koszt</th><th></th>";
while ($row = mysqli_fetch_array($wynik_zapytania, MYSQLI_ASSOC)) {
$zapytanie_suma = "SELECT SUM(product_cost) AS cost FROM product WHERE product_forordkey = '" . $row["order_id"] . "';";
$koszt = mysqli_query($link, $zapytanie_suma);
$row2 = mysqli_fetch_array($koszt, MYSQLI_ASSOC);
echo "<tr><td>" . $row["order_date"] . "</td><td>" . $row["order_fname"] . "</td><td>" . $row["order_lname"] . "</td><td>" . $row2["cost"] . "</td><td>";
echo "<form method='POST' action='showdetails.php'><input name='forordkey' type='hidden' value='" . $row["order_id"] . "'><input type='submit' value='Pokaż szczegóły'></form>";
}
echo "</table></center>";
//echo count($row);
mysqli_free_result($wynik_zapytania);
if (mysqli_connect_errno()) {
echo "Nie dodano<br>";
return 'Nie działa :o';
} else {
//echo "Wczytano dane z bazy";
}
if (!mysqli_close($link)) {
return 'Problem z zamknieciem bazy';
}
return $row;
}
