|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2005-06-30 11:52 UTC] tony2001@php.net
[2005-06-30 15:15 UTC] francoisdanielloubser at hotmail dot com
[2005-06-30 16:22 UTC] sniper@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Oct 29 01:00:01 2025 UTC |
Description: ------------ The PECL distribution for PHP 5.0.4 does not include the postgres dll. Instead it include's another one that does not work. Even if I rename the dll included to be the same as the name in the ini file and copy it to the windows system directory, I still get the same error. Reproduce code: --------------- <?php /* * Define PostgreSQL database server connect parameters. */ define('PGHOST','10.0.0.218'); define('PGPORT',5432); define('PGDATABASE','example'); define('PGUSER', 'root'); define('PGPASSWORD', 'nopass'); define('PGCLIENTENCODING','UNICODE'); define('ERROR_ON_CONNECT_FAILED','Sorry, can not connect the database server now!'); /* * Merge connect string and connect db server with default parameters. */ pg_pconnect('host=' . PGHOST . ' port=' . PGPORT . ' dbname=' . PGDATABASE . ' user=' . PGUSER . ' password=' . PGPASSWORD); /* * generate sql statements to call db-server-side stored procedure(or function) * @parameter string $proc stored procedure name. * @parameter array $paras parameters, 2 dimensions array. * @return string $sql = 'select "proc"(para1,para2,para3);' * @example pg_prepare('userExists', * array( * array('userName','chin','string'), * array('userId','7777','numeric') * ) * ) */ function pg_prepare($proc, $paras) { $sql = 'select "' . $proc . '"('; $sql .= $paras[0][2] == 'numeric' ? $paras[0][1] : "'" . str_replace("'","''",$paras[0][1]) . "'"; $len = count($paras); for ($i = 1; $i < $len; $i ++) { $sql .= ','; $sql .= $paras[$i][2] == 'numeric' ? $paras[$i][1] : "'" . str_replace("'","''",$paras[$i][1]) . "'"; } $sql .= ');'; return $sql; } ?> Expected result: ---------------- Standard example Actual result: -------------- Error cannot find dll.