ADODB Database abstraction layer

dinangkur

Hi,

When you develop web based solution, our first choice php-mysql. We use php native functions to connect mysql database. But if we use a database abstraction layer, we can do it easily and more quickly.

http://adodb.sourceforge.net

Now check ADODB abstraction layer and see for yourself. I will post more information time to time on this layer.

Current version is adodb-4.68

-Dinangkur
_________________
...we too are stardust...

Guest

Thanks dinagkur for your kind information.
Another database abstraction layer solution could be used, that is PEAR DB.
example :

$dsn = "mysql://$user:$pass@$host/$db_name";

$db = DB::connect($dsn);
if (DB::isError($db)) {die ($db->getMessage());}

foreach ($db->query('SELECT * from FOO') as $row)
{
print_r($row);
}
$dbh = null;

PDO also be used in your development.
example :

Code:

<?php
try {
$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
foreach ($dbh->query('SELECT * from FOO') as $row) {
print_r($row);
}
$dbh = null;
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "<br/>";
die();
}
?>

And there is more package/classes/module available online.

Thanks,

http://www.kernelbd.com