tom7890

thank you, that worked. Much appreciated. If a time has been selected and it has been added to the database how can i block this out so it cant be selected again? 2. Also am i able to get the date which has been selected from the calendar into the database too? so it would be date selected, start time, end time ie. tom 16:00 16:45

html code.. start and end are the column names, i have doubled it up on the page as it was toooo long <form method="post" > <div align="center"> <table width='400' border='6' cellpadding='2' cellspacing='2' id='timeslots' style="display:none;"'> <tr> <th width='71' height="32" bgcolor="#999999" border='6 align='left'><div align="center">Start</div></th> <th width='70' align='left' bgcolor="#999999"><div align="center">End</div></th> <th width='38' align='left' bgcolor="#999999"><div align="center">Book</div></th> <th width='6' align='left' bgcolor="#666666"> </th> <th width='115' align='left' bgcolor="#999999"><div align="center">Start</div></th> <th width='63' align='left' bgcolor="#999999"> <div align="center">End</div></th> <th width='41' align='left' bgcolor="#999999"><div align="center">Book</div></th> </tr> <tr> <td height="26"><div align="center">08:00 </div></td> <td><div align="center">08:15</div></td> <td><div align="center"> <input data-val='08:00 - 08:15' class='fields' type='checkbox' name="booked[]"/> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">08:15</div></td> <td><div align="center">08:30</div></td> <td><div align="center"> <input data-val='08:15 - 08:30' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">08:30</div></td> <td><div align="center">08:45</div></td> <td><div align="center"> <input data-val='08:30 - 08:45' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">08:45</div></td> <td><div align="center">09:00 </div></td> <td><div align="center"> <input data-val='08:45 - 09:00' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">09:00</div></td> <td><div align="center">09:15</div></td> <td><div align="center"> <input data-val='09:00 - 09:15' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">09:15</div></td> <td><div align="center">09:30</div></td> <td><div align="center"> <input data-val='09:15- 09:30' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">09:30</div></td> <td><div align="center">09:45</div></td> <td><div align="center"> <input data-val='09:30:00 - 09:45' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">09:45</div></td> <td><div align="center">10:00</div></td> <td><div align="center"> <input data-val='09:45 - 10:00' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">10:00</div></td> <td><div align="center">10:15</div></td> <td><div align="center"> <input data-val='10:00 - 10:15' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">10:15</div></td> <td><div align="center">10:30</div></td> <td><div align="center"> <input data-val='10:15 - 10:30' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">10:30</div></td> <td><div align="center">10:45</div></td> <td><div align="center"> <input data-val='10:30 - 10:45' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">10:45</div></td> <td><div align="center">11:00</div></td> <td><div align="center"> <input data-val='09:30:00 - 10:00:00' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">11:00</div></td> <td><div align="center">11:15</div></td> <td><div align="center"> <input data-val='11:00 - 11:15' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">11:15</div></td> <td><div align="center">11:30</div></td> <td><div align="center"> <input data-val='11:15 - 11:30' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">11:30</div></td> <td><div align="center">11:45</div></td> <td><div align="center"> <input data-val='11:30 - 11:45' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">11:45</div></td> <td><div align="center">12:00</div></td> <td><div align="center"> <input data-val='11:45 - 12:00' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">12:00</div></td> <td><div align="center">12:15</div></td> <td><div align="center"> <input data-val='12:00 - 12:15' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">12:15</div></td> <td><div align="center">12:30</div></td> <td><div align="center"> <input data-val='12:15 - 12:30' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">12:30</div></td> <td><div align="center">12:45</div></td> <td><div align="center"> <input data-val='12:30 - 12:45' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">12:45</div></td> <td><div align="center">13:00</div></td> <td><div align="center"> <input data-val='12:45 - 13:00' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">13:00</div></td> <td><div align="center">13:15</div></td> <td><div align="center"> <input data-val='13:00 - 13:15' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">13:15</div></td> <td><div align="center">13:30</div></td> <td><div align="center"> <input data-val='13:15 - 13:30' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">13:30</div></td> <td><div align="center">13:45</div></td> <td><div align="center"> <input data-val='13:30 - 13:45' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">13:45</div></td> <td><div align="center">14:00</div></td> <td><div align="center"> <input data-val='13:45 - 14:00' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">14:00</div></td> <td><p align="center">14:15</p></td> <td><div align="center"> <input data-val='14:00 - 14:15' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">14:15</div></td> <td><div align="center">14:30</div></td> <td><div align="center"> <input data-val='14:15 - 14:30' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">14:30</div></td> <td><div align="center">14:45</div></td> <td><div align="center"> <input data-val='14:30 - 14:45' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">14:45</div></td> <td><div align="center">15:00</div></td> <td><div align="center"> <input data-val='14:45 - 15:00' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">15:00</div></td> <td><div align="center">15:15</div></td> <td><div align="center"> <input data-val='15:00 - 15:15' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">15:15</div></td> <td><div align="center">15:30</div></td> <td><div align="center"> <input data-val='15:15 - 15:30' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">15:30</div></td> <td><div align="center">15:45</div></td> <td><div align="center"> <input data-val='15:30 - 15:45' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">15:45</div></td> <td><div align="center">16:00</div></td> <td><div align="center"> <input data-val='15:45 - 16:00' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">16:00</div></td> <td><div align="center">16:15</div></td> <td><div align="center"> <input data-val='16:00 - 16:15' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">16:30</div></td> <td><div align="center">16:45</div></td> <td><div align="center"> <input data-val='16:15 - 16:45' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">16:45</div></td> <td><div align="center">17:00</div></td> <td><div align="center"> <input data-val='16:45 - 17:00' class='fields' type='checkbox' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">17:00</div></td> <td><div align="center">17:15</div></td> <td><div align="center"> <input data-val='17:00 - 17:15' class='fields' type='checkbox' name="booked[]" /> </div></td> </tr> <tr> <td height="26"><div align="center">17:15</div></td> <td><div align="center">17:30</div></td> <td><div align="center"> <input type='checkbox' value='17:15 - 17:30' name="booked[]" /> </div></td> <td bgcolor="#666666"> </td> <td><div align="center">17:30</div></td> <td><div align="center">17:45</div></td> <td><div align="center"> <input type="checkbox" value="17:30 - 17:45" name="booked[]" <br> </div></td> </tr> <tr> <td height="26"><div align="center">17:45</div></td> <td><div align="center">18:00</div></td> <td><div align="center"> <input data-val='17:45 - 18:00' class='fields' type='checkbox' name="booked[]" /> <td bgcolor="#666666"> </td> <td colspan="3"><div align="center"> <input type="Submit" name="Submit" id="Submit" value="Submit" /> </div> <div align="center"></div> <div align="center"></div></td> </tr> </table>

