August 18th, 2011, 03:31 AM
Hello every body here
I am about to design Limo booking system, similar to that in this site: execucar dot com
could any one here please give me an idea about the database table design similar to that.
I will include only 2 airport in my database, so far I have the price table according to zip code for one state, I will work in one state. I will integrate the whole thing with online payment.
I will use Mysql and PHP for this site
I appreciate any help or idea of the database table and relation.
August 19th, 2011, 03:33 AM
I have created the following table could you please correct me and establish the relationship.
3- client Table
4- flight Table
August 20th, 2011, 03:27 AM
August 20th, 2011, 03:41 AM
you are right vuxi the design is nice, but in my opinion the reservation form is very simple, and its not interactive, because the user will get the information by email. and
I am expecting my design to interact with the user, so he can get the price directly online and make the payment online. I am working in that, but I need some help.
August 20th, 2011, 04:15 AM
I agree with you, the previous site has done that part better. that I am a user, I would like to have as the previous site to choose from the drop-down menu service, that there are several species and not overcrowded, and it is essential that all of this is that there are no broken links and other vulnerabilities. and when to make a count on that later you can easily daodati, modify, remove the service, link ....
August 23rd, 2011, 11:27 PM
I am still need help in this issue.
I am using session to pass data from one form to another form (Multi page form). the next page I need the user to select the zip code from drop down list, I need to check his selection with the my table in the database based on the selection and variable stored in session, so far I have this code:
$resultid=mysql_query("SELECT zipcode,airport,price FROM price WHERE zipcode='$zipcode' AND airport != ' " .$_SESSION['airport'] ."' ; ", $linkid);