Jump to content

Creating a booking system in PHP


Go to solution Solved by WebStyles,

Recommended Posts

 

HI I'm creating a booking system in PHP that allows estate agents to book viewings for houses. I am having a slight issue. The concept is simple, a user searches for the property using postal code, the database then returns the property results. The user then ticks a checkbox next to the property they want to add the viewing for. This is where the issue is occurring. 

 

Each property has an ID. The ID is assigned to the name="" element in the HTML. I'm now not sure where to go from here. What I want is this, once the user selects the property, the property ID for the selected row needs to be stored so that I can use it later on in the booking. Here is the part of the Code I have.

 

$newrecord = "Here are the results";
 
if (isset($_POST['submitted']))
{
$PostCode = $_POST['PostCode'];
 
$error;
 
$checkpostcode = "SELECT * from PropertyTable WHERE PostCode = '$PostCode'";
$resultpostcode = mysql_query($checkpostcode);
$count = mysql_num_rows($resultpostcode);
 
if ($count == 0) {
$_POST["PostCode"] = $PostCode;
 
echo 'Sorry no properties were found with this Post Code. Please check it is entered correctly, then try again.';
 
}
 
else
{
//show options
 
$selectproperty ="SELECT * from PropertyTable WHERE PostCode = '$PostCode'";
$propertyresults = mysql_query($selectproperty);
echo"<div class='page-restrict-output'>";
echo "<form method='post' action='add-viewing'>";
echo "<input id='addviewingbutton' type='Submit' name='addviewingbtn' value='Select Property' /><br><br /></td></tr>";
echo"<table id='selectviewingtable' border='1'>"; 
echo "<tr><th>Property Name</th><th>Post Code</th><th>Property ID</th><th>Add Viewing</th></tr>"; 
while($row = mysql_fetch_array($propertyresults)) { 
echo "<tr><td>"; 
echo $row['PropertyName']; 
echo "</td><td>";
echo $row['PostCode'];  
echo "</td><td>";
echo $row['ProductID'];  
echo "</td><td>";
echo $row['SelectViewing']; 
echo "<input id='selectviewingbutton' type='checkbox' name='$row[ProductID]' value='True' /></td></tr>";
echo" </form>";
echo "</div>";
 
}
}
}
 
