} $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();