Warning: Supplied argument is not a valid PostgreSQL link resource

From: jan(at)klog(dot)dk (Jan Gravgaard)
To: pgsql-general(at)postgresql(dot)org
Subject: Warning: Supplied argument is not a valid PostgreSQL link resource
Date: 2003-02-28 10:28:30
Message-ID: bf0aae73.0302280228.20d487d1@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there

I get this warning when I execute the following code:

(It is danish)

include_once("php/postgre-funktioner.php");
   
$conn = aabn_forbindelse_og_vaelgdb; // open connection and select db
$query = "SELECT navn, citat FROM citater"; // my query which works
$array = sql_spoerg_og_faa_svar($conn, $query); //execute the query

if(!$array)
{
        echo "Kunne ikke udføre: <em>$query</em>";
}
     
luk_forbindelse($conn); // close connection

#my function library

function aabn_forbindelse_og_vaelgdb() {
    $dbcon = pg_connect("host=XXX port=5432 dbname=XXX user=XXX password=XXX");
      if (!$dbcon) {
            echo "Kunne ikke oprette en forbindelse til PostGre databasen.";
      }
      return $dbcon;
}
   
function luk_forbindelse($dbcon) {
      if(!pg_close($dbcon)) {
            echo "Kunne ikke lukke forbindelsen til PostGre!";
        }
}
 
function sql_spoerg($dbcon, $query) {
      $resultat = pg_exec($dbcon, $query);
          if(!$resultat) {
                echo "Kunne ikke udføre: <em>$query</em>";
          }
}
   
function sql_spoerg_og_faa_svar($dbcon, $query){
      $resultat = pg_exec($dbcon, $query);
      $resultat_array = array();
      if(!$resultat)
      {
        echo "Kunne ikke udføre: <em>$query</em>";
      }
      while($raekke = pg_fetch_array($resultat))
      {
        $resultat_array[] = $raekke;
      }
          return $resultat_array;
}

Any Ideas ???

Browse pgsql-general by date

  From Date Subject
Next Message vasanth madhu 2003-02-28 10:29:51
Previous Message Jean-Christian Imbeault 2003-02-28 10:26:55 Locking rows