PHP - Php Booking Form

I'm new to this blog but need serious help. I want to add a calendar to a Hotel website for the booking part, I did it once but I forgot how to do it. Here is the link to the booking file. http://regencycountryclub.com/QuickReserve.php I just want instead of having to select the day, month and year. I want to add a calendar to select the arrival date and departure date. I would really appreciate the help. Thanks

I have a problem which is why I am here. 

What I am trying to achieve

I am creating a very very basic timetabling system online, using php and sql. I am still in the process of completing it and changing bits from here to there. Although I am fully aware that the current design / implementation needs several changes and amendments, but however it performs most of the basic functionalities from a login system to the ability to add data delete data and also reset the database and recreate.


The problem

I have a table called tCourse althouogh a full ERD implementation has not taken place, it is still trial and error period.

The table consists of the following:

- Course
- Unit
- Course_Code
- Year (i.e. Yr1, Yr2, Yr3)
- Credits (Value of the unit)
- Day
- Semester
- Start_Time
- End_Time
- Room
- Tutor

At the moment the primary keys for the table a  

- Day
- Start_Time
- Room_   
- Semester

This basically prevents a particular day, a semester, a room having been booked at the same time. Which for a very basic one is ok. The only problem is though,

if someone books for example:

Monday >> 13:00:00 To 14:00:00 >> 205 >> Sem1 (ok)
Monday >> 13:00:00 To 14:00:00 >> 205 >> Sem1 (Not ok, which is good, as it is a repeat and prevents double booking)

However the problem comes he


Monday >> 12:00:00 To 14:00:00 >> 205 >> Sem1 (ok)
So this is allowing a booking even though that room will be busy i.e. booked between 13:00 to 14:00

So is there a way I can limit it, so if there is a room booked for that particular period it will not do it.

I have done a bit of research and friend's have suggested doind several for loops and quering the database beforehand. I came here, mainly because there are a lot of experienced individuals here whom may have a simpler solution, although I can understand it won't be a one liner .

I would appreciate any help, if not, it is still ok.

Hi there

Got a problem needs a solution, basically a booking system has been built (by me) and works great except for the checking availablity

Basically they can do drives in a car (in any order) so I need to try all possible combinations.
one idea I had was to use an array holding the availability for each slot so that it looks like

slotArray=array("ABC","AC","C","A","BC","AB","ABC" ...etc)

looking for drives A and B

so check if slotArray[1] contains A and Slot Array 2 contains b or vice versa

what i need to do is work out all the possible orders of a string ABCDE
(there will be 120 of them) so I can systematically check the order
anyone have a function that will do this?

$sql="SELECT COUNT(*) as conflicts
FROM rental
WHERE plateNum = $plateNum AND Dispatch > $Dropoff AND Dropoff > $Dispatch";
if("0"){
  $sql="INSERT INTO rental (Rentdate,Dispatch,Dropoff,Dis_TIME,Drop_TIME,Ins,Tcost,PDcost,plateNum,userID)VALUES(CURDATE(),'$Dispatch','$Dropoff','$Dis_TIME','$Drop_TIME','$Ins','$Tcost','$PDcost','$plateNum','$userID')";  
    $result=$conn->query($sql);
}else{ echo"Fail";}
 

 

how do I get the value of the conflicts im now very clueless

Hello Friends,

I am trying to execute Time slot booking for an application. - When user selects a date - 
In a calendar I have monthly calendar dates and (5) time slot for booking. (9-10, 10-11, 11-12, 12-1, 1-2)

Each time slot can be booked by 2 users

User 1 selected a date (2nd March)and selected a time slot (10:00 - 11:00 AM). 

User 2 selected a date (2nd March)and selected a time slot (10:00 - 11:00 AM). 
When User 3 try to book a slot (10:00 - 11:00 AM) on 2nd March -   I would like to disable or display  "Slot Not Available" for that Time slot. 

Please find the script below. Your help is really appreciated.

<?php 
include('database.php');
$fname="";
$lname="";
$email="";
$phone="";
$date="";
if(isset($_POST['fname'])){ $fname=$_POST['fname'];}
if(isset($_POST['lname'])){$lname=$_POST['lname'];}
if(isset($_POST['email'])){$email=$_POST['email'];}
if(isset($_POST['phone'])){$phone=$_POST['phone'];}
if(isset($_POST['date'])){$date=$_POST['date'];}
 else $date=date("m-d-Y")

$result=mysqli_query($conn,"SELECT exam_time,count()from test_booking_confirm where  DATEDIFF('exam_date',DATE_FORMAT('"+$date+"','%m-%d-%Y'))=0  group by exam_date,exam_time having count()>1");
$slots=array();
$i=0;
if (mysqli_num_rows($result) != 0)
{
     while($row = mysqli_fetch_assoc($result)) {
         $slots[$i]=$row["exam_time"];
         $i++;
    }
}
?>

<!doctype html>
<html>
<head>
<title></title>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
        <link rel="stylesheet" href="css/style.css" />
    <link rel="stylesheet" href="css/bootstrap.min.css" />
    <!-------date picker------->
    <link rel="stylesheet" href="css/jquery-ui.css" />
    <script src="js/jquery.js"></script>
    <script src="js/jquery-ui.js"></script>
    <script>    
    $(document).ready(function(){
    $("#datepicker").datepicker({
    beforeShowDay: function(date)
        {
        var day=date.getDay();
        if(day==2)
        {
        return [false];
        }
        else
        {
        return [true];
        }
        }
    });
    });
    </script>
    <script>
     $(document).ready(function() {
            $('#datepicker').datepicker();
             $('#datepicker').datepicker("show");
              });
        
   </script>
    
<script>
  function setToday()
  {
      var n =  new Date();
y = n.getFullYear();
m = n.getMonth() + 1;
d = n.getDate();
var x=m + "/" + d + "/" + y;
document.getElementById("datepicker").value = x;
      }
