Count the values for today and yesterday in PHP

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

I am looking for a freelancer who are expert in coding PHP and mysql. I need some help with my PHP as I want to fetch the data from mysql database and count how many contacts I have today and yesterday for each different campaign. And also I want you to count the values in the total for today and yesterday as well. When you are done, please send me the screenshot so I will take a look. The reason I am asking you to do this is because the last time I hired a freelancer he didn't complete as my requirement. If you can complete my requirement for $20 that will be great. Thank you for your interest.

HTML MySQL PHP

ID Проекту: #18652167

Про проект

15 заявок(-ки) Дистанційний проект Остання активність 5 роки(ів) тому

Доручено:

irvingdev14

Hi I can do what you need in a few mins but want to make sure first, do you have a lot of freelancers right now working on the demo?

$20 USD за 1 день
(41 відгуків(-и))
5.7

15 фрілансерів(-и) готові виконати цю роботу у середньому за $23

shihan033010

Hi can you please send me the sql file with data. I will show you demo through my server. after your satisfaction we can proceed.

$20 USD за 1 день
(319 відгуків(и))
6.8
ludwig333

Hi. I am a full stack developer and have been working for over 5 years on the freelancer.com. I have read your description in detail and have interests in your project. I have some experiences that have ever done Більше

$30 USD за 1 день
(62 відгуків(и))
6.2
ramtricky

Dear Hiring Manager, I have read your full project description. I am interested in collaborating with you. All programmers are not the same ,I have 6 years of experience in building websites. I’m very competent Більше

$50 USD за 1 день
(33 відгуків(и))
5.1
SwapnilChouhan

Hi, I am expert PHP developer. I can develop PHP code exactly as you want. I am ready in 20$. And will send you screenshot first Please send me a message so that we can discuss more, Thanks, Swapnil Більше

$20 USD за 1 день
(32 відгуків(и))
5.1
gogabidzi1

Hi, simple query: SELECT COUNT(*) FROM contacts WHERE campaign_id = ?? AND DATE > YESTERDAY_START AND DATE < TODAY START. Second query is almost the same but we need to select SUM(column) instead of COUNT() Se Більше

$20 USD за 1 день
(23 відгуків(и))
5.0
nadeemgorsi

Hi, there, Pls, ping me if you want me to open up the zip file and start the work. clarify your requirements and get the quality work done. Thank You :)

$30 USD за 1 день
(16 відгуків(и))
3.8
vacikabre

Hi! I think you might be looking someone who is fluent in English and has the skills & time to do the job effectively and clean. I would refer myself as a person that owns the characteristics mentioned above and I Більше

$10 USD за 1 день
(2 відгуків(и))
1.1
elvislakota

have done it, please ping me and i will give you a link with the demo, the tables are a bit edited ..

$25 USD за 1 день
(2 відгуків(и))
1.2
johnfsemancik

As a web developer with experience working for various organizations, I have a firm grasp of PHP and MySQL (in fact, both of these were my first programming languages, when I began programming almost ten years ago). I Більше

$20 USD за 1 день
(0 відгуків(и))
0.0
boletagaming

hello, that's a simple SQL query, depending on your DB schema it could be a couple joins, a group by and a SUM aggregate function.

$25 USD за 1 день
(0 відгуків(и))
0.0
dsimek

Hi, Sorry if i am late but do you still need this done? I am half way done, just to collect it all in one query.

$10 USD за 1 день
(1 відгук)
0.0