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)