We have a database which our users when they make a booking their info is inserted there, and we need to create an PHP result page with three TABS as follow:
1-When we run the page, it should go to the first tab through the data base (MySQL database) and select all users who did have one or more appointments and spend more than 200€ during that month ( first name, last name, phone, email, appointments date from, appointments date to, total amount spend during that period. Also, ideally if possible, to run this page each Saturday night and send the result by email to an email address.
2-The second TAB on top of the page will do like point 1, but to show if any customer spends more than 500€ during that month and as point 1, to run this page each Saturday night and send the result by email to an email address.
3-Our database has a few tables and all these information’s are gathered in these tables. This result page should be accessed by a secure crypted username/password.
4-A third TAB, here we will put the first name, last name and email addresses and it should show the list of all appointments of that customer appointments (date of each appointment and the price of that appointment).
We can provide you our MYSQL database backup and the Generated page should be very clean and used pastel colors for background, buttons and the select areas, Tabs.
28 freelancers are bidding on average €165 for this job
Hi. I understand that you have booking type database and ned generate some tabs interface with result reports. I have stong experience with MySql and booking schemes.
Hi, I am a web developer https://www.freelancer.com/u/unix515 Also I have rich experience web design. I am clear your all requirement. I can start work right now. Thanks