PHP and PostgreSQL function malfunction

[bandit_oos]

<?php
error_reporting(E_ALL);
$conn_string = "host=localhost port=5432 dbname=categories";
$conn = pg_pconnect($conn_string);
if (!$conn)
{
echo "An error occured connecting to the database.\n";
exit;
}

function createTable($id, $name, $level)
{
$createS = "CREATE TABLE table_s (id SERIAL, node_name CHAR(30), parent_id SERIAL)";
$createR = pg_query($conn, $createS);

if(!createR)
{
echo "An error occured with query.";
exit;
}else echo "Query success";

$createSt = "INSERT INTO table_s VALUES (2,'test',3)";
$createRt = pg_query($conn, $createSt);
echo "a";
}

createTable();
pg_close($conn);
?>

Hi

I'm pretty new at this, the database connects, but the CREATE TABLE query doesn't work. I get no errors and the 'a' is printed.

Please help

[Saviola]

Maybe the connection is falited. At least with Postgres 7.2, connecting to local postgresdatabase requires a user in the database with the same name as the user running apache, or the connection fails.

$connection = pg_connect("host=localhost port=5432 dbname=DATABASENAME user=USERNAME password=PASSWORD")
      or die ("Connection error --> " . pg_last_error($conn)); 

You only have to pass the $connection variable if you have more than one connection to choose from (for example, if you have opened two connections with the pg_connect() function).

Also you can try to use pg_exec() :

function createTable($id, $name, $level)
{
  $createS = "CREATE TABLE table_s (id SERIAL, node_name CHAR(30), parent_id SERIAL)";
  $createR = pg_exec($conn, $createS);

  if(!createR)
  {
    echo "An error occured with query.";
    exit;
  }else echo "Query success";

  $createSt = "INSERT INTO table_s VALUES (2,'test',3)";
  $createRt = pg_exec($conn, $createSt);
  echo "a";
}