Re: postgresql csv import pdo
| From: | Christophe DALOZ - DE LOS RIOS | Date: | Wed, 15 Sep 2021 03:49:03 +0000 |
| Subject: | Re: postgresql csv import pdo | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-327689@lists.php.net to get a copy of this message | ||
Hello,
The entire code block can in try catch, but if the error in PDO usage, the
PDOException is catching.
Le mar. 14 sept. 2021 à 23:50, ourdiaspora <ourdiaspora@protonmail.com> a
écrit :
> 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?
>