Re: Installing PEAR

In article <11.1177ad96.27ead90b@aol.com>, RalphGzman@aol.com writes >Ok, IM a bit confused as to how PEAR is installed. I read through the README >file in the php source but found no explanation. > >I am tryin to use the PEARs DB abstracion. I have DB.php and DB/ in >/usr/local/lib/php. I added: 'include_once(DB/mysql.php);' to the top of my >script but it failed since it is not finding it. Do I need to assign a path in >the php.ini file or have I missed an installation step? > >Can somebody please explain or point me to some docs on how I get up and going >with PEAR. Hi, Try something like: <?php require_once ('DB.php'); // connection $db_type = "mysql"; // type of database - must correspond to a PEAR type $db_user = "user"; // database access username $db_pswd = "password"; // database access password $db_host = "localhost"; // hostname of database $db_name = "you_db_name"; // database name $db_connectString = "$db_type://$db_user:$db_pswd@$db_host/$db_name"; // the above, collected here for convenience $usePersistentConnects = true; // true - uses persistent connects to the database (always leaves a link open, false - not) if (! $db_con) $db_con = DB::connect ($db_connectString, $usePersistentConnects); $sql = "SELECT column FROM $tableName WHERE whatever = '$whatever'"; if (DB::isError ($result = $db_con -> query ($sql))) handle_db_error ($result); else $resultArray = $result -> fetchRow (DB_FETCHMODE_ASSOC); $db_con -> commit(); if ($db_con && (! $usePersistentConnects)) $db_con -> disconnect(); ?> I hope the line wraps still leave the above readable. I made a separate function of my own, handle_db_error (), to handle errors - you might like to do something like: echo DB::errorMessage($result); ... instead. I recommend putting all the db connection stuff in a file which resides outside of the document root and including it where you need it. The following links may prove useful - the user comments in the phpbuilder article were particularly helpful in pointing me in the right direction. http://cvs.php.net/viewcvs.cgi/php4/pear/DB/ http://www.phpdoc.de/pear/index2.html http://www.phpbuilder.com/columns/allan20010115.php3 http://pear.php.net http://www.php.net/manual/en/pear.php All the best, -- Paul Rees Web Application Programmer/Developer surfEU.com GmbH