Download ezSQL Database Class (2.05)

Rate this:

By JV (Contact - View My Woyano)

Published Tue 06 Feb 2007, 69663 Views, 30 Comments

ez_sql_2.05.zip

(60 KB, upload, archive) ~ (right click to download)

Please check out my new weekly podcast techZING!
News and views from the front-line of tech & startups
http://techzinglive.com/

Overview

see what’s going on

Features

ezSQL is a widget that makes it ridiculously easy for you to use PHP-PDO, mySQL, Oracle8, InterBase/FireBird, PostgreSQL, SQLite (PHP), SQLite (C++) or MS-SQL database(s) within your PHP/C++ scripts (more db's coming soon) - now works with codeigniter!
It is one php file that you include at the top of your script. Then, instead of using standard php database functions listed in the php manual, you use a much smaller (and easier) set of ezSQL functions.
It automatically caches query results and allows you to use easy to understand functions to manipulate and extract them without causing extra server overhead
It has excellent debug functions making it lightning-fast to see what's going on in your SQL code
Most ezSQL functions can return results as Objects, Associative Arrays, or Numerical Arrays
It can dramatically decrease development time and in most cases will streamline your code and make things run faster as well as making it very easy to debug and optimise your database queries.
Works with Smarty templating language
It is a small class and will not add very much overhead to your website.

Download

Download ezSQL completely Free from the download link at the top of this page, also check out EZ Results Paging Class ezSQL's sister class that makes result paging a snip.

Important Note!
For Inerbase/Firebase, PostgreSQL, SQLite (C++), MS-SQL database(s) download version 1.26. Or, even better, help port ezSQL to version two.

Documentation

Extensive help documentation and examples (N.B. Full docs in download file).
ezSQL revision/build history
Article explaining the theory behind ezSQL

ezSQL Forum

The ezSQL forum is here..

Testemonials

Chris Ray

www.reviewcast.com

Robin Jackson

Luke Hendricks

LL Ceder

Will Macdonald

Kevin Danenberg

www.blbex.com

Alan Graham

www.parallel56.com

Matthew Hellinger

projects

Jim O'Halloran's Web Log

Sites Using ezSQL

www.reviewcast.com - Community review site
www.blbex.com - Big League Baseball Exchange
www.acaldra.com - Community site
www.okyz.com - French Mac, PC, Unix software company
www.WebspaceEnterprises.com - E-Business development company
www.polandguangzhou.com - Polish Consulate in China (Commercial and Economic Section)

Author

Justin Vincent

Great content, let me share it! �

30 Comments

Hi -

EZsql looks to fit my needs. But I'm trying to install and am not having luck. The instructions indicate a file "ez_sql_core.php" should be present but it doesn't appear to be in the zip file I download.

Am I missing something??

[ reply ]

Best thing to do is get ezsql/mysql/demo.php to work.

Just edit the values at the top of the file.

p.s. ez_sql_core.php is in the dir ezsql/shared

Hope this helps!

Yes, thanks it works now. It wasn't clear to me that the values in demo.php needed edit.

Thanks again

JV,
what is new in version 2.03?
your build history doc hasn't been updated.

The download links appear to be broken. :(

I had downloaded and tried this files, but where can find the demo for sybase, I need this, Thanks.

--------------------
software reviews

hi,

please help me with my ezsql error.

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 33172040 bytes) in /hsphere/local/home/livinise/blobees.com/libs/ez_sql_core.php on line 370

please look at this link for more explanation
http://forums.pligg.com/showthread.php?p=29747

any help please? with the porblem above?

I'm new to PHP. I've been using this not-so-good php class for simplified mysql usage, and want to migrate to ezSql. Everything has went wel, but I have one question: is it possible to do an "or die" style error reporting on all query functions? (Example, $db-query("insert query here") or die("...") will do the query and then die if I try to do it)

Hello,

In the file ez_sql_mysql.php I have adapted the following part.

function escape($str)
{
// aanpassing 14-07-2007
// return mysql_escape_string(stripslashes($str));
$str2 = mysql_escape_string(stripslashes($str));
return htmlentities($str2, ENT_QUOTES, 'UTF-8');
}

This extended function gave me the the mixed leters like � and �.

Maybe someone can use this.

Ubel Jan

Hi JV,
I'm converting to XAMPP and PHP5 -- now getting this error - does ezSQL not run on PHP5? Is there some PHP config change that will solve this?
Strict Standards: var: Deprecated. Please use the public/private/protected modifiers in c:XAMPPxamppxamppphp_incez_sql_core.php on line 32
(and repeats for many lines)
Thanks for ezSQL,

ezSQL Database Class 2.03 with PostgreSQL support
http://postgresql.fortunecity.com/
Hope this helps!

Selina ~ 26 months ago

0 votes

thanks,, very helpful

regards, selina

[ reply ]

we are still waiting for some demo.... of this database

Regards, Topanga

I have not been able to use the variable $db->insert_id successfully. For example, should this work?



	$sql="INSERT INTO test_mdb_members (".$fields.") VALUES (".$values.")";

	$results=$db->query($sql); 

	$last_id = $db->insert_id;

	echo "Records added: ".count($results).". Last ID: ".$last_id."
";

I forgot to say. Nothing is displayed for $last_id in the echo statement.

Just a quick note to everyone.

I added support for PHP PDO, and also added postgress and ms-sql to the main distribution.

Thanks for the contributions.

JV

JV, do you have a public Subversion repository set up for this?

On the Constructor on ezSQL_mysql ver.2.04 why did you leave out the function to connect to the Database?
My Copy Just Had
$this->dbuser = $dbuser;
$this->dbpassword = $dbpassword;
$this->dbname = $dbname;
$this->dbhost = $dbhost;
So I added
$this->quick_connect($this->dbuser, $this->dbpassword, $this->dbname, $this->dbhost);

I'm new to PHP. I've been using this not-so-good php class for simplified mysql usage, and want to migrate to ezSql. Everything has went wel, but I have one question: is it possible to do an "or die" style error reporting on all query functions?
(Example, $db-query("insert query here") or die("...") will do the query and then die if I try to do it)

Janet Kellman, software reviews manager

Hi, I got this error message on my localhost:

Strict Standards: Declaration of ezSQL_mysql::query() should be compatible with that of ezSQLcore::query() in D:serverfinance_systemtemp213-ez_sql_2.04ezsqlmysqlez_sql_mysql.php on line 263

Strict Standards: Declaration of ezSQL_mysql::escape() should be compatible with that of ezSQLcore::escape() in D:serverfinance_systemtemp213-ez_sql_2.04ezsqlmysqlez_sql_mysql.php on line 263
ezSQL demo for mySQL database run @ 2008-02-26 12:59:26

What is the best way to fix it?

Jed ~ 2 months ago

0 votes

I have the same problem. There are coding errors in the ez_sql class that display when E_STRICT is enabled in php.

You can correct the errors, at least for the MySQL class, by changing the following in ez_sql_core.php on lines 80 & 90 respectively.
(80) from: function query()
(80) to: function query($query)
(90) from: function escape()
(90) to: function escape($str)

However, for all I know this could break compatibility with other database classes. So I only recommend doing it if you use the MySQL class.

[ reply ]

Is there an answer to this problem:
http://www.jvmultimedia.com/portal/node/208

I can't remember my username/password to see the answer!
I have the same problem.

Caprice ~ 15 months ago

0 votes

thanks, I had same problem as well... now it's solved
caprice

[ reply ]

hi, i got this error message when using mysql_real_escape_string;

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:xampphtdocsnewupmmainlogin.php on line 7

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:xampphtdocsnewupmmainlogin.php on line 7

my code:
include_once "include/ez_sql_core.php";
include_once "include/ez_sql_mysql.php";
$db = new ezSQL_mysql('root','','um','localhost');
$username = mysql_real_escape_string($_POST["username"]);
$query = $db->get_row("SELECT * FROM user WHERE Username='$username'");

hi, I have to thanks for this great class that I use it from 1.26.
But, I'm facing a problem that how to do runtime-created function within a function in php, could you please show me some example !

Best,

mosphp ~ 22 months ago

0 votes

i mean:
function aaa(){
..
$result =$db->get_results($array); <-- getting error of Fatal error: Call to a member function get_results() on a non-object in
..
}

thanks

[ reply ]

Terry ~ 22 months ago

0 votes

mosphp:

You need to do something like this:

function aaa($sql)
{
global $db;
$result = $db->get_results($sql);
return $result;
}

Hope that it helps.

Cheers,

Terry

[ reply ]

Only one question...are stored procedures executed for this php library? I mean Can this library execute stored procedures? Because I tried to execute one of mine (Call stored(params)) and answer is PROCEDURE stored can't return a result set in the given context
Any comments? please

Small question. While I in 'plain' php/mysql do something like "mysql_connect("host", "user", "pw") or die("could not connect");" i cannot find a way to 'die' with ezsql if the DB is not answering. Any tips? Thanx alot!

This is my two cents...

Hey you know AdGuy always gets the last word! ;)

Download ezSQL Database Class (2.05)

Please check out my new weekly podcast techZING!
News and views from the front-line of tech & startups
http://techzinglive.com/

Overview

Features

Download

Documentation

ezSQL Forum

Testemonials

Sites Using ezSQL

Author

People who liked this item

30 Comments

Records added: ".count($results).". Last ID: ".$last_id."

Please Login to Add Your Comment ..or..

Replying to comment by

Download ezSQL Database Class (2.05)

Please check out my new weekly podcast techZING!News and views from the front-line of tech & startupshttp://techzinglive.com/

Overview

Features

Download

Documentation

ezSQL Forum

Testemonials

Sites Using ezSQL

Author

People who liked this item

30 Comments

Records added: ".count($results).". Last ID: ".$last_id."

Please Login to Add Your Comment ..or..

Replying to comment by

Please check out my new weekly podcast techZING!
News and views from the front-line of tech & startups
http://techzinglive.com/