define the connection object as a global var in ur function
function ( params)
{
global $ur_connection_obj;
...
...
}
On Thu, 23 Sep 2004 14:56:10 -0300, Eduardo Sampaio <esampaio@xxxxxxxxx> wrote:
> Its because the function cannot access your connection object...
> Try passing it to the function..
>
> function makelistboxentries($link, $title, $mytable, $mycolumn, $othertable,
> $wherestring)
>
>
>
>
> On Thu, 23 Sep 2004 19:44:51 +0200, Antoine <melser.anton@xxxxxxxxx> wrote:
> > 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
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
M.Saleh.E.G
97150-4779817
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