<?php $username = "root"; $password = ""; $hostname = "localhost"; $dbhandle = mysql_connect($hostname, $username, $password) or die ("no connection to database"); if(isset($_POST['Submit'])){ $start = mysql_real_escape_string($_POST['start']); $end = mysql_real_escape_string($_POST['end']); $selected = mysql_select_db("booking", $dbhandle); $insert = mysql_query("INSERT into booking (start, end) VALUES ('".$start."','".$end."')"); if($insert) echo "Success"; else echo "There was an error " . mysql_error(); } mysql_close(); ?>

i have amended that but now i have an error the data saved into the database is incorrect it shows: i selected 17:45-18:00 but in the database it is shown as: start end 00:00: 00:00:

I have a table made up of time slots, when the user clicks maybe one or two and presses submit, i would like the date selected and the time slots chosen to be saved in to my sql. I am working on the query but a little stuck in regards to the query, i have done the following: <?php $username = "root"; $password = ""; $hostname = "localhost"; $dbhandle = mysql_connect($hostname, $username, $password) or die ("no connection to database"); if(isset($_POST['Submit'])){ $start = mysql_real_escape_string($_POST['start']); $end = mysql_real_escape_string($_POST['end']); $booked = mysql_real_escape_string($_POST['booked']); $selected = mysql_select_db("booking", $dbhandle); ?> i have set the table as follows <input data-val='08:30 - 08:45' class='fields' type='checkbox' name="booked[]" />

i have not used a style sheet for my project that i have so far, i think this is the reason i dont get ur code

i cnt make sense of what i need to do although suggestions have been. I dont understand

I dont understad the logic behind colouring the calendar to show the status of each day..

The user will select a day from a calendar, a form will show with timeslots, once they pick a time another form will appear where they enter details and book that timeslot. I am trying to make a key for the calendar which shows what is available and what is not, but i cant seem to get it around my head on how to do this. I am not asking for code or anything, im trying to see if anyone can explain in such a way that i can implement like tasks of what need to done, i.e. 1) Create a key table etc

