Cannibal_Monkey Posted January 15, 2007 Share Posted January 15, 2007 There's a problem with a semicolon in our code on line 18 and we can't find out where it is supposed to be. We coppied the code from a book, and they don't have one. Please help us. Thanks :)[code]<!-- Program: mysql_send.php Desc: 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 $host=”localhost”; $user=”root“; $password=””; /* Section that executes query */ if(@$_GET[‘form’] == “yes”) { mysql_connect($host,$user,$password); mysql_select_db($_POST[‘database’]); $query = stripSlashes($_POST[‘query’]); $result = mysql_query($query); echo “Database Selected: <b>{$_POST[‘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>”; } //end else echo “ <hr><br> <form action=\”{$_SERVER[‘PHP_SELF’]}\” method=\”POST\”> <input type=’hidden’ name=’query’ value=’$query’> <input type=’hidden’ name=’database’ value={$_POST[‘database’]}> <input type=’submit’ name=\”queryButton\” value=\”New Query\”> <input type=’submit’ name=\”queryButton\” value=\”Edit Query\”> </form>”; unset($form); exit(); } // endif form=yes @$query=stripSlashes($_POST[‘query’]); if (@$_POST[‘queryButton’] != “Edit Query”) { $query = “ “; } ?> <form action=”<?php echo $_SERVER[‘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 @$_POST[‘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> [/code] Quote Link to comment https://forums.phpfreaks.com/topic/34185-problem-with-code/ Share on other sites More sharing options...
MCP Posted January 15, 2007 Share Posted January 15, 2007 Your single and double quotes look strange.Make sure they're:[code=php:0]"[/code]or[code=php:0]'[/code] Quote Link to comment https://forums.phpfreaks.com/topic/34185-problem-with-code/#findComment-160917 Share on other sites More sharing options...
Cannibal_Monkey Posted January 15, 2007 Author Share Posted January 15, 2007 Ah, thanks :)It was from a book which I converted to .txt, and the quotes were wierd like that. Thanks :) Quote Link to comment https://forums.phpfreaks.com/topic/34185-problem-with-code/#findComment-160932 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.