Re: postgresql csv import
| From: | ourdiaspora | Date: | Thu, 16 Sep 2021 20:30:41 +0000 |
| Subject: | Re: postgresql csv import | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-327704@lists.php.net to get a copy of this message | ||
Readers,
Please excuse, but very confused the options available; none seem easy to understand. Tried:
Readers,
Please could someone help to explain why the following code fails:
<?php
$uploaddir = '~/tmp/cpac/cpactmp/';
$uploadfile = $uploaddir . basename($_FILES['userfile']['name']);
$dbconnect = pg_connect("dbname=cpacweb user=cpaca");
$targetfilepath = $uploaddir . $uploadfile;
if(isset($_POST["submit"])){
$dbconnect = "INSERT INTO somedata(name, id, emailaddress, groupname) VALUES ('jane
bloggs','1234','jbloggs@some.where','1a1')";
}
$query = "SELECT * FROM somedata";
$result = pg_exec($dbconnect, $query);
echo "Number of rows: " . pg_numrows($result);
pg_freeresult($result);
pg_close($dbconnect);
?>
The web page reports:
"
Number of rows: 0
"
This suggests successful connection to the database, but some failure to enter new data.
sudo nano /etc/php/7.0/apache2/php.ini
"
...
[line number]483 log_errors = On
...
571 error_log = ~/tmp/webserver/phperrors.log
...
The directory does not show creation of such an error file to interrogate further. Please what next
to investigate?