From: francoisdanielloubser at hotmail dot com
Operating system: Windows XP
PHP version: 5.0.4
PHP Bug Type: PostgreSQL related
Bug description: Postgres dll not included in PECL
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.
--
Edit bug report at http://bugs.php.net/?id=33514&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33514&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=33514&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=33514&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=33514&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=33514&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=33514&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=33514&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=33514&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=33514&r=support
Expected behavior: http://bugs.php.net/fix.php?id=33514&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=33514&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=33514&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=33514&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33514&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=33514&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=33514&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=33514&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=33514&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=33514&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=33514&r=mysqlcfg
