Completed

Mysql / PHP result page request

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.

Skills: MySQL, PHP, HTML5

See more: php mysql query, mysql_query(insert), php code to retrieve data from mysql database and display, how to fetch data from database in php using mysqli, select query in php mysql with example, how to fetch data from database in php and display in html table, how to retrieve data from database in php using mysql, select query in php with where clause, submit hours mysql php result, php mysql script landing page generator, php mysql user registration page, drag drop php arrange page mysql, php mysql navigate multi page, mysql php show page views, mysql php web page entry, php mysql slideshow admin page, php mysql show table page, php mysql profile entries page, php mysql pictures per page, mysql php login page

About the Employer:
( 1 review ) BRUXELLES, Belgium

Project ID: #24522858

Awarded to:

gutibs

Hello, i can have it done in less than 48 hours, will need cpanel access to your server or a copy of your database. Thanks!

€200 EUR in 2 days
(146 Reviews)
7.1

28 freelancers are bidding on average €165 for this job

FASTGuru

Hi there! I am Muaaz, full stack web developer and I believe that I can complete this project perfectly as I am highly experienced in PHP, HTML5/CSS3/SCSS and MySQL. I would like to hear more details and discuss furth More

€200 EUR in 1 day
(221 Reviews)
8.0
coolguyinus2004

I can work on your site and finish this for the result page with each link for 3 options you asked me. Also for saturday email setup it should be different script which has run as cronjob and send csv file for all data More

€125 EUR in 1 day
(351 Reviews)
7.6
amranreza70

Hello there, I am a professional web developer and expert in PHP & MySQL. I can make your secure result page after successful operation. It will be great if we can arrange a privet chat on project further discussion & More

€150 EUR in 7 days
(152 Reviews)
6.9
AndrwProjects

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.

€125 EUR in 7 days
(303 Reviews)
7.1
mak94pk

Hi I’m Ashar from Maksof I am running a firm for the last 5 years. We are experts in developing websites , android and iOS apps . We can complete your project under the time period that we have decided in a chat. More

€200 EUR in 7 days
(99 Reviews)
6.9
mvaqasuddin

Hi there, I can develop using php pdo mysql database as per your logical conditions. could you please come over chat and lets discuss. thanks

€294 EUR in 4 days
(239 Reviews)
6.7
ineedWorkJob

Greetings sir, I have read your project details and i will develop the 3 page/tab reporting system for you with first 2 page sent as email on each Saturday. Sir, i can deliver this project sooner than you expect More

€300 EUR in 2 days
(127 Reviews)
6.6
atozweblogic

Dear Client. I have read description and very interested. I am a senior web developer working for 6+ years and my skills and experiences are perfectly fitted on this project. It is my pleasure to work with you, and I More

€140 EUR in 7 days
(91 Reviews)
6.3
unix515

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

€250 EUR in 7 days
(31 Reviews)
5.9
hassanmustafa01

Hey I am a Full stack developer with years of experience in PHP frameworks and have gone through your project details and understand them and willing to process the database table to show results like you wanted so fee More

€120 EUR in 3 days
(65 Reviews)
5.6
umairmalik10

Hi, I've read your points and understand the points your mentioned. I'll use an attractive theme for this, very neat code will be done for you and if you agree I can use a framework for better code and security. I've More

€200 EUR in 4 days
(48 Reviews)
5.3
josephscott0605

Dear client! I am a professional web developer and PHP/Mysql expert. I have checked your project description carefully so I understood all. Please send messages so that we can discuss more. I can do your project su More

€155 EUR in 3 days
(15 Reviews)
4.9
kirstarg

Hello! How are you? We have a few works like this. You can see our profile or ask me for show you some links of our work, all from my company (NexoSmart). I can show you my works and talk about everything. Our priorit More

€300 EUR in 1 day
(23 Reviews)
5.8
deividvasquez625

Hi I've read the specifications I am able to do it with PHP , Mysqli. I am full stack developer who have more than 8+ years of experience in web development. Core PHP HTML5/CSS3 Bootstrap/jQuery, all of them are my bas More

€100 EUR in 7 days
(35 Reviews)
5.1
romanzahidullin

Hello! Nice to meet you. I think I am a good fit for your project because I have skills for your project. I am a full-time freelancer and full stack developer. - Backend PHP (Laravel, Symfony, YII, CodeIgnitor) Pytho More

€200 EUR in 7 days
(6 Reviews)
4.6
gurpreet0173

Hello, Greetings of the Day. This is Gurpreet Singh.I have 6 year experience in development.I am expert in Laravel ,Codeigniter,PHP,Javascript,Jquery,AngualrJS,Vuejs,ReactJs, Mysql, HTML,CSS,Bootstrap.I develop respon More

€100 EUR in 2 days
(13 Reviews)
3.7
nemanjadj20

Hello? I have worked on LAMP STACK projects to what you are looking for, and I am confident I can exceed your expectations. Thank you for your time. I have attached samples of work very similar to what you are seeki More

€155 EUR in 3 days
(2 Reviews)
3.2
olegprokopiv39

I`ve read your job description very carefully. As a Php and mysql expert,I have 5+ years experience with Php and mysql. I have developed various kind of projects such as MES, eCommerce, social projects and yours with P More

€100 EUR in 2 days
(2 Reviews)
3.0
fugus

Greetings! My name is Christopher and I am an expert, full-stack developer. I have 10 years of experience in web design and development. I specialize in custom PHP, HTML, CSS and bootstrap development. I am readily ava More

€140 EUR in 3 days
(2 Reviews)
2.2
ThomasMomo

Hello, I read the job description carefully. 1. I will make the design by BootStrap. 2. I can make advanced and optimized the SQL query based on understanding the job descriptions. I fully understood the requirement More

€112 EUR in 2 days
(2 Reviews)
2.0