How to fetch google my business reviews to my website?

|
Alone_Surviour94 2021-05-08 16:09:03
I am trying to show below table using php and mysqli. I want to achieve like below.

1. Get the R,S,T values of all parameters(from A to K) for three days(6th, 7th and 8th may).

2. Merge them and show it as one single table(similar to a data dashboard)

3. When date changes(say to tomorow), the dashboard should display 7th, 8th and 9th may.

However, i am able to change the dates but not the data(colored cells) associated with that dates…

Please see the table created in excel for better understanding..

Alone_Surviour94 2021-05-08 16:09:10
Using php
RichardMuvirimi 2021-05-08 16:33:17
Alone_Surviour94 2021-05-08 16:09:03
Today the dashboard has three days data (6th, 7th and 8th),

Excel and mysql. 🙅‍♂

No relation whatsoever.

Makes it more difficult to understand what you want to achieve.

But guessing that you just want to display as html. Get the data in three separate requests and position the data using css.

Alone_Surviour94 2021-05-08 16:38:05
RichardMuvirimi 2021-05-08 16:33:17
Excel and mysql. 🙅‍♂

No relation whatsoever.

Makes it more difficult to understand what you want to achieve.

But guessing that you just want to display as html. Get the data in three separate requests and position the data using css.

Let me explain you with an example
Need to fetch and display 3 days data, days should be day before yesterday, yesterday and today(6th, 7th and 8th)..
For 6th, the table cells are in green, for 7th, it is in amber and for 8th thr color code is red…

Now, when date changes to tomorrow, the 3 days should be 7th, 8th and 9th.. and along with that the color code will also move just like date(6th will be vanished, 7th will occupy 6th position and shows amber, 8th will occupy 7th position and display red color, and 9th date, will be empty..)

Alone_Surviour94 2021-05-08 16:38:45
Now plse tell me how i can achieve it
Alone_Surviour94 2021-05-08 16:38:52
With help of php
RichardMuvirimi 2021-05-08 16:55:19
The best way to approach a programming task is to break it down into smaller parts (functions/methods) different but working towards the same goal. Data structures and algorithm lessons might help.

Now onto what you want

You need a reference date (say today) that all segments will reference (best would be unix as it will be an int)

Saying you actually use mysql dates there is the BETWEEN key word that you can also use to search between start and end of day or simply if there is no time get the data for specified date directly

For each segment you increase the offset by a day if using date or equivalent in unix

Now once you have the data with appropriate functions/methods you should be able to change the date and get the data for the three different dates

Create a new php file somewhere and build the steps one by one and copy into your code.

I cannot write the code as i do not know the structure of you data or the frameworks you are using (that’s if)

RichardMuvirimi 2021-05-08 17:00:59
There are many ways to do this. All you have to do is layout a path to achieve what you want. I usually open a blank file and write pseudo code with all the feasible routes to achieve whatever i want to do, then start coding following that otherwise trying to solve it in one go you might end up going in circles always refactoring the code
2021-05-08 17:18:39
Any Simple php projects DM me

Big Projects will get 80% discount on Hosting

ipsita11 2021-05-08 18:43:26
nextElementSibling can’t be access by classname of an element??
2021-05-08 19:01:52
DM If you want to develop website or android app or college assignment or project We will do in cheapest price
Pame 2021-05-08 21:27:39
Thank you Rose this has been helpful
rohit267 2021-05-08 21:52:22
2021-05-08 19:01:52
DM If you want to develop website or android app or college assignment or project We will do in cheapest price

/warn No personal ads until asked

Acird Burn 2021-05-08 23:07:52
anyone here that has worked with Asana that can help with setting up a couple of Boards and Bots ?
rlgrlg 2021-05-09 05:45:49
2021-05-08 13:06:21
I’m Website developer and android developer dm if you want to develop

Ok

rlgrlg 2021-05-09 05:46:12
How much
maachittibabu 2021-05-09 05:46:57
luv_php-31961.jpg
https://zoom.us/j/94995927307
2021-05-09 05:47:00
rlgrlg 2021-05-09 05:46:12
How much

According to your requirements

rlgrlg 2021-05-09 05:48:49
2021-05-09 05:47:00
According to your requirements

For static website 4-5 pages

2021-05-09 05:49:10
rlgrlg 2021-05-09 05:48:49
For static website 4-5 pages

Only 2k-3k

rlgrlg 2021-05-09 05:49:20
2021-05-09 05:49:10
Only 2k-3k

Ok thanks

2021-05-09 10:25:38
2021-05-08 13:06:21
I’m Website developer and android developer dm if you want to develop

Yes

cyberlika 2021-05-09 10:56:08
I need php developer
cyberlika 2021-05-09 10:56:39
Who can build php script of group buy seo tool ahref nd semrush like tools
2021-05-09 10:57:22
Need help in php telegram bot please dm me
Var1002 2021-05-09 12:04:18
Hi… I need php developer…
faisalamin001 2021-05-09 12:12:45
Var1002 2021-05-09 12:04:18
Hi… I need php developer…

yes

Ravi Bagariya 2021-05-09 12:16:23
luv_php-31980.jpg
How to manage user wise Working hours should manage Whole day how many hours u work in laravel anyone’s one how write code this purpose
mahesh14300 2021-05-09 19:17:51
How do i check if a Youtube Channel is currently streaming live or not Using PHP or Javascript
For example i have Channel id of 10 channels
I have to check which which channels are currently streaming live right now
Does any one have the code
Plz help
Thanks in Advance
2021-05-09 19:26:54
mahesh14300 2021-05-09 19:17:51
How do i check if a Youtube Channel is currently streaming live or not Using PHP or Javascript
For example i have Channel id of 10 channels
I have to check which which channels are currently streaming live right now
Does any one have the code
Plz help
Thanks in Advance

Read YouTube docs

2021-05-10 06:00:05
Looking for codeigniter developer
maachittibabu 2021-05-10 09:07:51
luv_php-31996.jpg

maachittibabu 2021-05-10 09:08:12
Register for Free Demo: http://bit.ly/UIWeb
. 2021-05-10 11:19:17
How to fetch google my business reviews to my website? pls help
sathishkumar1 2021-05-10 11:27:03
auto generate table of content php code?? please anyone knows reply me!
|