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']);
