Woyano - Download ezSQL Database Class (2.05)

Download ezSQL Database Class (2.05)

JV — Tue, 06 Feb 2007 10:25:39 +0000

Please check out my new weekly podcast techZING! News and views from the front-line of tech & startups Overview

-- Comments (33)

sagetips

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??

JV

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!

sagetips

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

bkramer

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

MazY

The download links appear to be broken. :(

alan

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

johntheentrepreneur

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

johntheentrepreneur

any help please? with the porblem above?

FSDFSDFHSJKGFJLDKFHG

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)

muurbloem

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

tom151

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,

Dory Spartan

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

topanga

we are still waiting for some demo.... of this database Regards, Topanga

ozyank

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."";

ozyank

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

JV

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

Christophe

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

greg

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);

Janet Kellman

Selina

thanks,, very helpful

regards, selina

Bancer

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?

foof

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.

teapear

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'");

mosphp

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

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

Terry

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

New Member

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

holtbakk

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!

Caprice

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

Jed

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.

Madalin

I use strip_tags,real escape strings and ENT_Quotes to sanitize inputs. I have modified a little the script, but is really useful. software reviews

Jeff Salam

Hi Madalin; Im new to php and I was wondering if you could share the script modification with strip_tags,real escape strings and ENT_Quotes to sanitize inputs . thanks jeff

Jose A. Cely

Hi, Before, thanks for that great library, i work whith ezsql for 3 years! I found small bug, where you have multiple database conections and/or classes. I write an small module for Drupal. In my module, $db->query($sql) returns false "randomly" where INSERT, however the insert works fine, after hours of debug my work ( days :$ ), found the "bug" in the line 212 of ez_sql_mysql.php . $this->rows_affected = @mysql_affected_rows(); lack link identifier!, change the line to: $this->rows_affected = @mysql_affected_rows($this->dbh); And works fine. Hope that it helps. Cheers, Jose A. Cely