if (isset($_POST['addviewingbtn']))
{
foreach ($_POST as $key => $value){
 
if ($value="True"){
$ProductId = $key;
}
}
 
$choseproperty = "SELECT ProductID from PropertyTable WHERE '$row[ProductID]' = True";
$chosenpropertyresults = mysql_query($choseproperty);
while($row = mysql_fetch_array($chosenpropertyresults)) { 
}
print_r($_POST);
echo "$chosenproperty";
}
else {
 

 

 

Using print_r I get Array ( [addviewingbtn] => Select Property [4] => True ). The [4] is the property ID, this changes on which item you select. I'm just a bit lost here. I'm still getting to grips with PHP and any help would be much appreciated.

Link to comment
https://forums.phpfreaks.com/topic/286347-creating-a-booking-system-in-php/
Share on other sites

assuming you want to allow the user to select several results, I would give all the checkboxes the same name (i.e an array) and put the ProductID in the value field. something like this:

 

echo '<input id="selectviewingbutton" type="checkbox" name="selectedProductIDS[]" value=" . $row[ProductID] . " /></td></tr>';

 

when this get's POSTED to your script, you'll have an array of selected ids inside $_POST['selectedProductIDS'], you can loop through it and get the values with something like:

 

foreach($_POST['selectedProductIDS'] as $pid){

  echo $pid .'<br>';

}

 

Ok I'm having trouble with the next stage. It's probably something stupid but I can't seem to figure out why.

 

After the user selects a property, the property variable is stored for use later. This works. PHP then echoes out another form when the Select Property button is pressed. The form that is echoed out allows a user to enter an Employee ID (to assign an employee to the viewing). This form is echoed out and it has a button called Add Employee. Once this button is pressed the Employee ID the user has entered is checked against the database to ensure its a legitimate entry and if it is the Employee ID is stored in a variable for use later. The system then echoes out saying you have selected employee number [variable that has been stored]. The problem is here. Instead of doing any of this the form just redirects to the start once the add employee button is pressed. No error messages. No success messages. It's probably something small and stupid but I can't seem to find it looking at each line individually. Here is the code.  



$newrecord = "Your viewing was added.";

if (isset($_POST['submitpostcode']))
{
$SearchPostCode = $_POST['SearchPostCode'];

$error;

$checkpostcode = "SELECT * from PropertyTable WHERE PostCode = '$SearchPostCode'";
$resultpostcode = mysql_query($checkpostcode);
$count = mysql_num_rows($resultpostcode);

if ($count == 0) {
$_POST["SearchPostCode"] = $SearchPostCode;

echo 'Sorry no properties were found with this Post Code. Please check it is entered correctly, then try again.';

}

else
{
//show options

$selectproperty ="SELECT * from PropertyTable WHERE PostCode = '$SearchPostCode'";
$propertyresults = mysql_query($selectproperty);
echo"<div class='page-restrict-output'>";
echo "<form method='post' action='add-viewing'>";
echo "<input id='selectpropertybtn' type='Submit' name='selectpropertybtn' value='Select Property' /><br><br /></td></tr>";
echo "Here are the results, Select only ONE property or the operation will FAIL. <br>";
echo "<br>";
echo"<table id='selectviewingtable' border='1'>"; 
echo "<tr><th>Property Name</th><th>Post Code</th><th>Property ID</th><th>Add Viewing</th></tr>"; 
while($row = mysql_fetch_array($propertyresults)) { 
echo "<tr><td>"; 
echo $row['PropertyName']; 
echo "</td><td>";
echo $row['PostCode'];  
echo "</td><td>";
echo $row['ProductID'];  
echo "</td><td>";
echo $row['SelectViewing']; 
echo "<input id='selectviewingbutton' type='checkbox' name='selectedProductIDS[]' value='$row[ProductID]'  /></td></tr>";
echo" </form>";


mysql_real_escape_string($PostCode);

mysql_real_escape_string($newrecord);

}
}
}


if (isset($_POST['selectpropertybtn']))
{
$_POST['selectedProductIDS'];
{
 echo "<form action='add-viewing' autocomplete='on' method='post'>";
 foreach($_POST['selectedProductIDS'] as $PropertyIDforviewing){
  echo "<br>";
  echo "You have Selected Property Number $PropertyIDforviewing.<br>";
  echo "<br>";
  }
  echo "Please Enter Your Employee ID Number.";
  echo "<br>";
  echo "<br>";
  echo "<label for='addEmployeeID'>Employee ID*:</label><br>";
  echo "<input id='addEmployeeID' type='number' name='$addEmployeeID' required /><br>";
  echo "<br>";
  echo "<input id='addemployeebtn' type='submit' name='addemployeebtn' value='Add Employee' /><br>";
  echo "</form>";
}

if (isset($_POST['addemployeebtn']))
{
$addEmployeeID = $_POST['addEmployeeID'];
{
echo "You have Selected Employee Number $addEmployeeID.<br>";
$selectemployee = "SELECT * from EmployeeTable WHERE EmployeeID = '$addEmployeeID'";
$resultselectemployee = mysql_query($selectemployeee);
$count = mysql_num_rows($resultselectemployee);

}

if ($count == 0) {
$_POST["addEmployeeID"] = $addEmployeeID;

echo 'Sorry no employees were found with this ID Number. Please check it is entered correctly, then try again.';

}

else {
$selectemployee = "SELECT * from EmployeeTable WHERE EmployeeID = '$addEmployeeID'";
$resultselectemployee = mysql_query($selectemployeee);
$count = mysql_num_rows($resultselectemployee);
$row = mysql_fetch_assoc($resultselectemployee);
}
}
}


 
  • Solution

change this

echo "<input id='addEmployeeID' type='number' name='$addEmployeeID' required /><br>";

to this

echo "<input id='addEmployeeID' type='number' name='addEmployeeID' required /><br>";

(changed name).

 

I didn't read through all your code, but saw this and saw you were trying to grab $_POST['addEmployeeID'] further down, so I'm guessing that's the problem.)

 

hope this helps

P.S. Why are you doing this

$_POST["SearchPostCode"] = $SearchPostCode; // Why are you assigning a value to $_POST like this?

// further down...

if (isset($_POST['selectpropertybtn']))
{
$_POST['selectedProductIDS']; // what's this supposed to do?
{
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.