Ask Question

Menu


How to show all booked date in calendar using PHP MySQLi


Hi, Friends in this example i am going to show you how to show the booked date and free date in date picker calendar.

Real world example: Hotel Booking system, Movie ticket booking system

Path : datepicker/libs/bootstrap-datepicker/1.4.1/php/bootstrap-datepicker.php

Just go to line 382 and past the code upto 408.

bootstrap-datepicker.php

getClassNames: function(b) {
var c = [],
d = this.viewDate.getUTCFullYear(),
f = this.viewDate.getUTCMonth();
var zzD =b.getUTCDate();
var zzY = b.getUTCFullYear();
var zzM = b.getUTCMonth();
<?php
$host='localhost';
$username='root';
$password='';
$conn=mysqli_connect($host,$username,$password,"student");
if(!$conn){
die('Could not Connect My Sql:' .mysql_error());
}
$result = mysqli_query($conn,"SELECT * FROM book_date");
$i=0;
while($row = mysqli_fetch_array($result)) {
?>
if(zzM==<?php echo $row["mm"]-1;?> && zzD==<?php echo $row["dd"];?> && zzY==<?php echo $row["yyyy"];?>) {c.push("busy");}
<?php
$i++;
}
?>
if(zzM==2 && zzD==11) c.push("free");
g = new Date;
return b.getUTCFullYear() < d || b.getUTCFullYear() === d && b.getUTCMonth() < f ? c.push("old") :
(b.getUTCFullYear() > d || b.getUTCFullYear() === d && b.getUTCMonth() > f) && c.push("new"),
this.focusDate && b.valueOf() === this.focusDate.valueOf() && c.push("focused"), this.o.todayHighlight
&& b.getUTCFullYear() === g.getFullYear() && b.getUTCMonth() === g.getMonth() && b.getUTCDate()
=== g.getDate() && c.push("today"), -1 !== this.dates.contains(b) && c.push("active"),
(b.valueOf() < this.o.startDate || b.valueOf() > this.o.endDate || -1 !== a.inArray(b.getUTCDay(),
this.o.daysOfWeekDisabled)) && c.push("disabled"), this.o.datesDisabled.length > 0 &&
a.grep(this.o.datesDisabled, function(a) {
return e(b, a)
}).length > 0 && c.push("disabled", "disabled-date"), this.range && (b > this.range[0] && b <
this.range[this.range.length - 1] && c.push("range"), -1 !== a.inArray(b.valueOf(), this.range) &&
c.push("selected")), c
}

Now run the index.php file.



Buy Template