Difference between #5 and #6 of
Yii v2 snippet guide

Revision #6 has been created by rackycz on Sep 19, 2019, 8:42:57 PM with the memo:

db
« previous (#5) next (#7) »

Changes

Title unchanged

Yii v2 for beginners

Category unchanged

Tutorials

Yii version unchanged

2.0

Tags unchanged

tutorial,beginner,yii2

Content changed

[...]
---
... text ...

User management + basic SQL commands
---
... text ...To create DB with users, use following command. If you must use MyISAM instead of InnoDB, just skip the last row.
 
 
```MySQL
 
CREATE TABLE IF NOT EXISTS `user` (
 
  `id` INT NOT NULL AUTO_INCREMENT,
 
  `username` VARCHAR(45) NOT NULL,
 
  `password` VARCHAR(60) NOT NULL,
 
  PRIMARY KEY (`id`))
 
ENGINE = InnoDB;
 
```
 
 
First user:
 
```MySQL
 
INSERT INTO `user` (`id`, `username`, `password`) VALUES (1, 'user01', '0497fe4d674fe37194a6fcb08913e596ef6a307f');
 
```

Login via database + Session
---
... text ...
[...]
7 0
4 followers
Viewed: 274 821 times
Version: 2.0
Category: Tutorials
Tags: beginner, tutorial, yii2
Written by: rackycz
Last updated by: rackycz
Created on: Sep 19, 2019
Last updated: a year ago
Update Article
Revert to #5 | Revert to #6

Revisions

View all history