From: arne@vajhoej.dk

On 7/7/2025 5:36 PM, Arne Vajhøj wrote:
> On 7/7/2025 5:06 PM, Mark Berryman wrote:
>> On 7/7/25 12:01 PM, Arne Vajhøj wrote:
>>> I do use your PHP.
>>>
>>> But I do not have pgsql and pdo_pgsql loaded.
>>>
>>> $ pipe php -i | search sys$input php,version/match=and
>>> PHP Version => 8.1.23
>>> $ pipe php -i | search sys$input pdo
>>> ...
>>> PDO
>>> PDO support => enabled
>>> PDO drivers => mysql
>>> pdo_mysql
>>> PDO Driver for MySQL => enabled
>>> ...
>>>
>>> The funny thing is that unlike most other extensions
>>> then PHP_PGSQL.EXE and PHP_PDO_PGSQL.EXE exist
>>> as seperate files. But even if I try to load them in
>>> php.ini, then nothing.
>>>
>>> I must be missing something. Probably something basic,
>>> but ...
>>
>> Some of the extensions were built as separate loadable modules either
>> due to their size or because they require separate optional libraries
>> that not everyone has.  All that is necessary to load them is to have
>> the following in php_root:[000000]php.ini:
>>
>> extension=php_pdo_pgsql.exe
>> extension=php_pgsql.exe
>>
>> and to make sure that php.ini is readable by the account running php
>> (and, of course, for libpq from VSI to be installed).
>
> First I did not have anything for pgsql in php.ini
> and second I tried without php_ prefix.
>
> Loading with php_ prefix and everything works!

$ type TestPDO.php
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$con->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$stmt = $con->prepare('SELECT f1,f2 FROM t1');
$stmt->execute(array());
while($row = $stmt->fetch()) {
     $f1 = $row['f1'];
     $f2 = $row['f2'];
     echo "$f1 $f2\r\n";
}
?>
$ php TestPDO.php
1 A
2 BB
3 CCC

Arne

--- SoupGate-Win32 v1.05
 * Origin: you cannot sedate... all the things you hate (1:229/2)