Download ezSQL Database Class (2.05)

People who liked this item

33 Comments

1.  

   sagetips ~ 42 months ago

   0 votes
   
   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 ]
2.  

   JV ~ 42 months ago

   0 votes
   
   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!
   [ reply ]
3.  

   sagetips ~ 42 months ago

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

   bkramer ~ 42 months ago

   0 votes
   
   JV,
   what is new in version 2.03?
   your build history doc hasn't been updated.
   [ reply ]
5.  

   MazY ~ 42 months ago

   0 votes
   
   The download links appear to be broken. :(
   [ reply ]
6.  

   alan ~ 41 months ago

   0 votes
   
   I had downloaded and tried this files, but where can find the demo for sybase, I need this, Thanks.
   
   
   --------------------
   software reviews
   [ reply ]
7.  

   johntheentrepreneur ~ 40 months ago

   0 votes
   
   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
   
   
   [ reply ]
8.  

   johntheentrepreneur ~ 40 months ago

   0 votes
   
   any help please? with the porblem above?
   [ reply ]
9.  

   FSDFSDFHSJKGFJLDKFHG ~ 39 months ago

   0 votes
   
   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)
   [ reply ]
10.  

    muurbloem ~ 38 months ago

    0 votes
    
    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
    
    
    [ reply ]
11.  

    tom151 ~ 38 months ago

    0 votes
    
    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,
    [ reply ]
12.  

    Dory Spartan ~ 37 months ago

    0 votes
    
    ezSQL Database Class 2.03 with PostgreSQL support
    http://postgresql.fortunecity.com/
    Hope this helps!
    [ reply ]
    1.  

       Selina ~ 32 months ago

       0 votes
       
       thanks,, very helpful
       
       
       
       
       regards, selina
       [ reply ]
13.  

    topanga ~ 37 months ago

    0 votes
    
    we are still waiting for some demo.... of this database
    
    Regards, Topanga
    [ reply ]
14.  

    ozyank ~ 36 months ago

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

    [ reply ]
15.  

    ozyank ~ 36 months ago

    0 votes
    
    I forgot to say. Nothing is displayed for $last_id in the echo statement.
    [ reply ]
16.  

    JV ~ 35 months ago

    0 votes
    
    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
    [ reply ]
17.  

    Christophe ~ 35 months ago

    0 votes
    
    JV, do you have a public Subversion repository set up for this?
    [ reply ]
18.  

    greg ~ 34 months ago

    0 votes
    
    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);
    
    [ reply ]
19.  

    Janet Kellman ~ 32 months ago

    0 votes
    
    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
    [ reply ]
20.  

    Bancer ~ 31 months ago

    0 votes
    
    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?
    [ reply ]
    1.  

       Jed ~ 8 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 ]
21.  

    foof ~ 29 months ago

    0 votes
    
    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.
    [ reply ]
    1.  

       Caprice ~ 21 months ago

       0 votes
       
       thanks, I had same problem as well... now it's solved
       caprice
       [ reply ]
22.  

    teapear ~ 28 months ago

    0 votes
    
    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'");
    [ reply ]
23.  

    mosphp ~ 28 months ago

    0 votes
    
    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,
    [ reply ]
    1.  

       mosphp ~ 28 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 ]
    2.  

       Terry ~ 28 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 ]
24.  

    New Member ~ 23 months ago

    0 votes
    
    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
    [ reply ]
25.  

    holtbakk ~ 22 months ago

    0 votes
    
    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!
    [ reply ]
26.  

    Madalin ~ 5 months ago

    0 votes
    
    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
    [ reply ]
    1.  

       Jeff Salam ~ 4 months ago

       0 votes
       
       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
       [ reply ]
27.  

    Jose A. Cely ~ 23 days ago

    0 votes
    
    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
    [ reply ]
28.  

    AdGuy

    22 votes
    
    This is my two cents...
    
       
    Hey you know AdGuy always gets the last word! ;)