function generateDB() { R::exec('DROP TABLE category'); R::exec('DROP TABLE item'); R::exec('DROP TABLE shop'); require __DIR__ . '/../utility/insert-categories.php'; $storeData = json_decode(file_get_contents(__DIR__ . '/../data/stores.json'), true); $categories = R::findAll("category"); foreach ($storeData as $store) { $store['_type'] = 'shop'; $storeBean = R::dispense($store); R::store($storeBean); } if ($handle = opendir(__DIR__ . '/../data/items/')) { while (false !== ($entry = readdir($handle))) { if ($entry != "." && $entry != "..") { addItemToDB($entry, $categories); } } closedir($handle); } }
<?php include '__database.php'; include '__functions.php'; error_reporting(E_ERROR | E_WARNING | E_PARSE); if ($_POST['type'] == 'make_post') { // return, array with vars text with text, action with action item to do $name = trim($_POST['name']); $description = trim($_POST['description']); $price = floatval(trim($_POST['price'])); $seller = trim($_POST['seller']); if ($name == '') { echo json_encode(array("text" => 'You need to specify a name', 'action' => 'alert')); } if ($description == '') { return echoJSON(array("text" => 'You need a description', 'action' => 'alert')); } $added = addItemToDB($name, $description, $price, '', $seller, null); return echoJSON(array("text" => "Added your item (" . $name . ")!", 'action' => '/item.php?id=' . $added[0]['id'] . '&newlycreated=true')); } function echoJSON($arr) { echo json_encode($arr); }