7 comments
The latest version, docs, etc can now be found on github, at:
http://wiki.github.com/nshahzad/ezdb/
Written by Nabeel
March 3rd, 2009 at 9:45 pm
Posted in General
Subscribe to comments with RSS or TrackBack to 'ezDB 2.0'.
[...] ezSQL 2.0 [...]
ezSQL Database Library (Improved!) | nsslive
6 Mar 09 at 11:35 am
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 ; } }
CalinSoft
26 Mar 09 at 6:12 pm
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.
Jay
26 Jun 09 at 12:14 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
nyë
17 Nov 09 at 7:52 am
I forgot to say that I use the mysqli class “ezDB_MySQLi.class.php”
17 Nov 09 at 8:29 am
Sounds like a bug. I have a few fixes, which I need to commit upto github.
Nabeel
17 Nov 09 at 12:10 pm
Are you going to commit it soon? Or maybe you can give me a clue on how to fix it meanwhile…
Many thanks!
23 Nov 09 at 10:34 am
Name (required)
Mail (will not be published) (required)
Website
[...] ezSQL 2.0 [...]
ezSQL Database Library (Improved!) | nsslive
6 Mar 09 at 11:35 am
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 ;
}
}
CalinSoft
26 Mar 09 at 6:12 pm
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.
Jay
26 Jun 09 at 12:14 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
nyë
17 Nov 09 at 7:52 am
I forgot to say that I use the mysqli class “ezDB_MySQLi.class.php”
nyë
17 Nov 09 at 8:29 am
Sounds like a bug. I have a few fixes, which I need to commit upto github.
Nabeel
17 Nov 09 at 12:10 pm
Hello,
Are you going to commit it soon? Or maybe you can give me a clue on how to fix it meanwhile…
Many thanks!
nyë
23 Nov 09 at 10:34 am