<?php //set up the database connection $servername = "192.129.1.209"; $username = "meaadmin"; $password = "Kasten_15&"; $dbname = "typo3mea"; $conn = mysql_connect($servername, $username, $password); mysql_select_db($dbname); echo "connected successfully" . '<br>'; //read the json file content $jsondata = file_get_contents('http://127.0.0.1:8000/api/thesis/?format=json'); //convert json object to php array $data = json_decode($jsondata); //var_dump($data); //get the thesis details //$id = $data['id']; //$author = $data['author']; //$type = $data['type']; //$title = $data['title']; //$year = $data['year']; //insert into mysql table foreach($data -> title as $title) { $sql = "INSERT INTO mea_thesis(title) VALUES('$title')"; } //debug if(!mysql_query($sql,$conn)) { die('Error : '.mysql_error()); } //database connection close mysql_close($conn); echo "Hello Munir :D"; //print $data["objects"]; //echo $data; ?>
You have javascript disabled. You will not be able to edit any code.