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;
}
}
function cloneDB($database_name = false)
{
$this->db->query('CREATE DATABASE ' . $database_name);
if ($_SERVER['HTTP_HOST'] == "localhost") {
//$dbname=$database_name;
$password = "";
$username = "******";
}
if ($_SERVER['HTTP_HOST'] == "junctiondev.cloudapp.net") {
//$dbname=$database_name;
$password = "******";
$username = "******";
}
if ($_SERVER['HTTP_HOST'] == "junctiontech.in") {
//$dbname=$database_name;
$password = "******";
$username = "******";
}
$connect = mysqli_connect('localhost', $username, $password, $database_name);
$db_file = file_get_contents('school_mgt.sql');
mysqli_multi_query($connect, $db_file);
do {
mysqli_store_result($connect);
} while (mysqli_more_results($connect) && mysqli_next_result($connect));
}
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 clone_db($database_name = false, $organization_id = false)
{
$qry = $this->db->query('CREATE DATABASE ' . $database_name);
if (!$qry) {
$value = array('code' => '500', 'organization_id' => $organization_id);
$json_data = json_encode($value);
redirect('http://junctiondev.cloudapp.net/appmanager/login/result_application?json=' . $json_data);
}
$this->session->set_userdata('db_name', $database_name);
$this->session->userdata('db_name');
if ($_SERVER['HTTP_HOST'] == "localhost") {
//$dbname=$database_name;
$password = "";
$username = "******";
}
if ($_SERVER['HTTP_HOST'] == "junctiondev.cloudapp.net") {
//$dbname=$database_name;
$password = "******";
$username = "******";
}
if ($_SERVER['HTTP_HOST'] == "junctiontech.in") {
//$dbname=$database_name;
$password = "******";
$username = "******";
}
$connect = mysqli_connect('localhost', $username, $password, $database_name);
$db_file = file_get_contents('junctionerp.sql');
mysqli_multi_query($connect, $db_file);
do {
mysqli_store_result($connect);
} while (mysqli_more_results($connect) && mysqli_next_result($connect));
return true;
}
function finalize_order($eid, $details_xml)
{
// $sql = sprintf("Call finalize_order(%s,%s)",$eid, $details_xml);
// if (!mysqli_multi_query($_SESSION['mysqli_link'], $sql )) echo "<div style='z-index:1500'>ERROR! (UpdaterSprocsContainer:aassdskarek)".mysqli_error($_SESSION['mysqli_link'])."</div>";
//<<<EOT
$QUERY = sprintf("Call finalize_order(%s,%s,@out_order_id);", $eid, $details_xml) . "SELECT @out_order_id as order_id;";
//EOT;
$mysqli = $_SESSION['mysqli_link'];
$query = mysqli_multi_query($mysqli, $QUERY) or die("error 9832lkjaklh3" . mysqli_error($mysqli));
if ($query) {
do {
if ($result = mysqli_store_result($mysqli)) {
$subresult = mysqli_fetch_assoc($result);
if (!isset($subresult['order_id'])) {
continue;
}
$_SESSION['finalized_order_id'] = $subresult['order_id'];
// foreach( $subresult AS $k => $v )
// {
// var_dump( $k , $v );
// }
}
} while (mysqli_next_result($mysqli));
}
}
function query($sql, $check_duplicate = '')
{
if (empty($this->link_id)) {
die('Нет подключения к базе данных');
}
if ($sql == '') {
die('Пустой запрос');
}
$run_query = 1;
/* Проверка на наличе дубликата у добавляемых данных */
if ($check_duplicate != '') {
if ($this->check_double($sql) == false) {
$run_query = 0;
write_log($run_query, 'double_check');
}
}
if ($run_query == 1) {
if ($this->query_id = mysqli_query($this->link_id, $sql)) {
mysqli_next_result($this->link_id);
return $this->query_id;
} else {
$this->error($sql);
}
} else {
//return false;
}
}
public function ResistMenuLog($_uid, $_log)
{
$query = "TRUNCATE TABLE UM" . $_uid . ";";
$result = $this->_db_throw_query("Users_Geo", $query);
$query = "";
$tmp = "INSERT INTO UM" . $_uid . " VALUES ( '";
for ($i = 0; $i < 7; $i++) {
for ($j = 0; $j < 3; $j++) {
if ($j == 2) {
if (strpos($_log[$this->week[$i]][$this->kind[$j]], '|') !== false) {
$div = explode('|', $_log[$this->week[$i]][$this->kind[$j]]);
$size = count($div);
for ($k = 0; $k < $size; $k++) {
$query = $query . $tmp . $div[$k] . "', '" . $this->kind[$j] . "', ( NOW() + INTERVAL " . $i . " DAY ) );";
}
break;
}
}
$query = $query . $tmp . $_log[$this->week[$i]][$this->kind[$j]] . "', '" . $this->kind[$j] . "', ( NOW() + INTERVAL " . $i . " DAY ) );";
}
}
$this->_db_select("Users_Geo");
$result = mysqli_multi_query($this->_connection, $query);
if (!$result) {
print "Quely Failed.\n" . mysqli_error($this->_connection);
return false;
}
do {
mysqli_store_result($this->_connection);
} while (mysqli_next_result($this->_connection));
return true;
}
public function get_menu($parent = 0)
{
$active_lang = $this->db->escape($this->config->item('language_abbr'));
$result = $this->db->query("call get_menu({$active_lang},'page','{$parent}','published')");
mysqli_next_result($this->db->conn_id);
return $result;
}
function task_optimize($connection, $settings, $time, $table = false, $and_default = true)
{
require_once $settings['functions'] . 'function.task.log.php';
if ($table) {
$tables[] = $table;
}
if ($and_default) {
$tables[] = 'peers';
$tables[] = 'tasks';
$tables[] = 'torrents';
}
$sql = '';
foreach ($tables as $table) {
$sql .= 'CHECK TABLE `' . $settings['db_prefix'] . $table . '`;' . 'ANALYZE TABLE `' . $settings['db_prefix'] . $table . '`;' . 'REPAIR TABLE `' . $settings['db_prefix'] . $table . '`;' . 'OPTIMIZE TABLE `' . $settings['db_prefix'] . $table . '`;';
}
$result = mysqli_multi_query($connection, $sql);
if ($result) {
while (mysqli_more_results($connection)) {
mysqli_next_result($connection);
mysqli_store_result($connection);
}
}
if ($result) {
task_log($connection, $settings, 'optimize', $time);
}
return $result;
}
public function ClearStoredResults($link)
{
while (mysqli_next_result($link)) {
if ($resultval = mysqli_store_result($link)) {
$this->free_result($resultval);
}
}
}
function freeDBResource($dbh)
{
while (mysqli_next_result($dbh)) {
if ($l_result = mysqli_store_result($dbh)) {
mysqli_free_result($l_result);
}
}
}
function free_mysqli_results()
{
while (mysqli_next_result($_SESSION['mysqli_link'])) {
//free each result.
$result = mysqli_use_result($_SESSION['mysqli_link']);
if ($result instanceof mysqli_result) {
$result->free();
}
}
}
public function get_consistency_board()
{
$this->config->load('wellness');
$query = "call consistency(" . $this->config->item('hw_consistency_goal') . ")";
$result = $this->db->query($query);
$array = $result->result_array();
// Need to run this to free up resource for next query
// see: http://stackoverflow.com/questions/16029729/mysql-error-commands-out-of-sync-you-cant-run-this-command-now
mysqli_next_result($this->db->conn_id);
return $array;
}
function callStoredProcedure($procedure)
{
global $link;
// if (DEBUGGING) { echo "CALL ".$procedure ."<BR>";}
$resultset = mysqli_multi_query($link, "CALL " . $procedure) or die(__FILE__ . __LINE__ . mysqli_error($link) . $procedure);
$data = mysqli_store_result($link);
// clear remaining sets in the resultset before returning
while (mysqli_more_results($link)) {
mysqli_next_result($link);
}
return $data;
}
public function query($SQL)
{
if ($SQL !== "") {
if (stristr($SQL, "call") and stripos($SQL, "call") === 0) {
mysqli_multi_query(self::$connection, $SQL);
$this->query = mysqli_store_result(self::$connection);
if (mysqli_more_results(self::$connection)) {
mysqli_next_result(self::$connection);
}
} else {
$this->query = mysqli_query(self::$connection, $SQL);
}
}
return $this->query ? $this->query : false;
}
function query($sql)
{
if (empty($this->link_id)) {
die('Нет подключения к базе данных');
}
if ($sql == '') {
die('Пустой запрос');
}
if ($this->query_id = mysqli_query($this->link_id, $sql)) {
mysqli_next_result($this->link_id);
return $this->query_id;
} else {
$this->error($sql);
}
}
function query($queryString, $params = NULL)
{
$queryString = isset($params) ? str_format($queryString, $params) : $queryString;
$queryResult = mysqli_query($this->connection, $queryString);
if ($queryResult) {
$outputArray = array();
while ($row = mysqli_fetch_assoc($queryResult)) {
$outputArray[] = $row;
}
mysqli_free_result($queryResult);
mysqli_next_result($this->connection);
return $outputArray;
}
return FALSE;
}
public static function fetch_r($r)
{
if (is_object($r)) {
$i = 0;
$arr = array();
while ($r->data_seek($i)) {
$arr[$i] = $r->fetch_row();
$i++;
}
mysqli_next_result(self::$msql);
return $arr;
} else {
return $r;
}
}
/**
* Free memory associated with the resultset
*
* @return void
*/
public function flush()
{
if ($this->result instanceof mysqli_stmt) {
$this->result->free_result();
}
$this->result = null;
$this->col_info = null;
// Sanity check before using the handle
if (empty($this->dbh) || !$this->dbh instanceof mysqli) {
return;
}
// Clear out any results from a multi-query
while (mysqli_more_results($this->dbh)) {
mysqli_next_result($this->dbh);
}
}
/**
* Send an SQL Query to the DB
*
* @param string $query
* @return mysql_result
*/
public function Query($query)
{
try {
if (!$this->connection) {
throw new ErrorException();
}
$result = mysqli_query($this->connection, $query);
while (mysqli_more_results($this->connection)) {
mysqli_next_result($this->connection);
}
return $result;
} catch (ErrorException $obj) {
@error_log($query . $this->errorString);
}
//end try
}
function executeQuery($query, $host, $user, $pass, $db, $port, $link = null)
{
if (!$link && !connect($link, $host, $user, $pass, $db, $port)) {
return false;
} else {
if (isset($db) && !mysqli_select_db($link, $db)) {
return false;
}
}
if (!mysqli_multi_query($link, $query) || $link->error != '') {
return false;
}
while (mysqli_more_results($link) && mysqli_next_result($link)) {
$discard = mysqli_store_result($link);
}
$link->commit();
return true;
}
function sql($string)
{
global $db;
global $result;
if (trim($string) === '') {
return;
}
mysqli_multi_query($db, $string) or die("MySQL Error when executing: {$string} <br/>\n" . mysqli_error($db) . "\n");
$test = true;
while (mysqli_more_results($db)) {
$test = false;
$result = mysqli_store_result($db);
mysqli_next_result($db) or die("MySQL Error when executing: {$string} <br/>\n" . mysqli_error($db) . "\n");
}
if ($test) {
$result = mysqli_store_result($db);
}
}
function clone_db($database_name = false)
{
//echo $database_name; return;
$this->db->query('CREATE DATABASE ' . $database_name);
if ($_SERVER['HTTP_HOST'] == "localhost") {
//$dbname=$database_name;
$password = "";
$username = "******";
}
if ($_SERVER['HTTP_HOST'] == "junctiondev.cloudapp.net") {
//$dbname=$database_name;
$password = "******";
$username = "******";
}
if ($_SERVER['HTTP_HOST'] == "junctiontech.in") {
//$dbname=$database_name;
$password = "******";
$username = "******";
}
$connect = mysqli_connect('localhost', $username, $password, $database_name);
$db_file = file_get_contents('school_mgt.sql');
mysqli_multi_query($connect, $db_file);
do {
mysqli_store_result($connect);
} while (mysqli_more_results($connect) && mysqli_next_result($connect));
$query = "SELECT count(*) as 'Tables', table_schema as 'Database' FROM information_schema.TABLES WHERE table_schema= '" . $database_name . "' GROUP BY table_schema";
$result = mysqli_query($connect, $query);
$countTable = mysqli_fetch_assoc($result);
//echo $countTable['Tables'];die;
if (isset($countTable['Tables']) && $countTable['Tables'] == '76') {
return true;
} else {
//$CII =& get_instance();
// $CII->load->library('session'); //if it's not autoloaded in your CI setup
// $database_name=$CII->session->userdata('db_name');
// $CII->session->unset_userdata($database_name);
// $CII->session->sess_destroy();
echo 'database does not exist';
return;
die;
}
}
protected function exec($qs)
{
if (null == $this->conn) {
return false;
}
$status = true;
foreach ($qs as $q) {
$res = @mysqli_query($this->conn, $q);
if (false == $res) {
$this->session->addError(@mysqli_error($this->conn));
$status = false;
continue;
}
if (@mysqli_more_results($this->conn)) {
@mysqli_next_result($this->conn);
@mysqli_free_result($res);
}
}
return $status;
}
private function testMysqli()
{
$connection = mysqli_connect($this->host, $this->user, $this->pass, $this->db, $this->port) or $this->error("Unable to connect:" . mysqli_connect_error());
$rows = [];
if (mysqli_multi_query($connection, "SHOW TABLES FROM {$this->db};")) {
do {
if ($result = mysqli_use_result($connection)) {
while ($row = mysqli_fetch_row($result)) {
$rows[] = $row[0];
}
if (!mysqli_more_results($connection)) {
break;
}
mysqli_free_result($result);
}
} while (mysqli_next_result($connection));
}
mysqli_close($connection);
return $rows;
}
function domy($query)
{
$link = $GLOBALS["C"]["sql"]["i"];
$data = array();
if (mysqli_multi_query($link, $query)) {
do {
/* store first result set */
if ($result = mysqli_use_result($link)) {
while ($row = mysqli_fetch_row($result)) {
$data[] = $row;
}
mysqli_free_result($result);
}
/* print divider
if (mysqli_more_results($link)) {
printf("-----------------\n");
}*/
} while (mysqli_next_result($link));
}
return $data;
}
/**
* Execute a mySQL query or multi queries
* @param string $query mySQL query, or multiple queries seperated by a ';'
* @param array $db_params db parameters array 'db_host', 'db_user', 'db_pass', 'db_port'
* @param string $db_name database name
* @param mysqli $link mysqli link
* @return true on success, false otherwise
*/
public static function executeQuery($query, $db_params, $db_name, $link = null)
{
// connect if not yet connected
if (!$link && !self::connect($link, $db_params, $db_name)) {
return false;
} else {
if (isset($db_name) && !mysqli_select_db($link, $db_name)) {
logMessage(L_ERROR, "Cannot execute query: could not find the db: {$db}");
return false;
}
}
// execute all queries
if (!mysqli_multi_query($link, $query) || $link->error != '') {
logMessage(L_ERROR, "Cannot execute query: error with query: {$query}, error: " . $link->error);
return false;
}
// flush
while (mysqli_more_results($link) && mysqli_next_result($link)) {
$discard = mysqli_store_result($link);
}
$link->commit();
return true;
}
function func_test_mysqli_next_result($link, $query, $offset, $num_results, $strict_on)
{
if (!mysqli_multi_query($link, $query)) {
printf("[%03d] [%d] %s\n", $offset, mysqli_errno($link), mysqli_error($link));
}
$i = 0;
if ($strict_on) {
ob_start();
}
do {
if ($res = mysqli_store_result($link)) {
mysqli_free_result($res);
$i++;
}
} while (true === mysqli_next_result($link));
if ($strict_on) {
$tmp = ob_get_contents();
ob_end_clean();
if (!preg_match('@Strict Standards: mysqli_next_result\\(\\): There is no next result set@ismU', $tmp)) {
printf("[%03d] Strict Standards warning missing\n", $offset + 1);
} else {
$tmp = trim(preg_replace('@Strict Standards: mysqli_next_result\\(\\).*on line \\d+@ism', '', $tmp));
}
print trim($tmp) . "\n";
}
if ($i !== $num_results) {
printf("[%03d] Expecting %d result(s), got %d result(s)\n", $offset + 2, $num_results, $i);
}
if (mysqli_more_results($link)) {
printf("[%03d] mysqli_more_results() indicates more results than expected\n", $offset + 3);
}
if (!($res = mysqli_query($link, "SELECT 1 AS b"))) {
printf("[%03d] [%d] %s\n", $offset + 4, mysqli_errno($link), mysqli_error($link));
} else {
mysqli_free_result($res);
}
}
session_start();
$facebook = new Facebook("", "");
$fb_user = $facebook->require_login();
$user_details = $facebook->api_client->users_getInfo($fb_user, 'last_name, first_name, pic');
$_SESSION['faceInfo'] = $user_details[0]['uid'];
// store session data
$id = $user_details[0]['uid'];
$name = $user_details[0]['first_name'];
$lastname = $user_details[0]['last_name'];
$query = "call checkForUserExist(" . $id . ")";
$result = mysqli_query($conn, $query);
$res = mysqli_fetch_row($result);
if ($res[0] == 0) {
mysqli_next_result($conn);
$hash = md5($id . $name . $lastname);
mysqli_next_result($conn);
$query = "call insertUserFace({$id},'{$name}', '{$lastname}','" . $user_details[0]['pic'] . "')";
$result = mysqli_query($conn, $query);
}
?>
<!-- saved from url=(0014)about:internet -->
<html lang="en">
<!--
Smart developers always View Source.
This application was built using Adobe Flex, an open source framework
for building rich Internet applications that get delivered via the
Flash Player or to desktops via Adobe AIR.
function editEmployee($conn, $empAndTraits)
{
$query = "UPDATE `test_two`.`employee_info`" . " SET `first_name`='{$empAndTraits['firstName']}'," . "`last_name` = '{$empAndTraits['lastName']}'," . "`phone_number` = '{$empAndTraits['phoneNumber']}'," . "`address`='{$empAndTraits['address']}'," . "`age`='{$empAndTraits['age']}'" . "WHERE `idemployee_info` = '{$empAndTraits['idToEdit']}';";
$query .= "UPDATE `test_two`.`traits`" . " SET `hair_color`='{$empAndTraits['hairColor']}'," . "`eye_color` = '{$empAndTraits['eyeColor']}'," . "`weight` = '{$empAndTraits['weight']}'," . "`height`='{$empAndTraits['height']}'" . "WHERE `employee_id` = '{$empAndTraits['idToEdit']}';";
if ($is_successful = mysqli_multi_query($conn, $query)) {
do {
if ($result = mysqli_store_result($conn)) {
my_sqli_free_result($result);
}
} while (mysqli_next_result($conn));
}
if ($is_successful) {
return showAllrows($conn);
} else {
return 'ERROR';
}
}
