Re: postgresql csv import pdo

On 14/09/2021 22:50, ourdiaspora wrote:
> Readers,
>
> Forgive the simplicity, but having problems to start:
>
> <?php
> 	try {
> 		$dbconnect = new PDO(pgsql:host=localhost; dbname=cpacweb; user=someuser; password=somepassword);
> 		}
> 	catch(PDOException $e) {
> 		print "Error!: " . $e->getMessage() . "<br/>";
> 		die();
> 		}
>
> 	$query = "SELECT * FROM somedata";
> 	$result = pg_exec($dbconnect, $query);
> 	echo "Number of rows: " . pg_numrows($result);
> 	pg_freeresult($result);
> 	pg_close($dbconnect);
> ?>
>
> No error message, no print of rows of table. Please what is the error?

I can see 2 obvious issues with this code:

1) The DSN passed to PDO should be a single string, but this is missing 
quotes in the code above;

2) You are mixing PDO with pg_ functions - this will not work as they 
are separate extensions. You need to use only 1 or the other - either 
use PDO, or use pg_ functions.


If you're using PDO on PHP < 8, you'll want to enable the exceptions 
error reporting mode. See https://phpdelusions.net/pdo#errors
(In PHP 8+ the default PDO error reporting mode is already set to 
exceptions)


For general error reporting in PHP, ensure that the following ini 
settings are set:

* error_reporting = E_ALL  (report all errors and warnings)
* display_errors = 1  (display errors in output / on the web page)

On production you'll want to set display_errors to 0 and use the 
log_errors and error_log ini settings to log errors to a file instead as 
some error messages may contain sensitive information such as passwords 
or api keys.

For more information on these ini settings see: 
https://www.php.net/manual/en/errorfunc.configuration.php