Hey I was hoping i could get some help in regards to a time slot calendar i am working on. I have created a calendar in php, a table for the time slots but i am a little stuck on how to do the next tasks. I need a key for the calendar so which shows what days are: 1. Available to be book 2. Partially booked 3. Fully booked 4. Closed I need to create a table in sql for the key and then where days are closed i need to color them say red, those that are available color green etc.. Im stuck on the how to implment this in sql. How do i link it all up to the database

<?php $timestamp = mktime(0,0,0,$cMonth,1,$cYear); $maxday = date("t",$timestamp); $thismonth = getdate ($timestamp); $startday = $thismonth['wday']; for ($i=0; $i<($maxday+$startday); $i++) { if(($i % 7) == 0 ) echo "<tr> "; if($i < $startday) echo "<td></td> "; else echo "<td align='center' valign='middle' height='20px'><a href='timeslots.html'>". ($i - $startday + 1) . "</a></td> "; if(($i % 7) == 6 ) echo "</tr> "; } ?> how do i change this???

i need a form that is hidden until the user clicks a button on a calendar only Then the form will be visible and have a field for the day that way pressed on submit the form would go back to being invisible. not sure how to implement this can anyone help

how to i change this to show a form not a href link for a new page else echo "<td align='center' valign='middle' height='20px'><a href='timeslots.html'>". ($i - $startday + 1) . "</a></td> ";

i couldnt get it to work within my code i will have another try thanks

can anyone tell me how i could possibly get a my current date highlighted on the calendar?

thank you for ur example, this is not right for my target audience

Can anyone help me.. I have achieved what i wanted with the clickable dates but it is given me double dates i cant figure out why. my code is: if(($i % 7) == 0 ) echo "<tr>"; if($i < $startday) echo "<td style='background-color:gray;'></td>"; else if(($i - $startday +1 ==$today) and ($cMonth == date("n")) and ($cYear == date("Y"))) echo "<td id='timer.php?day=".($i - $startday + 1)."&month=$cMonth&year=$cYear' align='center' valign='middle' height='20px' style='background-color:#F2054D;'>".($i - $startday + 1)."</td>"; else echo "<td id='timer.php?day=".($i - $startday + 1)."&month=$cMonth&year=$cYear' align='center' valign='middle' height='20px' style='background-color:gray;'>".($i - $startday + 1)."</td>"; echo '<td align="center" valign="middle" height="80px" width="80px"><a href="timeslots.html?date='.($i - $startday + 1).'- '.$cMonth.'- '.$cYear.'">'. ($i - $startday + 1) . '</a> <br>'.$result["title"].'</td>'; if(($i % 7) == 6 ) echo "</tr>"; } ?> I think the error is in this code here else echo "<td id='timer.php?day=".($i - $startday + 1)."&month=$cMonth&year=$cYear' align='center' valign='middle' height='20px' style='background-color:gray;'>".($i - $startday + 1)."</td>"; echo '<td align="center" valign="middle" height="80px" width="80px"><a href="timeslots.html?date='.($i - $startday + 1).'-'.$cMonth.'- '.$cYear.'">'. ($i - $startday + 1) . '</a><br>'.$result["title"].'</td>'; if(($i % 7) == 6 ) echo "</tr>"; }

