CodeCanyon EazSQL PHP MySQL Helper 621923

CodeCanyon EazSQL PHP MySQL Helper 621923

CodeCanyon EazSQL PHP MySQL Helper 621923
PHP Script \ Database Abstraction
Query \ Phpmyadmin \ Result \ Rows \ Update \ Mysql \ Delete \ Count \ Easy \ Helper


PHP Script - EazSQL PHP MySQL Helper 621923 by Sourcegeek @ CodeCanyon

PHP Script \ Database Abstraction

Last Update: 2 December 12; Software Version: MySQL 5.x; High Resolution: No; Files Included: JavaScript JS, HTML, CSS, PHP.

This is a PHP5 Class-Helper that will allow you to make MySQL actions more easy, without too much lines. You will use like only 70% of classic code, and the syntax is more easy.

Here you can see some examples.

$mysql = new EazSQL('host', 'username', 'password', 'database');
// VS Old (classic) method.
$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 (classic) method.
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 (classic) method.
mysql_query("DELETE FROM mytable WHERE id=1", $connection) or die ('Mysql error, query');
mysql_query("DELETE FROM mytable WHERE content='example'", $connection) or die ('Mysql error, query');
mysql_query("UPDATE mytable SET val = 'CodeCanyon'", $connection) or die ('Mysql error, query');

Retrieve rows as object!

$results = $foo->get_rows("SELECT * FROM mytable");
foreach($results as $res) {
echo $res->title.'<br />';
}
// Versus..
$qry = mysql_query("SELECT * FROM mytable",$connection) or die ('Mysql error, query);
if(mysql_num_rows($qry) > 0) {
while($res = mysql_fetch_assoc($qry)) {
echo $res['title'].'<br />';
}
}

With this helper, you can easy make queries, multi-queries, retrieve rows as an easy syntax, do update, delete, insert, and much more! Plus, it has a very explicit Documentation.

Why you don’t try it?

Rating will be really appreciated.
Questions? Suggestions? Please, don't doubt to leave a comment!

ParseRSS - Parse a RSS with PHP5 Class; AdvPlugin - Advanced Plugin System; MyJSON - Work with MySQL + JSON; HackerCatcher - Catch hackers w/ Admin Panel; MyXML - Work with MySQL+XML; MyRegExp - PHP Regular Expression Builder; PHP Advanced String Class.

Keywords: class, count, delete, easy, helper, insert, multi, mysql, oop, phpmyadmin, query, result, rows, sql, update.



Tags: Helper, Query, Phpmyadmin, Result, Update, Mysql

Premium CodeCanyon EazSQL PHP MySQL Helper 621923 WordPress Themes, Website Templates, Mobile Themes, Flash Templates & Scripts from creative professional designers. Full details of CodeCanyon EazSQL PHP MySQL Helper 621923 for digital design and education. CodeCanyon EazSQL PHP MySQL Helper 621923 desigen style information or anything related.

Comments:

Name:*
E-Mail:*
Add Comments:
Enter Code: *