function datechange(vv)
{
    document.myform.action="test_booking.php";
    document.myform.submit();
    
    }
</script>

    
        
    </head>
    <body OnLoad="document.myform.fname.focus();setToday()">

    
        <div class="container register">
                <div class="row">
                    <div class="col-md-3 training_bk register-left">
                        <img src="images/ESStechlogo.png" alt=""/>
                        <h3>Welcome</h3>
                        <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</p>
                        
                    </div>
                    
                    <div class="col-md-9 register-right">
                     <form method="post" action="test_booking_review.php" name="myform">
                        <div class="tab-content" id="myTabContent">
                            <div class="tab-pane fade show active" id="home" role="tabpanel" aria-labelledby="home-tab">
                                <h3 class="register-heading">Book your Training</h3>
                                <div class="row register-form">
                                    <div class="col-md-6">
                                    
                                        <div class="form-group">
                                            <input type="text" autofocus name="fname" required class="form-control" placeholder="First Name*" />
                                        </div>
                                        <div class="form-group">
                                            <input type="text" name="lname" required class="form-control" placeholder="Last Name*" />
                                        </div>
                                        
                                    
                                        <h5>Your Preferred Slot</h5>
                                         <div class="form-group">
                                         <!--<div id="datepicker" required name="date" ></div>-->
                                               <input type="text"  id="datepicker" required name="date"  placeholder="mm/dd/yyyy" class="form-control" onChange ="datechange(this.value)">
                                                
                                            
                                            </div>
                                            
                                    </div>
                                    <div class="col-md-6">
                                    <div class="form-group">
                                            <input type="email" name="email" required class="form-control" placeholder="Email*" />
                                        </div>
                                     <div class="form-group">
                                            <input type="number" name="phone" required class="form-control" placeholder="Phone*" />
                                        </div>
                                     
                                         <!--<div class="form-group">
                                            <select class="form-control">
                                                <option class="hidden"  selected disabled>City</option>
                                                <option>option</option>
                                                <option>option</option>
                                                <option>option</option>
                                            </select>
                                        </div>-->
                                        <div class="form-group">
                                            <div class="maxl">
                                            <?php
                                            if (!in_array("08:00AM TO 09:00AM", $slots))
                                            {

                                            ?>
                                                <label class="radio inline"> 
                                                    <input type="radio" name="time" value="08:00AM TO 09:00AM" checked>
                                                    <span>08:00AM TO 09:00AM (Available)</span> 
                                                </label>
                                                <?php
                                                }
                                            if (!in_array("09:00AM TO 10:00AM", $slots))
                                            {
                                            ?>
                                            
                                                <label class="radio inline"> 
                                                    <input type="radio" name="time" value="09:00AM TO 10:00AM">
                                                    <span>09:00AM TO 10:00AM (Available)</span> 
                                              </label>
                                        <?php
                                                }
                                            if (!in_array("10:00AM TO 11:00AM", $slots))
                                            {
                                            ?>

                                                 <label class="radio inline"> 
                                                    <input type="radio" name="time" value="10:00AM TO 11:00AM">
                                                    <span>10:00AM TO 11:00AM (Available)</span> 
                                                </label>
                                        <?php
                                                }
                                            if (!in_array("11:00AM TO 12:00PM", $slots))
                                            {
                                            ?>

                                                 <label class="radio inline"> 
                                                    <input type="radio" name="time" value="11:00AM TO 12:00PM">
                                                    <span>11:00AM TO 12:00PM (Available)</span> 
                                                </label>
                                        <?php
                                                }
                                            if (!in_array("12:00PM TO 01:00PM", $slots))
                                            {
                                            ?>

                                                <label class="radio inline"> 
                                                    <input type="radio" name="time" value="12:00PM TO 01:00PM">
                                                    <span>12:00PM TO 01:00PM (Available)</span> 
                                                </label>
                                        <?php
                                                }
                                            ?>

                                            </div>
                                        </div>
                                        <input type="submit" class="btnRegister"  value="Continue"/>
                                    </div>
                                    
                                </div>
                            </div>
                           
                        </div>
                        </form>
                    </div>
                    
                </div>

            </div>
             
    </body>

 

Edited March 4, 2020 by Barand
Added code tags

Hi,

As a part of my university course final year project i have to create a room reservation system.

I have found this
http://www.phpjabbers.com/availability-booking-calendar/index.php
Which looks perfect but i cant use that as i have to code it myself.

Does anyone know of a guide that will help me build something similar?

Thanks in advance

Hi , 

 

I try to change a PHP code for a booking program without succes. Now the time set is from 00.00 - 24.00hours but it must be fixed on 15.00H ( dropoff) and 11.00H (pick-up). Can someone help me please ? 

 

Big thanks in advance !

 

