爱程序网

Eloquent ORM 学习笔记

来源: 阅读:

  最近在学习Laravel,觉得ORM功能很强大,我这里只是简单探索了一点,如果有更好的笔记,还请分享。

  因为重点在于Eloquent ORM,所以路由设置,控制器就不详细描述了,这里直接进入Models么模块。

 

  1.数据库准备(Mysql)

  在这里需要创建users和users_ext两张表,并初始化数据  

 1 CREATE TABLE 2 IF NOT EXISTS users ( 3     iAutoId INT (11) NOT NULL AUTO_INCREMENT, 4     sNmame VARCHAR (20), 5     iStatus TINYINT (4), 6     iCreateTime INT (11), 7     PRIMARY KEY (iAutoId) 8 ) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1; 9 10 INSERT INTO users (sNmame, iStatus, iCreateTime)11 VALUES12     ('test1', 1, 1400085387),13     ('test2', 1, 1400085387),14     ('test3', 1, 1400085387),15     ('test4', 1, 1400085387),16     ('test5', 1, 1400085387),17     ('test6', 1, 1400085387);18 19 CREATE TABLE20 IF NOT EXISTS users_ext (21     iAutoId INT (11) NOT NULL AUTO_INCREMENT,22     iAge DECIMAL (3, 0),23     sSex TINYINT (4),24     iUserID INT (11),25     PRIMARY KEY (iAutoId)26 ) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;27 28 INSERT INTO users_ext (iAge, sSex, iUserID)29 VALUES30     (24, 1, 1),31     (109, 0, 2),32     (25, 1, 3),33     (20, 1, 5),34     (68, 0, 4),35     (48, 1, 6);