Re: Pear - autoExecute()
| From: | pete M | Date: | Thu, 29 Apr 2004 12:48:34 +0000 |
| Subject: | Re: Pear - autoExecute() | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34175@lists.php.net to get a copy of this message | ||
yep
This is from config.inc.php
$dsn = "mysql://$username_DB:$password_DB@$hostname_DB/$database_DB";
//echo $dsn;
require_once('../includes/DB/DB.php');
$db = DB::connect($dsn,true);
if (DB::isError($db)) {
die ($db->getMessage()); }$db->setFetchMode(DB_FETCHMODE_ASSOC); I'm using the getAll(), query(), getOne(), etc ok - it just doesnt see autoExecute() ?? Or I'm missing the obvious ! pete ;-) Uzi Klein wrote:
Did you use $db = new DB; ? -----Original Message----- From: pete M [mailto:pmorgan@ukds.net] Sent: Thursday, April 29, 2004 14:31 To: php-db@lists.php.net Subject: Re: [PHP-DB] Pear - autoExecute() That's where I copied the code below that does not work ;-( Uzi Klein wrote:http://pear.php.net/manual/en/package.database.php -----Original Message----- From: pete M [mailto:pmorgan@ukds.net] Sent: Thursday, April 29, 2004 14:03 To: php-db@lists.php.net Subject: [PHP-DB] Pear - autoExecute() Am trying the following bit of code usind the PEAR DB.php class $table = 'reports'; $fields = array('report_name' => $_POST['report_name'],'report_desc' => $_POST['report_desc'] );$res = $db->autoExecute($table,$fields,DB_AUTOQUERY_INSERT); if (DB::isError($res)) {die($res->getMessage());} However I get the error Fatal error: Call to undefined function: autoexecute() in /home/jp/public_html/v1/reports.php on line 19 I'm using the $db->query() methods and getALL etc so I know the class is loaded and working. Is there a library I'm missing tia Pete