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] 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] 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 :) Link to comment https://forums.phpfreaks.com/topic/34185-problem-with-code/#findComment-160932 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.