Working with Database in Yii2 - An artist's personal website

Create a database yiibasic

#database

CREATE TABLE IF NOT EXISTS `employees` (

`Id` int(11) NOT NULL,

`first_name` text NOT NULL,

`last_name` text NOT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `employees`

INSERT INTO `employees` (`Id`, `first_name`, `last_name`) VALUES

(1, 'aaaa', 'cccc'),

(2, 'ssss', 'cccc');

select * from employees;

create a model
id=3;
$newEmployee->first_name=’inserted f name’;
$newEmployee->save();

#Read
$employee = Employee::findOne(1); //return a single object
or
$employees = Employee::findAll([1,2,3]); //return a array of employee

#update
$employee = Employee::findOne(1);
$employee->first_name=’updatedName’;
$employee->save();

#delete
$employee = Employee::findOne(1);
$employee->delete();