stargeek
ADOdb 2.20 releasedADOdb 2.20 releasedADOdb 2.20 released 07/09/2002 09:09 AM ADOdb is a PHP library for writing portable database code. It supports many databases, including oracle, mysql, mssql, postgresql, access, informix, sybase, db2, interbase, firebird, frontbase, foxpro, etc.
"zeldman.57" This is a GrokNews Entry: (what is grok?)ADOdb 2.20 releasedGrok Headline matches for ADOdb 2.20 releasedADODB 0.70 ReleasedADODB 0.70 Released 06/11/2004 11:17 AM ADODB is a database wrapper library for PHP4 modelled on Microsoft's ADO. You are all urged to upgrade because of a bug in MoveNext(), which did not handle EOF properly. --Calls by reference have been removed (call_time_pass_reference=Off) to ensure compatibility with future versions of PHP, except in Oracle 7 driver due to a bug in php_oracle.dll. --PostgreSQL database driver contributed by Alberto Cerezal (acerezalp@dbnet.es). --Oci8 driver for Oracle 8 contributed by George Fourlanos (fou@infomap.gr). --Added mysqlt database driver to support MySQL 3.23 which has transaction support. --Oracle default date format (DD-MON-YY) did not match ADODB default date format (which is YYYY-MM-DD). Use ALTER SESSION to force the default date. --Error message checking is now included in test suite. -- MoveNext() did not check EOF properly -- fixed.
ADOdb 2.10 ReleasedADOdb 2.10 Released 06/05/2002 07:50 AM ADOdb 2.10 has just been released. This is a database abstraction library for PHP that supports many databases, including Oracle, MySQL, PostgreSQL, Informix, Sybase, Microsoft SQL Server, Access, FoxPro, DB2, ODBC etc. It now provides an easy-to-use pager class. The following code
include_once('../adodb.inc.php');
include_once('../adodb-pager.inc.php');
session_start();
$db = &NewADOConnection('mysql');
$db->Connect('localhost','root','','xphplens');
$sql = "select * from adoxyz ";
$pager = new ADODB_Pager($db,$sql);
$pager->Render($rows_per_page=5);
will produce:
ADOdb and PDOADOdb and PDO 06/14/2004 10:38 PM PDO is a new database API that will be part of the official PHP 5.1 release. AFAIK, PDO will not be a full-fledged database abstraction library, but will provide a standard database API for PHP. Here is a sample taken from the PDO download:
<?php
$x = new PDO("odbc:ram", 'php', 'php',
array(PDO_ATTR_AUTOCOMMIT => 0));
$stmt = $x->prepare("select NAME, VALUE from test where value
like ?");
$the_name = 'bar%';
$stmt->execute(array($the_name)) or die("failed to
execute!");
$stmt->bindColumn('VALUE', $value);
while ($row = $stmt->fetch()) {
echo "name=$row[NAME] value=$row[VALUE]n";
echo "value is $valuen";
echo "n";
}
echo "Let's try an updaten"
$stmt = $x->prepare("INSERT INTO test (NAME, VALUE) VALUES
(:name, :value)");
$stmt->bindParam(":name", $the_name, PDO_PARAM_STR,
32);
$stmt->bindParam(":value", $the_value, PDO_PARAM_STR,
32);
for ($i = 0; $i < 4; $i++) {
$the_name = "foo" . rand();
$the_value = "bar" . rand();
if (!$stmt->execute()) {
break;
}
}
echo "All donen"; ?> Highlights of PDO include the unified object-oriented API, compiled statements are now first class objects (the PDOStatement class), and better support for bind variables, which will give a substantial speed boost for performance freaks. Does this make ADOdb superflous? If you are looking for something that just works with mysql, then ADOdb might not be for you. However ADOdb still has a big role to play, because: (1) ADOdb makes it easier to develop PHP apps that work with multiple databases, with portable handling of data types and schemas. (2) PDO does not provide an infrastructure for enterprise database access, such as recordset caching, sql logging and tuning, and session management. (3) If you come from a Windows background (like me), it is easy to learn ADOdb because it follows many M'soft conventions. So the next question is, how to extend ADOdb to support PDO? I think we can retain the existing ADOdb infrastructure, treating PDO as just another ADOdb driver. At the same time, we will add PDO specific extensions to the ADOdb PDO driver. So the classic ADOdb calling conventions will still work:
include('adodb.inc.php');
$DB = NewADOConnection('pdo');
$DB->Connect($host, $user, $pwd, $db);
$rs = $DB->Execute("select * from table where name=?",array('Jill'));
while (!$rs->EOF) {
var_dump($rs->fields);
$rs->MoveNext();
}
And we will add a new ADOdb statement class to support PDO
conventions:
include('adodb.inc.php');
$DB = NewADOConnection('pdo');
$DB->Connect($pdo_connection_string);
$stmt = $DB->PrepareStmt("select * from
table where name=?");
$stmt->Execute(array('Jill'));
while ($arr = $stmt->Fetch()) {
var_dump($arr);
}
Wez has more PDO examples. A PDO discussion at sitepoint.
ADODB 4.52ADODB 4.52 08/17/2004 09:14 AM A PHP database abstraction layer. ADOdb for PythonADOdb for Python 01/26/2004 10:15 AM In my work with Python, I found that there's no good database abstraction library, so I wrote my own. Looks familiar, doesn't it?
It also supports the iterator protocol:
cursor = conn.Execute('select * from table')
for row in cursor:
print row
Python does have the DB API, but it's similar to ODBC in that it provides a very minimal layer, without abstracting SELECT ... LIMIT, LOBs, string quoting, etc. Download zip. I will try to post a comparison between developing in Python and PHP when I have more time.
adodb-xmlschema 0.0.2.4adodb-xmlschema 0.0.2.4 11/17/2003 08:54 PM An XML database creation extension for ADODB. adodb-xmlschemaadodb-xmlschema 02/12/2004 10:14 PM adodb-xmlschema (axmls) Release 1.0! Comparing PEAR DB to ADOdbComparing PEAR DB to ADOdb 11/17/2002 10:47 PM PEAR DB is the default database abstraction library for PEAR. ADOdb is a high end database abstraction library modelled on Microsoft's ADO that is also very popular. 1. Feature ComparisonWhere we try to put you to sleep by showing you the similarities between PEAR DB and ADOdb 2. Features Missing from PEAR DB Now we try to wake you up with some teasers 3. Criticisms of ADOdb Read what other people are moaning and complaining about
"zeldman.57" PHP App Development With ADODB (part 2)PHP App Development With ADODB (part 2) 08/05/2002 10:44 PM In the first part of this article, I introduced you to the ADODB database abstraction library, and showed you a little of how it works. I demonstrated how using it in your PHP application development could substantially reduce the time spent on code rewrites if your RDBMS decided to change shape, and also gave you a crash course in the basic functions built into the library. Fortunately, that isn't all she wrote. ADODB comes with a whole bunch of bells and whistles, which allow you to do some fairly nifty new things in your PHP scripts. Over the next few pages, I'll be showing you some of them - so flip the page, and let's get started! -- icarus PS: : ADOdb 2.30 released on August 1st. Features generation of SQL for pivot-tables/cross-tabulations. Thanks to Daniel Lucazeau for the original idea. Also a mssql "select distinct" bug fix when the SelectLimit() function is used.
"zeldman.pinme" Pseudo PostreSQL ADODBPseudo PostreSQL ADODB 11/08/2002 07:17 PM Pseudo PostgreSQL ADODB is a PHP class designed as a drop-in replacement for ADOdb for PHP applications that do not need the full power of ADOdb, want to remain light and fast but want to remain compatible with ADOdb. The API of PostgreSQL ADODB Emulation was designed to be compatible with ADOdb. I was able to remove ADOdb from my application framework and use this class instead. Pear Versus ADOdbPear Versus ADOdb 11/25/2002 09:58 AM Comparing Pear and ADOdb is one of those PHP things that we're all curious about. I haven't used it but I'd also look at Metabase (sorry for no link) since someone I respect technically really likes it. [ Go ] ADOdb: Making MySQL EfficientADOdb: Making MySQL Efficient 10/29/2003 12:11 AM Learn how to use Active Data Objects Data Base (ADOdb) to make your websites utilize MySQL more efficiently. PHP Application Development With ADODB
|
Also check out: |
