Community News: More from PHPCon

Community News: First PHP DVD Released!

Community News: GOTO in PHP?

Community News: PHP-Help.net Announced

Community News: PHP 4.3.4 Released!

Community News: PHP Magazine Goes PDF!

Community News: More about the Intl. PHP
Con.

Community News: XML Is Just Too Hard!

Community News: Seeing the Future in PHP

Community News for April

"BBC News | Front Page | UK Edition"

Yahoo! News Home Page

beta.news.yahoo.com
track this site | 3 links

Ranking Added To News Page

TRIBnet 24-hour News Page

tribnet.com/24hour/entertainment/story/1441686p-8798481c. html
track this site | 5 links

eGroupWare 1.0 RC6

eGroupWare 1.0 RC7

eGroupWare 0.9.99.008

eGroupWare 0.9.99.006

eGroupWare 1.0 RC7 released

eGroupWare 1.0 RC5 released

eGroupWare 1.0 RC4 released

eGroupWare 1.0.0.007 (Default branch)

eGroupWare Leaks Files

SourceForge May Project of the Month:
eGroupWare

eGroupWare, Enterprise collab suite

[ GLSA 200409-06 ] eGroupWare: Multiple
XSS vulnerabilities

Multiple Cross Site Scripting
Vulnerabilities in eGroupWare

ADODB 4.52

ADOdb and PDO

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();
	}

        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 for Python

PHP	Python
include "adodb.inc.php"; $conn = NewADOConnection('mysql'); $conn->Connect('server','user','pwd','db'); $rs = $conn->Execute('select * from tab); while (!$rs->EOF) { print_r($rs->fields); $rs->MoveNext(); } $rs->Close(); $conn->Close();	import adodb_mysql; conn = adodb_mysql.adodb_mysql() conn.Connect('server','user','pwd','db') cursor = conn.Execute('select * from tab) while not cursor.EOF: print cursor.fields cursor.MoveNext() cursor.Close() conn.Close()

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 2.20 released

• Busy working on making the code more consistent and modular. Added new caching functions: CacheGetOne($secs2cache,$sql), CacheGetRow($secs2cache,$sql), CacheGetAll($secs2cache,$sql).
• Added a new function useful for scheduling appointments portably. $conn->OffsetDate($dayFraction,$date=false) to generate sql that calcs date offsets.
• Improved portability when handling joins. Added connection properties: leftOuter, rightOuter that hold left and right outer join operators, and ansiOuter to indicate whether ansi outer joins supported.
• New driver mssqlpo, the portable mssql driver, which converts the string concat operator from || to +. This allows you to write portable sql using || that is automatically converted to + when you switch databases to mssql.
• Fixes PageExecute() bug when sql has GROUP BY, and msaccess SelectLimit() bug.

"zeldman.57"

ADODB 0.70 Released

--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 Released

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);

adodb-xmlschema

adodb-xmlschema 0.0.2.4

Pseudo PostreSQL ADODB

Pear Versus ADOdb

Comparing PEAR DB to ADOdb

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.

"zeldman.57"

PHP App Development With ADODB (part 2)

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"

ADOdb: Making MySQL Efficient

Simple persistence engine for PHP and
ADODB 0.1

PHP Application Development With ADODB
(part 2)

PHP Application Development With ADODB
(part 1)

Portability is a Good Thing (ADODB)

Community News: ADODB Page Moved