/** * 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 {