HotelDruid

hello,

in the case you have already a client database builded from another booking form. i want to insert those client data in php-residence. everything seems fine but i don't get the date format. my check-in and check-our date are in mysql format 0000-00-00. should i use php on the fly to translate the dates in numbers of days since the begining of each year?

thanks for your help

Are you trying to insert them directly in the database? For dates in reservations table (prenota200X) there is an id that refers to the periods table (periodi200X).

Marco

is to take another database with a different structure and update the php-residence one with the past datas: name, check-in date, check-out date, room number. i've figured out the most of it but not how how i can integrate the rate associated for each day. i saw in your structure that you repeat the rate according to the number of day your client will stay so if i create a script to transfert all the datas from my old database i have to find out how i can do that...

For the prenota200X table:
The rates for each period, separated by commas, are stored in "tariffesettimanali". Their sum is stored in "tariffa", separated from the rate name by symbols #@&. The entire rate (including extra costs, discounts, etc.) is stored in "tariffa_tot".

Marco

you are a great help