}
$education = new DB\SQL\Mapper($db, 'education');
$education->username = $username;
$education->passout = $passout;
$education->course = $course;
$education->university = $university;
$education->save();
$work = new DB\SQL\Mapper($db, 'work');
$work->user_name = $username;
$work->area = $area;
$work->company = $company;
$work->designation = $designation;
$work->save();
$response['status'] = 200;
$response['message'] = 'Successfully registered user';
$response['data'] = $user->cast();
unset($response['data']['password']);
echo json_encode($response);
return;
} catch (Exception $e) {
$elog->write($e->getMessage());
$elog->write($e->getTraceAsString());
$response['status'] = 500;
$response['message'] = 'Internal server error';
echo json_encode($response);
return;
}
});
$f3->route('POST /updateProfile', function ($f3) {
$elog = new Log('logs/' . date('Y-m-d') . '_err.log');
$ilog = new Log('logs/' . date('Y-m-d') . '_info.log');
$row = array('id' => $id, 'randomNumber' => $db->exec('SELECT randomNumber FROM World WHERE id = ?', $id, 0, false));
$rnu = mt_rand(1, 10000);
$row['randomNumber'] = $rnu;
$db->exec('UPDATE World SET randomNumber = :ranNum WHERE id = :id', array(':ranNum' => $rnu, ':id' => $id), 0, false);
$result[] = $row;
}
header("Content-type: application/json");
echo json_encode($result);
});
$f3->route(array('GET /update-orm', 'GET /update-orm/@queries'), function ($f3, $params) {
/** @var Base $f3 */
$queries = 1;
if (isset($params['queries'])) {
$queries = (int) $params['queries'];
$queries = $queries < 1 ? 1 : ($queries > 500 ? 500 : $queries);
}
$dbc = $f3->get('DBS');
$db = new \DB\SQL($dbc[0], $dbc[1], $dbc[2], array(\PDO::ATTR_PERSISTENT => TRUE));
$world = new \DB\SQL\Mapper($db, 'World');
$result = array();
for ($i = 0; $i < $queries; $i++) {
$id = mt_rand(1, 10000);
$world->load(array('id = ?', $id));
$world->randomNumber = mt_rand(1, 10000);
$world->save();
$result[] = $world->cast();
}
header("Content-type: application/json");
echo json_encode($result);
});
$f3->run();
