/**
* Criação de dispositivo
*/
function createDevice()
{
global $log;
$device = null;
$app = Slim::getInstance();
try {
$input = json_decode($app->request()->getBody());
$log->Debug(sprintf("api - createDevice - %s", print_r($input, true)));
$device = getDevice($input);
} catch (Exception $e) {
badRequest($e, $log);
return;
}
try {
$deviceCreated = DeviceManager::insertDevice($device);
if ($deviceCreated) {
created("Dispositivo criado com sucesso.");
} else {
conflict("O dispositivo já está cadastrado", $log);
}
} catch (Exception $e) {
internalServerError($e, $log);
}
}
} else {
echo 'SQL/PHP Connection: Successful <br><br>';
}
//STORES UIDS INTO PHP ARRAY
$sql = "SELECT uid FROM users";
$result = mysqli_query($link, $sql);
$uid_array = array();
while ($row = mysqli_fetch_assoc($result)) {
//stores UID in UID_ARRAY
array_push($uid_array, $row['uid']);
}
$length = count($uid_array);
//UPDATES DATA TO mySQL DATABASE
foreach ($uid_array as $array_index => $uid) {
$pass = pass_gen();
$created = created();
$email = email_gen();
$fname = fname_gen();
$lname = lname_gen();
$rnc = real_name_created();
if ($array_index == 0) {
$sql = "UPDATE users SET pass='******', created='" . $created . "', mail='" . $email . "', fname='" . $fname . "', lname='" . $lname . "', real_name_created='" . $rnc . "' WHERE uid ='" . $uid . "';";
} else {
$sql .= "UPDATE users SET pass='******', created='" . $created . "', mail='" . $email . "', fname='" . $fname . "', \n\t\t\t\t\tlname='" . $lname . "', real_name_created='" . $rnc . "' WHERE uid ='" . $uid . "';";
}
}
unset($uid, $array_index);
//CONFIRMS SQL/PHP CONNECTION
if (mysqli_query($link, $sql)) {
echo "Record updated successfully";
} else {
