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 ???
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 |