Category: АГЕНЦИЯ ПО СОРТОИЗПИТВАНЕ

Presenting several UTF-8 / Multibyte-aware escape functions.These functions represent alternatives to mysqli::real_escape_string, as long as your DB connection and Multibyte extension are using the same character set (UTF-8), they will…

Despite native driver (mysqlnd 8.3.20) and MySQL >5.6, the flagMYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT will cause connection to be rejected as "not secure", if server is set to require SSL connection (--require-secure-transport=ON). It appears…

Beware, trigger_error() is absolutely useless for transporting your own function's error messages in $php_errormsg:ini_set('track_errors', TRUE);function x() { trigger_error('MY ERROR'); }@x();echo "Error 1: \"$php_errormsg\"\n";@file_get_contents('/nonexisting');echo "Error 2: \"$php_errormsg\"\n";This outputs:Error 1: ""Error 2:…

Please note that this property returns different versionstrings for MariaDB instances on LINUX and WINDOWS environments.For a MariaDB instance 10.0.17:on LINUX, this returns strings like "10.0.17-MariaDB-log"on WINDOWS environments, this returns…

В периода 15 – 17 юли се проведе работна среща между представители на CREA-DC - Италианска република и Изпълнителна агенция по сортоизпитване, апробация и семеконтрол. Бяха посетени опитите със слънчоглед…

Improved version of using polling to check for slow query,"KILL #ID" does not work if id of the myqsli link is the same as the one that kills it,so you…

Stored procedures few rowset example:some_file.phpfunction proc() {global $global;$db_connect_list = array('site');SQLinit($db_connect_list);if(isset($global)){return;}SQL('CALL `procedure`();');while($row=mysqli_fetch_assoc($global)){// do some}SQLnext();while($row=mysqli_fetch_assoc($global)){// do some}SQLnext();while($row=mysqli_fetch_assoc($global)){// do some}SQLclose($db_connect_list);}?>config.php$global = array('host'=>'localhost', 'user'=>'site', 'pass'=>'');?>engine.phpfunction SQLinit($array_list){global $global;foreach($array_list as $set){if(!$global = mysqli_connect($global,$global,$global)){$global = 500;$global =…

(PHP 5, PHP 7, PHP 8)mysqli::multi_query -- mysqli_multi_query — Performs one or more queries on the database Description Object-oriented style Queries are sent asynchronously in a single call to the…

(PHP 5 >= 5.1.0, PHP 7, PHP 8)mysqli::get_warnings -- mysqli_get_warnings — Get result of SHOW WARNINGS Description Object-oriented style Procedural style Returns a singly linked list comprised of mysqli_warning or…

(PHP 5 >= 5.3.0, PHP 7, PHP 8)mysqli::get_connection_stats -- mysqli_get_connection_stats — Returns statistics about the client connection Description Object-oriented style public mysqli::get_connection_stats(): array Procedural style Returns statistics about the client…