Member Avatar for Goddy_1

Customers pick When finished If on the book, such as the selection of Van Dyke VT01 from 1/07/59 - 2/07/59-day period, you will not be able to book your car again. It is based on the availability of the vehicle.

I made a separate table Storage booking Van table separately too.

Tables, storage, booked by id_car I take from the table and put the van.

https://s32.postimg.org/lqrclkbl1/image.png

Table of van

https://s31.postimg.org/pb8zg7pwb/Untitled.png

This is the code that I defined it booked only three people per day.

$date = "$rn_gostart"; //กำหนดค้นวันที่  

$result = mysqli_query($mysqli,"select * from vn_rent where rn_gostart = '$date'");  
$ckd = mysqli_num_rows($result);  

if($ckd >= 3){  

$msg = "<div class='alert alert-danger'>  
<span class='glyphicon glyphicon-info-sign'></span> &nbsp; วันที่จองเต็มแล้ว  
</div>";  
}else{

Sorry I am not good at English Please help me

  • 2 Contributors
  • 1 Reply
  • 172 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for cereal

Hi!

Your thread is marked solved, did you actually solved the issue? Do you care to share your solutions for the readers? Last question: are these 1/07/59 - 2/07/59 Thai calendar dates?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.