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 getResults($sSQL)
{
$oQuery = mysqli_query($this->_connection, $sSQL);
if ($oQuery) {
return mysqli_fetch_all($oQuery, MYSQLI_ASSOC);
}
return false;
}
function show_brand_goods()
{
$brand = $_GET['brand'];
$link = mysqli_connect("localhost", "magUser", "Mag_user", "magazine");
if (!$link) {
echo "Ведутся технические работы";
die;
}
$res = mysqli_query($link, "SELECT * FROM `t_products` WHERE `brand`= '{$brand}'");
$main_brand = mysqli_fetch_all($res, MYSQLI_ASSOC);
foreach ($main_brand as $key => $val) {
?>
<article class="oneGood">
<a class="imgGood" href="#">
<img src="images/oneGood.png" alt="">
</a>
<p class="priceGood">
<?php
echo $main_brand[$key]['price'];
?>
</p>
<p class="descGood">
<a href="http://shop/cart.php?id=<?php
echo $main_brand[$key]['id'];
?>
"><?php
echo $main_brand[$key]['name'];
?>
</a>
</p>
</article>
<?php
}
}
function getCabinInclusions($link, $id)
{
$query = "SELECT inclID, inclusionName, tblCabins_cabinID\n\t\tFROM tblInclusions, tblCabinInc\n\t\tWHERE tblInclusions.inclID = tblCabinInc.tblInclusions_InclID\n\t\tAND tblCabinInc.tblCabins_cabinID = {$id}";
$result = mysqli_query($link, $query);
$inclusions = mysqli_fetch_all($result, MYSQLI_ASSOC);
return $inclusions;
}
function book()
{
global $database;
$check_in = $_POST['checkIn'];
$check_out = $_POST['checkOut'];
$room_id = $_POST['roomId'];
$sql = "SELECT * FROM bookings WHERE room_id = {$room_id} AND ( '{$check_in}' BETWEEN arrival AND departure ) OR ( '{$check_out}' BETWEEN arrival AND departure )";
$result = $database->query($sql);
$result = mysqli_fetch_all($result);
if (!empty($result)) {
$data = array('success' => false, 'message' => 'The room is already booked');
echo json_encode($data);
} else {
$sql = "INSERT INTO bookings(room_id,arrival,departure)";
$sql .= "VALUES({$room_id},'{$check_in}','{$check_out}')";
$database->query($sql);
$data = array('success' => true, 'message' => 'You booked the room');
echo json_encode($data);
}
die;
/*print_r( $result );
die();*/
}
public function query($sql)
{
$resource = mysqli_query($this->link, $sql);
if ($resource != false) {
if ($resource !== true && get_class($resource) == 'mysqli_result') {
$data = array();
if (function_exists('mysqli_fetch_all')) {
$data = mysqli_fetch_all($resource, MYSQLI_ASSOC);
} else {
$i = 0;
while ($result = mysqli_fetch_assoc($resource)) {
$data[$i] = $result;
$i++;
}
}
$query = new stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = mysqli_num_rows($resource);
mysqli_free_result($resource);
unset($data);
return $query;
} else {
return true;
}
} else {
trigger_error('Error: ' . mysqli_error($this->link) . '<br />Error No: ' . mysqli_errno($this->link) . '<br />' . $sql);
exit;
}
}
function updateList($user, $nbmessages)
{
$sql = "SELECT COUNT(*) FROM message";
$result = mysqli_query(db(), $sql);
$result = mysqli_fetch_all($result)[0][0];
$DATA = ["new" => false, "message" => ""];
if ($nbmessages < $result) {
if ($nbmessages != 0) {
$nbnew = $result - $nbmessages;
$sql = "SELECT * FROM message ORDER BY date DESC LIMIT {$nbnew}";
$result = mysqli_query(db(), $sql);
$messages = mysqli_fetch_all($result, MYSQLI_ASSOC);
$taille = count($messages);
$message = $messages;
for ($i = 1; $i < $taille - 1; $i++) {
$messages[$i] = $message[$taille - $i];
}
} else {
$sql = "SELECT * FROM message";
$result = mysqli_query(db(), $sql);
$messages = mysqli_fetch_all($result, MYSQLI_ASSOC);
}
foreach ($messages as $row) {
if ($row['user'] == $user) {
$DATA['message'] .= "<div class='sent'><p class='content' title='{$row['date']}'>{$row['msg']}</p><div class='icon'>me</div></div>";
} else {
$DATA['message'] .= "<div class='received'><div class='icon'>anonym</div><p class='content' title='{$row['date']}'>{$row['msg']}</p></div>";
$DATA['new'] = true;
}
}
}
echo json_encode($DATA);
}
public function getAllAssoc($sql)
{
$queryRes = $this->query($sql);
$res = mysqli_fetch_all($queryRes, MYSQLI_ASSOC);
if (!empty($res)) {
return $res;
}
}
function findCarEngines($model)
{
global $db;
$query = 'SELECT * FROM car_engines WHERE model_id = ' . $model;
$result = mysqli_query($db, $query);
$engines = mysqli_fetch_all($result);
echo json_encode($engines);
}
function findCarEngines($makeId, $modelId)
{
global $connection;
$query = "SELECT * FROM engines WHERE make=" . $makeId . " AND model=" . $modelId;
$result = mysqli_query($connection, $query);
$engines = mysqli_fetch_all($result);
echo json_encode($engines);
}
function get_datakader_by_nim($nimkader)
{
$info = array();
include 'connectdb.php';
$result = mysqli_query($con, 'SELECT tabel_data_kader.NIM, Nama_Mahasiswa, Organisasi, Posisi, Acara FROM tabel_mahasiswa, tabel_data_kader WHERE tabel_data_kader.NIM = ' . $nimkader . ' AND tabel_mahasiswa.NIM = ' . $nimkader);
$info = mysqli_fetch_all($result, MYSQL_ASSOC);
return $info;
}
public function getList($limit = 0, $offset = 0)
{
$sql = 'select * from films';
$limit ? $sql = $sql . ' limit ' . intval($limit) : '';
$limit && $offset ? $sql = $sql . ' offset ' . intval($limit) : '';
$result = $this->query($sql);
return mysqli_fetch_all($result, MYSQLI_ASSOC);
}
function sqlQuerySelect($sqlQuery)
{
$connect = sqlConnect();
$result = mysqli_query($connect, $sqlQuery);
$data = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_close($connect);
return $data;
}
function db_select($select_query)
{
global $conn;
$result = mysqli_query($conn, $select_query);
$assoc = mysqli_fetch_all($result, MYSQL_ASSOC);
//mysqli_free_result($result);
return $assoc;
}
public static function allPosts()
{
$sql = "SELECT * FROM %s";
$query = sprintf($sql, self::$table);
$result = mysqli_query(self::connect(), $query);
$allPostsArr = mysqli_fetch_all($result, MYSQLI_ASSOC);
return $allPostsArr;
}
function strategies_getStatistics($tournament)
{
$tournament = intval($tournament);
$link = getDBConnection();
if (mysqli_select_db($link, getDBName())) {
$query = "SELECT COUNT(*) as cnt, DAY(date) as dt FROM strategies " . ($tournament == -1 ? "" : " WHERE tournament=" . $tournament) . " GROUP BY DATE(date)";
return mysqli_fetch_all(mysqli_query($link, $query));
}
}
/**
* @param mixed $result
*
* @return array|null
*/
function resultQuery($result)
{
if ($result instanceof mysqli_result) {
$data = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
return $data;
}
return $result;
}
public function select($columns = array(), $tableName = null, $where = array())
{
$columns = empty($columns) ? array('*') : $columns;
$columnsData = implode(', ', $columns);
$query = "SELECT {$columnsData} FROM {$this->_getTableName($tableName)} {$this->_where($where)}";
$result = mysqli_query($this->_mySqlConnect, $query);
$data = mysqli_fetch_all($result, MYSQLI_ASSOC);
return $data;
}
function array_product($q)
{
$result = mysqli_query($cnct, "SELECT * FROM `t_products` WHERE `id`= '{$id}' ");
mysqli_close($cnct);
$array_prod = mysqli_fetch_all($result, MYSQLI_ASSOC);
foreach ($array_prod as $key => $val) {
return $val;
}
}
function getWords($id)
{
$query = "SELECT `lang1`,`priority` FROM `word` WHERE `user`={$id} ORDER BY `priority` ASC";
$result = wordQuery($query);
if (mysqli_num_rows($result) == 0) {
return "";
}
return mysqli_fetch_all($result);
}
public function __construct()
{
$this->link = new mysqli('localhost', 'root', NULL, 'imobiliaria');
if (!$this->link) {
die('Não foi possível conectar: ' . mysql_error());
}
$this->tipoImovel = mysqli_fetch_all(mysqli_query($this->link, "SELECT tipoImaovel FROM tipoImovel"));
$this->estado = mysqli_fetch_all(mysqli_query($this->link, "SELECT estado FROM estado"));
}
function listarProveedoresSQL()
{
$conexion = ConectarDB();
$sql = "SELECT *\r\n\tFROM Proveedor\r\n\tWHERE 1";
$resultadoDatos = mysqli_query($conexion, $sql);
$resultadoDatosRetornar = mysqli_fetch_all($resultadoDatos, MYSQLI_ASSOC);
mysqli_close($conexion);
return $resultadoDatosRetornar;
}
function transformar_a_lista($resultado)
{
if (mysqli_num_rows($resultado) > 0) {
$lista = mysqli_fetch_all($resultado, MYSQLI_ASSOC);
return $lista;
} else {
return 0;
}
}
/**
* Get bookmarks from MySQL. Die directly if can not fetch notes.
*/
function get_notes($conn, $user)
{
$sql = "SELECT * FROM `ybk_notes` WHERE user = '******'";
$notes = mysqli_query($conn, $sql);
if (!$notes) {
http_response_code(400);
die('Could not get data: ' . mysqli_error($conn));
}
return json_encode(mysqli_fetch_all($notes, MYSQLI_ASSOC));
}
public function getAll($table, $cols)
{
$sql = "SELECT {$cols} FROM {$table}";
$result = mysqli_query($this->conn, $sql);
if (mysqli_num_rows($result) > 0) {
return mysqli_fetch_all($result, MYSQLI_ASSOC);
} else {
echo "No data avalible";
}
}
public function userMapping($username, $password)
{
$sql_query = "SELECT *\r\n FROM blog_user\r\n WHERE user_name = '{$username}' AND user_password = '******' AND user_privilege = '0'";
$query = mysqli_query($this->postMapper, $sql_query);
$result = mysqli_fetch_all($query);
if (empty($result)) {
return false;
} else {
return true;
}
}
/**
* @param $maxi
* @return array|bool|null
*/
function getControlUnit($maxi)
{
global $link;
$sql = "SELECT n.article, n.name, p.code AS code, p.value, p1.code AS code1, p1.value AS value1\n FROM nomenklatura AS n\n INNER JOIN properties AS p ON n.article = p.article\n INNER JOIN properties AS p1 ON n.article = p1.article\n WHERE p.code = '000000074'\n AND p1.code = '000000073'\n AND ( {$maxi}\n BETWEEN p.value\n AND p1.value )";
if (!($result = mysqli_query($link, $sql))) {
return false;
}
$items = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
return $items;
}
public function getUser($SSO)
{
$result = $this->db->query("select * FROM personal WHERE SSO = '{$SSO}'");
$users = mysqli_fetch_all($result['result']);
if (!empty($users)) {
$user = $users[0];
$userObj = new user($user[0], $user[1], $user[2], $user[3], $user[4], $user[5], $user[6], $user[7], $user[8], $user[9]);
return $userObj;
} else {
}
}
function mysqli_select($db, $sql)
{
$stmt = call_user_func_array('mysqli_interpolate', func_get_args());
if (!mysqli_stmt_execute($stmt) || false === ($result = mysqli_stmt_get_result($stmt))) {
throw new mysqli_sql_exception(mysqli_stmt_error($stmt), mysqli_stmt_errno($stmt));
}
$rows = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
mysqli_stmt_close($stmt);
return (array) $rows;
}
function csvDataAlt($table, $state_name, $col, $key, $key2, $key2val)
{
$query = 'SELECT ' . $col . ' FROM ' . $table . ' WHERE ' . $key . '="' . $state_name . '" AND ' . $key2 . '="' . $key2val . '" LIMIT 1';
$query_result = mysqli_query($query);
if (!$query_result) {
die('Invalid query: ' . mysql_error());
}
$query_result = mysqli_fetch_all($query_result);
//$query_result = str_replace("’","'",$query_result); //clean dirty characters
return $query_result[0][$col];
}
