public function listAction() { $db_params = get_db_params_from_config(); $db_conn = new DBConnection($db_params); $db_conn->connect(); $results = get_users($db_conn); return $this->render('TestCMSCMSBundle:Users:list.html.twig', array("results" => $results)); }
public function authenticateAction(Request $req) { $results = array("token" => "", "success" => "false", "message" => "", "error" => ""); if (0 === strpos($this->getRequest()->headers->get("Content-Type"), "application/json")) { $data = json_decode($this->getRequest()->getContent(), true); } else { $results["error"] .= "Wrong format received. "; } $email = filter_var($data["email"], FILTER_SANITIZE_EMAIL); $password_dec = filter_var($data["password"], FILTER_SANITIZE_SPECIAL_CHARS); $db_params = get_db_params_from_config(); $db_conn = new DBConnection($db_params); $db_conn->connect(); $res_arr = retrieve_password_fields($conn, $user_name); $enc_vals = get_enc_vals(); $enc_pw = encrypt($_SESSION["salt"], $password_dec, $_SESSION["iv"]); // Search database for user with matching encrypted password. // ... $response = new Response(json_encode($results)); $response->headers->set('Content-Type', 'application/json'); return $response; }
$user_strgs = array(); foreach ($json_obj->users as $user) { $user_strgs[] = sprintf("('%s', '%s', '%s', '%s', '%s', %d, '%s', '%s', \n'%s', '%s')", $user->first_name, $user->last_name, $user->email, $user->password_enc, $user->group_name, $user->active, $user->created_date, $user->updated_date, $user->facebook_id, $user->twitter_id); } $sql = sprintf($sql, join($user_strgs, ",")); $res = $db_conn->query($sql); } /** * Main flow of program. */ $web_data_dir = __DIR__ . "/../../../../../web/bundles/testcmscms/data"; $groups_data_fname = "groups_init.json"; $users_data_fname = "users_init.json"; //Try connecting to the database. $db_params = get_db_params_from_config(); $db_conn = new DBConnection($db_params); $db_conn->connect(); if (strlen($db_conn->get_error()) > 0) { echo "Error: " . $db_conn->get_error(); exit; } //Clear out any existing data. drop_all_tables($db_conn); //Create the tables in the database. $error_msg = create_all_tables($db_conn); if (strlen($error_msg) > 0) { echo $error_msg . "\n"; } else { echo "All tables created.\n"; } //Insert default access_groups into db.