/** * Schreibe neue DB-Einträge. * * @param $jsonData * @param $db * @param $datum * * @return bool (true|false) */ function writeDB($jsonData, $db, $datum) { $checkCount = count($jsonData["podcasts"]) - 1; #echo '<pre>'; #var_dump( $jsonData ); #echo '</pre>'; //Prüfe ob DB vorhanden und einen Eintrag hat. $newEntrysInDB = testDB($db, $checkCount); #var_dump( $newEntrysInDB ); if ($newEntrysInDB == false) { $i = 0; // Lese Json aus und trage sie in DB ein. while ($i <= count($jsonData["podcasts"]) - 1) { $db->exec("INSERT INTO new\n ('podcast','slug','url','nodetime', 'podbetime', 'ok')\n VALUES\n ( '" . $jsonData["podcasts"][$i]["name"] . "',\n '" . $jsonData["podcasts"][$i]["slug"] . "',\n '" . $jsonData["podcasts"][$i]["url"] . "',\n '" . $datum . "',\n '" . $jsonData["podcasts"][$i]["time"] . "',\n 'i.A.'\n )"); $i++; } $out = true; } else { $out = false; } return $out; }
<?php include "init.php"; ?> <html> <head> <title>Roexian's projects page</title> </head> <body> <div> My page is dedicated to the learning and understanding of web programming and other ideas. In the future I hope let this serve as a blog and a repository of accumulated knowledge. <br /> <br /> <?php testDB(); ?> </div> </body> </html>