ezDB 2.0

Note

The latest version, docs, etc can now be found on github, at:

http://wiki.github.com/nshahzad/ezdb/

Share and Enjoy:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • HackerNews
  • Netvibes
  • Reddit
  • StumbleUpon
  • Twitter
  • Yahoo! Buzz

13 Responses - Add Yours+

  1. ezSQL Database Library (Improved!) | nsslive says:
    March 6, 2009 at 11:35 am

    [...] ezSQL 2.0 [...]

  2. CalinSoft says:
    March 26, 2009 at 6:12 pm

    Nice Works.!

    You can add this feature?

    $table_prefix =”m2_”;

    $tables = array( ‘table1′ => ‘table1′,
    ‘table2′ => ‘menu’,
    ‘table3′ => ‘users’ );

    $db->mapping_tables($tables,$table_prefix);

    echo $db->users; // m2_table3

    —————
    classs db

    function mapping_tables($tables = array(), $prefix=”m2_”)
    {
    $this->tables = $tables;
    $this->prefix = $prefix;

    // build the mapping with prefixes
    foreach ( $this->tables as $s => $t ) {
    $this->$t= $prefix .$s ;
    }
    }

  3. Jay says:
    June 26, 2009 at 12:14 am

    Your class really takes ezSQL to the next level. I’m a big fan of SQLite, so I’ve ported a PDO module to your improved ezSQL. You can find the source code here:

    http://github.com/jaywilliams/ultralite/raw/012e2cfeced015c4bc5658ad85e726cd1ea2780f/app/classes/Pixelpost/DB/PDO.php

    You’ll probably have to make a few modifications from the source, but the bulk of it should be usable.

  4. nyë says:
    November 17, 2009 at 7:52 am

    Hello,

    How can I get the last inserted id after doing $res=DB::query(“INSERT…”);

    I’ve tried with $id=DB::$insert_id; but a I get an empty value…

    Thanks

  5. nyë says:
    November 17, 2009 at 8:29 am

    I forgot to say that I use the mysqli class “ezDB_MySQLi.class.php”

  6. Nabeel says:
    November 17, 2009 at 12:10 pm

    Sounds like a bug. I have a few fixes, which I need to commit upto github.

  7. nyë says:
    November 23, 2009 at 10:34 am

    Hello,

    Are you going to commit it soon? Or maybe you can give me a clue on how to fix it meanwhile…

    Many thanks!

  8. Jon says:
    March 19, 2010 at 6:03 pm

    I really appreciate this script. Thank you for working on it!
    I believe there is one issue in error handling.
    In ezDB.class.php on line 58, we see:

    [code]public static $throw_exceptions = true;[/code]

    then, throughout the rest of the scripts we see:

    [code]if($this->use_exceptions)[/code]

    shouldn’t these be the same?

    Thanks again!

  9. Nabeel says:
    March 19, 2010 at 6:06 pm

    Thanks for your reply. I think I’ve fixed that, I will check it though. There’s an updated copy on github which I had updated a few days ago. Cheers!

  10. Jon says:
    April 6, 2010 at 2:44 pm

    You replied so quickly! That’s wonderful!
    I downloaded the latest version you have posted and it is still like that. It’s an easy fix, I just changed

    public static $throw_exceptions = true;

    in ezdb.class.php to:

    public static $use_exceptions = true;

    I have another question.
    I would like to define the character encoding used in the database. There is an excellent page at http://www.stumbleupon.com/group/php/forum/37465/
    He suggests using something like:

    // Make sure we are using UTF-8 Character Encoding.
    mysql_query(“SET NAMES ‘utf8′;”, $this->dbh);
    mysql_query(“SET CHARACTER SET ‘utf8′;”, $this->dbh);

    just after opening the connection to the database.
    How could I incorporate this into the ezdb script most elegantly?

    Thank you once again for the great scripts!

  11. Nabeel says:
    April 6, 2010 at 2:47 pm

    Hi Jon,

    It’s updated on github, I had fixed that, along with a few mysqli issues. You can also post issues on the site there :)

    The easiest way for that might just be:

    DB::query(‘SET NAMES `utf8`’)
    DB::query(‘SET CHARACTER SET `utf8`’);

  12. Jackie says:
    July 14, 2010 at 9:44 pm

    Thanks to improve ezsql.
    I really love ezsql.
    but want to have ezDB and use it with codeigniter..
    so help me how to use ezDB with codeigniter….

  13. Nabeel says:
    July 14, 2010 at 9:46 pm

    Hi Jackie, Thanks! I’m not too familiar with CodeIgnitor, but it doesn’t have it own database functions? If it doesn’t, I’m sure there’s a way to include external libraries

Leave a Reply