Feature: Home on the iPod

Simple database library 0.5.3

Simple database library 0.5.5

Simple database library 0.5.0 released

GDL2: the GNUstep Database Library

Google to announce library database
collaborations

Feature Rich Home Theater System
Solutions from Norcent at CES

The Library of Congress Comes Home

Homer Library Comes Home to My
Aggregator!

My home library unveiled a new web site today and the home page is now a blog (powered by Blogger). Happy, happy, happy dance, happy, happy, happy dance!

Of course, my favorite part is the sidebar on the right-hand side where you'll find links to Ask a Librarian (their email and VR service), Find It Online (their database section), ListenIllinois (my statewide group purchase!), the new Homer Community web site (funded by a library the grant received - more on that in the future), and ........drum roll, please....... an RSS feed!! Happy, happy, joy, joy, happy, happy, joy, joy! Subscribed!

Of course, this will change my RSS class because I always show how I can't find my library's feed in Bloglines or Yahoo as a way to prod attendees to get their own feed. Now that will change when the feed does appear!

Oh, and one of the blog posts mentions a LibraryLookup bookmarklet for their catalog!

Did I mention I'm happy?  :-)

Professional Database Builder for Home
and Business

MUG News: Washington Apple Pi to feature
iMovie

Miami New Times | miaminewtimes.com |
News : Feature

miaminewtimes.com/issues/1997-06-05/feature.html
track this site | 11 links

Info on Geek News Central's New
Commenting Feature

I have been getting some negative e-mail on us locking down our commentng system, we now require you to register with Typekey. I want to explain why we had to lock down the comments. I was spending 20 to 30 minutes a day removing spams that contained adult or inappropriate content. The spammers where using commenting programs that would put several 100 comments per spamming run places throughout our 2500 articles. We had a tool to help us clean those comments up but it took entirely to much time.

The new system is enable through a service called Typekey. Once you are registered with Typekey you will be able to post comments on any Movabletype 3.0 or greater webllog. They have a very clear policy that they will not disclose any more information than what you allow in your profile. If you look at my profile you will see that I have opted to allow you to see a variety of information about me. All of that information is OPTIONAL.

No they do require you to divulge a minimal amount of information when you signup but the main point is to verify posters identities. We do not require your e-mail address be posted on the website. This is to keep spam out of your inbox when spammers come harvesting e-mail address's.

I encourage our readers to forward me any concerns you have directly to geek at geeknewscentral.com

News: Court bars Microsoft from shipping
networking feature

Other News: IBM Contributes Database

Other News: Nightmare Database

East Bay Express | eastbayexpress.com |
News | Feature | Berkeley Intifada,As
students embrace the Palestinian ...

New York Daily News - Home - Daily News
Exclusive: Valedictorian who ripped
school denied diploma

nydailynews.com/front/story/206424p-178119c.html
track this site | 4 links

News Aggregation Library for Java

Other News: Federal Student-Tracking
Database

CNET News: Mainframes Get Open-Source
Database

News: CatDV 4.0 media database adds
H.264 support, more

Korean Integrated News Database System
(KINDS)

News: NAB: 'The Scene' pro soundtrack
library coming soon

BBC NEWS | Science/Nature | Library of
Alexandria discovered

news.bbc.co.uk/1/hi/sci/tech/3707641.stm
track this site | 6 links

"BBC NEWS | Entertainment | Arts |
British Library archives websites"

Web Host & Domain News-U.S. Law Library
of Congress, Selects Verio for Managed H

RatherBiased.com | News | Home

ratherbiased.com/news
track this site | 3 links

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 4.52

XP SP2 good news for home users

New York Daily News - Home - One last
look

nydailynews.com/front/story/200903p-173326c.html
track this site | 4 links

NaNoWriMo.org : Home - Breaking News

nanowrimo.org
track this site | 6 links

Yahoo! News Home Page

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

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 0.0.2.4

adodb-xmlschema

PHP Everywhere: Home. News and feature articles on PHP and ADOdb database library.