PHP Self Post

[anton_1]

Hey guys,

 

Any help is much appreciated!

 

I want to make it, that when a form is submitted it inserts the booking and echos a message to the user without directing them to another page.

 

Just now when you hit book, it shows the booking page on another page instead of just display Booking Complete on the same page

 

Code:

 

<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" >

<table width="450px">

</tr>

<tr>

<td valign="top">

  <label for="first_name">First Name *</label>

</td>

<td valign="top">

  <input  type="text" name="fname" maxlength="50" size="40">

</td>

</tr>

 

<tr>

<td valign="top"">

  <label for="last_name">Last Name *</label>

</td>

<td valign="top">

  <input  type="text" name="lname" maxlength="50" size="40">

</td>

</tr>

<tr>

<td valign="top">

  <label for="email">Address</label>

</td>

<td valign="top">

  <input  type="text" name="address" maxlength="80" size="40">

</td>

 

</tr>

 

 

<tr>

<td valign="top">

  <label for="County">County</label>

</td>

<td valign="top">

  <input  type="text" name="county" maxlength="80" size="40">

</td>

 

</tr>

 

 

 

<tr>

<td valign="top">

  <label for="postcode">Postcode</label>

</td>

<td valign="top">

  <input  type="text" name="postcode" maxlength="80" size="40">

</td>

 

</tr>

 

 

<tr>

<td valign="top">

  <label for="telephone">Telephone Number</label>

</td>

<td valign="top">

  <input  type="text" name="telno" maxlength="30" size="40">

</td>

</tr>

 

 

<tr>

<td valign="top">

  <label for="CheckInDate">Check In Date</label>

</td>

<td valign="top">

  <input  type="text" name="checkIn" id="date" maxlength="30" size="40">

</td>

</tr>

 

<tr>

<td valign="top">

  <label for="CheckOutDate">Check Out Date</label>

</td>

<td valign="top">

  <input  type="text" name="checkOut" class="date" maxlength="30" size="40">

</td>

</tr>

 

 

<tr>

<td colspan="2" style="text-align:center">

  <input type="submit" name="submit" value="Book Room">

</td>

</tr>

</table>

</form>

 

PHP Code:

 

 

<?php

 

if(isset($_POST['submit']))

{

$fname = $_POST['fname'];

$lname = $_POST['lname'];

$address = $_POST['address'];

$county = $_POST['county'];

$pcode = $_POST['postcode'];

$telno = $_POST['telno'];

$checkIn = $_POST['checkIn'];

$checkOut = $_POST['checkOut'];

 

 

$con = mysql_connect("localhost","root","");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

mysql_select_db("forumtututorial", $con);

 

$sql="INSERT INTO RoomBookings (FirstName, LastName, Address, County, Postcode, TelNo, CheckInDate, CheckOutDate)

VALUES

('$_POST[fname]','$_POST[lname]','$_POST[address]','$_POST[county]','$_POST[postcode]','$_POST[telno]','$_POST[checkIn]','$_POST[checkOut]')";

 

if (!mysql_query($sql,$con))

  {

  die('Error: ' . mysql_error());

  }

 

 

// mail customer reciept

 

$to = "08006925@live.napier.ac.uk";

$subject = "Booking Reservation";

$message = $fname . "has made a booking";

$headers = "Highlander Hotel";

mail($to,$subject,$message,$headers);

 

echo "Booking Complete";

 

}

?>

 

Thanks!!

 

 

[Pikachu2000]

It really isn't clear what you're asking. First you say the script echoes a message on the same page, then you say it doesn't, but you never actually ask a question.