$pickhdeftime = !empty($places[$indvrcplace]['defaulttime']) ? ((int)$places[$indvrcplace]['defaulttime'] / 3600) : '';
    if (!($i < $j)) {
        while (intval($i) != (int)$j) {
            $sayi = $i < 10 ? "0".$i : $i;
            if ($nowtf != 'H:i') {
                $ampm = $i < 12 ? ' am' : ' pm';
                $ampmh = $i > 12 ? ($i - 12) : $i;
                $sayh = $ampmh < 10 ? "0".$ampmh.$ampm : $ampmh.$ampm;
            } else {
                $sayh = $sayi;
            }
            $hours .= "<option value=\"" . (int)$i . "\"".($pickhdeftime == (int)$i ? ' selected="selected"' : '').">" . $sayh . "</option>\n";
            $i++;
            $i = $i > 23 ? 0 : $i;
        }
        $sayi = $i < 10 ? "0".$i : $i;
        if ($nowtf != 'H:i') {
            $ampm = $i < 12 ? ' am' : ' pm';
            $ampmh = $i > 12 ? ($i - 12) : $i;
            $sayh = $ampmh < 10 ? "0".$ampmh.$ampm : $ampmh.$ampm;
        } else {
            $sayh = $sayi;
        }
        $hours .= "<option value=\"" . (int)$i . "\">" . $sayh . "</option>\n";
    } else {
        while ($i <= $j) {
            $sayi = $i < 10 ? "0".$i : $i;
            if ($nowtf != 'H:i') {
                $ampm = $i < 12 ? ' am' : ' pm';
                $ampmh = $i > 12 ? ($i - 12) : $i;
                $sayh = $ampmh < 10 ? "0".$ampmh.$ampm : $ampmh.$ampm;
            } else {
                $sayh = $sayi;
            }
            $hours .= "<option value=\"" . (int)$i . "\"".($pickhdeftime == (int)$i ? ' selected="selected"' : '').">" . $sayh . "</option>\n";
            $i++;
        }
    }
    //
    $hoursret = "";
    //VRC 1.9
    $drophdeftime = !empty($places[$indvrcreturnplace]['defaulttime']) ? ((int)$places[$indvrcreturnplace]['defaulttime'] / 3600) : '';
    if (!($iret < $jret)) {
        while (intval($iret) != (int)$jret) {
            $sayiret = $iret < 10 ? "0".$iret : $iret;
            if ($nowtf != 'H:i') {
                $ampm = $iret < 12 ? ' am' : ' pm';
                $ampmh = $iret > 12 ? ($iret - 12) : $iret;
                $sayhret = $ampmh < 10 ? "0".$ampmh.$ampm : $ampmh.$ampm;
            } else {
                $sayhret = $sayiret;
            }
            $hoursret .= "<option value=\"" . (int)$iret . "\"".($drophdeftime == (int)$iret ? ' selected="selected"' : '').">" . $sayhret . "</option>\n";
            $iret++;
            $iret = $iret > 23 ? 0 : $iret;
        }
        $sayiret = $iret < 10 ? "0".$iret : $iret;
        if ($nowtf != 'H:i') {
            $ampm = $iret < 12 ? ' am' : ' pm';
            $ampmh = $iret > 12 ? ($iret - 12) : $iret;
            $sayhret = $ampmh < 10 ? "0".$ampmh.$ampm : $ampmh.$ampm;
        } else {
            $sayhret = $sayiret;
        }
        $hoursret .= "<option value=\"" . (int)$iret . "\">" . $sayhret . "</option>\n";
    } else {
        while ((int)$iret <= $jret) {
            $sayiret = $iret < 10 ? "0".$iret : $iret;
            if ($nowtf != 'H:i') {
                $ampm = $iret < 12 ? ' am' : ' pm';
                $ampmh = $iret > 12 ? ($iret - 12) : $iret;
                $sayhret = $ampmh < 10 ? "0".$ampmh.$ampm : $ampmh.$ampm;
            } else {
                $sayhret = $sayiret;
            }
            $hoursret .= "<option value=\"" . (int)$iret . "\"".($drophdeftime == (int)$iret ? ' selected="selected"' : '').">" . $sayhret . "</option>\n";
            $iret++;
        }
    }
    //
    $minutes = "";
    for ($i = 0; $i < 60; $i += 15) {
        if ($i < 10) {
            $i = "0" . $i;
        }
        $minutes .= "<option value=\"" . (int)$i . "\"".((int)$i == $imin ? " selected=\"selected\"" : "").">" . $i . "</option>\n";
    }
    $minutesret = "";
    for ($iret = 0; $iret < 60; $iret += 15) {
        if ($iret < 10) {
            $iret = "0" . $iret;
        }
        $minutesret .= "<option value=\"" . (int)$iret . "\"".((int)$iret == $iminret ? " selected=\"selected\"" : "").">" . $iret . "</option>\n";
    }
    
    $sval = $session->get('getDateFormat', '');
    if (!empty($sval)) {
        $dateformat = $sval;
    } else {
        $q = "SELECT `setting` FROM `#__vikrentcar_config` WHERE `param`='dateformat';";
        $dbo->setQuery($q);
        $dbo->execute();
        if ($dbo->getNumRows() == 1) {
            $df = $dbo->loadAssocList();
            $dateformat = $df[0]['setting'];
        } else{
            $dateformat = "%d/%m/%Y";
        }
    }
    
    if (true) {
        if ($dateformat == "%d/%m/%Y") {
            $juidf = 'dd/mm/yy';
        } elseif ($dateformat == "%m/%d/%Y") {
            $juidf = 'mm/dd/yy';
        } else {
            $juidf = 'yy/mm/dd';
        }

Hello.  I'm trying to build a site where users can book appointments with personal trainers.  I want to use the free and open source jQuery Full Calendar for the look and feel of the calendar since it looks pleasant and is responsive. <link removed>
 
I want each personal trainer to have their own calendar which will show the days that they're available.  When a user clicks on an available day then they will see a list of time slots that they can book in 15 minute increments.
 
So, for instance lets say a trainer named Mike is available on Mondays-Friday from 8am-5pm. If a user comes to his calendar they will see that certain days are not fully booked and they can click on a day. Then when they click on a day they can see time intervals like this:

Mike's available time slots for Tuesday August 25, 2014:

8:00 am-9:00 am - Click here to book appointment!
8:15 am-9:15 am - Click here to book appointment!
2:00 pm - 3:00 pm - Click here to book appointment!
 
The page above can be a separate page from the calendar, but it would need to be synced with the calendar to be able to fetch the times and days that he's available for appointments. Then when the user clicks on a day, he can book an appointment and after the trainer confirms via email then the user will receive an email confirmation that his appointment is scheduled. While it's still being confirmed though, that time slot would need to be no longer visible to other users, so that there wouldn't be multiple bookings for the same time slot, to avoid those conflicts.

So, the application would need to fetch the data from MySQL and use that to display the available days. If a day is not available then the user will not be able to click on it in the calendar. Also, the trainers should be able to set their schedule which will get updated to MySQL, so the schedule is normally recurring but they should also be able to change certain days if they feel like they can or cannot work on that day. 

Also, the appointments will vary by time, so a training session can last 30 minutes, 1 hour, 3 hours, 1 hour and a half, etc. and that would need to be taken into account when the user books an appointment because if the trainer has a 1 hour gap between 2pm and 3pm, but the session is for 2 hours, they should not be able to book that time slot, since it wouldn't make any sense. 
 
What makes this complicated is that the appointment lengths can vary.  Otherwise, if every appointment was 1 hour long I would be able to just create a table for appointment times and do a query to see if they're booked and only show the booked ones.  How can I do it with variable time lengths?  Any help would be greatly appreciated.
Edited by mac_gyver, 16 August 2014 - 09:04 AM.
removed link, not relevant to post

Here's what I'm trying to do.

1. A user creates a calendar that shows which dates he's available. This calendar could showcase availability for up to a year.

2. Other users can do a search for a user that's available on a set date. For e.g. July 1st. 

3. All the users available on July 1st will show up in the search results.

 

There is no booking for appointments involved. It simply needs to show the users available on set dates. I am wondering what's the best way to create this calendar feature?

Hello there,

I have a problem with this project I'm working on, everything is working fine except for one last thing.
it goes as you go to the website, search for a city, choose a hotel from a list in that city, then book a room in that hotel, go to confirmation page then to paypal.
everything is fine except after the booking when you go to the confirmation page, it shows correctly the number of nights you booked and everything, all except the rooms, it shows 0 rooms selected, and it doesn't give any price at all.

here is the code

Code: [Select]
<?php

include("db.class.php");




class hotelManager
{


public function getHotel($where)
{
$where = isset($_POST['where']) ? $_POST['where'] : "";
$dbObj = new DB();
$where = $_POST['where'];
$sql = "select * from hotels where city_id IN (select id from cities where name = '$where') or country_id IN (select id from countries where name = '$where')";
$result = mysql_query($sql);
$arr = array();
echo "<table>";
while($row = mysql_fetch_array($result)
or die(mysql_error()))
{
echo "<tr>";
echo "<td valign=\"top\" width=\"120px\">";
$rowid = $row['id'];
$imageqry=mysql_query("SELECT * FROM `hotelphotos` where hotel_id='$rowid'");
$image=mysql_fetch_array($imageqry);
$imagename=$image['attachmentName'];
echo "<img src=\"foxmaincms/webroot/files/small/$imagename\"/>";
echo "</td>";
echo "<td valign=\"top\">";

echo "<table>
<tr>
<td valign=\"top\">
<a href=\"hotels.php?id=".$row['id']."\" class=\"titleslink\">".$row['name']."</a>
</td>
</tr>
<tr>
<td class=\"text\" valign=\"top\">
".$row['location']."
</td>
</tr>
</table>";

echo "</td>";
echo "</tr>";
}
echo "</table>";

  //return $arr; // array of arrays

}
/*************************** GET ONE HOTEL *****************************/
public function getHotelbyID($hotelID)
{
$dbObj = new DB();
$result = mysql_query("select * from hotels where id = '$hotelID'");
return $result;
}

public function HotelDatatabel($result)
{
$row = @mysql_fetch_array($result);
echo "<table width=98%>";       
        echo "<tr>";
echo "<td valign=\"top\" width=\"120px\">";
$rowid = $row['id'];
$imageqry=mysql_query("SELECT * FROM `hotelphotos` where hotel_id='$rowid' LIMIT 1");
$image=mysql_fetch_array($imageqry);
$imagename=$image['attachmentName'];
echo "<img src=\"foxmaincms/webroot/files/small/$imagename\"/>";
echo "</td>";
echo "<td valign=\"top\">";
echo "<table>
<tr>
<td valign=\"top\" class=\"searchtitle\">
".$row['name']."
</td>
</tr>
<tr>
<td class=\"text\" valign=\"top\">
".$row['location']."
</td>
</tr>
<tr>
<td>
".$row['details']."
</td>
</tr>
<tr>
<td>
<a href=\"http://".$row['website']."\" class=\"link\">".$row['website']."</a>
</td>
</tr>
</table>";
echo "</td>";
echo "</tr>";
echo "</table>";

}

/************************************ GET ROOMS **************************************/

public function getHotelRooms($hotelID)
{
$result = mysql_query("select * from rooms where hotel_id = '$hotelID'");
echo "<form name='bookingform' id='bookingform' method='post' action='book.php'>";
echo "<input name=\"roomid\" id=\"roomid\" type=\"hidden\" />";
echo "<input name=\"roomnum\" id=\"roomnum\" type=\"hidden\" />";

echo "<input name=\"hotelid\" id=\"hotelid\" type=\"hidden\" value=\"$hotelID\"/>";
echo "<table width=80% >";
echo"<tr>";
echo "<td>Check-in date</td>";
echo "<td>";
echo "<input type=\"text\" name=\"datein\" class=\"date_input\" />";
echo "</td>";
echo "<td>Check-out date</td>";
echo "<td>";
echo "<input type=\"text\" name=\"dateout\" class=\"date_input\" />";
echo "</td>";
echo"</tr>";
echo "<table>";
echo "<table class=\"rooms\" width=100% cellspacing=\"1\" >";
echo "<tr>
<th class=\"rooms\">Room Type</th>
<th class=\"rooms\">Rate for night</th>
<th class=\"rooms\">MAX</th>
<th class=\"rooms\">Nr.rooms</th>
<th class=\"rooms\">Book</th>
</tr>";
while($row = @mysql_fetch_array($result))
{
echo "<tr>";
echo "<td class=\"text\" align=center>".$row['room_type']."</td>";
echo "<td class=\"text\" align=center>".$row['price_per_day']."</td>";
echo "<td class=\"text\" align=center>".$row['people']." People</td>";
echo "<td class=\"text\" align=center>";

?>

                        <select name="nrooms" id="nrooms" onchange="
                        //alert('<?php echo $row['id'] ; ?>');
                        //alert(this.value);
                        var exist = 0;
                        if(roomids.length > 0)
                        {
for(var hh = 0;hh < roomids.length; hh++)
{

if(roomids[hh] == <?php echo $row['id'] ; ?>)
{
exist = 1;
//alert(hh);
roomnumar[hh] = this.value;


}
}
if(exist == 0)
{
roomids.push(<?php echo $row['id'] ; ?>);
roomnumar.push(this.value);
}
                        }
                        else
                        {
                        roomids.push(<?php echo $row['id'] ; ?>);
                        roomnumar.push(this.value);
                        }
                       
                        document.bookingform.roomid.value = roomids;
                        document.bookingform.roomnum.value = roomnumar;
                       
                       
                       
                        ">
                        <option value=0>  0  </option>
                        <?php
                        for($i = 0; $i < $row['available_rooms']; $i++)
                         {
                         $nr = $i+1;
                         $pr=$nr * $row['price_per_day'];
                         echo "<option value=$nr>$nr ($pr\$)</option>";
                         }
                        echo "</select>
                        </td>";
                        echo "<td align=center>
                        &nbsp;
                        </td>";
echo "</tr>";
echo "<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>";

}
echo "<tr class=\"rooms\">
<td colspan=\"4\">&nbsp;</td>

<td align=center><input type=\"submit\" value=\"book\" id=\"bookroom\" name=\"bookroom\"/></td>
</tr>";
echo "</table>";
echo "</form>";
print_r($_SESSION['order']);

$_SESSION['order']=0;
unset($_SESSION['order']);

}

}


?>
BookinManager.php

Code: [Select]
<?php include("hotelsManager.php"); ?>
<?php include("config.php"); ?>
<?php include("textManager.php"); ?>
<?php
 function echoPostedData()
 {
   
   $dbo = new DB();
   $hotelObj = new hotelManager();
   $hotelID = $_POST['hotelid'];
   $datein = $_POST['datein'];
   $dateout = $_POST['dateout'];
   $roomid = $_POST['roomid'];
   $pr = $_POST['pr'];
   
   $_SESSION['hotelID'] = isset($_POST['hotelid']) ? $_POST['hotelid'] : $_SESSION['hotelID'];
   $_SESSION['datein'] = isset($_POST['datein']) ? $_POST['datein'] : $_SESSION['datein'];
   $_SESSION['dateout'] = isset($_POST['dateout']) ? $_POST['dateout'] : $_SESSION['dateout'];
         $_SESSION['roomid'] = isset($_POST['roomid']) ? $_POST['roomid'] : $_SESSION['roomid'];   
   
   
   $roomsarray = explode(",",$_POST['roomid']);
   $_SESSION['roomsarray'] = isset($_POST['roomid']) ? explode(",",$_POST['roomid']) : $_SESSION['roomsarray'];
   $roonsNo = $_POST['nrooms'];
   $_SESSION['nrooms'] = isset($_POST['roomnum']) ? explode(",",$_POST['roomnum']) : $_SESSION['nrooms'];
   
   
   
   /********************** hotels ************************/
   
   /******************************************************/
   
   echo "<table width=95% border=0 align=\"center\" cellpadding=\"0\" cellspacing=\"0\">
         <tr><td valign=\"top\">";
                  echo "<table>";
                  echo "<tr>";
                  echo "<td valign=top>";
                   $imageqry=mysql_query("SELECT * FROM `hotelphotos` where hotel_id='".$_SESSION['hotelID']."' LIMIT 1");
$image=mysql_fetch_array($imageqry);
$imagename=$image['attachmentName'];
echo "<img src=\"foxmaincms/webroot/files/small/$imagename\"/>";
  echo "</td>";
  echo "<td>";
  $result=$hotelObj->getHotelbyID($_SESSION['hotelID']);
  $row = mysql_fetch_array($result);
  echo "<table>";
  echo "<tr><td valign=top><strong class=subtitle3>".$row['name']."</strong></td></tr>";
  echo "<tr><td class=text valign=top>".$row['location']."</td></tr>";
  echo "<tr><td class=text valign=top>check-in Date: ".$_SESSION['datein']."</td></tr>";
  echo "<tr><td class=text valign=top>check-out Date: ".$_SESSION['dateout']."</td></tr>";
  echo "<tr><td class=text valign=top>";
  $newdate = $_SESSION['dateout'] - $_SESSION['datein'];
  $totalprice = array_sum($_SESSION['totalprice'])
  echo "</td></tr>";
  echo "<tr><td class=text valign=top>Total Price: ".$totalprice."</td></tr>";
  echo "</table>";
  
  echo "</td>";
  echo "</tr>";
  echo "</table>";
        echo "</td></tr></table>";
 }
 
 function echoForm2()
 {
?>
  <form id="userDetails" name="userDetails" action="" method="post">
                  <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
                    <tr>
                      <td valign="top" class="subtitle3"><strong>Your Name</strong><br />
                      <input type="text" name="name" size="50" /></td>
                     
                    </tr>
                    <tr>
                      <td valign="top" class="subtitle3"><strong>Email address</strong><br />
                        <input type="text" name="email" size="50" />
                      </td>
                    </tr>
                    <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    </tr>
                    <tr>
                      <td valign="top" class="subtitle3">
                     
                      <?php
$roomsarray = explode(",",$_POST['roomid']);
$roonsNo =  explode(",",$_POST['roomnum']);

for($i = 0;$i<count($roomsarray);$i++)
{
if($roonsNo[$i] > 1)
{

for($j = 0;$j<$roonsNo[$i];$j++)
{
echo "<div>";
$result = mysql_query("select * from rooms where id = '$roomsarray[$i]'");
$row = mysql_fetch_array($result);
echo "<span class=subtitle3><strong>Room: </strong>".$row['room_type']." #".($j+1)."</span>";
echo "</div>";
echo "<table>";
echo "<tr>";
echo "<td>";
echo "<span class=subtitle3><strong> Full guest name </strong></span>";
echo "<br />";
echo "<input type=text name=\"guest_name[]\" size=30/>";
echo "</td>";
echo "<td align=center>
<span class=subtitle3><strong> Max people</strong></span>
<br />
<span class=subtitle3>".$row['people']."guests</span>
</td>";
echo "<td align=center>
<span class=subtitle3><strong>Smoking</strong></span><br />
<select name='smoking'>
<option value=\"\">...</option>
<option value=\"yes\">Yes</option>
<option value=\"no\">No</option>
</select>
</td>";
echo "</tr>";
echo "</table>";
echo "<br />";
}
}
else
{
if($roonsNo[$i] != 0)
{
echo "<div>";
$result = mysql_query("select * from rooms where id = '$roomsarray[$i]'");
$row = mysql_fetch_array($result);
echo "<span class=subtitle3><strong>Room: </strong>".$row['room_type']."</span>";
echo "</div>";

echo "<table>";
echo "<tr>";
echo "<td>";
echo "<span class=subtitle3><strong> Full guest name</strong></span>";
echo "<br />";
echo "<input type=text name=\"guest_name[]\" size=30/>";
echo "</td>";
echo "<td align=center>
<span class=subtitle3><strong> Max people</strong></span>
<br />
<span class=subtitle3>".$row['people']."guests</span>
</td>";
echo "<td align=center>
<span class=subtitle3><strong>Smoking</strong></span><br />
<select name='smoking'>
<option value=\"\">...</option>
<option value=\"yes\">Yes</option>
<option value=\"no\">No</option>
</select>
</td>";
echo "</tr>";
echo "</table>";

echo "<br />";
}
}

}

?>
<hr>
                      </td>
                     
                    </tr>
                    <tr>
                    <td align="right">
                      <input type="submit" name="submit" id="submit" value="Make the reservation" />
                      </td>
                    </tr>
                  </table>
  </form>
<?php
 }
 
?>
Code: [Select]
<?php include("includes/bookinManager.php"); ?>
                 
              <table width="100%" border="0" cellpadding="0" cellspacing="0" class="formtable">
                <tr>
                  <th align="left" valign="top" class="formtable"> Booking Data </th>
                </tr>
                <tr>
                  <td valign="top">&nbsp;</td>
                </tr>
                <tr>
                  <td valign="top">
  <?php
   echoPostedData();
  ?>
                  </td>
                </tr>
                <tr>
                  <td valign="top">&nbsp;</td>
                </tr>
              </table>
             
             
              </td>
            </tr>
            <tr>
              <td valign="top"><img src="images/spacer.gif" width="28" height="10" /></td>
            </tr>
            <tr>
              <td valign="top">
              <?php
if(isset($_POST['bookroom']))
  {?>
              <table width="100%" border="0" cellpadding="0" cellspacing="0" class="formtable">
                <tr>
                  <th align="left" valign="top" class="formtable"> Your Details </th>
                </tr>
                <tr>
                  <td valign="top" >
                  <form action="book.php" method="post" id="payPalForm">  
<table width="60%" border="0" cellpadding="0" cellspacing="0" class="formtable">
<tr>
<td>First name :</td>
<td><input type="text" name="first_name" /></td>
</tr>
<tr>
<td>Last name :</td>
<td><input type="text" name="last_name" /></td>
</tr>
<tr>
<td>Email address :</td>
<td><input type="text" name="email" /></td>
</tr>
<tr>
<td>Full guest name :</td>
<td><input type="text" name="full" /></td>
</tr>
<tr>
<td>Address :</td>
<td><INPUT type="text" NAME="address1" VALUE=""/></td>
</tr>
<tr>
<td>Special Requests :</td>
<td><input type="text" name="special" /></td>
</tr>

</table>
  </td>
                </tr>
                <tr>
                  <td valign="top">
                  <?php //echoForm2();
                  ?>
                 
                 


                  <input type="hidden" name="item_number" value="<?php echo $row['id']; ?>">
<input type="hidden" name="cmd" value="_ext-enter">
<input type="hidden" name="redirect_cmd" value="_xclick">
<input type="hidden" name="business" value="tarek_1305896294_biz@gotharious.com">
<input type="hidden" name="item_name" value="Standard Room: Dar El Masyaf Hotel : 2 nights : 9th, july, 2011">
<input type="hidden" name="currency_code" value="USD">
<INPUT TYPE="hidden" NAME="first_name" VALUE="Tarek">
<INPUT TYPE="hidden" NAME="last_name" VALUE="Sabrouty">
<INPUT TYPE="hidden" NAME="address1" VALUE="9th Popastes St.">
<INPUT TYPE="hidden" NAME="address2" VALUE="Cleopatra Hamamat">
<INPUT TYPE="hidden" NAME="city" VALUE="Alexandria">
<INPUT TYPE="hidden" NAME="Country" VALUE="Egypt">
<INPUT TYPE="hidden" NAME="lc" VALUE="US">
<INPUT TYPE="hidden" NAME="email" VALUE="tarek@gotharious.com">
<INPUT TYPE="hidden" NAME="night_phone_a" VALUE="+20166005733">
<INPUT TYPE="hidden" NAME="amount" VALUE="100.00">

                     
                      <?php
$roomsarray = explode(",",$_POST['roomid']);
$roonsNo =  explode(",",$_POST['roomnum']);

for($i = 0;$i<count($roomsarray);$i++)
{
if($roonsNo[$i] > 1)
{

for($j = 0;$j<$roonsNo[$i];$j++)
{
echo "<div>";
$result = mysql_query("select * from rooms where id = '$roomsarray[$i]'");
$row = mysql_fetch_array($result);
echo "<span class=subtitle3><strong>Room: </strong>".$row['room_type']." #".($j+1)."</span>";
echo "</div>";
echo "<table>";
echo "<tr>";
echo "<td>";
echo "<span class=subtitle3><strong> Full guest name </strong></span>";
echo "<br />";
echo "<input type=text name=\"guest_name[]\" size=30/>";
echo "</td>";
echo "<td align=center>
<span class=subtitle3><strong> Max people</strong></span>
<br />
<span class=subtitle3>".$row['people']."guests</span>
</td>";
echo "<td align=center>
<span class=subtitle3><strong>Smoking</strong></span><br />
<select name='smoking'>
<option value=\"\">...</option>
<option value=\"yes\">Yes</option>
<option value=\"no\">No</option>
</select>
</td>";
echo "</tr>";
echo "</table>";
echo "<br />";
}
}
else
{
if($roonsNo[$i] != 0)
{
echo "<div>";
$result = mysql_query("select * from rooms where id = '$roomsarray[$i]'");
$row = mysql_fetch_array($result);
echo "<span class=subtitle3><strong>Room: </strong>".$row['room_type']."</span>";
echo "</div>";

echo "<table>";
echo "<tr>";
echo "<td>";
echo "<span class=subtitle3><strong> Full guest name</strong></span>";
echo "<br />";
echo "<input type=text name=\"guest_name[]\" size=30/>";
echo "</td>";
echo "<td align=center>
<span class=subtitle3><strong> Max people</strong></span>
<br />
<span class=subtitle3>".$row['people']."guests</span>
</td>";
echo "<td align=center>
<span class=subtitle3><strong>Smoking</strong></span><br />
<select name='smoking'>
<option value=\"\">...</option>
<option value=\"yes\">Yes</option>
<option value=\"no\">No</option>
</select>
</td>";
echo "</tr>";
echo "</table>";

echo "<br />";
}
}

}

?>

                     
                    <input type="submit" name="Submit" value="Submit">

</form>
                 
                <tr>
                  <td valign="top">&nbsp;</td>
                </tr>
              </table>
              <?php } ?>

Hi,

I want to check entered dates and times that a user selects against my "book-off" calendar which is a Google Calendar.
The dates&times from Google is in the form: 2011-04-29T23:00:00.000+02:00

The dates in my booking software (ABPro) is in the form: 2011-04-29
Times in form: 23:00:00

All I want the function to return is a number other than 0 if any of the dates/times in Google feed overlap the requested date/time entered in the booking.

So I add a function and get the feed from Google:
Code: [Select]
function checkOverlapG($calendarID, $startdate, $starttime, $enddate, $endtime){
// Create an instance of the Calendar service using an unauthenticated
//HTTP client
$service = new Zend_Gdata_Calendar();
//Retrieving events in order of start time
$query = $service->newEventQuery();
$query->setUser('calendarID');
// Set to $query->setVisibility('private-magicCookieValue') if using MagicCookie auth
$query->setVisibility('public');
$query->setProjection('full');
$query->setOrderby('starttime');
$query->setSortOrder('ascending');                  //start with first event in future
//seFutureevents must be commented out when using start and end times.
$query->setFutureevents('true');
$query->setSingleEvents('true');
$query->setMaxResults('200');      //Guess this could be anything, but can possibly make things slower. Default 25 events
//$query->setStartMin('2006-12-01');
//$query->setStartMax('2006-12-16);  // setStartMax is exclusive, will not include last date. Must add +1 day.
// Retrieve the event list from the calendar server
try {
$eventFeed = $service->getCalendarEventFeed($query);
               }  catch (Zend_Gdata_App_Exception $e) {
echo "Error: " . $e->getMessage();
return null;
}

Now I want to compare the dates and times and see if any of them collide or overlap. I want to add a counter, and if any of the events overlap, I want the counter to add one number.
1. the first thing I do is check if the event feed include. any events.
2. then I add a counter
3. then I run a foreach to retrieve events one at a time
4. then I change the date and time format from Google Event to match the date and time format form the booking.
5. If fullday event from google, no time information is added, so I add this
6. COMPARE DATES AND TIMES and if overlapping events --> n++;

I've not gotten this code to work. Probably I'm doing something wrong, and I'm sorry but I'm completely new to this.
Getting the Google Calendar data is working fine, and so is changing the format of the dates/times to be same format as request data.
After that (and before, I don't know).

Code: [Select]
$gCount = count($eventFeed);
$n = 0;
if (gCount>0){
foreach($eventFeed as $event){
foreach ($event->when as $when) {
//Getting rid of extra 00's and time zone info for now
$startGevent = $when->startTime;
$startGevent = str_replace('.000+02:00',"",$startGevent);
$endGevent = $when->endTime;
$endGevent = str_replace('.000+02:00',"",$endGevent);

//Splitting date and time into two variables
list($startDateEvent, $startTimeEvent) = split('T',$startGevent);
list($endDateEvent, $endTimeEvent) = split('T',$endGevent);

//Fill in the blanks
if($startTimeEvent!=0) {}
else{$startTimeEvent = "00:00:00";}
if($endTimeEvent!=0) {}
else{$endTimeEvent = "00:00:00";}

//Compare dates
if($startdate == $endDateEvent){
if($starttime > $endTimeEvent OR $endtime < $startTimeEvent){}
else {
n++;
}
} if($enddate == $startDateEvent){
if($endtime < $startTimeEvent OR $starttime > $endTimeEvent){}
else {
n++;
}
}

}
}
return $n;
}

Hello, I have coded a contact form in PHP and I want to know, if according to you, it is secure! I am new in PHP, so I want some feedback from you.

Moreover, I have also two problems based on the contact form. It is a bit complicated to explain, thus, I will break each of my problem one by one.

FIRST:The first thing I want to know, is if my contact form secure according to you:

The HTML with the PHP codes:

Code: [Select]
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {

//Assigning variables to elements
$first = htmlentities($_POST['first']);
$last = htmlentities($_POST['last']);
$sub = htmlentities($_POST['subject']);
$email = htmlentities($_POST['email']);
$web = htmlentities($_POST['website']);
$heard = htmlentities($_POST['heard']);
$comment = htmlentities($_POST['message']);
$cap = htmlentities($_POST['captcha']);

//Declaring the email address with body content
$to = 'alithebestofall2010@gmail.com';
$body ="First name: '$first' \n\n Last name: '$last' \n\n Subject: '$sub' \n\n Email: '$email' \n\n Website: '$web' \n\n Heard from us: '$heard' \n\n Comments: '$comment'";

//Validate the forms
if (empty($first) || empty($last) || empty($sub) || empty($email) || empty($comment) || empty($cap)) {
echo '<p class="error">Required fields must be filled!</p>';
header ('refresh= 3; url= index.php');
return false;

} 
elseif (filter_var($first, FILTER_VALIDATE_INT) || filter_var($last, FILTER_VALIDATE_INT)) {
echo '<p class="error">You cannot enter a number as either the first or last name!</p>';
return false;
} 
elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
echo '<p class="error">Incorrect email address!</p>';
return false;
}
elseif (!($cap === '12')){
echo '<p class="error">Invalid captcha, try again!</p>';
return false;
}
else {
mail ($to, $sub, $body);
echo '<p class="success">Thank you for contacting us!</p>';
}
}
?>
<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<p>Your first name: <span class="required">*</span></p>
<p><input type="text" name="first" size="40" placeholder="Ex: Paul"/></p>

<p>Your last name: <span class="required">*</span></p>
<p><input type="text" name="last" size="40" placeholder="Ex: Smith"/></p>

<p>Subject: <span class="required">*</span></p>
<p><input type="text" name="subject" size="40" placeholder="Ex: Contact"/></p>

<p>Your email address: <span class="required">*</span></p>
<p><input type="text" name="email" size="40" placeholder="Ex: example@xxx.com"/></p>

<p>Website:</p>
<p><input type="text" name="website" size="40" placeholder="Ex: http//:google.com"/></p>

<p>Where you have heard us?: <span class="required">*</span></p>
<p><select name="heard">
<option>Internet</option>
<option>Newspapers</option>
<option>Friends or relatives</option>
<option>Others</option>
</select></p>

<p>Your message: <span class="required">*</span></p>
<p><textarea cols="75" rows="20" name="message"></textarea></p>

<p>Are you human? Sum this please: 5 + 7 = ?: <span class="required">*</span></p></p>
<p><input type="text" name="captcha" size="10"/></p>

<p><input type="submit" name="submit" value="Send" class="button"/>
<input type="reset" value="Reset" class="button"/></p>
</form>

SECOND PROBLEM:If a user has made a mistake, he gets the error message so that he can correct! However, when a mistake in the form occurs, all the data the user has entered are disappeared! I want the data to keep appearing so that the user does not start over again to fill the form.

THIRD: When the erro message is displayed to notify the user that he made a mistake when submitting the form, the message is displaying on the top of the page. I want it to appear below each respective field. How to do that? In JQuery it is simple, but in PHP, I am confusing!

Hello, first time poster..  I've looked the web over for a long time and can't figure this one out.

- Below is basic code that successfully checks MySQL for a match and displays result.  I was debugging and forced the "height" and "width" to be 24 and 36 to make sure that wasn't the problem.  That's good.. 
- I'd like to give the user ability to select width and height from a form.. and have it do an onchange this.form.submit so the form can be changing as fields are altered (thus the onchange interaction)
- In a normal coding environment I've done this numerous times with no "Page cannot be displayed" problems.  It would simply change one select-option value at a time til they get down the form and click submit...  but in WordPress I'm having trouble making even ONE single onchange work!
- I've implemented the plugins they offer which allows you to "copy+paste" your php code directly into their wysiwyg editor.  That works with basic tests like my first bullet point above.
- I've copied and pasted the wordpress url (including the little ?page_id=123) into the form "action" url... that didn't work...  tried forcing it into an <option value=""> tag.. didn't work.  I'm just not sure. 

I've obviously put xx's in place of private info..

Why does this form give me Page Cannot Be Displayed in WordPress every time?  It won't do anything no matter how simple.. using onchange..

Code..

$con = mysql_connect("xxxx.xxxxxxx.com","xxxxxx","xxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("xxxxxx", $con);
$myprodwidth=24;
$myprodheight=36;
$result = mysql_query("SELECT * FROM product_sizes WHERE prodwidth='$myprodwidth' and prodheight='$myprodheight'");
while($row = mysql_fetch_array($result))
  {
  echo $row['prodprice'];
  }
mysql_close($con);


<form method="post" action="">
<select name="myheight" onchange="this.form.submit();">
<option selected="selected" value="">select height</option>
<option value="xxxxxxxxx.com/wordpress/?page_id=199&height=36">36</option>
<option value="xxxxxxxxx.com/wordpress/?page_id=199&height=36">48</option>
</select>