/**
* Vy`polnenie zaprosa i vozvrashchenie deskriptora na rezul`tat
*
* Dlia khranimy`kh protcedur
* - Zamer vremeni vy`polneniia zaprosa
* - V sluchae oshibki vozvrashchaet false
* - Zapis` zaprosa i vremeni ego vy`polneniia v fai`l-loge
*
* @param string $sql zapros k BD
* @return bool|mysqli_result
* @throws Exception
*/
protected static function Query_Real($sql)
{
Zero_Logs::Info('#{SQL} ' . $sql);
$res = self::$DB->real_query($sql);
if (!$res) {
Zero_Logs::Error('#{SQL ERROR} ' . self::$DB->error);
Zero_Logs::Error('#{SQL} ' . $sql);
throw new Exception(self::$DB->error, 500);
}
return $res;
}
public function execute($sql, array $parameters = null)
{
$this->initConnection();
if ($parameters) {
$sql = $this->escapeSql($sql, $parameters);
}
$this->log($sql);
if (!$this->mysql->real_query($sql)) {
$this->checkDbError($sql);
}
}
public function insert($sql)
{
$this->errorCode = 0;
$this->lastSql = $sql;
if (!$this->MySqli->real_query($sql)) {
$this->error('insert');
}
$this->numRows = $this->MySqli->affected_rows;
return $this;
//For chaining and PONIES!!!
}
/**
* @param string $query
* @return bool|null
*/
public function real_query($query)
{
$result = parent::real_query($query);
if ($this->errno) {
$error = $this->error;
$this->rollback();
$this->ThrowQueryError($query, $error);
return null;
} else {
return $result;
}
}
/**
Initialises a mysql prepared statement.
@param $oDb The mysql link resource.
@param $sQuery The query.
*/
public function __construct(weeDatabase $oDb, mysqli $oMySQLi, $sQuery)
{
preg_match_all('/:([\\w_]+)/', $sQuery, $aMatches, PREG_OFFSET_CAPTURE);
$s = '';
$iOffset = 0;
foreach ($aMatches[1] as $aMatch) {
$this->aParametersMap[] = $aMatch[0];
$s .= substr($sQuery, $iOffset, $aMatch[1] - $iOffset - 1) . '?';
$iOffset = $aMatch[1] + strlen($aMatch[0]);
}
$s .= substr($sQuery, $iOffset);
$this->sStatementName = 'st_' . md5($sQuery);
$this->oDb = $oDb;
$this->oMySQLi = $oMySQLi;
$s = 'PREPARE ' . $this->sStatementName . ' FROM ' . $this->oDb->escape($s);
$oMySQLi->real_query($s) or burn('DatabaseException', sprintf(_WT("Failed to prepare the query with the following error:\n%s"), $oMySQLi->error));
}
public function test(Request $request)
{
$db = new \mysqli('localhost', 'root', 'root', 'ryan');
$count = 10;
/*
$category_map = array('/shop/art-design-books'=>'6','/shop/backpacks'=>'3','/shop/bags'=>'3','/shop/bar'=>'5','/shop/blocks'=>'8','/shop/books'=>'6','/shop/camping'=>'7','/shop/candles'=>'5','/shop/clocks'=>'5','/shop/coffee-&-tea'=>'5','/shop/cycling'=>'7','/shop/everyday-carry'=>'1','/shop/fragrance'=>'2','/shop/furniture'=>'5','/shop/gadgets'=>'4','/shop/garden'=>'5','/shop/handbags'=>'9','/shop/headphones'=>'4','/shop/home'=>'5','/shop/kitchen'=>'5','/shop/kitchen-knives'=>'5','/shop/knit-hats'=>'3','/shop/lighting'=>'5','/shop/mens-apparel'=>'10','/shop/men-s-shoes'=>'10','/shop/mugs'=>'5','/shop/office'=>'1','/shop/personal-care'=>'1','/shop/photography'=>'4','/shop/photography-books'=>'6','/shop/picnic'=>'5','/shop/pocket-knives'=>'7','/shop/socks'=>'3','/shop/speakers'=>'4','/shop/stationery'=>'1','/shop/storage-&-organization'=>'5','/shop/sunglasses'=>'3','/shop/toys-&-things'=>'8','/shop/watches'=>'3','/shop/water-bottles'=>'1','/shop/womens-apparel'=>'9','/shop/womens-shoes'=>'9');
foreach($category_map as $from_where => $to_where)
{
$db->query("UPDATE `canopy_item_list` SET `to_where`='{$to_where}' WHERE `from_where`='{$from_where}'");
}
dd($category_map);
*/
for ($i = 1; $i < 11; $i++) {
$results = $db->query("SELECT * FROM `canopy_item_list` WHERE `title`<>'' AND `price`<>'' AND `image_data`<>'' AND `to_where` = {$i} AND `sent_at` IS NULL ORDER BY `id` ASC LIMIT 0,{$count}");
while ($row = $results->fetch_assoc()) {
$this->post->storeCurated($row, $i);
$db->real_query("UPDATE `canopy_item_list` SET `sent_at` = CURRENT_TIMESTAMP WHERE id={$row['id']}");
}
}
$db->close();
}
<?php
//LOGOWANIE TaWuA8kf
$haslo = $_GET['password'];
$login = $_GET['name'];
$servername = "db.zut.edu.pl";
$dbname = "gg36296";
$username = "******";
$password = "******";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} else {
$sql = "SELECT name,password FROM accountdata WHERE name LIKE '{$login}' AND password LIKE '{$haslo}' ";
$conn->real_query($sql);
$res = $conn->use_result();
while ($row = $res->fetch_assoc()) {
if ($login == $row['name'] && $haslo == $row['password']) {
echo "xD";
} else {
echo "login or password is incorrect";
}
}
}
<?php
$IP = "localhost";
$USER = "******";
$PASS = "******";
$BD = "shop";
$mysqli = new mysqli($IP, $USER, $PASS, $BD);
if ($mysqli->connect_errno) {
echo "Falló la conexión con MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
$mysqli->real_query("SELECT * FROM books");
$resultado = $mysqli->use_result();
while ($fila = $resultado->fetch_assoc()) {
echo "Id = " . $fila['book_id'] . "<br>";
echo "Titulo = " . $fila['title'] . "<br>";
echo "Autor = " . $fila['author'] . "<br>";
echo "Precio = " . $fila['price'] . "<br>";
echo "<br>";
}
function callMySQLIProcedure($sql)
{
$mysqli = new mysqli(XOOPS_DB_HOST, XOOPS_DB_USER, XOOPS_DB_PASS, XOOPS_DB_NAME);
$mysqli->real_query($sql);
$result = $mysqli->store_result();
$row = $result->fetch_assoc();
$status = $row['status'];
$mysqli->close();
return $status;
}
<?php
$mysqli = new mysqli("localhost", "daohang", "e02b2943b3c6265b12da8f385f7cab75", "daohang");
/* check connection */
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
/* change character set to utf8 */
if (!$mysqli->set_charset("utf8")) {
printf("Error loading character set utf8: %s\n", $mysqli->error);
} else {
//printf("Current character set: %s\n", $mysqli->character_set_name());
}
$mysqli->real_query("select *from xinwenkeji order by id asc");
$res = $mysqli->use_result();
$items = array();
while ($row = $res->fetch_assoc()) {
//print_r($row);
array_push($items, $row);
}
echo json_encode($items);
//echo $_GET['query'];
/**
* Выполнение SQL запроса.
*
* Если запрос вернет несколько наборов результатов(multi query)
* будет обработан только первый. Все остальные будут проигнорированы,
* а соединение с базой данных будет доступно для следующих запросов.
*
* Данный метод реккомендуется использовать для выполнения
* хранимых продцедур, которые возвращают один набор результатов.
* Второй набор результатов OK/ERR будет автоматически проигнорирован.
*
* @throws DBException в случае возникновения ошибки в запросе
* @param string $query SQL запрос
* @param int $flags флаги для обработки результатов доступны следующие флаги: {@link DB::USE_RESULT DB::USE_RESULT}, {@link DB::STORE_RESULT},
* {@link DB::FETCH_NUM DB::FETCH_NUM }, {@link DB::FETCH_ASSOC DB::FETCH_ASSOC }, {@link DB::FETCH_BOTH DB::FETCH_BOTH };
* @return mixed массив результатов; affected_rows в случает успешного "UPDATE"-одобного запроса; lastInsertedId в случае insert запроса.
*/
public static function query($query, $flags = null)
{
//print_pre('==============================mysql:<b>'.$query.'</b>' );
$r = self::$mysqli->real_query($query);
if ($r === true) {
// process flags
$data_process = 'mysqli_store_result';
if ($flags & DB::USE_RESULT) {
$data_process = 'mysqli_use_result';
}
//var_dump($data_process);
$resulttype = MYSQLI_ASSOC;
if ($flags & DB::FETCH_NUM) {
$resulttype = MYSQLI_NUM;
} else {
if ($flags & DB::FETCH_BOTH) {
$resulttype = MYSQLI_BOTH;
}
}
$res = call_user_func($data_process, self::$mysqli);
if (is_object($res)) {
$data = array();
while (($d = $res->fetch_array($resulttype)) !== null) {
$data[] = $d;
}
} else {
if (strcmp(strtolower(substr(ltrim($query), 6)), 'insert')) {
$data = self::$mysqli->insert_id;
} else {
$data = self::$mysqli->affected_rows;
}
}
self::clearResultset($res);
return $data;
} else {
throw new DBException(self::$mysqli->error, self::$mysqli->errno, $query);
}
}
public static function getDBSize($dbname, mysqli $mysqli)
{
$sql = "SELECT\n\t\t\tTABLE_SCHEMA AS db_name,\n\t\t\tCONCAT(TRUNCATE(SUM(data_length)/1024/1024,2),' MB') AS data_size,\n\t\t\tCONCAT(TRUNCATE(SUM(index_length)/1024/1024,2),'MB') AS index_size\n\t\tFROM information_schema.tables WHERE TABLE_SCHEMA='{$dbname}'\n\t\tGROUP BY TABLE_SCHEMA\n\t\tORDER BY data_length DESC";
if (!$mysqli->real_query($sql)) {
if (self::$verbose) {
echo 'getDBSize failed:' . $mysqli->error . "\n";
}
return false;
}
$result = $mysqli->store_result();
if ($row = $result->fetch_assoc()) {
return $row;
}
if (self::$verbose) {
echo "Schema {$dbname} not exist\n";
}
return false;
}
/**
* Execute an SQL query.
*
* Wrapper around [mysqli::real_query](http://php.net/manual/en/mysqli.real-query.php), however on failure an
* exception is thrown.
*
* @param string $query The SQL statement.
*/
protected static function realQuery($query)
{
if (self::$logQueries) {
$time0 = microtime(true);
$ret = self::$mysqli->real_query($query);
if ($ret === false) {
throw new DataLayerException(self::$mysqli->errno, self::$mysqli->error, $query);
}
self::$queryLog[] = ['query' => $query, 'time' => microtime(true) - $time0];
} else {
$ret = self::$mysqli->real_query($query);
if ($ret === false) {
throw new DataLayerException(self::$mysqli->errno, self::$mysqli->error, $query);
}
}
}
<?php
$mysqli = new mysqli("localhost", "daohang", "e02b2943b3c6265b12da8f385f7cab75", "daohang");
/* check connection */
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
/* change character set to utf8 */
if (!$mysqli->set_charset("utf8")) {
printf("Error loading character set utf8: %s\n", $mysqli->error);
} else {
//printf("Current character set: %s\n", $mysqli->character_set_name());
}
$mysqli->real_query("SELECT * FROM xinwenyule ORDER BY id ASC");
$res = $mysqli->use_result();
//echo "Result set order...\n";
while ($row = $res->fetch_assoc()) {
echo $row['title'] . $row['author'] . $row['link'] . '\\n';
echo '<a href="' . $row['link'] . '" target="_blank">' . $row['title'] . ' by ' . $row['author'] . '</a>';
}
public function setUp()
{
if (!self::$mysql->real_query("TRUNCATE TABLE " . self::$DB_TABLE_NAME)) {
throw new \Exception("Could not truncate table");
}
}
if (!$mysqli->query("DROP TABLE IF EXISTS test") || !$mysqli->query("CREATE TABLE test(id INT)") || !$mysqli->query("INSERT INTO test(id) VALUES (1), (2), (3)")) {
echo "Table creation failed: (" . $mysqli->errno . ") " . $mysqli->error;
}
$res = $mysqli->query("SELECT id FROM test ORDER BY id ASC");
echo "Reverse order...\n";
for ($row_no = $res->num_rows - 1; $row_no >= 0; $row_no--) {
$res->data_seek($row_no);
$row = $res->fetch_assoc();
echo " id = " . $row['id'] . "\n";
}
echo "Result set order...\n";
$res->data_seek(1);
while ($row = $res->fetch_assoc()) {
echo " id = " . $row['id'] . "\n";
}
$mysqli->real_query("SELECT id FROM test ORDER BY id ASC");
$res = $mysqli->use_result();
echo "Result set order...\n";
while ($row = $res->fetch_assoc()) {
echo " id = " . $row['id'] . "\n";
}
if (!$mysqli->query("DROP TABLE IF EXISTS test") || !$mysqli->query("CREATE TABLE test(id INT, label CHAR(1))") || !$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')")) {
echo "Table creation failed: (" . $mysqli->errno . ") " . $mysqli->error;
}
$res = $mysqli->query("SELECT id, label FROM test WHERE id = 1");
$row = $res->fetch_assoc();
printf("id = %s (%s)\n", $row['id'], gettype($row['id']));
printf("label = %s (%s)\n", $row['label'], gettype($row['label']));
/* Prepared statement, stage 1: prepare */
if (!($stmt = $mysqli->prepare("INSERT INTO test(id) VALUES (?)"))) {
echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
<?php
if ($_SERVER['REMOTE_ADDR'] != '127.0.0.1') {
die(__('You must run this script from your localhost (to stop hackers)'));
}
if (isset($_POST['action']) && $_POST['action'] == 'convert') {
$mysqli = new mysqli($_POST['hostname'], $_POST['username'], $_POST['password'], $_POST['database']);
if ($mysqli->connect_error) {
die(__('Connect Error') . ' (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
}
// { products
$query = $mysqli->real_query('select * from wp_wpsc_product_list');
if (!($result = $mysqli->use_result())) {
die(__('error retrieving products list'));
}
$products = array();
while ($row = $result->fetch_array()) {
$products[] = array('id' => $row['id'], 'name' => $row['name'], 'product_type_id' => 1, 'image_default' => 0, 'enabled' => $row['active'], 'date_created' => $row['date_added'], 'data_fields' => json_encode(array(array('n' => 'description', 'v' => $row['description']), array('n' => 'additional_description', 'v' => $row['additional_description']))), 'images_directory' => '/products/product-images/' . $row['id'], 'online_store_fields' => json_encode(array('_price' => $row['price'], '_weight(kg)' => $row['weight'], '_vatfree' => $row['notax'])));
}
// }
// { images
$images = array();
$query2 = $mysqli->real_query('select * from wp_wpsc_product_images order by product_id,image_order');
if (!($result = $mysqli->use_result())) {
die(__('error retrieving products list'));
}
while ($row = $result->fetch_array()) {
if ($row['image_order'] == '') {
$row['image_order'] = '_';
}
$images[] = array($row['product_id'] . '/' . $row['image_order'] . $row['image'], $_POST['url'] . 'wp-content/uploads/wpsc/product_images/' . $row['image']);
