complete basic submit form, mysql query and generate results
$10-30 USD
In Progress
Posted over 7 years ago
$10-30 USD
Paid on delivery
Hi Everyone,
I will only award this project to someone whom has clearly read and understand my requirements.
I need a basic php code to query a date range in one field in a table and show grouped results and totals.
Sample table and date
id, Reg, Date, Type, Amount
1001027, 1 2015-09-30 gold 20.0
1001028 2 2016-09-15 gold 19.99
1001029 3 2016-09-16 bronze 15.99
1001030 2 2016-09-16 silver 14.99
I will expect to get the following result
1. All records between the date range, Grouped by Reg
2. Showing Amount total per group
3. Showing Amount Total across date search
For example, based on the dates 09/01/2016 and 09/18/2016
Reg, Date, Type, Amount
2 2016-09-15 gold 19.99
2 2016-09-16 silver 14.99
Total £34.98
3 2016-09-16 bronze 15.99
Total £15.99
Results Total £50.97
There is an excellent datepicker script to download [login to view URL]
Happy Bidding
Although I am brand new to Freelancer, I have been developing with PHP for ten years. I have looked at your example table and I know I can easily get this form with the three different functions (All records for date range, Amount total per group, and Amount total overall) set up for you within a day. I am even more motivated to do this project fast and right for you, because as a new Freelancer.com member, a positive review is very important to me to get my reputation on this site started.
Thank you for your consideration.
Sincerely,
Ian Rose
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
11 freelancers are bidding on average $45 USD for this job
Hi there,
I am a professional Graphic Designer & wordpress expert with 2+ years experience.
I am also a Student of Software Engineering in Pakistan.
I have read and understand your project Description.
I can make complex SQL complex Queries to insert, fetch, delete and update data from your database.
previous work : Found errors in query
select *, count(distinct vi.views_id) as ViewCount from campaigns cam left join views vi ON vi.views_campaign_id = cam.campaigns_id left join rates ra on
ra.rates_id = cam.campaigns_rates_id where cam.campaigns_budget_used_today < cam.campaigns_daily_budget and cam.campaigns_current_budget > 0
and cam.campaigns_approved = 1 and cam.campaigns_status = 0 and cam.campaigns_payment_accepted = 1 and cam.campaigns_device = 1
or cam.campaigns_device = 0 and ra.rates_location IS NULL group by cam.campaigns_daily_budget having
ViewCount <= cam.campaigns_ordered_views * 1000 order by cam.campaigns_daily_budget asc
If you want to see more sample or past work please inbox me.
Please inbox me if you are willing to work with me.
Waiting for your response.
Thanks
Kind Regards
Rehan828
Hello,
I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development. i have recently also earned my preferred freelancer badge. I have been working in the field of web development for roughly 7 years. I take great pride in my work and deliver only the best quality.
My skill-set includes...
-PHP
-HTML5
-CSS
-AJAX
-Responsive Design
-Joomla
-Wordpress
-Magento
-Drupal
-Photoshop
-Illustrator
-Video Editing
-Data entry
-Iphone
-Android
I look forward to hearing from you and hopefully we will have the opportunity to work together.
Thank you,
Coasif
Let's start! I understand what you need and you will have a 100% complete job on time.
I can assure you that if you work with me once, you will always work with me for these kind of projects.
I have already worked on databases and your project seems easy but I got couple of questions to clear before we proceed further. Kindly knock me to have a quick chat.
Thanks!!