dannymadatgravity

Can anyone help? When I hit the delete record button nothing happens <?php require_once 'dbconnect.php'; //selects the php file with login details. $db_server = mysql_connect($db_hostname,$db_username,$db_password); //sets the varible to connect to mysql if (!$db_server) die ("Unable to connect to server" .mysql_error ()); //! means not true so if the exisistance of the server is not true then display the die message. mysql_select_db($db_database) or die ("Can not connect to your database" . mysql_error ()); //selects the database defined in dbconnect.php if not display die message. if (isset($_POST['id'])&& isset($_POST['Fname'])&& isset($_POST['Lname'])&& isset($_POST['Number'])) { $id = get_post('id'); $Fname = get_post('Fname'); $Lname = get_post('Lname'); $Number = get_post('Number'); if (isset($_POST['delete']) && $id !="") { $query ="DELETE FROM mobile WHERE id='$id'"; if (!mysql_query($query, $db_server)) echo "DELETE failed: $query <br>". mysql_error() . "<br><br>"; } else { $query= "INSERT INTO mobile VALUES"."('$id','$Fname','$Lname','$Number')"; if (!mysql_query($query, $db_server)) echo "INSERT failed: $query<br>". mysql_error(). "<br><br>"; } } echo <<<_END <form action="update.php" method="post"> <pre> <h1> Phone record list </h1> <h2> Add new record </h2> <table> <input type="hidden" name="id"> <table> <tr> <td>First name: </td> <td> <input type="text" name="Fname"></td></tr> <tr> <td>Last name: </td> <td> <input type="text" name="Lname"></td></tr> <tr> <td>Number:</td> <td> <input type="text" name="Number"></td></tr> <tr> <td colspan="2"> <input type="submit" value="ADD RECORD"></td></tr> </table> </pre> </form> <h3> Phone records 2010 </h3> _END; $query ="SELECT * FROM mobile"; $result =mysql_query($query); if (!$result) die ("Database access failed:" . mysql_error()); $rows =mysql_num_rows($result); for($j = 0 ; $j < $rows ; ++$j) { $row =mysql_fetch_row($result); echo <<<_END <pre> Reference id: $row[0] First name: $row[1] Last name: $row[2] Number: $row[3] </pre> <form action ="update.php" method="POST"> <input type="hidden" name="delete" value="yes"> <input type="hidden" name="id" value="$row[0]"> <input type="submit" value="DELETE RECORD"> </form> _END; } mysql_close($db_server); function get_post($var) { return mysql_real_escape_string($_POST[$var]); } ?>

Hi I am just starting to learn PHP and I am banging my head against the wall because I get Parse error: syntax error, unexpected $end in C:\web\update_data_test.php on line 94 somewhere in.... <?php require_once 'login.php'; $db_server = mysql_connect ($db_hostname, $db_username, $db_password); if (!$db_server) die("Unable to connect to server, check username in login.php:" .mysql.error()); else echo "Connection to server sucessfull <br>" ; mysql_select_db($db_database, $db_server) or die ("Connection to database failed: " . mysql_error()); if (isset($_POST['author']) && isset($_POST['title']) && isset($_POST['catergory']) && isset($_POST['year']) && isset($_POST['isbn'])) { $author = get_post('author'); $title = get_post('title'); $catergory = get_post('catergory'); $year = get_post('year'); $isbn = get_post('isbn'); if (isset($_POST['delete']) && $isbn !="") { $query = "DELETE FROM danielsbooks WHERE isbn='$isbn'"; if (!mysql_query($query, $db_server)) echo "DELETE failed: $query <br />". mysql_error() . "<br /><br />"; } else { $query ="INSERT INTO danielsbooks VALUES" . "('$author', '$title','$catergory','$year','$isbn')"; if (!mysql_query($query, $db_server)) echo "INSERT failed: $query <br>". mysql_error(). "<br><br>"; } } echo <<<_END <form action="update_data_test.php" method="post"> <pre> Author <input type="text" name="author" /> Title <input type="text" name="title" /> catergory <input type="text" name="catergory" /> year <input type="text" name="year" /> isbn <input type="text" name="isbn" /> <input type="submit" Value="ADD RECORD" > </pre> </form> _END; $query = "SELECT * FROM danielsbooks"; $result = mysql_query($query); if (!$result) die ("Database access failed: " . mysql_error()); $rows = mysql_num_rows($result); for ($j = 0; $j < $rows ; ++$j) { $row = mysql_fetch_row($result); echo <<<_END <pre> Author $row[0] Title $row[1] Catergory $row[2] Year $row[3] isbn $row[4] </pre> <form action "update_data_test.php" method ="post"> <input type="hidden" name="delete" value="yes" /> <input type="hidden" name="isbn" value="$row[4]" /> <input type="submit" value="DELETE RECORD" /> </form> _END; } mysql_close($db_server); function get_post($var) { return mysql_real_escape_string($_POST[$var]); } ?>