/**
* @param $sql string
* // todo: add fetch types
* @param string $fetch_type string [assoc, object, ...]
* @return array
*/
public function query($sql, $fetch_type = 'assoc')
{
// todo: check sql string
$this->mysqli->query($sql);
$rows = array();
$result = $this->mysqli->query($sql);
if (!$result) {
$this->loger->addLog(LOG_ERR, mysqli_error($this->mysqli));
// todo: goto html output
die;
}
switch ($fetch_type) {
default:
case 'assoc':
while ($row = $result->fetch_assoc()) {
$rows[] = $row;
}
break;
case 'object':
while ($row = $result->fetch_object()) {
$rows[] = $row;
}
break;
}
return $rows;
}
public function query($sql, $mode = MYSQLI_STORE_RESULT)
{
$this->_QSQL[] = $sql;
Mdl_Mysql_Safecheck::checkquery($sql);
if ($rs = $this->query($sql, $mode)) {
return new Mdl_Mysqli_Result($rs);
}
$this->_ERR[] = $this->errno . ':' . $this->error;
return false;
$this->connect();
if (__CFG::DEBUG) {
$starttime = microtime(true);
}
$rs = parent::query($sql, $mode);
if (__CFG::DEBUG) {
$errno = $this->errno;
$exec_time = number_format(microtime(true) - $starttime, 6);
$this->total_exec_time += $exec_time;
$this->_QSQL[] = array($sql, $exec_time, $this->link, $errno);
if ($errno > 0) {
$this->_ESQL[] = array($sql, $this->mysql_debug_backtrace(), $errno, $this->error);
}
}
if (preg_match("/(SELECT|SHOW|DESCRIBE|EXPLAIN)\\s+/i", $sql, $match)) {
return new Mdl_Mysqli_Result($rs);
}
return $rs;
}
/**
* Revert this migration
*/
public function runDown()
{
foreach ($this->buildPredown() as $query) {
Output::verbose('PREDOWN: ' . $query);
if ($this->db->query($query)) {
Output::verbose("Ok");
} else {
Output::verbose($this->db->error);
}
}
foreach ($this->buildDown() as $query) {
Output::verbose('DOWN:' . $query);
$this->db->query($query);
}
foreach ($this->buildPostdown() as $query) {
Output::verbose('POSTDOWN: ' . $query);
if ($this->db->query($query)) {
Output::verbose("Ok");
} else {
Output::verbose($this->db->error);
}
}
$verT = Helper::get('versiontable');
$rev = $this->getRev();
$query = "DELETE FROM `{$verT}` WHERE `rev`={$rev}";
Output::verbose($query);
$this->db->query($query);
}
public function query($query, $mode = MYSQLI_STORE_RESULT)
{
$res = parent::query($query, $mode);
if (!$res) {
throw new SphinxException($this->error);
}
return $res;
}
/**
* Using native connector, query against Db server.
*
* @param string $query Query to be performed.
* @return mixed|DbIterator
* @throws DbLinkException Thrown when an error occur on querying.
*/
public function query($query)
{
$result = $this->link->query($query);
if (false === $result) {
$message = <<<ERROR
Error on '{$this->user}@{$this->host}' when executing
{$query}
Message error: {$this->link->error}
ERROR;
$this->errors[] = $message;
throw new DbLinkException($message);
}
if (!$result instanceof \mysqli_result) {
return $result;
}
return new MysqlIterator($result);
}
/**
* Returns the custom table's name for a module
*
* @param string $module Module's name
*
* @throws \InvalidArgumentException
*
* @return string Returns the table name
*/
public function getModuleCustomTable($module)
{
$sugarBean = $this->getBean($module);
$customTable = $sugarBean->get_custom_table_name();
$data = $this->db->query("SHOW TABLES LIKE '{$customTable}'");
if (empty($data)) {
return '';
}
return $customTable;
}
function RegisterMember(User $newUser, $RegDate, $name, $image)
{
global $connection;
// if (!find_member($Lname,$DOB)) {
$query = "INSERT INTO members(id,Lname,Fname,Title,Gender,DOB,MemberImageName,MemberImage,Phone,Email,Program,Year,Hall,Parish,Subgroups,RegDate) \n\tVALUES(\n\t\t'',\n\t\t'{$newUser->getLastName()}',\n\t\t'{$newUser->getFirstName()}',\n\t\t'{$newUser->getTitle()}',\n\t\t'{$newUser->getGender()}',\n\t\t'{$newUser->getDateOfBirth()}',\n\t\t'{$name}',\n\t\t'{$image}',\n\t\t'{$newUser->getPhoneNumber()}',\n\t\t'{$newUser->getEmail()}',\n\t\t'{$newUser->getProgram()}',\n\t\t'{$newUser->getYear()}',\n\t\t'{$newUser->getHall()}',\n\t\t'{$newUser->getParish()}',\n\t\t'{$newUser->getSubGroup()}',\n\t\t'{$RegDate}'\n\t\t)";
// mysql_query($query,$connection);
// // confirm_query($result_set);
// if (mysql_affected_rows() == 1) {
// echo "success";
// }
// else {
// echo "err2";
// }
$mysqli = new Mysqli('localhost', 'root', 'PASSword1', 'paxromanadata');
return $mysqli->query($query);
}
/**
* Run the actual query with deadlock checks
* @return bool|object
* @throws TransactionDeadlockException
*/
protected function runQuery()
{
$numRetry = 0;
do {
$returned = $this->isSingleQuery ? $this->connection->query($this->sqlQuery) : $this->connection->multi_query($this->sqlQuery);
if ($returned) {
break;
}
$errno = mysqli_errno($this->connection);
if ($errno != '1205' && $errno != '1213') {
break;
}
// innodb deadlock; retry or if in transaction throw exception
if ($this->isTransaction) {
$this->rollback();
throw new TransactionDeadlockException('Transaction deadlock.');
}
if ($numRetry == 5) {
sleep(1);
}
++$numRetry;
} while ($numRetry < 10);
return $returned;
}
<?php
error_reporting(0);
$conn = new Mysqli($host, $usuario, $cont, $bdd);
if ($conn->connect_error) {
die($conn->connect_error);
}
if ($_POST) {
$nombre = $_POST['nombre'];
$email = $_POST['email'];
$telefono = $_POST['telefono'];
$direccion = $_POST['direccion'];
$usuario = $_POST['usuario'];
$contrasenia = $_POST['contrasenia'];
if ($nombre != '' && $email != '' && $telefono != '' && $direccion != '' && $usuario != '' && $contrasenia != '') {
$q_insert = "insert into registro(nombre,email,telefono,direccion,usuario,contrasenia)\n values ('{$nombre}', '{$email}', '{$telefono}', '{$direccion}','{$usuario}','{$econtrasenia}')";
$res = $conn->query($q_insert);
if (!$res) {
echo '<div align="center"> No se puede guardar datos' . $conn->error . '</div>';
} else {
echo '<div align="center">Informacion guardada correctamente.</div>';
}
}
}
?>
<p align="center">
<a href="./index.html">Formulario de registro</a>
</p>
</body>
</html>
<?php
if (isset($_POST['name'], $_POST['age'])) {
$db = new Mysqli("localhost", "root", "", "postdata");
$name = $db->real_escape_string($_POST['name']);
$age = (int) $_POST['age'];
$query = "INSERT INTO data SET mydata='{$name}, {$age}'";
$db->query($query);
}
error_reporting(E_ALL);
ini_set('display_errors', 1);
require 'vendor/autoload.php';
use sandeepshetty\shopify_api;
?>
<?php
echo 'ssss';
session_start();
//start a session
$db = new Mysqli("localhost", "root", "", "shopify_app");
if ($db->connect_errno) {
die('Connect Error: ' . $db->connect_errno);
}
$select_settings = $db->query("SELECT * FROM tbl_appsettings WHERE id = 1");
$app_settings = $select_settings->fetch_object();
if (!empty($_GET['shop'])) {
//check if the shop name is passed in the URL
$shop = $_GET['shop'];
//shop-name.myshopify.com
$select_store = $db->query("SELECT store_name FROM tbl_usersettings WHERE store_name = '{$shop}'");
//check if the store exists
if ($select_store->num_rows > 0) {
if (shopify_api\is_valid_request($_GET, $app_settings->shared_secret)) {
//check if its a valid request from Shopify
$_SESSION['shopify_signature'] = $_GET['signature'];
$_SESSION['shop'] = $shop;
header('Location: http://localhost/shopifyapi/admin.php');
//redirect to the admin page
}
<?php
//include 'conf.php';
//$name = $_POST['name'];
$comment = $_POST['comment'];
$article_id = $_POST['article_id'];
$user_login = $_POST['user_login'];
echo $article_id;
echo $comment;
$mysqli = new Mysqli('localhost', 'u911040123_admin', 'olko111', 'u911040123_ki');
//$mysqli->query("SET NAMES utf8");
$mysqli->query("INSERT INTO `comm`(`article_id`, `user_login`, `comment`) VALUES('{$article_id}','{$user_login}', '{$comment}')");
?>
<?php
header("Content-Type: text/html; charset=UTF-8");
//$count = $_POST['count'];
$data = $_POST['data'];
//$article_id=$_POST['article_id'];
//echo $count ;
//echo $article_id;
$mysqli = new Mysqli('localhost', 'root', '', 'ki');
$mysqli->query("SET NAMES utf8");
$r = array();
$mysqli->query("INSERT INTO `comm`( `comment`) VALUES( '{$data}')");
/**
* Чистый запрос для дебаггера
*
* $param string $sql
*
* @return void
*/
public function rawQuery($sql)
{
return parent::query($sql);
}
<?php
require_once 'vendor/autoload.php';
use phpish\shopify;
session_start();
//start a session
$db = new Mysqli("localhost", "root", "Coramaebanjo1!", "zoomATron");
if ($db->connect_errno) {
die('Connect Error: ' . $db->connect_errno);
}
$select_settings = $db->query("SELECT * FROM zoomATronsettings WHERE id = 1");
$app_settings = $select_settings->fetch_object();
if (!empty($_GET['shop'])) {
//check if the shop name is passed in the URL
$shop = $_GET['shop'];
//shop-name.myshopify.com
$select_store = $db->query("SELECT store_name FROM zat_usersettings WHERE store_name = '{$shop}'");
//check if the store exists
if ($select_store->num_rows > 0) {
if (shopify_api\is_valid_request($_GET, $app_settings->shared_secret)) {
//check if its a valid request from Shopify
$_SESSION['shopify_signature'] = $_GET['signature'];
$_SESSION['shop'] = $shop;
header('Location: http://localhost/shopify_testing/admin.php');
//redirect to the admin page
}
} else {
//convert the permissions to an array
$permissions = json_decode($app_settings->permissions, true);
//get the permission url
$permission_url = shopify_api\permission_url($_GET['shop'], $app_settings->api_key, $permissions);
$page = 0;
$date = '2011-06-20';
$loop = true;
$numrows = 0;
$limit = isset($ops['limit']) && !empty($ops['limit']) ? $ops['limit'] : 100000;
$start = isset($ops['start']) && !empty($ops['start']) ? $ops['start'] : 218000000;
$total = isset($ops['total']) && !empty($ops['total']) ? $ops['total'] : 1000000;
$end = $start + $total;
while ($loop) {
$offset = $page * $limit;
$sql = "SELECT \n\t \t \t PageView.session,DimRequest.request_uri,\n\t \t \t DimDate.report_hour,DimDate.report_day,DimDate.report_month,DimDate.report_year,\n\t \t \t DimLocation.country_code,\n\t \t \t DimLocation.region_name,\n\t \t \t PageView.mobile\n\t \t \t FROM fact_page_views `PageView`\n\t \t \t INNER JOIN dim_requests `DimRequest` on DimRequest.id = PageView.dim_request_id\n\t \t \t INNER JOIN dim_dates `DimDate` on DimDate.id = PageView.dim_date_id\n\t \t \t INNER JOIN dim_locations `DimLocation` on DimLocation.id = PageView.dim_location_id\n\t \t \t WHERE PageView.id > {$start} AND PageView.id <= {$end}\n\t \t \t ORDER BY PageView.id ASC\n\t \t \t LIMIT {$offset},{$limit}";
//$mysql->refresh();
//test
$start_time = time();
echo "Start Query Page ({$page}) \n";
$test = $mysql->query($sql);
echo "Query Time:";
echo time() - $start_time;
echo "\n";
echo "Query: \n";
echo $sql;
echo "\n";
if ($test->num_rows > 0) {
while ($row = $test->fetch_row()) {
foreach ($row as $k => $v) {
$row[$k] = preg_replace("/[',]/", "", $v);
}
$day = strlen($row[3]) == 1 ? "0" . $row[3] : $row[3];
//date string
$row[] = $row[5] . "-" . $row[4] . "-" . $day;
//date hour string
<?php
header("Content-Type: text/html; charset=UTF-8");
$count = $_POST['count'];
//$article_id=$_POST['article_id'];
//echo $count ;
//echo $article_id;
$mysqli = new Mysqli('localhost', 'root', '', 'ki');
$mysqli->query("SET NAMES utf8");
$r = array();
$result = $mysqli->query("SELECT * FROM comm WHERE id > {$count}");
while ($row = $result->fetch_assoc()) {
$r[] = $row;
}
if (empty($r)) {
echo "empty";
} else {
echo json_encode($r);
}
public function query($q)
{
return parent::query($q);
}
<meta charset="utf-8">
<title>Cancelar Registro</title>
</head>
<body>
<?php
$conn = new Mysqli($host, $usuario, $cont, $bdd);
if ($conn->connect_error) {
die($conn->connect_error);
}
if ($_POST) {
$id = $_POST['id'];
$q_delete = "delete from registro where id ='{$id}'";
$r = $conn->query($q_delete);
if (!$r) {
echo '<div align="center">No se puede cancelar el registro seleccionado</div>';
} else {
echo '<div align="center">Registro se a cancelado exitosamente</div>';
}
}
?>
<p align="center">
<a href="./index.php">Formulario de registro</a>
</p>
</body>
</html>
<?php
$allSets = json_decode(file_get_contents('/var/www/AllSets.json'));
$db = new Mysqli("localhost", "root", "root", "Hearthstone");
$now = date('Y-m-d H:i:s', time());
foreach ($allSets as $set => $cards) {
foreach ($cards as $card) {
// reset
unset($setId);
$class = 1;
$faction = 1;
$rarity = 1;
$artist = 1;
// Set
$query = "SELECT id FROM `Set` WHERE name = '{$set}'";
$result = $db->query($query);
$row = mysqli_fetch_assoc($result);
$setId = $row['id'];
if ($setId == NULL) {
$query = "INSERT INTO `Set` (name, created) VALUES('{$set}', '{$now}')";
$db->query($query);
$setId = $db->insert_id;
}
// Class
if ($card->playerClass) {
$query = "SELECT id FROM Class WHERE name = '{$card->playerClass}'";
$result = $db->query($query);
$row = mysqli_fetch_assoc($result);
$class = $row['id'];
if ($class == NULL) {
$query = "INSERT INTO Class (name, created) VALUES('{$card->playerClass}', '{$now}')";
<?php
$__t1 = microtime(TRUE);
if (!file_exists(__DIR__ . '/config.php')) {
die("缺少 config.php 文件，可以尝试 mv config.sample.php config.php");
} else {
require_once __DIR__ . '/config.php';
}
/// 创建数据库连接
$mysqli = new Mysqli($DB_HOST, $DB_USER, $DB_PASSWORD, $DB_DATABASE);
if (!$mysqli) {
LOGE('无法创建 MySQL 连接: ' . $mysqli->error);
die;
}
$mysqli->query("set NAMES 'utf8'");
$CSP_NONCE = uniqid() . 'X' . rand();
require_once __DIR__ . '/func.php';
function getAmount()
{
$id = $_GET['id'];
$type = $_GET['type'];
$mysqli = new Mysqli(DBSERVER, DBUSER, DBPWD, DB);
switch ($type) {
case "cantine":
case "repas":
$query = "SELECT `montantfcp`,`montanteuro`,`restearegler` FROM `" . DB . "`.`factures_cantine` WHERE `idfacture` = {$id}";
$result = $mysqli->query($query);
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
//$output = "&montantcfp=".$row['montantfcp']."&montanteuro=".$row['montanteuro']."&restearegler=".$row['restearegler'];
$output = $row;
}
break;
case "etal":
$query = "SELECT `montantfcp`,`montanteuro`,`restearegler` FROM `" . DB . "`.`factures_etal` WHERE `idfacture` = {$id}";
$result = $mysqli->query($query);
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
//$output = "&montantcfp=".$row['montantfcp']."&montanteuro=".$row['montanteuro']."&restearegler=".$row['restearegler'];
$output = $row;
}
break;
case "amarrage":
$query = "SELECT `montantfcp`,`montanteuro`,`restearegler` FROM `" . DB . "`.`factures_amarrage` WHERE `idfacture` = {$id}";
$result = $mysqli->query($query);
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
//$output = "&montantcfp=".$row['montantfcp']."&montanteuro=".$row['montanteuro']."&restearegler=".$row['restearegler'];
$output = $row;
}
break;
}
$mysqli->close();
return $output;
}
<?php
//error_reporting(E_ALL);
session_start();
$mysqli = new Mysqli('localhost', 'root', '923885', 'cacp_gestor');
//$mysqli = new Mysqli('192.168.0.58', 'root', 'admin923885', 'cacp_gestor');
//$mysqli = new Mysqli('localhost:3307', 'root', 'admin923885', 'cacp_gestor');
$empresaId = $_SESSION['selected_company'];
$result = $mysqli->query("SET NAMES 'UTF8'") or die($mysqli->error);
$result = $mysqli->query("\t\t\t\n\t\t\t\tSELECT \n\t\t\t\tid\t\t\t\t\n\t\t\t\tFROM\t\t\t\t\t\t\t\t\n\t\t\t\tusuarios\n\t\t\t\tWHERE\n\t\t\t\thash = '" . $_SESSION['userhash'] . "'\t\t\t\t\n\t\t\t\t") or die($mysqli->error);
$userId = null;
if ($result->num_rows) {
$r = $result->fetch_assoc();
$userId = $r['id'];
}
public function __construct()
{
$args = func_get_args();
for ($i = 0; $i < 6; $i++) {
if (!isset($args[$i])) {
$args[$i] = NULL;
}
}
if ($args[0] instanceof \MySQLi) {
$mysqli = $args[0];
} else {
$mysqli = new \Mysqli($args[0], $args[1], $args[2], $args[3], $args[4], $args[5]);
}
$callbacks = array();
$wrapper = $this;
$callbacks['__tostring'] = function () use($mysqli) {
@($res = '(Gaia\\DB\\MySQLi object - ' . "\n" . ' [affected_rows] => ' . $mysqli->affected_rows . "\n" . ' [client_info] => ' . $mysqli->client_info . "\n" . ' [client_version] => ' . $mysqli->client_version . "\n" . ' [connect_errno] => ' . $mysqli->connect_errno . "\n" . ' [connect_error] => ' . $mysqli->connect_error . "\n" . ' [errno] => ' . $mysqli->errno . "\n" . ' [error] => ' . $mysqli->error . "\n" . ' [field_count] => ' . $mysqli->field_count . "\n" . ' [host_info] => ' . $mysqli->host_info . "\n" . ' [info] => ' . $mysqli->info . "\n" . ' [insert_id] => ' . $mysqli->insert_id . "\n" . ' [server_info] => ' . $mysqli->server_info . "\n" . ' [server_version] => ' . $mysqli->server_version . "\n" . ' [sqlstate] => ' . $mysqli->sqlstate . "\n" . ' [protocol_version] => ' . $mysqli->protocol_version . "\n" . ' [thread_id] => ' . $mysqli->thread_id . "\n" . ' [warning_count] => ' . $mysqli->warning_count . "\n" . ')');
return $res;
};
$callbacks['prep_args'] = $prep_args = function ($query, array $args) use($mysqli) {
if (!$args || count($args) < 1) {
return $query;
}
return \Gaia\DB\Query::prepare($query, $args, function ($v) use($mysqli) {
return "'" . $mysqli->real_escape_string($v) . "'";
});
};
$callbacks['execute'] = function ($query) use($mysqli, $prep_args) {
$args = func_get_args();
array_shift($args);
return $mysqli->query($prep_args($query, $args));
};
$callbacks['start'] = function () use($mysqli) {
return $mysqli->query('START TRANSACTION');
};
$callbacks['autocommit'] = function ($mode) use($wrapper) {
return $mode ? $wrapper->commit() : $wrapper->start();
};
$callbacks['hash'] = function () use($mysqli) {
return spl_object_hash($mysqli);
};
$callbacks['rollback'] = function () use($mysqli) {
return $mysqli->query('ROLLBACK');
};
$callbacks['commit'] = function () use($mysqli) {
return $mysqli->query('COMMIT');
};
$callbacks['prepare'] = function ($query) {
trigger_error('unsupported method ' . __CLASS__ . '::' . __FUNCTION__, E_USER_ERROR);
exit;
};
$callbacks['close'] = function () use($mysqli, $wrapper) {
Connection::remove($wrapper);
if ($wrapper->lock) {
return FALSE;
}
$rs = $mysqli->close();
$wrapper->lock = TRUE;
return $rs;
};
$callbacks['__get'] = function ($k) use($mysqli) {
return $mysqli->{$k};
};
$callbacks['__call'] = function ($method, array $args) use($mysqli) {
return call_user_func_array(array($mysqli, $method), $args);
};
$callbacks['query'] = function ($query, $mode = MYSQLI_STORE_RESULT) use($mysqli, $wrapper) {
if ($wrapper->lock) {
return FALSE;
}
$res = $mysqli->query($query, $mode);
if ($res) {
return $res;
}
if ($wrapper->txn) {
Transaction::block();
$wrapper->lock = TRUE;
}
return $res;
};
$callbacks['multi_query'] = function ($query) use($mysqli, $wrapper) {
if ($wrapper->lock) {
return FALSE;
}
$res = $mysqli->multi_query($query);
if ($res) {
return $res;
}
if ($wrapper->txn) {
Transaction::block();
$wrapper->lock = TRUE;
}
return $res;
};
$callbacks['real_query'] = function ($query) use($mysqli, $wrapper) {
if ($wrapper->lock) {
return FALSE;
}
$res = $mysqli->real_query($query);
if ($res) {
return $res;
}
if ($wrapper->txn) {
Transaction::block();
$wrapper->lock = TRUE;
}
return $res;
};
$callbacks['isa'] = function ($name) use($wrapper, $mysqli) {
if ($wrapper instanceof $name) {
return TRUE;
}
if ($mysqli instanceof $name) {
return TRUE;
}
$name = strtolower($name);
if ($name == 'mysqli') {
return TRUE;
}
//if( strpos($name, 'mysqli') !== FALSE ) return TRUE;
return FALSE;
};
parent::__construct($callbacks);
}
/**
* Get all revisions that have been applied to the database
*
* @param Mysqli $db Database instance
* @return array|bool List of applied revisions, False on error
*/
static function getDatabaseVersions(Mysqli $db)
{
$result = array();
$tbl = self::get('versiontable');
$res = $db->query("SELECT rev FROM `{$tbl}` ORDER BY rev ASC");
if ($res === false) {
return false;
}
while ($row = $res->fetch_array(MYSQLI_NUM)) {
$result[] = $row[0];
}
return $result;
}
