Have you checked register_globals = on/off in your php.ini?
If register_globals=off, then you must access your POST variables by:
$_POST['whatever'];
and your get (the stuff you put at the end of your URL's):
$_GET['whatever'];
On Mon, 2003-06-30 at 15:48, Simon Chappell wrote:
> Hi can anyone help me with this?
>
> I have been failing to get any forms working with PHP now I have run out of
> ideas? Having bought 3 books the latest one being php & mysql for
> dummies(which might be appropriate for me) I am still failing at this hurdle.
>
> the following script is a classic example taken straight out of the book, I
> get round the $PHP_SELF problem ok but then all the script does is loop back
> to itself?
>
> <!-- Program Name: mysql_send.php
> Description: PHP program that sends an SQL query to the
> MySQL server and displays the results.
> -->
> <html>
> <head>
> <title>SQL Query Sender</title>
> </head>
> <body>
> <?php
> $user="root";
> $host="localhost";
> $password="";
>
> /* Section that executes query */
> if (@$form == "yes")
> {
> mysql_connect($host,$user,$password);
> mysql_select_db($database);
> $query = stripSlashes($query) ;
> $result = mysql_query($query);
> echo "Database Selected: <b>$database</b><br>
> Query: <b>$query</b>
> <h3>Results</h3>
> <hr>";
> if ($result == 0)
> echo("<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>");
>
> elseif (@mysql_num_rows($result) == 0)
> echo("<b>Query completed. No results returned.</b><br>");
> else
> {
> echo "<table border='1'>
> <thead>
> <tr>";
> for ($i = 0; $i < mysql_num_fields($result); $i++)
> {
> echo("<th>" . mysql_field_name($result,$i) . "</th>");
> }
> echo " </tr>
> </thead>
> <tbody>";
> for ($i = 0; $i < mysql_num_rows($result); $i++)
> {
> echo "<tr>";
> $row = mysql_fetch_row($result);
> for ($j = 0; $j < mysql_num_fields($result); $j++)
> {
> echo("<td>" . $row[$j] . "</td>");
> }
> echo "</tr>";
> }
> echo "</tbody>
> </table>";
> }
> echo "<hr><br>
> <form action=$PHP_SELF method=post>
> <input type=hidden name=query value=\"$query\">
> <input type=hidden name=database value=$database>
> <input type=submit name=\"queryButton\" value=\"New Query\">
> <input type=submit name=\"queryButton\" value=\"Edit Query\">
> </form>";
> unset($form);
> exit();
> }
>
> /* Section that requests user input of query */
> @$query = stripSlashes($query);
> if (@$queryButton != "Edit Query")
> {
> $database = " ";
> $query = " ";
> }
> ?>
>
> <form action=<?php echo $PHP_SELF ?>?form=yes method="post">
> <table>
> <tr>
> <td align="right"><b>Type in database name</b></td>
> <td>
> <input type=text name="database" value=<?php echo $database ?> >
> </td>
> </tr>
> <tr>
> <td align="right" valign="top"><b>Type in SQL query</b></td>
> <td><textarea name="query" cols="60" rows="10"><?php echo $query
> ?></textarea>
> </td>
> </tr>
> <tr>
> <td colspan="2" align="center"><input type="submit" value="Submit
> Query"></td>
> </tr>
> </table>
> </form>
>
> </body>
> </html>
>
> Any ideas would be greatly appreciated as I am floundering badly!
>
> Simon
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
