You are not logged in.
I am creating a site where the cost of the service is calculated prior to booking.
Regardless of service, the cost will always be carried through via a cookie.
EITHER
Where can I read the cookie and change the default service cost to the contents of the cookie?
OR
How do I change the service cost in the database just prior to running the Booking s/w?
Thank you
Jan
Offline
Sorry for not making it clearer!
Whatever the service cost is set to, say 99.99
When a site visitor has been quizzed over other details PRIOR to entering the booking system - the cost of service will be different (calculated on the fly depending on specific requirements)
So, can that data replace the original 99.99 throughout the booking system?
OR
What code (php) would I need to use to change the cost (of all services available to the same figure) in the database JUST PRIOR to running the booking system?
Hope that makes sense!!! :-)
Jan
Offline
Wish I'd put it like that!!!!!!!!!!!!
Yep, that wot I mean :-)
Offline
:-)
I see. I'm sorry, I don't see any way to implement this at the moment.
We have planned to introduce some sort of coupon/discounts feature. There will be 2 options:
- on checkout, a client will enter a coupon code and will get a discount for the total order price
- there will be groups of users, and for some group there will be a 10% discount for example
Will it resolve your requirements?
Offline
Unfortunately no!
Is there any way of searching the database for, for example, every occurance of 99.99 (or other unique identifier) and change them all to a new number?
Or is there a way of changing all cost fields (by name/tag) to a specific value?
I know you can access mysql databases via php script but I don't know the syntax and more to the point whats possible.
Help, please...
Jan
Offline
hmm
ok, why do we need to change the database? we can see the price of a service when showing a page for the client. If the price is 99.99, then set it to 89.99 for this client. For another client you can set it to 74.95 for example. Nevertheless, it will still be 99.99 in the database.
Is it what you are looking for?
Offline