PHP Users::insert方法代码示例

 public function pdoAddModelAction()
 {
     $this->_view->title = 'Model Add Form';
     $this->_view->link = base_url() . 'pdo-database/pdo-model/pdo-add-model';
     $val = new Validation();
     $val->source = $_POST;
     if (!empty($_POST)) {
         $val = new Validation();
         $val->source = $_POST;
         $val->addValidator(array('name' => 'first_name', 'type' => 'string', 'required' => true));
         $val->addValidator(array('name' => 'last_name', 'type' => 'string', 'required' => true));
         $val->addValidator(array('name' => 'email', 'type' => 'email', 'required' => true));
         $val->addValidator(array('name' => 'address', 'type' => 'string', 'required' => true));
         $val->run();
         if (!$val->hasError()) {
             $users = new Users();
             $data = array('first_name' => $_POST['first_name'], 'last_name' => $_POST['last_name'], 'email' => $_POST['email'], 'address' => $_POST['address']);
             $users->insert($data);
             redirect('pdo-database/pdo-model/pdo-model');
         }
         $this->_view->errorMessage = $val->errorMessage();
         $this->_view->data = $_POST;
     }
     $this->renderView('pdo-database/pdo-model/_form');
 }

 public function register(UI\Form $form)
 {
     try {
         $values = $form->getValues();
         $unhash_password = $values->password;
         $values->password = $this->users->calculateHash($values->password);
         $values->hash = sha1($values->username . $values->password);
         unset($values['agree']);
         $this->users->insert($values);
         $template = $this->createTemplate();
         $template->setFile(__DIR__ . "/../templates/Sign/mail-confirmation.latte");
         $template->setTranslator($this->translator);
         $template->hash = $values->hash;
         $msg = new \Nette\Mail\Message();
         $msg->setHtmlBody($template)->setFrom('noreply@peknyden.cz')->setSubject('Potvrzení registrace na portálu Peknyden.cz')->addTo(trim($values->email));
         $this->mailer->send($msg);
     } catch (Exception $e) {
         error_log($e->getMessage());
         switch ($e->getCode()) {
             case "23000":
                 $form->addError('There is account with this username or e-mail. Please select different one.');
                 break;
             default:
                 $form->addError('There is some error. Our administrator was informed.', 'error');
                 throw new Exception($e->getMessage());
         }
     }
     if ($form->isSuccess()) {
         $this->cleanCache('users', 'user');
         $this->flashMessage('Výborně, jste úspěšně zaregistrováni. Zkontrolujte váš e-mail!', 'success');
         $this->logUser($values->username, $unhash_password, null, true);
     }
 }

 public function create_user()
 {
     // If there are no users then let's create one.
     $db = Database::get_instance();
     $db->query('SELECT * FROM `users` LIMIT 1');
     if ($db->has_rows() && !Auth::get_instance()->logged_in()) {
         Flash::set('<p class="flash validation">Sorry but to create new users, you must be logged in.</p>');
         Core_Helpers::redirect(WEB_ROOT . 'login/');
     }
     $validator = Error::instance();
     if (isset($_POST['email'])) {
         $validator->email($_POST['email'], 'email');
         $validator->blank($_POST['username'], 'username');
         $validator->blank($_POST['password'], 'password');
         $validator->passwords($_POST['password'], $_POST['confirm_password'], 'confirm_password');
         $user = new Users();
         if ($user->select(array('username' => $_POST['username']))) {
             $validator->add('username', 'The username <strong>' . htmlspecialchars($_POST['username']) . '</strong> is already taken.');
         }
         if ($validator->ok()) {
             $user = new Users();
             $user->load($_POST);
             $user->level = 'admin';
             $user->insert();
             Flash::set('<p class="flash success">User created successfully.</p>');
             Core_Helpers::redirect(WEB_ROOT . 'login/');
         }
     }
     $this->data['error'] = $validator;
     $this->load_template('create_user');
 }

 public static function create()
 {
     !$_SESSION['id'] ? static::isRobot() : null;
     static::purifier();
     if ($_POST['name'] != "" && $_POST['email'] != "" && $_POST['course'] != "" && $_POST['phone'] != "" && $_POST['semester'] != "" && $_POST['registry'] != "") {
         $user = new Users($_POST);
         try {
             $user->insert();
             $_SESSION['msg'] = 'success">Cadastro realizado com sucesso!';
             $email = new Email($_POST);
             $email->send();
         } catch (pdoexception $e) {
             $_SESSION['msg'] = 'fail">Erro ao cadastrar. Confira as informações inseridas.';
         }
     }
     isset($_SESSION['id']) ? header('Location: ../views/subscribers') : header('Location: ../#subscribe');
 }

 public function actionRegisting()
 {
     $Users = new Users();
     $data = $this->Common->getFilter($_POST);
     if (empty($data['email'])) {
         $this->Common->exportResult(false, '请输入邮箱！');
     }
     if (empty($data['password'])) {
         $this->Common->exportResult(false, '请输入密码！');
     }
     $data['add_date'] = $this->Common->getDate();
     $data['password'] = md5($data['password']);
     if ($Users->insert($data)) {
         $this->Common->exportResult(true, '注册成功！');
     } else {
         $this->Common->exportResult(false, '注册失败！');
     }
 }

 /**
  * Page
  */
 public function usersAction()
 {
     $usersModel = new Users();
     if ($this->getRequest()->isPost()) {
         $data = $this->getRequest()->getPost();
         if (@$data['method'] == 'create') {
             //CREATE NEW USER
             unset($data['method']);
             if ($data['email'] == '' || $data['password'] == '') {
                 $this->view->error = "Please complete all fields.";
                 $this->view->data = $data;
             } else {
                 $data['password'] = sha1($data['password']);
                 $usersModel->insert($data);
                 $this->view->success = "New User Created.";
             }
         }
         if (@$data['method'] == 'update') {
             //UPDATE USER
             unset($data['method']);
             if ($data['password'] == '') {
                 unset($data['password']);
             } else {
                 $data['password'] = sha1($data['password']);
             }
             $usersModel->updateRecord($data['id'], $data);
             $this->view->success = "User Record Updated.";
         }
         if (@$data['method'] == 'delete') {
             //DELETE USER
             $where = "id=" . $data['id'];
             $usersModel->delete($where);
         }
     }
     $users = $usersModel->getAll();
     $page = $this->_getParam('page', 1);
     $paginator = Zend_Paginator::factory($users);
     $paginator->setItemCountPerPage(20);
     $paginator->setCurrentPageNumber($page);
     $this->view->users = $paginator;
     $locationsModel = new Locations();
     $this->view->locations = $locationsModel->getAll();
 }

