@ 2015-09-07T08:48:22Z <?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);
//insert into mysql table
foreach($data -> title as $title)
{
$sql = "INSERT INTO mea_thesis(title)
VALUES('$title')";
}
//debug
echo 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/7tUlZ:7
Stack trace:
#0 {main}
thrown in /in/7tUlZ 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/7tUlZ on line 7
Process exited with code 255 . preferences:dark mode live preview
332.7 ms | 402 KiB | 376 Q