PHP Script To Insert Data Into MYSQL Database

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. <?php //connect to mysql db $con = mysql_connect("myip","user","pw") or die('Could not connect: ' . mysql_error()); //connect to the employee database mysql_select_db("dbname", $con); //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) VALUES('$id', '$name')"; if(!mysql_query($sql,$con)) { die('Error : ' . mysql_error()); } ?>