function insertProcess()
{
    $valid = Validator::make(array('send.firstname' => 'min:1|slashes', 'send.lastname' => 'min:1|slashes', 'send.groupid' => 'number|slashes', 'send.username' => 'min:3|slashes', 'send.email' => 'email|slashes', 'address.address_1' => 'slashes', 'address.address_2' => 'slashes', 'address.city' => 'slashes', 'address.state' => 'slashes', 'address.postcode' => 'slashes', 'address.country' => 'slashes'));
    if (!$valid) {
        throw new Exception("Error Processing Request: " . Validator::getMessage());
    }
    $username = Request::get('send.username');
    $email = Request::get('send.email');
    $loadData = Users::get(array('where' => "where username='{$username}' OR email='{$email}'"));
    if (isset($loadData[0]['userid'])) {
        throw new Exception("This user have been exist in database.");
    }
    $send = Request::get('send');
    $address = Request::get('address');
    $thepass = Request::get('thepass');
    $passMd5 = String::encrypt($thepass);
    $send['password'] = $passMd5;
    $address['firstname'] = $send['firstname'];
    $address['lastname'] = $send['lastname'];
    $userid = Users::insert($send);
    $address['userid'] = $userid;
    Address::insert($address);
}

 public function action()
 {
     // load
     $this->load->model('Users');
     // variables
     $username = $_POST['username'];
     $password = $_POST['password'];
     $confirm_password = $_POST['confirm_password'];
     $target_dir = base_url() . 'assets/images/';
     //var_dump($avatar);
     // if the username exist in database return to register page
     if ($this->Users->check_username($username) != null) {
         redirect('register');
     } else {
         if ($password != $confirm_password) {
             redirect('register');
         } else {
             if (getimagesize($_FILES["avatar"]["tmp_name"]) == false) {
                 redirect('register');
             }
         }
     }
     // check if file is too big
     if ($_FILES["avatar"]["size"] > 500000) {
         redirect('register');
     } else {
         $user = new Users();
         $user->username = $username;
         $user->password = hash('md5', $password);
         $user->avatar = 'something';
         $user->isAdmin = false;
         $user->insert();
         // move_uploaded_file($_FILES["avatar"]["tmp_name"], "assets/images/" . ($user->get_largest_id() + 1));
         redirect('login');
     }
 }

 /**
  * 提交信息
  */
 public function actionModified()
 {
     $data = $this->Common->getFilter($_POST);
     $userid = (int) $data['userid'];
     unset($data['userid']);
     $Users = new Users();
     if ($userid == 0) {
         unset($data['oldemail']);
         $count = $Users->getCount('*', array('email' => $data['email']));
         if ($count > 0) {
             $this->jumpBox('邮箱不能重复！', Wave::app()->homeUrl . 'users', 1);
         }
         $data['password'] = md5($data['password']);
         $data['add_date'] = date('Y-m-d H:i:s');
         $userid = $Users->insert($data);
         $data['userid'] = $userid;
         $this->Log->saveLogs('添加用户', 1, $data);
     } else {
         if ($data['oldemail'] != $data['email']) {
             $count = $Users->getCount('*', array('email' => $data['email']));
             if ($count > 0) {
                 $this->jumpBox('邮箱不能重复！', Wave::app()->homeUrl . 'users', 1);
             }
         }
         unset($data['oldemail']);
         if (!empty($data['password'])) {
             $data['password'] = md5($data['password']);
         } else {
             unset($data['password']);
         }
         $Users->update($data, array('userid' => $userid));
         $data['userid'] = $userid;
         $this->Log->saveLogs('更新用户', 1, $data);
     }
     $this->jumpBox('成功！', Wave::app()->homeUrl . 'users', 1);
 }

 public static function insertUser()
 {
     return Users::insert(array('email' => Input::get('email'), 'username' => Input::get('username'), 'password' => Hash::make(Input::get('password')), 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s')));
 }

 function testdataAction()
 {
     $request = new Bolts_Request($this->getRequest());
     if ($this->getRequest()->isPost()) {
         $errors = array();
         $data_path = $request->data_path;
         $data_file = $data_path . "/users.dat";
         $image_dir = $data_path . "/images";
         $users_table = new Users();
         $users_roles_table = new UsersRoles();
         if ($request->has("email_domain")) {
             $email_domain = $request->email_domain;
         } else {
             $email_domain = "nowhere.com";
         }
         if (!file_exists($data_file)) {
             $errors[] = $this->_T("Data file missing. Check path.");
         } else {
             $users = unserialize(file_get_contents($data_file));
             if (!is_array($users)) {
                 $errors[] = $this->_T("Data file is corrupt or something.");
             }
         }
         if (count($errors) == 0) {
             $old_users = $users_table->fetchAll();
             foreach ($old_users as $old_user) {
                 if ($users_table->getMetaData($old_user->username, "is_test_user") == "true") {
                     $where = $users_table->getAdapter()->quoteInto("username = ?", $old_user->username);
                     $users_table->delete($where);
                     $users_roles_table->delete($where);
                 }
             }
             $count = 0;
             foreach ($users as $user) {
                 $tmp_user = array();
                 foreach ($user as $key => $value) {
                     if ($key != "avatar") {
                         $tmp_user[$key] = $value;
                     }
                 }
                 $tmp_user['email'] = strtolower($tmp_user['username'] . "@" . $email_domain);
                 $tmp_user['password'] = "password";
                 $destination_path = $users_table->getAvatarPath($user['username']);
                 $destination_filename = $users_table->getAvatarPath($user['username'], true);
                 if (!is_dir($destination_path)) {
                     mkdir($destination_path, 0777, true);
                 }
                 if (file_exists($destination_filename)) {
                     unlink($destination_filename);
                 }
                 $source_image = $image_dir . "/" . $user['avatar'];
                 copy($source_image, $destination_filename);
                 $role_data = array("username" => $tmp_user['username'], "role_id" => $tmp_user['role_id']);
                 $users_roles_table->insert($role_data);
                 unset($tmp_user['role_id']);
                 $users_table->insert($tmp_user);
                 $users_table->setMetaData($tmp_user['username'], "is_test_user", "true");
                 $save_users[] = $user;
                 $count++;
             }
             $this->view->success = "User data loaded. Created " . $count . " users.";
             Bolts_Registry::set('test_data_path', $request->data_path);
             $this->view->data_path = Bolts_Registry::get('test_data_path');
             $this->view->email_domain = $email_domain;
         } else {
             $this->view->errors = $errors;
             $this->view->data_path = Zend_Registry::get('basepath') . "/tmp/testdata";
             $this->view->email_domain = $request->email_domain;
         }
     } else {
         $this->view->data_path = Zend_Registry::get('basepath') . "/tmp/testdata";
         $this->view->email_domain = "nowhere.com";
         $this->view->notice = $this->_T("Warning: If you are reinstalling the test data, the old test data will be overwritten. Users created outside the test data should not be affected.");
     }
 }

 public static function makeRegister($inputData = array())
 {
     if (!isset($_REQUEST['send']['firstname']) && isset($inputData['firstname'])) {
         $_REQUEST['send'] = $inputData;
     }
     $valid = Validator::make(array('send.firstname' => 'required|min:1|max:20|slashes', 'send.lastname' => 'required|min:1|max:20|slashes', 'send.username' => 'required|min:1|max:30|slashes', 'send.email' => 'required|email|max:120|slashes', 'send.password' => 'required|min:1|max:30|slashes'));
     if (!$valid) {
         throw new Exception("Check your infomartion again: " . Validator::getMessage());
     }
     $insertData = Request::get('send');
     if (!($id = Users::insert($insertData))) {
         throw new Exception("Check your infomartion again, pls!");
     }
     $addData = array('firstname' => trim($insertData['firstname']), 'lastname' => trim($insertData['lastname']), 'userid' => $id);
     Address::insert($addData);
     try {
         self::newRegister($insertData);
     } catch (Exception $e) {
         throw new Exception($e->getMessage());
     }
 }

     $email = $app->request->post('email');
     $created_at = date('Y-m-d H:i:s');
     if ($username == "") {
         $app->flash('error', 1);
         $app->redirect($settings->base_url . '/admin/users/new');
     }
     if ($password == "") {
         $app->flash('error', 2);
         $app->redirect($settings->base_url . '/admin/users/new');
     }
     if ($email == "" or !filter_var($email, FILTER_VALIDATE_EMAIL)) {
         $app->flash('error', 3);
         $app->redirect($settings->base_url . '/admin/users/new');
     }
     $redirect = $settings->base_url . '/admin/users';
     Users::insert(array('username' => $username, 'password' => $password, 'email' => $email, 'created_at' => $created_at));
     $app->render('success.html', array('redirect' => $redirect));
 });
 $app->get('/posts/activate/:id', $authenticate($app, $settings), function ($id) use($app, $settings) {
     $post = Posts::where('id', '=', $id)->first();
     if ($post) {
         $redirect = $settings->base_url . '/admin';
         $post->update(array('active' => 'true'));
         $app->render('success.html', array('redirect' => $redirect));
     } else {
         $app->render('404_post.html');
     }
 })->conditions(array('id' => '\\d+'));
 $app->get('/posts/deactivate/:id', $authenticate($app, $settings), function ($id) use($app, $settings) {
     $post = Posts::where('id', '=', $id)->first();
     if ($post) {

                // $json_response = json_encode($response);
                // echo $json_response;
            }
        }
    } else {
        //insert action
        $user = new Users();
        $user->name = $_POST['name'];
        $user->birthday = $_POST['birthday'];
        $user->address = $_POST['address'];
        $user->username = $_POST['username'];
        $user->email = $_POST['email'];
        $user->password = $_POST['password'];
        $user->credit = $_POST['credit'];
        $user->image = $_POST['image'];
        $user->id = $user->insert();
        if ($user->id > 0) {
            // $status=200;
            $response['data'] = array('user_id' => $user->id);
            $rest = new User_server();
            $rest->handle_response($response['data'], 200);
            // $response['status'] = 'OK';
            // $json_response = json_encode($response);
            // echo $json_response;
        }
    }
    //get user either with id or all
} else {
    if ($_method == 'GET') {
        // get user with a specific id
        if (isset($_GET['id'])) {

 public function addModelAction()
 {
     $this->_view->title = 'Model Add Form';
     $this->_view->link = base_url() . 'database/model/add-model';
     $val = new Validation();
     $val->source = $_POST;
     if (!empty($_POST)) {
         $val = new Validation();
         $val->source = $_POST;
         $val->addValidator(array('name' => 'first_name', 'type' => 'string', 'required' => true));
         $val->addValidator(array('name' => 'last_name', 'type' => 'string', 'required' => true));
         $val->addValidator(array('name' => 'email', 'type' => 'email', 'required' => true));
         $val->addValidator(array('name' => 'address', 'type' => 'string', 'required' => true));
         $val->run();
         if (sizeof($val->errors) == 0) {
             $users = new Users();
             $users->addValue('first_name', $_POST['first_name']);
             $users->addValue('last_name', $_POST['last_name']);
             $users->addValue('email', $_POST['email']);
             $users->addValue('address', $_POST['address']);
             $users->insert();
             redirect('database/model/model');
         }
         $this->_view->errorMessage = $val->errorMessage();
         $this->_view->data = $_POST;
     }
     $this->renderView('database/model/_form');
 }