Hi thanks, what im trying to do is firstly make all the dates on the calender clickable.. secondly once any day is selected it opens up a form. The form I have created in sql database oredi. But im stuck on how to accomplish this.

can i use a jquery version on how to get clickable cells in the calendar like this <script> $(document).ready( function() { $(this).on("click", function(e) { alert( $(e.target).text()); }); </script> how would i use this with my calendar code i have posted in the first post? is there another way doing this?

thanks Cronix for the advice, i will stick to the click and have a pop up form. im not too sure on how to code this, are u able to suggest anything to help me?

i meant easier for the user so they dont have to keep on clicking on the data and have a form come up, instead they can hover over see whats available and select the date. i dont mind either one will do.

okay i have taken that on board. please can you guide me on how to make the date cells clickable or how to hover over them to show the available time slots from the sql database?

hiya, i was just thinking would it be better and easier to implement this hover over a date and it display time available, then click on the date and it will tak you to booking form?? can anyone help me implement this?

i have amended my above post for the time slots html and all database tables are now complete. what would be the next step? how do i make the clickable date cells?

Bookings table id date start time name email phone comments Time slots table start time end time booked in the time slots table i want to have 30 mins slots per hour do i need to add them in the table? <table width='400' border='0' cellpadding='2' cellspacing='0' id='booking'> <tr> <th width='150' align='left'>Start</th> <th width='150' align='left'>End</th> <th width='20' align='left'>Book</th> </tr> <tr> <td> </td><td> </td><td> </td><td> </td> </tr> <tr> <td>09:30:00</td> <td>10:00:00</td> <td><input data-val='09:30:00 - 10:00:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>10:00:00</td> <td>10:30:00</td> <td><input data-val='10:00:00 - 10:30:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>10:30:00</td> <td>11:00:00</td> <td><input data-val='10:30:00 - 11:00:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>11:00:00</td> <td>11:30:00</td> <td><input data-val='11:00:00 - 11:30:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>11:30:00</td> <td>12:00:00</td> <td><input data-val='11:30:00 - 12:00:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>12:00:00</td> <td>12:30:00</td> <td><input data-val='12:00:00 - 12:30:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>12:30:00</td> <td>13:00:00</td> <td><input data-val='12:30:00 - 13:00:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>13:00:00</td> <td>13:30:00</td> <td><input data-val='13:00:00 - 13:30:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>13:30:00</td> <td>14:00:00</td> <td><input data-val='13:30:00 - 14:00:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>14:00:00</td> <td>14:30:00</td> <td><input data-val='14:00:00 - 14:30:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>14:30:00</td> <td>15:00:00</td> <td><input data-val='14:30:00 - 15:00:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>15:00:00</td> <td>15:30:00</td> <td><input data-val='15:00:00 - 15:30:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>15:30:00</td> <td>16:00:00</td> <td><input data-val='15:30:00 - 16:00:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>16:00:00</td> <td>16:30:00</td> <td><input data-val='16:00:00 - 16:30:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>16:30:00</td> <td>17:00:00</td> <td><input data-val='16:30:00 - 17:00:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>17:00:00</td> <td>17:30:00</td> <td><input data-val='17:00:00 - 17:30:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>17:30:00</td> <td>18:00:00</td> <td><input data-val='17:30:00 - 18:00:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>18:00:00</td> <td>18:30:00</td> <td><input data-val='18:00:00 - 18:30:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>18:30:00</td> <td>19:00:00</td> <td><input data-val='18:30:00 - 19:00:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr> <tr> <td>19:00:00</td> <td>19:30:00</td> <td><input data-val='19:00:00 - 19:30:00' class='fields' type='checkbox'></td> <td width='110'> </td> </tr></table></div> </body> </html>