matthewdacruz
asked on
Need help with inserting records from json array - SEMRUSH api response
Hi Guys
I'm trying to get a an api response from semrush to insert into a mysql database when the record is called.
For some reason I cannot figure out what it is not inserting.
The output from semrush api is this.
Array
(
[0] => Array
(
[domain] => digitalmarketer.com
[rank] => 70337
[organic_keywords] => 36220
[organic_traffic] => 23685
[organic_cost] => 161371
[adwords_keywords] => 613
[adwords_traffic] => 713
[adwords_cost] => 5735
)
)
Could you look at the insert script and see what I have done wrong
Thanks
I'm trying to get a an api response from semrush to insert into a mysql database when the record is called.
For some reason I cannot figure out what it is not inserting.
The output from semrush api is this.
Array
(
[0] => Array
(
[domain] => digitalmarketer.com
[rank] => 70337
[organic_keywords] => 36220
[organic_traffic] => 23685
[organic_cost] => 161371
[adwords_keywords] => 613
[adwords_traffic] => 713
[adwords_cost] => 5735
)
)
Could you look at the insert script and see what I have done wrong
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER