Error querying SQL SELECT in PHP

Question

I am trying to connect to and select data from an PostgreSQL server. I am able to connect to the server but my select query appears to be running an error. Any suggestions?

<?php

$conn = "host=#### port=5432 dbname=consolidated user=#### password=####";

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
echo "Connected successfully";

$dbconn = pg_connect($conn);

$result = pg_query($dbconn, "SELECT id FROM retailer_retailer;");
if (!$result) {
  echo "An error occurred.\n";
  exit;
}

while ($row = pg_fetch_row($result)) {
  echo "ID: $row[0]";
  echo "<br />\n";
}

?>

The semi-colon is unnecessary, but try checking for pg_last_error when your query fails. — aynber
– aynber, Commented Jan 4, 2017 at 17:49
@aynber I tried echo pg_last_error($result); but nothing came up — user2798841
– user2798841, Commented Jan 4, 2017 at 17:52

Veshraj Joshi · Accepted Answer · 2017-01-04 18:02:05Z

1

you miss the schema name right here, I assume you have table in public schema and your query should like-

$result = pg_query($dbconn, "SELECT id FROM public.retailer_retailer;");

If you have another schema then you can replace public with other schema name

answered Jan 4, 2017 at 18:02

Veshraj Joshi

3,5874 gold badges32 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Veshraj Joshi Over a year ago

let me know whether it works for you or not, if worked accept it as answer

user2798841 Over a year ago

@veshar_joshi I am trying to link to a public scheme but this still doesn't work

Veshraj Joshi Over a year ago

did you get any erroor

Collectives™ on Stack Overflow

Error querying SQL SELECT in PHP

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related