RE: mysql to postgres migration blues...

"Bastien Koert" <bastien_k@xxxxxxxxxxx> · Thu, 23 Sep 2004 13:51:15 -0400

Could be a scope problem. The connection is declared outside the function 
and the attempt to run a query is inside the function...Maybe add the global 
command to the connection. Or declare the connection inside the function...

Bastien

From: Antoine <melser.anton@xxxxxxxxx>
Reply-To: Antoine <melser.anton@xxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject:  mysql to postgres migration blues...
Date: Thu, 23 Sep 2004 19:44:51 +0200

Hi,
I am trying to get skilled up on postgres and decided to port a little
movie database I wrote for mysql with php to access it.
I used an auto converter for the bulk and then tried to tweak. The
following code does not work but the error message it gives me is
strange. It tells me that the connection string used on line 82 (where
it calls pg_query in makelistboxentries) is invalid... but the same
string/connection works just great in another script... any pointers
appreciated.
Cheers
Antoine

<?php

    /* Connect to database */
    $link = pg_connect("dbname=movies host=localhost user=anton
password=password")
        or die("Could not connect : " . pg_result_error($link));

print <<<TII
<div id=mybody>
Search by:
<BR>
<TABLE border="1" cellpadding="10" cellspacing="10"><TR>
<TD align="center">
ID:
<form name="input" action="searchout.php" method="post">
<input type="text" name="mychoice">
<input type=hidden name = wherestring value=" t1.ID = ">
<input type=hidden name = othertable value="movies">
<input type="submit" value="Submit">
</form>
</TD>
<TD align="center">
Name:
<form name="input" action="searchname.php" method="post">
<input type="text" name="mychoice">
<input type="submit" value="Submit">
</form>
</TD></TR>
</TABLE><BR>
<TABLE border="1" cellpadding="10" cellspacing="10"><TR>
TII;
makelistboxentries("Audio Language", "lang", "lang", " audio ", "
t2.movie = t1.ID and t2.lang = ");
makelistboxentries("Subtitle Language", "lang", "lang", " subtitles ",
" t2.movie = t1.ID and t2.lang = ");
makelistboxentries("Genre", "Genre", "Genre", " moviegenre ", "
t2.movie = t1.ID and t2.genre = ");

print <<<TINI
</TD>
</TR></TABLE>
<br><br>
<P>Show All:</P>
<form name="input" action="allout.php"
method="post">
<input type="submit" value="Submit">
</form>
</div>
<div id=mymenu>
	<P><A href="index.php"><H3>Back to main page</H3></A></P>
	<P><A href="movie.php">Add a movie</A></P>
	<P><a href="audio.php">Add a movie's audio languages</a></P>
	<P><a href="subtitles.php">Add a movie's subtitle languages</a></P>
	<P><a href="searchin.php">Search the movies</a></P>
</div>
TINI;
    /* Close connection */
    pg_close($link);

function makelistboxentries($title, $mytable, $mycolumn, $othertable,
$wherestring)
{

print "<TD align=\"center\">";

print "$title:";
    /* Perform SQL query */
    $query = "SELECT $mycolumn FROM $mytable";
    $result = pg_query($link,$query)
	or die("Query failed : " . pg_result_error($link));
	print "<form name=\"input\" action=\"searchout.php\" method=\"post\">";
    	print "<SELECT NAME=\"mychoice\">";
	print "<option value=\"zz\" SELECTED>Select $title</option>";
    while ($line = pg_fetch_array($result,$result_countt++,PGSQL_ASSOC)) {
        foreach ($line as $col_value) {
		print ("<OPTION VALUE=\"".$col_value."\">");
		print $col_value;
		print ("</OPTION>");
        }

    }
print "</select>";
print "<input type=hidden name = wherestring value=\"$wherestring\">";
print "<input type=hidden name = othertable value=$othertable>";
print "<input type=\"submit\" value=\"Submit\">";
print "</form>";

    pg_free_result($result);
}

?>

--
G System, The Evolving GUniverse - http://www.g-system.at

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

_________________________________________________________________

Take advantage of powerful junk e-mail filters built on patented Microsoft® 
SmartScreen Technology. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
 Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php