Differences

This shows you the differences between two versions of the page.

--- systems:yii2:basic_user_login_from_database [2018/04/03 08:44]
smayr
+++ systems:yii2:basic_user_login_from_database [2018/04/05 17:49] (current)
smayr
@@ Line 3: / Line 3: @@
 Perform these steps:
   * First create a ''user'' database table with your own requirements.
-  * In Gii, generate a User model. In this model, implement the ''IdentityInterfaceclass User extends \yii\db\ActiveRecord implements \yii\web\IdentityInterface''
+  * In Gii, generate a User model. In this model, implement the ''IdentityInterface''. <code php>class User extends \yii\db\ActiveRecord implements \yii\web\IdentityInterface
-  * Now in Login form (''[app]/site/login.php''), define User model so it will return back the userclass ''LoginForm extends Model { public $username; public $password; public $email; public $rememberMe = true;''
+{
+    //...
+}</code>
+  * Now in ''LoginForm'' model (''[app]/models/LoginForm.php''), define: <code php>class LoginForm extends Model
+{
+    public $username;
+    public $password;
+    public $email;
+    public $rememberMe = true;
+}
+</code>
 User Table:(''user.sql'')
@@ Line 22: / Line 32: @@
   PRIMARY KEY (`id`),
   UNIQUE KEY `username` (`username`),
-  INDEX `FK_contact_external_customer_id` (`external_customer_id`),
+)
-  CONSTRAINT `FK_contact_customer_id` FOREIGN KEY (`customer_id`)
+COLLATE='utf8_unicode_ci'
-      REFERENCES `customer` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
+ENGINE=InnoDB
+AUTO_INCREMENT=1;
+</code>
+Or:
+<code sql>
+CREATE TABLE `user` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `first_name` varchar(255) NOT NULL,
+  `last_name` varchar(255) NOT NULL,
+  `username` varchar(255) NOT NULL,
+  `phone` varchar(255) NOT NULL,
+  `email` varchar(255) NOT NULL,
+  `password` varchar(255) NOT NULL,
+  `password_hash` varchar(255) NOT NULL,
+  `auth_key` varchar(255) NOT NULL,
+  `password_reset_token` varchar(250) NOT NULL,
+  `avatar` varchar(255) NOT NULL,
+  `role` enum('Admin','Manager','Editor','Author','PowerUser','Registered') NOT NULL DEFAULT 'Registered'
 )
 COLLATE='utf8_unicode_ci'