function updateDevelopers($data, $database) { //get developers FROM database try { $sql = 'SELECT * FROM developer'; $results = $database->query($sql); } catch (Expcetion $e) { echo $e->getMessage(); die; } //gets all developers in the database and stores in array $inDBDev[] = ""; foreach ($results as $developer) { $inDBDeveloper = $developer['developer_name']; if (!in_array($inDBDeveloper, $inDBDev)) { $inDBDev[] = $inDBDeveloper; } } //gets all developers in JSON and stores in array $inJSONDev[] = ""; foreach ($data['library'] as $game) { $inJSONDeveloper = $game['developer']; if (!in_array($inJSONDeveloper, $inJSONDev)) { $inJSONDev[] = $inJSONDeveloper; } } //Returns the array with developers not in the database but in JSON file $updatedDevs = array_diff($inJSONDev, $inDBDev); //Adds updated developers to database; foreach ($updatedDevs as $newDev) { addDeveloper($newDev, $database); } }
require_once 'config.php'; //if(isset($_POST['dispatcher'])) $action = $_POST['dispatcher']; switch ($action) { case 'login': $user_id = login($_POST['email'], $_POST['password'], $_POST['remember']); if ($user_id) { $responce['result'] = 'OK'; } else { $responce['result'] = ''; } echo json_encode($responce); break; case 'add-developer': require_once DIR_APP . 'users.php'; $id = addDeveloper($_POST); if (!empty($id)) { $responce['result'] = 'OK'; $responce['id'] = $id; } else { $responce['result'] = ''; } echo json_encode($responce); break; case 'rate-project': require_once DIR_APP . 'projects.php'; require_once DIR_APP . 'users.php'; $id = rateProject($_POST['project_id'], $_POST['user_id'], $_POST['value']); if ($id) { $project_title = getProjectTitle($_POST['project_id']); $sent_to = getProjectAuthor($_POST['project_id']);