Compressed SQL Statements with the PurePHP MySQL API
Using the PurePHP MySQL API– Part 12
Foreword: In this part of the series I explain how to use PurePHP MySQL API to compress a SQL statement and send to the MySQL server.
By: Chrysanthus Date Published: 18 Jan 2018
Introduction
Compressing an INSERT Statement
The following code compresses an INSERT statement and send to MySQL server:
<?php
require_once("./Mysql.php");
if (!connect("root", "secret", "localhost", 3306, 'compress'))
{
echo "$Error_msg";
}
else
{
if (!select_db("PetStore"))
{
echo $Error_msg, "<br>";
}
else
{
$ins = "INSERT INTO pet (name, owner, species, sex, birth, death) VALUES ('Pin','Peop','brancher','m','2017-04-21',NULL)";
if (!query($ins))
{
echo $Error_msg, "<br>";
}
}
}
close();
?>
This code is similar to other code samples, except for the presence of the argument, 'compress' in the connection expression (above).
The following code compresses a SELECT statement and send:
<?php
require_once("./Mysql.php");
if (!connect("root", "secret", "localhost", 3306, 'compress'))
{
echo "$Error_msg";
}
else
{
if (!select_db("PetStore"))
{
echo $Error_msg, "<br>";
}
else
{
$sel = "select * from pet where name='Pin'";
if (!query($sel))
{
echo $Error_msg, "<br>";
}
else
{
for ($i=0; $i<$No_of_Rows; ++$i)
{
echo $Result[$i]['name'], ', ';
echo $Result[$i]['owner'], ', ';
echo $Result[$i]['species'], ', ';
echo $Result[$i]['sex'], ', ';
echo $Result[$i]['birth'], ', ';
echo $Result[$i]['death'], ', ';
echo "<br>";
}
}
}
}
close();
?>
Note the use of the 'compress' argument in the connection expression, which enabes the SELECT statement to be compressed (before being sent over the network).
The following code compresses a DELETE statement and send:
<?php
require_once("./Mysql.php");
if (!connect("root", "secret", "localhost", 3306, 'compress'))
{
echo "$Error_msg";
}
else
{
if (!select_db("PetStore"))
&fjST?&.brQ¿ &nfs`9 +f*jBr; +&Žzób3 fnbRp;¦nb1p;&nBsð+ &îrsp;&fbCt{.nbSð»2¹4c0 &îrsp=$vhrô;&fbSt9&fcsp;&nb3t;Wmböp»6Nj“@¿nbóp;dnbsp;&nbs0;&Obsp;$nhrx:&nb3p;nb3pæcs03&lf{ay&nCqt37lbsp&îjs7&ncsô9&fs303nb{ð#$æ3t»n"{;åShë $ rÒJâ]m3g$!&qunô?&.6;rrfït;dquot;;
{
echo $Error_msg, "<br>";
}
}
}
close();
?>
This code is similar to other code samples, except for the presence of the argument, 'compress' in the connection expression. Any compression of a SQL statement, needs this argument.
A compressed statement sent by the API should receive a compressed result from the server (the return compressed result is not made known to you).
Note: The API does not yet support a combination of INSERT, SELECT and DELETE.
That is it for this part of the series. We stop here and continue in the next part.
Chrys
Related Links
Pure PHP Mailsend - sendmailPurePHP MySQL API
Using the PurePHP MySQL API
More Related Links
Basics of PHP with Security Considerations
cousins
Using the EMySQL API
Using the PurePerl MySQL API
BACK NEXT