[ad_1]

To get this product on 50 % contact me on this link

LIVE PREVIEWBUY FOR $7

This is a PHP5 Class-Helper that may can help you make MySQL actions simpler, with out an excessive amount of strains. You will use like solely 70% of traditional code, and the syntax is simpler.

Here you possibly can see some examples:

$mysql = new EazSQL('host', 'username', 'password', 'database');

// VS Old (traditional) methodology:
$mysql = mysql_connect('host', 'username', 'password') or die ('Mysql error, connection');
mysql_select_db('datababse', $mysql) or die ('Mysql error, database');

$foo->delete('mytable', array('' => 'id=1', 'or' => 'id=2'));

// VS Old (traditional) methodology:
mysql_query("DELETE FROM mytable WHERE id=1 or id=2", $connection) or die ('Mysql error, delete');

Multi-queries!

$foo->multi_query(array("DELETE FROM mytable WHERE id=1", "DELETE FROM mytable WHERE content='example'", "UPDATE mytable SET val = 'CodeCanyon'"));

// VS Old (traditional) methodology:
mysql_query("DELETE FROM mytable WHERE id=1", $connection) or die ('Mysql error, question');
mysql_query("DELETE FROM mytable WHERE content='example'", $connection) or die ('Mysql error, question');
mysql_query("UPDATE mytable SET val = 'CodeCanyon'", $connection) or die ('Mysql error, question');

Retrieve rows as object!

$outcomes = $foo->get_rows("SELECT * FROM mytable");
foreach($outcomes as $res) {
    echo $res->title.'<br />';
}

// Versus....
$qry = mysql_query("SELECT * FROM mytable",$connection) or die ('Mysql error, question);
if(mysql_num_rows($qry) > 0) {
    whereas($res = mysql_fetch_assoc($qry)) {
        echo $res['title'].'<br />';
     }
}

With this helper, you possibly can simple make queries, multi-queries, retrieve rows as a simple syntax, do replace, delete, insert, and far more! Plus, it has a really specific Documentation.
Why you don’t attempt it?

Rating shall be actually appreciated.
Questions? Suggestions? Please, don’t doubt to depart a remark!

[ad_2]

To get this product on 50 % contact me on this link

Source