@ 2015-09-07T07:18:18Z <<?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, true);
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 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;
?>
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 7.0.0 - 7.0.33 , 7.1.0 - 7.1.33 , 7.2.0 - 7.2.33 , 7.3.0 - 7.3.33 , 7.4.0 - 7.4.33 , 8.0.0 - 8.0.30 , 8.1.0 - 8.1.28 , 8.2.0 - 8.2.18 , 8.3.0 - 8.3.6 <
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /in/jKAqL:7
Stack trace:
#0 {main}
thrown in /in/jKAqL on line 7
Process exited with code 255 . Output for 5.4.0 - 5.4.45 , 5.5.0 - 5.5.38 , 5.6.0 - 5.6.40 <
Fatal error: Call to undefined function mysql_connect() in /in/jKAqL on line 7
Process exited with code 255 . preferences:dark mode live preview
264.33 ms | 402 KiB | 376 Q