Thread: Booking system

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    7
    Rep Power
    0

    Booking system


    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.

    Regards
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    7
    Rep Power
    0
    Hi,
    I have created the following table could you please correct me and establish the relationship.
    1-booking table
    Id
    zip
    Adults
    Children
    Triptype
    Airport
    clientid
    2-price table
    zip
    airport
    price
    3- client Table
    clientid
    FirstName
    LastName
    Address
    City
    State
    Tel
    Email
    Cardno
    expiredate
    Specialinstructor

    4- flight Table
    Date
    Time
    Airline
    Flightno
    Flighttype
    clientid

    Regards
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2011
    Location
    New York
    Posts
    105
    Rep Power
    0
    I like this design

    link
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    7
    Rep Power
    0
    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.

    Regards
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2011
    Location
    New York
    Posts
    105
    Rep Power
    0
    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 ....
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    7
    Rep Power
    0
    hi,
    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:

    PHP Code:
    $resultid=mysql_query("SELECT zipcode,airport,price FROM price WHERE zipcode='$zipcode' AND airport != ' " .$_SESSION['airport'] ."' ; "$linkid); 
    Thank you

IMN logo majestic logo threadwatch logo seochat tools logo