return;
} else {
if ($androidVersion == '' && !ctype_alnum($androidVersion)) {
showError(ERROR_MISSING_ANDROID_VERSION);
return;
} else {
if ($screenSize == '' && !ctype_alnum($screenSize)) {
showError(ERROR_MISSING_SCREEN_SIZE);
return;
} else {
if ($price == '' && !ctype_alnum($price)) {
showError(ERROR_MISSING_PRICE);
return;
}
}
}
}
}
}
if ($isModification) {
$db->exec(sprintf('UPDATE phone SET name=%s,manufacturer=%s,androidVersion=%s,screenSize=%s,price=%s WHERE id=\'%s\'', protectFields($name, $db), protectFields($manufacturer, $db), protectFields($androidVersion, $db), protectFields($screenSize, $db), protectFields($price, $db), $phoneId));
} else {
$db->exec(sprintf('INSERT INTO phone(userId,name,manufacturer,androidVersion,screenSize,price) VALUES (\'%s\',%s,%s,%s,%s,%s)', $userRow['id'], protectFields($name, $db), protectFields($manufacturer, $db), protectFields($androidVersion, $db), protectFields($screenSize, $db), protectFields($price, $db)));
$phoneId = $db->lastInsertId();
}
$phone = array('phone' => array('id' => $phoneId, 'name' => $name, 'manufacturer' => $manufacturer, 'androidVersion' => $androidVersion, 'screenSize' => $screenSize, 'price' => $price));
header('Content-type: application/json;charset=utf-8');
echo json_encode($phone);
} catch (Exception $e) {
showErrorMessage('Erreur : ' . $e->getMessage());
}
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$db = new PDO(DATABASE_INFO, DATABASE_LOGIN, DATABASE_PASSWORD, $pdo_options);
// Get the user from the WS
$response = $db->query(sprintf('SELECT id FROM user WHERE udid = %s', protectFields($userUdid, $db)));
$userRow = $response->fetch();
if ($userRow == null || count($userRow) == 0) {
// There is no user matching this userId
// return an error
showError(ERROR_UNKNOWN_USER);
return;
}
$ids = isset($_GET['ids']) ? $_GET['ids'] : '';
$idArray = explode(',', $ids);
$idArrayCount = count($idArray);
for ($i = 0; $i < $idArrayCount; $i++) {
$response = $db->query(sprintf('SELECT * FROM phone WHERE id = %s and userId = \'%s\'', protectFields($idArray[$i], $db), $userRow['id']));
$phoneRow = $response->fetch();
if ($phoneRow == null || count($phoneRow) == 0) {
// There is no user matching this phoneId
// return an error
showError(ERROR_UNKNOWN_PHONE);
return;
}
}
$db->exec(sprintf('DELETE FROM phone WHERE id IN (%s)', "'" . implode("','", $idArray) . "'"));
$phones = array('phones' => array('phone' => array()));
for ($i = 0; $i < $idArrayCount; $i++) {
array_push($phones['phones']['phone'], array('id' => $idArray[$i]));
}
header('Content-type: application/json;charset=utf-8');
echo json_encode($phones);