PHP - Help - Simple Booking System

I have an Job, which i need some help with.   Its an ordering system.   its probably really simple to do, and i even know how i want it set up. all databases are setup. i cant pay much but my payment will be : 178.59 dollar which in this point of time is calculated from 1000 dkk   the task:   an ordering system which contains: selection menu - to select an activity, stored in an database
an starting time textfield. just a normal textfield i guess
a selection menu - for package selection- wich will find the packages in the package database with the matching target id for the selected Activity
a textfield for amount of people participating, as a multiplier for the price. a selection menu - for additions selecting. same as the Package selector. and an price field

this is in one row, where there should be a way to add these, so that its possible to get more acticity orderes
+ an Total amount field

all this data should then be viewable in a table, which ill create, and after that be able to be send through an email that is setup in html, which ill make:)   Why i need help: i took my hands full with this project, and im leaving soon for thailand, and that is why im a bit screwed;/   hope to hear from somone fast    many thanks Joachim Gerber

Hello,

I'm in need of assistance trying to get this PHP Script working and I'm hoping you'll be able to find a solution.

SQL Table Format: http://pastebin.com/LUuu2pLp
Code: [Select]
--
-- Table structure for table `hungergames_records`
--

CREATE TABLE IF NOT EXISTS `hungergames_records` (
  `user_id` int(10) unsigned NOT NULL,
  `victories` int(32) unsigned NOT NULL DEFAULT '0',
  `biggest_kill_streak` int(32) unsigned NOT NULL DEFAULT '0',
  `most_chests_opened` int(32) unsigned NOT NULL DEFAULT '0',
  `total_chests_opened` int(32) unsigned NOT NULL DEFAULT '0',
  `lastlogin` int(32) unsigned NOT NULL DEFAULT '0',
  `longest_lifespan` int(32) unsigned NOT NULL DEFAULT '0',
  `total_lifespan` int(32) unsigned NOT NULL DEFAULT '0',
  `total_points` int(32) unsigned NOT NULL DEFAULT '100',
  `most_points` int(32) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hungergames_users`
--

CREATE TABLE IF NOT EXISTS `hungergames_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `donor` int(32) unsigned NOT NULL DEFAULT '0',
  `user` varchar(40) NOT NULL,
  `donor_cooldown` int(100) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user` (`user`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12641 ;

PHP Code: http://pastebin.com/aQANz0BL
Code: [Select]
<?php
 
include("config.php");
 
$getRankQuery = "SELECT hungergames_users.id, hungergames_records.user_id, hungergames_records.victories, hungergames_records.biggest_kill_streak, hungergames_records.most_chests_opened, hungergames_records.total_chests_opened, hungergames_records.lastlogin, hungergames_records.longest_lifespan, hungergames_records.total_lifespan, hungergames_records.total_points, hungergames_records.most_points, hungergames_users.donor, hungergames_users.user FROM hungergames_records, hungergames_users WHERE hungergames_records.user_id = hungergames_users.id ORDER BY hungergames_records.total_points DESC";
$getRankResult =  mysql_query($getRankQuery);
 
//Source From: http://stackoverflow.com/questions/7704311/calculate-rank-with-points 
function getUserRank($searchedUserID)
{
    $userArray = getAllUsersOrderedByPoints();
    $rank       = 0;
    $lastPoints = -1; // Never happens
    foreach ( $userArray as $user) {
        if ($user['total_points'] != $lastPoints)  $rank++;
        if ($user['user_id'] == $searchedUserID) break;
    }
    return $rank;
}
 
while ($data = mysql_fetch_array($result)) {
echo getUserRank($data["user_id"]);
}
 
?>

What am I trying to accomplish? Simple Ranking System...

Basically, The total points is stored into total_points field for each user and whoever has the highest score will be Ranked #1 and count down to a the full database (Currently at 12,641 users)

Now the above function getUserRank is the code I pulled from the above source listed, I think my issue relies in the function of getAllUsersOrderedByPoints(); - I've tried doing something like.

Code: [Select]
$row = mysql_fetch_array($getRankResult);

Then adding:

    $userArray = $row["user_id"];

Didn't work - So if you can help me correct this than I'll be greatly appertiated.

Lastly, I've tried doing:

Code: [Select]
$index = 1;
  while ($data = mysql_fetch_array($getRankQuery)) {
    echo $index++ . " " . $data["id"] . " ".$data["user"]." <br>\n";
}

This solution works, but this solution would not work for when a "User is Search" it would count them as the highest rank 1,2,3 and wouldn't work, so either the function up there needs to be corrected or please help get a working solution, I've been googleing this issue and seems too be a common code issue with a lot people are having and not many solutions.

The application that records data (Not PHP) doesn't store any data with a "Rank" table otherwise this would be a simple echo'ed out data.

For a better understanding of what I'm trying to do - You may take a look at: http://justonemoreblock.com/lb/leaderboards.php

Regards,
Cory

Hey guys first of all I got 3 files -

index.php
require_once('/libs/template.class.php');

$template = new Template;

$template->assign("title","test");

template.php
<?php echo $title; ?>

template.class.php
function assign($var, $val)
    {
        $var = $val;
    }

I'm trying to assign a variable in index.php, then recall it in the template.php, how would I go about this?

Thank you!

Hello,

I have a simple dice system script I am using in a chat program for a website and I was wondering if someone could simply tell me how to limit the number of dice being rolled. Here are the two chunks of script that make it work:

if($irc_cmd == '/d') {
    if($irc_cmd == $txt) {
        // this can only happen with a no dice - '/d' - a help request
        // return an explanation of the correct format
        $text = "dice command is /d [[n]D]s[Xm|+a|-d|/q]*";
        $this->sendToUser(null, new Message($type, $this->userid, null, $text, $this->color));
        return 'ok';
    }
    // create standard failure message
    $invalid_msg = new Message($type, $this->userid, null, 'ERROR: invalid dice command - '.$txt.' - enter /d for help', $this->color);
    // remove the original command from the dice string
    $dicestring = str_replace($irc_cmd,'', $txt);
    // use lowercase versions of D and X to make parsing simpler
    $dicestring = strtolower($dicestring);
    // remove any user entered spaces
    $dicestring = str_replace(' ', '', $dicestring);
    // note that all modifiers will follow the dice spec 'nDs'
    // number of dice is optional e.g. 1d4 d4 and 4 all represent a single 4-sided die
    // if the first token is blank, then the user intended for one die e.g. /d d20 means /d 1d20
    // if the is no 'd' then the user intended one die e.g. /d 20 means /d 1d20
    $parts = explode('d', $dicestring);
    if(count($parts)>2) {
        // only one 'd' is allowed
        $this->sendToUser(null, $invalid_msg);
        return 'ok';
    } elseif(count($parts)==1) {
        // if no 'D' assume '1' die
        $number = 1;
    } else {
        $number = (int)$parts[0];
        if ($parts[0] == "") { // if $number == 0
            // if no number assume '1' die
            $number=1;
        } elseif ("$number" != "$parts[0]") {
            // only integers allowed
            $this->sendToUser(null, $invalid_msg);
            return 'ok';
        }
        $dicestring = $parts[1];
    }
    if($number < 1) {
        // can't allow a negative number of dice
        $this->sendToUser(null, $invalid_msg);
        return 'ok';
    }
    // check for sides and modifiers
    // expand the string to put spaces around all the tokens we want
    $dicestring = str_replace('+', ' + ', $dicestring);
    $dicestring = str_replace('-', ' - ', $dicestring);
    $dicestring = str_replace('x', ' x ', $dicestring);
    $dicestring = str_replace('/', ' / ', $dicestring);
    // explode the whole thing to create tokens
    $parts = explode(' ', $dicestring);
    // the only other tokens should be integers
    // allowed formats from here are s[Xm][+a][-d][/q]
    // we should allow any series of these in any order, applying them left to right
    // the first part must be the sides
    $sides = (int)$parts[0];
    if ("$sides" != "$parts[0]") {
        $this->sendToUser(null, $invalid_msg);
        return 'ok';
    }
    if($sides < 1) {
        // can't allow a negative number of sides
        $this->sendToUser(null, $invalid_msg);
        return 'ok';
    }
    // get the user's name
    //$user = ChatServer::getUser($this->userid);
    //$name= $user['login'];
    // start writing the reply string
    $text = '*rolls* '.$number.'d'.$sides.': ';
    // seed the randomizer
    srand(time());
    // with number and sides, roll the dice, adding them up
    $total = 0;
    for($i = 0; $i < $number; $i++) {
        $roll = (rand()%$sides)+1;
        if($i != 0)
            $text .= '+';
        $text .= $roll;
        $total += $roll;
    }
    // now apply all the modifiers to the roll, in the order the user specified them
    for ($i = 1; $i < count($parts); $i+=2) {
        // the value needs to be an integer
        $value = (int)$parts[$i+1];
        $v = $parts[$i+1];
        if ("$value" != "$v") {
            $this->sendToUser(null, $invalid_msg);
            return 'ok';
        }
        // the token needs to be one of the operators - otherwise abort
        $token = $parts[$i];
        switch ($token) {
        case '+':
            // add
            $total += $value;
            break;
        case '-':
            // subtract
            $total -= $value;
            // make minimum 1 - remove this like to allow 0 and lower
            if ($total<1) $total=1;
            break;
        case 'x':
            // multiply
            $total *= $value;
            break;
        case '/':
            // divide - round up so 1d6/3 will be the same as 1d2
            $total = ceil($total/$value);
            break;
        default:
            $this->sendToUser(null, $invalid_msg);
            return 'ok';
        }
        // add the modifier to the display string
        $text .= $token.$value;
    }
    // and display the final result
    $text .= ': '.$total;
    // gets sent to particular room, but with users name tacked on, so a user could spoof it
    // at least 'msgu' looks different
    $this->sendToRoom(null, new Message('rpg', $this->userid, $this->roomid, $text));
    return 'ok';
}


and

function Message($command, $userid = null, $roomid = null, $txt = null, $color = null) {

$this->command = $command;
                        if ($command == 'rpg') $this->command = 'msgu';

$this->userid = $userid;

$this->roomid = $roomid;

$this->color = htmlColor($color);

if($command != 'rpg') {

$txt = str_replace('*rolls*', 'rolls', $txt);

}

if(isset($txt)) {

$this->txt = $this->parse($txt);

}

}

So again all I want it to do is limit the number of dice being rolled because right now someone can do a /d 1000000d100000 and completely crash the chat for everyone. I am thinking 100 on either variable would be plenty. Thanks for your help!

I'm attempting to implement a simple social networking system but at the moment am confused about how to create a multiple query which will display a certain user's friends list.

The database contains four tables, the two tables that I'm using at the moment at 'usersTable' and 'friendshipsTable' are detailed below.


usersTable           | Table that stores all the user data

UserID         | Default primary key
Forename              |
Surname         |
Username           |
Password              |
Email Address      |


friendshipTable   | Table that stores information about friendships between users

FriendshipID      |  Default primary key
userID_1                |  UserID
userID_2         |  UserID
Status         |  Either Pending or Confirmed.

The user's id is parsed into the url, and then saved into a variable.

blah.com/userprofile.php?id=6

$id = $_GET['id']; 

I am familiar with creating simple queries, but can't quite work out how to set up multiple table queries.

What the query needs to do is to check the userID that is parsed with the url, and then check the friendshipsTable by checking if either the userID_1 or userID_2 field  matches the userID to grab the records from the table where there is a match.

The next step is to check to see if the friendship is 'Confirmed' or 'Pending' and if it is 'Pending' to ignore it. Once the records have then been chosen I need the query to then check the value in either userID_1 or userID_2 that doesn't match userID and then pull the user's username and name from the usersTable so it can be displayed on a webpage.

I've no idea hoe much I may or may not be overcomplicating this, an example of the code that I've got so far for this query can be found below, but that's as far as I've got at the moment.

$displayFriends = mysql_query("SELECT * FROM friendshipTable, usersTable WHERE friendshipTable.userID_1='$id' OR friendshipTable.userID_2='$id' ");

Cheers for any help.

Hi all

I am trying to edit a piece of code to change possible times for a booking system.

This is the code I have:

$count=0;
               for($b=$startTime;$b<$endTime;$b++){
                  if($count==$tempVar2){ $availability .= "</td><td align='left' valign='top'>"; }   
                  if(in_array($b,$reservedArray)){
                     $availability .= $b.":00 ".($b<12?"am":"pm")." - ".($b+1).":00 ".($b+1<12?"am":"pm")." - Booked.<br>";
                  } else {
                  $availability .=$b.":00 ".($b<12?"am":"pm")." - ".($b+1).":15 ".($b+1<13?"am":"pm")."- <input type=\"checkbox\" value=\"".$b."\" name=\"time[]\" ><br>";
                  }
                  $count++;
               }

It gives me the following times:

09:00 am - 10:15 am
10:00 am - 11:15 am
11:00 am - 12:15 am
12:00 pm - 13:15 pm
13:00 pm - 14:15 pm
14:00 pm - 15:15 pm
15:00 pm - 16:15 pm
16:00 pm - 17:15 pm

How can I change it so I can have the following times available:

10:00 am - 10:30 am
10:45 am - 11:15 am
11:30 am - 12:00 pm
12:15 pm - 12:30 pm
etc...

Many thanks for you help
Pete.

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

hello,

i have a booking form that allows people to book appointments from 0900 to 1800 with 30 min intervals 0900,0930,1000 etc and i was wondering if there is some php code out there that will stop people from booking an appointment at a time that is already booked. any ideas ?

cheers

i have installed a calendar
i want to extract the available id_item that are not id_state=1(booked)

i want to query all the items that are not booked the dates:
$fromdate=22-03-2011;
$todate=25-03-2011;


Code: [Select]
this is bookings.php
mysql_select_db($database_international, $international);
$query_RsBookingIO = sprintf("SELECT * FROM `bookings` LEFT JOIN bookings_items ON bookings.id_item = bookings_items.id WHERE dateDIFF (2011-03-22, 2011-03-25) and bookings.id_state ='1' LIMIT 0 , 30  ", GetSQLValueString($colname_RsBookingIO, "int"));
$RsBookingIO = mysql_query($query_RsBookingIO, $international) or die(mysql_error());
$row_RsBookingIO = mysql_fetch_assoc($RsBookingIO);

<?php do { echo $row_RsBookingIO['the_date'];  ?>
 
  <?php } while ($row_RsBookingIO = mysql_fetch_assoc($RsBookingIO)); ?>

now when creating the searchfunction.php

<?php
 $data = file_get_contents('http://localhost/bookings.php?fromdate=$fromdate and todate=$todate');
$fromdate = $_GET['fromdate'];
$todate = $_GET['todate'];
$dates = explode(' ',$data);
var_dump($data);
foreach($dates as $aDate) {
echo $aDate;
//$aDate = '\''.$aDate.'\'';
if (!in_array($aDate, $dates)) {
$available = true;
} 
}
return $available;
?>

//tables
CREATE TABLE `bookings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_item` int(20) NOT NULL DEFAULT '0',
  `the_date` date NOT NULL DEFAULT '0000-00-00',
  `id_state` int(11) NOT NULL DEFAULT '0',
  `id_booking` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id_item` (`id_item`),
  KEY `id_state` (`id_state`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` VALUES(1, 2, '2011-03-22', 1, 0);
INSERT INTO `bookings` VALUES(3, 2, '2011-03-23', 1, 0);
INSERT INTO `bookings` VALUES(4, 2, '2011-03-24', 1, 0);
INSERT INTO `bookings` VALUES(5, 2, '2011-03-25', 1, 0);
INSERT INTO `bookings` VALUES(6, 2, '2011-03-26', 1, 0);
INSERT INTO `bookings` VALUES(7, 3, '2011-03-23', 1, 0);
INSERT INTO `bookings` VALUES(8, 3, '2011-03-24', 1, 0);
INSERT INTO `bookings` VALUES(9, 3, '2011-03-25', 1, 0);
INSERT INTO `bookings` VALUES(10, 3, '2011-03-26', 1, 0);
INSERT INTO `bookings` VALUES(11, 3, '2011-03-27', 1, 0);


CREATE TABLE `bookings_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL DEFAULT '1',
  `id_ref_external` int(11) NOT NULL COMMENT 'link to external db table',
  `desc_en` varchar(100) NOT NULL DEFAULT '',
  `desc_es` varchar(100) NOT NULL DEFAULT '',
  `list_order` int(11) NOT NULL DEFAULT '0',
  `state` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `id_user` (`id_user`),
  KEY `id_ref_external` (`id_ref_external`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `bookings_items`
--

INSERT INTO `bookings_items` VALUES(1, 1, 4600, 'Suite_A', 'Suite_A', 2, 1);
INSERT INTO `bookings_items` VALUES(2, 1, 4601, 'Suite_B', 'Suite_B', 2, 1);

hello dear PHP-Fans - greetings to you - and a happy new year!!


i set up a WAMP-System on my openSuse 11.4 system.  In order to learn as much as i can bout PHP i want to do some tests and write some scripts.

Well the WAMP is allready up and running.  Now i try to give the writing access to the folder

mkdir /srv/www/

where the php-scripts should go in...

i want  to give write permission to all to all files in /srv/www

As root I generally:

mkdir /srv/www/
chown <webmaster usrername> /srv/www/

/srv/www/ should be readable and traversable by all, but only writeable by it's owner (the user designated as the webmaster.)

can i do this like mentioned above,...

Love to hear from you

greetings
db1

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

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.

$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