I want a php script that automatically adds data to my database from an api response (I already set the api response up)
here is what I currently have...
I basically just need it to automatically add data to database.
//connect to mysql db
$con = mysql_connect("myip","user","pw") or die('Could not connect: ' . mysql_error());
//connect to the employee database
//read the json file contents
$data = file_get_contents('http://urloffileconents/');
//convert json object to php associative array
//$data = json_decode($jsondata, true);
//get the employee details
$id = $data['customColumns']['totals'];
$name = $data['advertiserCost'];
$sql = "INSERT INTO db(another, one)
die('Error : ' . mysql_error());
35 freelancers are bidding on average $29/hour for this job
I can create php script to insert data into mysql database from API response. I will complete this work in next few hours. Looking for your reply to start this work immediately.
Hi I can modify your script right now to add data to database . I will need database connection information , access to database. Allow me to handle this for you.
Dear Hiring Manager, How are you? I am able to do this work. I have more than 3 years of experience in PHP,MySQL. I am ready to start right now. Thank you. Regards, Keval Thacker