Help needed with PEAR

fredmeyer

Hi!

I'm using the pear db package. I encountered the following error:
Call to undefined function: autoprepare()

during execution of this code:
<?php
require_once 'DB.php';
$dsn = "mysql://test:nopass@localhost/infodb";
$db = DB::connect($dsn);
if (DB::isError($db)) {
die ($db->getMessage());
}
$table_fields = array('refAuthor', 'body', 'publicationLevel', 'title');
$table_values = array('test', 'test', 0, 'test');
$table_name = 'info';
//the next line raise an undefined function error
$sth = $db->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_INSERT);
?>
What is wrong with this code? I give up!
Thanks for helping!

toma42

I've never heard of an 'autoprepare' function in pear and is isn't there in my copy. Why not just write your sql by hand? If it's just an insert than there's nothing speical you need to do to it.

fredmeyer

well, that's right, using all this stuff for just an insert seems to be a bit complicated. But, on the other hand, this method allows to prepare queries, in order to have them executed much faster -depends on the database used-, and adds a bit of abstraction in the dml code, to avoid syntax errors. autoPrepare definition could be found at : http://pear.php.net/manual/en/package.database.db.db-common.autoprepare.php.

thanks.

toma42

Ok, I've read through the docs on this now and damn do I think it's lame. I hate this kind of 'abstraction' in database classes. Don't know who's bright idea this was, but I sure won't use it.

You will need to get the latest version of PEAR from cvs.php.net. The version installed w/ the pear installer doesn't have this function in it (thankfully)