text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 本地
   Source Server Type    : MySQL
   Source Server Version : 50553
   Source Host           : localhost:3306
   Source Schema         : blog
  
   Target Server Type    : MySQL
   Target Server Version : 50553
   File Encoding         : 65001
  
   Date: 11/03/2019 17:00:50
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for admin
  -- ----------------------------
  DROP TABLE IF EXISTS `admin`;
  CREATE TABLE `admin`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `pass` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `admin_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
    `identity` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份',
    `admin_status` int(1) NULL DEFAULT 1 COMMENT '状态(0:停用,1:启用)',
    `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加时间',
    `last_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册时间',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of admin
  -- ----------------------------
  INSERT INTO `admin` VALUES (12, '提米', 'eyJpdiI6IkpuT0tFRnBWcXBzN1k0UU1oZGlON2c9PSIsInZhbHVlIjoiWHVKTWJ2YTdRME5uWHVJc2lcL2lcL0dnPT0iLCJtYWMiOiJkNjNjMzViMWY5ZmM3MGNlZDc0NTJhZGJjM2I5NzQwYTI5NTFlNjBjNTk0ZDc4YzExNmJjYjQ4ZWYyOWM1YTU0In0=', '/Style/upload_img/img/20181129/25220_023420_7883.png', '超级管理员', 1, NULL, NULL);
  INSERT INTO `admin` VALUES (15, '缇娜', 'eyJpdiI6IjJsQWI1c0JUZTlnUW1WYVg5djRSamc9PSIsInZhbHVlIjoib000Wnk4ZjF4N0NrT00zUDZkR3ZVUT09IiwibWFjIjoiYjUzZTE0NTQxMjJhYzJkNWYwMWZkYjVmYmQxZGI5N2FmNjQ5NmRhNTJjNmExZjJiZDQxMzE5YjQzN2Q3MTNkZiJ9', '/Style/upload_img/img/20181129/25220_024535_6309.png', '管理员', 1, '2018-11-29 02:45:45', NULL);
  
  -- ----------------------------
  -- Table structure for amity_link
  -- ----------------------------
  DROP TABLE IF EXISTS `amity_link`;
  CREATE TABLE `amity_link`  (
    `id` int(12) NOT NULL AUTO_INCREMENT,
    `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '友情链接名称',
    `link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '友情链接url',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of amity_link
  -- ----------------------------
  INSERT INTO `amity_link` VALUES (1, '杨青博客', 'http://www.yangqq.com/');
  INSERT INTO `amity_link` VALUES (2, '超能小紫博客', 'https://www.mokeyjay.com/');
  
  -- ----------------------------
  -- Table structure for article
  -- ----------------------------
  DROP TABLE IF EXISTS `article`;
  CREATE TABLE `article`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `article_describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述',
    `article_keywords` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键词',
    `type_id` int(5) NOT NULL DEFAULT 0 COMMENT '学习文章分类',
    `life_id` int(5) NOT NULL DEFAULT 0 COMMENT '生活文章分类',
    `article_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章标题',
    `article_status` int(11) NOT NULL COMMENT '状态（1:发布,2:未发布）',
    `article_addtime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发布时间',
    `article_img_status` int(1) NULL DEFAULT 0 COMMENT '封面图状态(0:没有图片,1:普通图片,2:多张图片,3:大图片)',
    `article_author` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '作者',
    `article_browse` mediumint(255) NULL DEFAULT 0 COMMENT '浏览量',
    `article_praise` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '点赞数',
    `article_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章来源',
    `recommend` int(2) NULL DEFAULT 0 COMMENT '推荐与分享(0:推荐,1:否)',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of article
  -- ----------------------------
  INSERT INTO `article` VALUES (20, 'PHP中如何利用PHPMailer配合QQ邮箱来发送邮件', 'php,phpmailer,邮件', 1, 0, 'PHP中利用PHPMailer来发送邮件', 1, '2018-01-23', 0, '提米', 0, NULL, NULL, 1);
  INSERT INTO `article` VALUES (21, 'Windows下composer的安装和使用', 'windows,composer', 1, 0, 'Windows下composer的安装和使用', 1, '2018-01-29', 0, '提米', 0, NULL, NULL, 0);
  INSERT INTO `article` VALUES (22, '这几天看了看laravel框架,才发现这么棒的框架居然没有验证码功能,于是自己研究了下如何在laravel框架里面使用验证码', 'laravel,php', 1, 0, 'laravel框架如何使用验证码进行验证', 1, '2018-04-08', 0, '提米', 0, NULL, NULL, 0);
  INSERT INTO `article` VALUES (23, 'laravel需要开启的环境配置', 'php，laravel', 1, 0, 'laravel需要开启的环境配置', 1, '2018-04-12', 3, '提米', 0, NULL, NULL, 0);
  INSERT INTO `article` VALUES (24, 'laravel框架的链表查询', 'laravel,php', 1, 0, 'laravel框架的链表查询', 1, '2018-05-02', 0, '提米', 0, NULL, NULL, 0);
  INSERT INTO `article` VALUES (25, 'input输出类型限制', 'css', 2, 0, 'input输出类型限制', 1, '2018-05-02', 0, '提米', 0, NULL, NULL, 0);
  INSERT INTO `article` VALUES (26, 'Laravel框架常用数据库CURD操作', 'Laravel,php', 1, 0, 'Laravel框架常用数据库CURD操作', 1, '2018-05-03', 0, '提米', 0, NULL, NULL, 1);
  INSERT INTO `article` VALUES (27, 'HTTP通信原理', '前端', 2, 0, 'HTTP通信原理', 1, '2018-05-08', 0, '提米', 0, NULL, NULL, 1);
  INSERT INTO `article` VALUES (28, 'tp5 隐藏index.php入口文件', 'tp5,php', 1, 0, 'tp5 隐藏index.php入口文件', 1, '2018-05-09', 0, '提米', 0, NULL, NULL, 0);
  INSERT INTO `article` VALUES (29, 'php时间戳的各种格式', 'php,时间戳', 1, 0, 'php时间戳各种格式', 1, '2018-05-14', 1, '提米', 0, NULL, NULL, 1);
  INSERT INTO `article` VALUES (30, 'CSS常用命名,页面结构常用命名,导航命名,功能命名', 'css', 2, 0, 'CSS命名', 1, '2018-06-24', 2, '提米', 0, NULL, NULL, 0);
  INSERT INTO `article` VALUES (31, 'window对象的属性和方法', 'css,前端', 2, 0, 'window对象的属性和方法', 1, '2018-07-02', 1, '提米', 0, NULL, NULL, 0);
  
  -- ----------------------------
  -- Table structure for article_content
  -- ----------------------------
  DROP TABLE IF EXISTS `article_content`;
  CREATE TABLE `article_content`  (
    `article_id` int(11) NOT NULL,
    `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '博文内容',
    PRIMARY KEY (`article_id`) USING BTREE
  ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of article_content
  -- ----------------------------
  INSERT INTO `article_content` VALUES (20, '<h3 style=\"margin: 10px 0px; padding: 0px; font-size: 16px; line-height: 1.5; font-family: Verdana, Arial, Helvetica, sans-serif; white-space: normal; background-color: rgb(238, 238, 238);\">1、开启SMTP服务</h3><p style=\"margin: 10px auto; padding: 0px; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(238, 238, 238);\">测试用的是自己的qq邮箱，首先需要开启邮箱的SMTP服务，开启之后，要记得给你的授权码，授权码一定要是最新的，我的已经开启啦，授权码也偷偷地背会了。</p><p style=\"margin: 10px auto; padding: 0px; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(238, 238, 238);\"><img src=\"https://images2015.cnblogs.com/blog/1109006/201707/1109006-20170712155445150-925764125.png\" alt=\"\"/></p><h3 style=\"margin: 10px 0px; padding: 0px; font-size: 16px; line-height: 1.5; font-family: Verdana, Arial, Helvetica, sans-serif; white-space: normal; background-color: rgb(238, 238, 238);\">2、安装phpmailer</h3><p style=\"margin: 10px auto; padding: 0px; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(238, 238, 238);\">使用composer，项目目录下运行</p><p style=\"margin: 10px auto; padding: 0px;\">composer&nbsp;<span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 255); line-height: 1.5 !important;\">require</span>&nbsp;phpmailer/phpmailer</p><p style=\"margin: 10px auto; padding: 0px; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(238, 238, 238);\">执行之后可以在vendor目录下看到phpmailer目录，这是一个用于发送电子邮件的php函数包，很方便。</p><h3 style=\"margin: 10px 0px; padding: 0px; font-size: 16px; line-height: 1.5; font-family: Verdana, Arial, Helvetica, sans-serif; white-space: normal; background-color: rgb(238, 238, 238);\">3、发送邮件函数</h3><p>/**</p><p>&nbsp;* 发送邮件方法</p><p>&nbsp;* @param string $to：接收者邮箱地址</p><p>&nbsp;* @param string $title：邮件的标题</p><p>&nbsp;* @param string $content：邮件内容</p><p>&nbsp;* @return boolean&nbsp; true:发送成功 false:发送失败</p><p>&nbsp;*/</p><p>function sendMail($to,$title,$content){</p><p>&nbsp; &nbsp;&nbsp;</p><p>&nbsp; &nbsp;&nbsp;</p><p>&nbsp; &nbsp; //实例化PHPMailer核心类</p><p>&nbsp; &nbsp; $mail = new \\PHPMailer();</p><p>&nbsp; &nbsp; //是否启用smtp的debug进行调试 开发环境建议开启 生产环境注释掉即可 默认关闭debug调试模式</p><p>&nbsp; &nbsp; $mail-&gt;SMTPDebug = 1;</p><p>&nbsp; &nbsp; //使用smtp鉴权方式发送邮件</p><p>&nbsp; &nbsp; $mail-&gt;isSMTP();</p><p>&nbsp; &nbsp; //smtp需要鉴权 这个必须是true</p><p>&nbsp; &nbsp; $mail-&gt;SMTPAuth=true;</p><p>&nbsp; &nbsp; //链接qq域名邮箱的服务器地址</p><p>&nbsp; &nbsp; $mail-&gt;Host = &#39;smtp.qq.com&#39;;</p><p>&nbsp; &nbsp; //设置使用ssl加密方式登录鉴权</p><p>&nbsp; &nbsp; $mail-&gt;SMTPSecure = &#39;ssl&#39;;</p><p>&nbsp; &nbsp; //设置ssl连接smtp服务器的远程服务器端口号，以前的默认是25，但是现在新的好像已经不可用了 可选465或587</p><p>&nbsp; &nbsp; $mail-&gt;Port = 465;</p><p>&nbsp; &nbsp; //设置smtp的helo消息头 这个可有可无 内容任意</p><p>&nbsp; &nbsp; $mail-&gt;Helo = &#39;Hello smtp.qq.com Server&#39;;</p><p>&nbsp; &nbsp; //设置发件人的主机域 可有可无 默认为localhost 内容任意，建议使用你的域名</p><p>&nbsp; &nbsp; $mail-&gt;Hostname = &#39;localhost&#39;;</p><p>&nbsp; &nbsp; //设置发送的邮件的编码 可选GB2312 我喜欢utf-8 据说utf8在某些客户端收信下会乱码</p><p>&nbsp; &nbsp; $mail-&gt;CharSet = &#39;UTF-8&#39;;</p><p>&nbsp; &nbsp; //设置发件人姓名（昵称） 任意内容，显示在收件人邮件的发件人邮箱地址前的发件人姓名</p><p>&nbsp; &nbsp; $mail-&gt;FromName = &#39;天下第一帅&#39;;</p><p>&nbsp; &nbsp; //smtp登录的账号 这里填入字符串格式的qq号即可</p><p>&nbsp; &nbsp; $mail-&gt;Username =&#39;&#39;;</p><p>&nbsp; &nbsp; //smtp登录的密码 使用生成的授权码 你的最新的授权码</p><p>&nbsp; &nbsp; $mail-&gt;Password = &#39;&#39;;</p><p>&nbsp; &nbsp; //设置发件人邮箱地址 这里填入上述提到的“发件人邮箱”</p><p>&nbsp; &nbsp; $mail-&gt;From = &#39;&#39;;</p><p>&nbsp; &nbsp; //邮件正文是否为html编码 注意此处是一个方法 不再是属性 true或false</p><p>&nbsp; &nbsp; $mail-&gt;isHTML(true);</p><p>&nbsp; &nbsp; //设置收件人邮箱地址 该方法有两个参数 第一个参数为收件人邮箱地址 第二参数为给该地址设置的昵称 不同的邮箱系统会自动进行处理变动 这里第二个参数的意义不大</p><p>&nbsp; &nbsp; $mail-&gt;addAddress($to,&#39;测试通知&#39;);</p><p>&nbsp; &nbsp; //添加多个收件人 则多次调用方法即可</p><p>&nbsp; &nbsp; // $mail-&gt;addAddress(&#39;xxx@qq.com&#39;,&#39;lsgo在线通知&#39;);</p><p>&nbsp; &nbsp; //添加该邮件的主题</p><p>&nbsp; &nbsp; $mail-&gt;Subject = $title;</p><p>&nbsp; &nbsp; //添加邮件正文 上方将isHTML设置成了true，则可以是完整的html字符串 如：使用file_get_contents函数读取本地的html文件</p><p>&nbsp; &nbsp; $mail-&gt;Body = $content;</p><p><br/></p><p>&nbsp; &nbsp; //为该邮件添加附件 该方法也有两个参数 第一个参数为附件存放的目录（相对目录、或绝对目录均可） 第二参数为在邮件附件中该附件的名称</p><p>&nbsp; &nbsp; // $mail-&gt;addAttachment(&#39;./d.jpg&#39;,&#39;mm.jpg&#39;);</p><p>&nbsp; &nbsp; //同样该方法可以多次调用 上传多个附件</p><p>&nbsp; &nbsp; // $mail-&gt;addAttachment(&#39;./Jlib-1.1.0.js&#39;,&#39;Jlib.js&#39;);</p><p><br/></p><p>&nbsp; &nbsp; $status = $mail-&gt;send();</p><p><br/></p><p>&nbsp; &nbsp; //简单的判断与提示信息</p><p>&nbsp; &nbsp; if($status) {</p><p>&nbsp; &nbsp; &nbsp; &nbsp; return true;</p><p>&nbsp; &nbsp; }else{</p><p>&nbsp; &nbsp; &nbsp; &nbsp; return false;</p><p>&nbsp; &nbsp; }</p><p>}</p><h3 style=\"margin: 10px 0px; padding: 0px; font-size: 16px; line-height: 1.5; font-family: Verdana, Arial, Helvetica, sans-serif; white-space: normal; background-color: rgb(238, 238, 238);\">4、测试效果</h3><p style=\"margin: 10px auto; padding: 0px; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(238, 238, 238);\">控制器中，写一个方法测试函数是不是好使。</p><pre style=\"margin-top: 0px; margin-bottom: 0px; padding: 0px; white-space: pre-wrap; word-wrap: break-word; font-family: \">1&nbsp;&nbsp;public&nbsp;function&nbsp;test(){2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sendMail(&#39;email&nbsp;address&#39;,&#39;邮件的标题&#39;,&#39;发送成功&#39;);3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</pre><p style=\"margin: 10px auto; padding: 0px; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(238, 238, 238);\"><img src=\"https://images2015.cnblogs.com/blog/1109006/201707/1109006-20170712161458243-494398045.png\" alt=\"\"/></p><p style=\"margin: 10px auto; padding: 0px; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(238, 238, 238);\">成功~</p><p><br/></p>');
  INSERT INTO `article_content` VALUES (21, '<p>https://www.cnblogs.com/lookphp/p/b15af85f67dc7df59a970d905713262a.html?t=1475222673008</p>');
  INSERT INTO `article_content` VALUES (22, '<p><strong>首先在框架内部打开黑窗口</strong>,&nbsp; <span style=\"color: rgb(255, 0, 0);\">php artisan make:middeware 中间键名 <span style=\"color: rgb(0, 0, 0);\">新建一个中间键名;</span></span><br/></p><p><strong>在后台web.php里面引入中间键</strong></p><pre style=\"background-color: rgb(255, 255, 255); font-family: 宋体; font-size: 11.3pt;\"><span style=\"background-color:#f7faff;\">Route::</span><span style=\"background-color:#f7faff;font-style:italic;\">group</span><span style=\"background-color:#f7faff;\">([</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;namespace&#39;</span><span style=\"background-color:#f7faff;\">=&gt;</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;Admin&#39;</span><span style=\"background-color:#f7faff;\">,</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;prefix&#39;</span><span style=\"background-color:#f7faff;\">=&gt;</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&quot;admin&quot;</span><span style=\"background-color:#f7faff;\">,</span><span style=\"color: rgb(255, 0, 0);\"><span style=\"background-color: rgb(247, 250, 255); font-weight: bold;\">&#39;middleware&#39;</span><span style=\"background-color: rgb(247, 250, 255);\">=&gt;</span><span style=\"background-color: rgb(247, 250, 255); font-weight: bold;\">&#39;adminLogin&#39;</span></span><span style=\"background-color:#f7faff;\">],</span><span style=\"color:#000080;background-color:#f7faff;font-weight:bold;\">function</span><span style=\"background-color:#f7faff;\">(){<br/> &nbsp; &nbsp;</span><span style=\"color:#808080;background-color:#f7faff;font-style:italic;\">//后台首页<br/> &nbsp; &nbsp;</span><span style=\"background-color:#f7faff;\">Route::</span><span style=\"background-color:#f7faff;font-style:italic;\">get</span><span style=\"background-color:#f7faff;\">(</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;/&#39;</span><span style=\"background-color:#f7faff;\">,</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;IndexController@index&#39;</span><span style=\"background-color:#f7faff;\">);<br/> &nbsp; &nbsp;Route::</span><span style=\"background-color:#f7faff;font-style:italic;\">get</span><span style=\"background-color:#f7faff;\">(</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;index&#39;</span><span style=\"background-color:#f7faff;\">,</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;IndexController@index2&#39;</span><span style=\"background-color:#f7faff;\">);<br/> &nbsp; &nbsp;</span><span style=\"color:#808080;background-color:#f7faff;font-style:italic;\">//管理员管理<br/> &nbsp; &nbsp;</span><span style=\"background-color:#f7faff;\">Route::</span><span style=\"background-color:#f7faff;font-style:italic;\">resource</span><span style=\"background-color:#f7faff;\">(</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;admin&#39;</span><span style=\"background-color:#f7faff;\">,</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;AdminController&#39;</span><span style=\"background-color:#f7faff;\">);<br/> &nbsp; &nbsp;</span><span style=\"color:#808080;background-color:#f7faff;font-style:italic;\">//用户管理<br/> &nbsp; &nbsp;</span><span style=\"background-color:#f7faff;\">Route::</span><span style=\"background-color:#f7faff;font-style:italic;\">resource</span><span style=\"background-color:#f7faff;\">(</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;user&#39;</span><span style=\"background-color:#f7faff;\">,</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;UserController&#39;</span><span style=\"background-color:#f7faff;\">);<br/>});</span></pre><p><strong>在kernel里面注册中间键</strong><br/></p><pre style=\"background-color: rgb(255, 255, 255); font-family: 宋体; font-size: 11.3pt;\"><span style=\"color:#000080;background-color:#f7faff;font-weight:bold;\">protected </span><span style=\"color:#660e7a;background-color:#f7faff;font-weight:bold;\">$routeMiddleware </span><span style=\"background-color:#f7faff;\">= [<br/> &nbsp; &nbsp;</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;auth&#39; </span><span style=\"background-color:#f7faff;\">=&gt; \\Illuminate\\Auth\\Middleware\\Authenticate::</span><span style=\"color:#660e7a;background-color:#f7faff;font-weight:bold;font-style:italic;\">class</span><span style=\"background-color:#f7faff;\">,<br/> &nbsp; &nbsp;</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;auth.basic&#39; </span><span style=\"background-color:#f7faff;\">=&gt; \\Illuminate\\Auth\\Middleware\\AuthenticateWithBasicAuth::</span><span style=\"color:#660e7a;background-color:#f7faff;font-weight:bold;font-style:italic;\">class</span><span style=\"background-color:#f7faff;\">,<br/> &nbsp; &nbsp;</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;bindings&#39; </span><span style=\"background-color:#f7faff;\">=&gt; \\Illuminate\\Routing\\Middleware\\SubstituteBindings::</span><span style=\"color:#660e7a;background-color:#f7faff;font-weight:bold;font-style:italic;\">class</span><span style=\"background-color:#f7faff;\">,<br/> &nbsp; &nbsp;</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;can&#39; </span><span style=\"background-color:#f7faff;\">=&gt; \\Illuminate\\Auth\\Middleware\\Authorize::</span><span style=\"color:#660e7a;background-color:#f7faff;font-weight:bold;font-style:italic;\">class</span><span style=\"background-color:#f7faff;\">,<br/> &nbsp; &nbsp;</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;guest&#39; </span><span style=\"background-color:#f7faff;\">=&gt; \\App\\Http\\Middleware\\RedirectIfAuthenticated::</span><span style=\"color:#660e7a;background-color:#f7faff;font-weight:bold;font-style:italic;\">class</span><span style=\"background-color:#f7faff;\">,<br/> &nbsp; &nbsp;</span><span style=\"color:#008000;background-color:#f7faff;font-weight:bold;\">&#39;throttle&#39; </span><span style=\"background-color:#f7faff;\">=&gt; \\Illuminate\\Routing\\Middleware\\ThrottleRequests::</span><span style=\"color:#660e7a;background-color:#f7faff;font-weight:bold;font-style:italic;\">class</span><span style=\"background-color:#f7faff;\">,<br/> &nbsp; &nbsp;</span><span style=\"color: rgb(255, 0, 0);\"><span style=\"background-color: rgb(247, 250, 255); font-weight: bold;\">&#39;adminLogin&#39;</span><span style=\"background-color: rgb(247, 250, 255);\">=&gt; \\App\\Http\\Middleware\\adminLogin::</span><span style=\"background-color: rgb(247, 250, 255); font-weight: bold; font-style: italic;\">class</span><span style=\"background-color: rgb(247, 250, 255);\">,</span></span><span style=\"background-color:#f7faff;\"><br/>];<br/><strong>在中间键页面里面判断是否登录</strong><br/>public function handle($request, Closure $next)<br/>{<br/> &nbsp; &nbsp;//判断后台是否登录<br/> &nbsp; &nbsp;if(session(&#39;aisAdminUserInfo&#39;)){<br/> &nbsp; &nbsp; &nbsp; &nbsp;return $next($request);<br/> &nbsp; &nbsp;}else{<br/> &nbsp; &nbsp; &nbsp; &nbsp;return &nbsp;redirect(&#39;admin/login&#39;);<br/> &nbsp; &nbsp;}<br/>}<br/><strong>在路由页面写验证码跳转过来的页面</strong><br/>//登录页面<br/>Route::get(&#39;admin/login&#39;,&#39;Admin\\LoginController@index&#39;);<br/>//后台验证码<br/>Route::get(&#39;admin/yzm&#39;,&#39;Admin\\LoginController@yzm&#39;);<br/><br/><strong>然后在黑窗口下载验证码插件</strong> <span style=\"background-color: rgb(247, 250, 255); color: rgb(255, 0, 0);\">composer require gregwar/captcha</span><br/><br/><br/><strong>在验证码页面调用下载来的插件</strong><br/><br/>use Gregwar\\Captcha\\CaptchaBuilder;<br/>use Session;<br/><br/> &nbsp; &nbsp;public function yzm(){<br/>// &nbsp; &nbsp; &nbsp; &nbsp;创建生成yzm的对象<br/> &nbsp; &nbsp; &nbsp; &nbsp;$yzm= new CaptchaBuilder();<br/> &nbsp; &nbsp; &nbsp; &nbsp;//使用$yzm-&gt;build函数设置图片的宽高以及字体<br/> &nbsp; &nbsp; &nbsp; &nbsp;$yzm-&gt;build(100,50);<br/> &nbsp; &nbsp; &nbsp; &nbsp;//使用getPhrase获取自动生成的验证码图片上的字符串<br/> &nbsp; &nbsp; &nbsp; &nbsp;$ais=$yzm-&gt;getPhrase();<br/> &nbsp; &nbsp; &nbsp; &nbsp;//把验证码存放到一次性session<br/> &nbsp; &nbsp; &nbsp; &nbsp;Session::flash(&#39;ais&#39;,$ais);<br/> &nbsp; &nbsp; &nbsp; &nbsp;//生成图片<br/> &nbsp; &nbsp; &nbsp; &nbsp;//发送一个报头，告诉浏览器当前页面不进行缓存，每次访问的时间必须从服务器上读取最新的数据<br/> &nbsp; &nbsp; &nbsp; &nbsp;header(&#39;cache-control:no-cache,must-revalidate&#39;);<br/> &nbsp; &nbsp; &nbsp; &nbsp;header(&#39;Content-type:image/jpeg&#39;);<br/> &nbsp; &nbsp; &nbsp; &nbsp;$yzm-&gt;output();<br/> &nbsp; &nbsp;}<br/><br/> &nbsp; &nbsp;<br/><strong>输出页面调用验证码</strong><br/>&lt;img src=&quot;/admin/yzm&quot; alt=&quot;captcha&quot; onclick=&quot;this.src=&#39;/admin/yzm?m&#39;+Math.random();&quot; style=&quot;cursor:pointer&quot;/&gt;<br/><br/></span></pre><p><br/></p>');
  INSERT INTO `article_content` VALUES (23, '<p style=\"margin-top: 0px; margin-bottom: 16px; padding: 0px; box-sizing: border-box; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; font-family: &quot;PingFang SC&quot;, &quot;Microsoft YaHei&quot;, SimHei, Arial, SimSun; white-space: normal; background-color: rgb(255, 255, 255);\">&nbsp;; extension_dir = &quot;ext&quot;</p><p style=\"margin-top: 0px; margin-bottom: 16px; padding: 0px; box-sizing: border-box; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; font-family: &quot;PingFang SC&quot;, &quot;Microsoft YaHei&quot;, SimHei, Arial, SimSun; white-space: normal; background-color: rgb(255, 255, 255);\">&nbsp; &nbsp;;extension=php_bz2.dll</p><p style=\"margin-top: 0px; margin-bottom: 16px; padding: 0px; box-sizing: border-box; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; font-family: &quot;PingFang SC&quot;, &quot;Microsoft YaHei&quot;, SimHei, Arial, SimSun; white-space: normal; background-color: rgb(255, 255, 255);\">&nbsp; &nbsp;;extension=php_curl.dll</p><p style=\"margin-top: 0px; margin-bottom: 16px; padding: 0px; box-sizing: border-box; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; font-family: &quot;PingFang SC&quot;, &quot;Microsoft YaHei&quot;, SimHei, Arial, SimSun; white-space: normal; background-color: rgb(255, 255, 255);\">&nbsp; &nbsp;;extension=php_mbstring.dll<br/></p><p style=\"margin-top: 0px; margin-bottom: 16px; padding: 0px; box-sizing: border-box; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; font-family: &quot;PingFang SC&quot;, &quot;Microsoft YaHei&quot;, SimHei, Arial, SimSun; white-space: normal; background-color: rgb(255, 255, 255);\">&nbsp; &nbsp;;extension=php_mysqli.dll<br/></p><p style=\"margin-top: 0px; margin-bottom: 16px; padding: 0px; box-sizing: border-box; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; font-family: &quot;PingFang SC&quot;, &quot;Microsoft YaHei&quot;, SimHei, Arial, SimSun; white-space: normal; background-color: rgb(255, 255, 255);\">&nbsp; &nbsp;;extension=php_openssl.dll<br/></p><p style=\"margin-top: 0px; margin-bottom: 16px; padding: 0px; box-sizing: border-box; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; font-family: &quot;PingFang SC&quot;, &quot;Microsoft YaHei&quot;, SimHei, Arial, SimSun; white-space: normal; background-color: rgb(255, 255, 255);\">&nbsp; &nbsp;;extension=php_pdo_mysql.dll</p><p><br/></p>');
  INSERT INTO `article_content` VALUES (24, '<h3 style=\"box-sizing: border-box; border: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Hiragino Sans GB W3&quot;, &quot;WenQuanYi Micro Hei&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, sans-serif; font-size: 24px; font-weight: 500; margin: 20px 0px 10px; outline: 0px; padding: 0px; vertical-align: baseline; clear: both; line-height: 1.1; color: rgb(51, 51, 51); white-space: normal; background-color: rgb(255, 255, 255);\"><strong style=\"box-sizing: border-box;\">连接（Join）</strong></h3><h4 style=\"box-sizing: border-box; border: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Hiragino Sans GB W3&quot;, &quot;WenQuanYi Micro Hei&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, sans-serif; font-size: 18px; font-weight: 500; margin: 10px 0px; outline: 0px; padding: 0px; vertical-align: baseline; clear: both; line-height: 1.1; color: rgb(51, 51, 51); white-space: normal; background-color: rgb(255, 255, 255);\"><strong style=\"box-sizing: border-box; border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">&nbsp;内连接（等值连接）</strong></h4><p style=\"box-sizing: border-box; border: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Hiragino Sans GB W3&quot;, &quot;WenQuanYi Micro Hei&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, sans-serif; font-size: 14px; margin-top: 0px; margin-bottom: 10px; outline: 0px; padding: 0px; vertical-align: baseline; color: rgb(51, 51, 51); white-space: normal; background-color: rgb(255, 255, 255);\">查询构建器还可以用于编写基本的SQL“内连接”，你可以使用查询构建器实例上的<code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">join</code>方法，传递给<code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">join</code>方法的第一次参数是你需要连接到的表名，剩余的其它参数则是为连接指定的列约束，当然，正如你所看到的，你可以在单个查询中连接多张表：</p><pre style=\"box-sizing: border-box; border: 1px solid rgb(204, 204, 204); font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 13px; margin-top: 10px; margin-bottom: 10px; outline: 0px; padding: 9.5px; vertical-align: baseline; background-color: rgb(245, 245, 245); line-height: 1.42857; max-width: 100%; overflow: auto; white-space: pre-wrap; color: rgb(51, 51, 51); word-break: break-all; word-wrap: break-word; border-radius: 4px;\">$users&nbsp;=&nbsp;DB::table(&#39;users&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;join(&#39;contacts&#39;,&nbsp;&#39;users.id&#39;,&nbsp;&#39;=&#39;,&nbsp;&#39;contacts.user_id&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;join(&#39;orders&#39;,&nbsp;&#39;users.id&#39;,&nbsp;&#39;=&#39;,&nbsp;&#39;orders.user_id&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;select(&#39;users.*&#39;,&nbsp;&#39;contacts.phone&#39;,&nbsp;&#39;orders.price&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;get();</pre><h4 style=\"box-sizing: border-box; border: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Hiragino Sans GB W3&quot;, &quot;WenQuanYi Micro Hei&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, sans-serif; font-size: 18px; font-weight: 500; margin: 10px 0px; outline: 0px; padding: 0px; vertical-align: baseline; clear: both; line-height: 1.1; color: rgb(51, 51, 51); white-space: normal; background-color: rgb(255, 255, 255);\"><strong style=\"box-sizing: border-box; border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">&nbsp;左连接</strong></h4><p style=\"box-sizing: border-box; border: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Hiragino Sans GB W3&quot;, &quot;WenQuanYi Micro Hei&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, sans-serif; font-size: 14px; margin-top: 0px; margin-bottom: 10px; outline: 0px; padding: 0px; vertical-align: baseline; color: rgb(51, 51, 51); white-space: normal; background-color: rgb(255, 255, 255);\">如果你是想要执行“左连接”而不是“内连接”，可以使用<code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">leftJoin</code>方法。该方法和<code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">join</code>方法的使用方法一样：</p><pre style=\"box-sizing: border-box; border: 1px solid rgb(204, 204, 204); font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 13px; margin-top: 10px; margin-bottom: 10px; outline: 0px; padding: 9.5px; vertical-align: baseline; background-color: rgb(245, 245, 245); line-height: 1.42857; max-width: 100%; overflow: auto; white-space: pre-wrap; color: rgb(51, 51, 51); word-break: break-all; word-wrap: break-word; border-radius: 4px;\">$users&nbsp;=&nbsp;DB::table(&#39;users&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;leftJoin(&#39;posts&#39;,&nbsp;&#39;users.id&#39;,&nbsp;&#39;=&#39;,&nbsp;&#39;posts.user_id&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;get();</pre><h4 style=\"box-sizing: border-box; border: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Hiragino Sans GB W3&quot;, &quot;WenQuanYi Micro Hei&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, sans-serif; font-size: 18px; font-weight: 500; margin: 10px 0px; outline: 0px; padding: 0px; vertical-align: baseline; clear: both; line-height: 1.1; color: rgb(51, 51, 51); white-space: normal; background-color: rgb(255, 255, 255);\"><strong style=\"box-sizing: border-box; border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">&nbsp;高级连接语句</strong></h4><p style=\"box-sizing: border-box; border: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Hiragino Sans GB W3&quot;, &quot;WenQuanYi Micro Hei&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, sans-serif; font-size: 14px; margin-top: 0px; margin-bottom: 10px; outline: 0px; padding: 0px; vertical-align: baseline; color: rgb(51, 51, 51); white-space: normal; background-color: rgb(255, 255, 255);\">你还可以指定更多的高级连接子句，传递一个闭包到<code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">join</code>方法作为该方法的第2个参数，该闭包将会返回允许你指定<code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">join</code>子句约束的<code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">JoinClause</code>对象：</p><pre style=\"box-sizing: border-box; border: 1px solid rgb(204, 204, 204); font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 13px; margin-top: 10px; margin-bottom: 10px; outline: 0px; padding: 9.5px; vertical-align: baseline; background-color: rgb(245, 245, 245); line-height: 1.42857; max-width: 100%; overflow: auto; white-space: pre-wrap; color: rgb(51, 51, 51); word-break: break-all; word-wrap: break-word; border-radius: 4px;\">DB::table(&#39;users&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;join(&#39;contacts&#39;,&nbsp;function&nbsp;($join)&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$join-&gt;on(&#39;users.id&#39;,&nbsp;&#39;=&#39;,&nbsp;&#39;contacts.user_id&#39;)-&gt;orOn(...);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;})\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;get();</pre><p style=\"box-sizing: border-box; border: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Hiragino Sans GB W3&quot;, &quot;WenQuanYi Micro Hei&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, sans-serif; font-size: 14px; margin-top: 0px; margin-bottom: 10px; outline: 0px; padding: 0px; vertical-align: baseline; color: rgb(51, 51, 51); white-space: normal; background-color: rgb(255, 255, 255);\">如果你想要在连接中使用“where”风格的子句，可以在查询中使用<code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">where</code>和<code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">orWhere</code>方法。这些方法将会将列和值进行比较而不是列和列进行比较：</p><pre style=\"box-sizing: border-box; border: 1px solid rgb(204, 204, 204); font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 13px; margin-top: 10px; margin-bottom: 10px; outline: 0px; padding: 9.5px; vertical-align: baseline; background-color: rgb(245, 245, 245); line-height: 1.42857; max-width: 100%; overflow: auto; white-space: pre-wrap; color: rgb(51, 51, 51); word-break: break-all; word-wrap: break-word; border-radius: 4px;\">DB::table(&#39;users&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;join(&#39;contacts&#39;,&nbsp;function&nbsp;($join)&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$join-&gt;on(&#39;users.id&#39;,&nbsp;&#39;=&#39;,&nbsp;&#39;contacts.user_id&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;where(&#39;contacts.user_id&#39;,&nbsp;&#39;&gt;&#39;,&nbsp;5);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;})\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;get();</pre><h3 style=\"box-sizing: border-box; border: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Hiragino Sans GB W3&quot;, &quot;WenQuanYi Micro Hei&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, sans-serif; font-size: 24px; font-weight: 500; margin: 20px 0px 10px; outline: 0px; padding: 0px; vertical-align: baseline; clear: both; line-height: 1.1; color: rgb(51, 51, 51); white-space: normal; background-color: rgb(255, 255, 255);\"><strong style=\"box-sizing: border-box;\">联合（Union）</strong></h3><p style=\"box-sizing: border-box; border: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Hiragino Sans GB W3&quot;, &quot;WenQuanYi Micro Hei&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, sans-serif; font-size: 14px; margin-top: 0px; margin-bottom: 10px; outline: 0px; padding: 0px; vertical-align: baseline; color: rgb(51, 51, 51); white-space: normal; background-color: rgb(255, 255, 255);\">查询构建器还提供了一条“联合”两个查询的快捷方式，比如，你要创建一个独立的查询，然后使用<code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">union</code>方法将其和第二个查询进行联合：</p><pre style=\"box-sizing: border-box; border: 1px solid rgb(204, 204, 204); font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 13px; margin-top: 10px; margin-bottom: 10px; outline: 0px; padding: 9.5px; vertical-align: baseline; background-color: rgb(245, 245, 245); line-height: 1.42857; max-width: 100%; overflow: auto; white-space: pre-wrap; color: rgb(51, 51, 51); word-break: break-all; word-wrap: break-word; border-radius: 4px;\">$first&nbsp;=&nbsp;DB::table(&#39;users&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;whereNull(&#39;first_name&#39;);\r\n\r\n$users&nbsp;=&nbsp;DB::table(&#39;users&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;whereNull(&#39;last_name&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;union($first)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;get();</pre><p style=\"box-sizing: border-box; border: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Hiragino Sans GB W3&quot;, &quot;WenQuanYi Micro Hei&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, sans-serif; font-size: 14px; margin-top: 0px; margin-bottom: 10px; outline: 0px; padding: 0px; vertical-align: baseline; color: rgb(51, 51, 51); white-space: normal; background-color: rgb(255, 255, 255);\"><code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">unionAll</code>方法也是有效的，并且和<code style=\"box-sizing: border-box; border: 0px; font-family: Monaco, Menlo, Consolas, &quot;Courier New&quot;, monospace; font-size: 12.6px; margin: 0px; outline: 0px; padding: 2px 4px; vertical-align: baseline; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal; color: rgb(244, 100, 95); background-color: rgb(249, 242, 244); border-radius: 4px;\">union</code>有同样的使用方法。</p><p><br/></p>');
  INSERT INTO `article_content` VALUES (25, '<p><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">1.只能输入和粘贴汉字&nbsp;</span></strong><br/><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">&lt;input onkeyup=&quot;value=value.replace(/[^\\u4E00-\\u9FA5]/g,&#39;&#39;)&quot; onbeforepaste=&quot;clipboardData.setData(&#39;text&#39;,clipboardData.getData(&#39;text&#39;).replace(/[^\\u4E00-\\u9FA5]/g,&#39;&#39;))&quot;&gt;&lt;br/&gt;&nbsp;</span><br/><br/><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">3.只能输入和粘贴数字&nbsp;</span></strong><br/><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">&lt;input onkeyup=&quot;this.value=this.value.replace(/\\D/g,&#39;&#39;)&quot; onafterpaste=&quot;this.value=this.value.replace(/\\D/g,&#39;&#39;)&quot; /&gt;&lt;br/&gt;&nbsp;</span></p><p><font color=\"#222222\" face=\"tahoma, arial, Microsoft YaHei\"><span style=\"font-size: 14px;\"><br/></span></font><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">5.数字脚本&nbsp;</span></strong><br/><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">&lt;input onkeyup=&quot;if(/\\D/.test(this.value)){alert(&#39;只能输入数字&#39;);this.value=&#39;&#39;;}&quot;&gt;&lt;br/&gt;&nbsp;</span><br/><br/><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">6.只能输入数字和英文&nbsp;</span></strong><br/><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">&lt;input onkeyup=&quot;value=value.replace(/[\\W]/g,&#39;&#39;) &quot; onbeforepaste=&quot;clipboardData.setData(&#39;text&#39;,clipboardData.getData(&#39;text&#39;).replace(/[^\\d]/g,&#39;&#39;))&quot;&gt;&lt;br/&gt;&nbsp;</span><br/><br/><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">8.简易禁止输入汉字</span></strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">&nbsp;</span><br/><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">&lt;input style=&quot;ime-mode:disabled&quot;&gt;输入法不转换，但可粘贴上&lt;br/&gt;&nbsp;</span><br/><br/><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">9.输入数字和小数点&nbsp;</span></strong><br/><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">&lt;input onkeyup=&quot;value=value.replace(/[^\\d{1,}\\.\\d{1,}|\\d{1,}]/g,&#39;&#39;)&quot; /&gt;&lt;br/&gt;&nbsp;</span><br/><br/><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">10.只能数字和&quot;-&quot;,例如在输入时间的时候可以用到&nbsp;</span></strong><br/><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">&lt;input onkeyup=&quot;value=value.replace(/[^\\w&amp;=]|_/ig,&#39;&#39;)&quot; onblur=&quot;value=value.replace(/[^\\w&amp;-]|_/ig,&#39;&#39;)&quot; /&gt;&nbsp;</span></p>');
  INSERT INTO `article_content` VALUES (26, '<p><span style=\"font-size: 20px; color: rgb(255, 0, 0);\">查询语句</span></p><p><strong><span style=\"font-size: 14px;\">1.<span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">检索表中的所有行</span></span></strong></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;get();</span></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;foreach ($users as $user){&nbsp;var_dump($user-&gt;name);}</span></p><p><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">2.从表检索单个行</span></strong></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;$user = DB::table(&#39;users&#39;)-&gt;where(&#39;name&#39;, &#39;John&#39;)-&gt;first();<br/>&nbsp;&nbsp;&nbsp;&nbsp;var_dump($user-&gt;name);</span></p><p><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">3.检索单个列的行</span></strong></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;$name = DB::table(&#39;users&#39;)-&gt;where(&#39;name&#39;, &#39;John&#39;)-&gt;pluck(&#39;name&#39;);</span></p><p><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">4.检索一个列值列表</span></strong></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;$roles = DB::table(&#39;roles&#39;)-&gt;lists(&#39;title&#39;);</span></p><p><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">5.该方法将返回一个数组标题的作用。你也可以指定一个自定义的键列返回的数组</span></strong></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;$roles = DB::table(&#39;roles&#39;)-&gt;lists(&#39;title&#39;, &#39;name&#39;);</span></p><p><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">6.指定一个Select子句</span></strong></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;select(&#39;name&#39;, &#39;email&#39;)-&gt;get();<br/>&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;distinct()-&gt;get();<br/>&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;select(&#39;name as user_name&#39;)-&gt;get();</span></p><p><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">7.Select子句添加到一个现有的查询$query = DB::table(&#39;users&#39;)-&gt;select(&#39;name&#39;);</span></strong></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;$users = $query-&gt;addSelect(&#39;age&#39;)-&gt;get();</span></p><p><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">8.where</span></strong></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;where(&#39;votes&#39;, &#39;&gt;&#39;, 100)-&gt;get();</span></p><p><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">9.OR</span></strong></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;where(&#39;votes&#39;, &#39;&gt;&#39;, 100)-&gt;orWhere(&#39;name&#39;, &#39;John&#39;)-&gt;get();</span></p><p><strong><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">10.Where Between</span></strong></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;whereBetween(&#39;votes&#39;, array(1, 100))-&gt;get();</span></p><p><strong><span style=\"font-size: 14px;\">11.Where Not Between</span></strong></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;whereNotBetween(&#39;votes&#39;, array(1, 100))-&gt;get();</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; line-height: 30px; color: rgb(34, 34, 34); white-space: normal; background-color: rgb(255, 255, 255);\"><strong><span style=\"font-size: 14px;\">12.Where In With An Array</span></strong><span style=\"font-size: 14px;\"><span style=\"font-family: tahoma, arial, \"><br/></span><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\"><span style=\"background-color: rgb(215, 227, 188); font-family: sans-serif; font-size: 16px;\">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;whereIn(&#39;id&#39;, array(1, 2, 3))-&gt;get();<br/></span>&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;whereNotIn(&#39;id&#39;, array(1, 2, 3))-&gt;get();</span></span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">13.Using Where Null To Find Records With Unset Values</span></strong></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;whereNull(&#39;updated_at&#39;)-&gt;get();</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">14.Order By, Group By, And Having</span></strong><span style=\"font-size: 14px;\"><br/></span></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp; &nbsp; $users = DB::table(&#39;users&#39;)-&gt;orderBy(&#39;name&#39;, &#39;desc&#39;)-&gt;groupBy(&#39;count&#39;)-&gt;having(&#39;count&#39;, &#39;&gt;&#39;, 100)-&gt;get();</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">15.Offset &amp; Limit</span></strong></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;skip(10)-&gt;take(5)-&gt;get();</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 20px; color: rgb(255, 0, 0);\">连接查询语句</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 14px;\"><strong>1.Joins</strong></span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \">查询构建器也可以用来编写连接语句。看看下面的例子:<br/></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"background-color: rgb(215, 227, 188);\"><span style=\"background-color: rgb(215, 227, 188); font-family: sans-serif; font-size: 14px;\">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)</span><span style=\"background-color: rgb(215, 227, 188); font-family: sans-serif;\">-&gt;join(&#39;contacts&#39;, &#39;users.id&#39;, &#39;=&#39;, &#39;contacts.user_id&#39;)-&gt;join(&#39;orders&#39;, &#39;users.id&#39;, &#39;=&#39;, &#39;orders.user_id&#39;)-&gt;select(&#39;users.id&#39;, &#39;contacts.phone&#39;, &#39;orders.price&#39;)-&gt;get();</span></span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">2.左连接语句</span></strong></p><p><span style=\"line-height: 25.2px; float: right; font-size: 14px;\"><a class=\"copybut\" style=\"color: rgb(51, 51, 51); cursor: pointer;\"><span style=\"font-size: 14px; line-height: 25.2px; float: right; text-decoration: underline;\">复制代码</span></a></span></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;leftJoin(&#39;posts&#39;, &#39;users.id&#39;, &#39;=&#39;, &#39;posts.user_id&#39;)-&gt;get();<br/>&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;join(&#39;contacts&#39;, function($join){<br/>　　&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$join-&gt;on(&#39;users.id&#39;, &#39;=&#39;, &#39;contacts.user_id&#39;)-&gt;orOn(...);<br/>　&nbsp;&nbsp;&nbsp;&nbsp;　})-&gt;get();<br/>&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;join(&#39;contacts&#39;, function($join){<br/>&nbsp;&nbsp;&nbsp;&nbsp;　　&nbsp;&nbsp;&nbsp;&nbsp;$join-&gt;on(&#39;users.id&#39;, &#39;=&#39;, &#39;contacts.user_id&#39;)-&gt;where(&#39;contacts.user_id&#39;, &#39;&gt;&#39;, 5);<br/>　&nbsp;&nbsp;&nbsp;&nbsp;　})-&gt;get();</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">3.分组</span></strong></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 14px;\">有时候,您可能需要创建更高级的where子句,如“存在”或嵌套参数分组。Laravel query builder可以处理这些:</span></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\"><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;where(&#39;name&#39;, &#39;=&#39;, &#39;John&#39;)-&gt;orWhere(function($query){</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$query-&gt;where(&#39;votes&#39;, &#39;&gt;&#39;, 100)-&gt;where(&#39;title&#39;, &#39;&lt;&gt;&#39;, &#39;Admin&#39;);</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">&nbsp;&nbsp;&nbsp;&nbsp;})-&gt;get();</span></span></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">上面的查询将产生以下SQL:</span></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\"><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">　　select * from users where name = &#39;John&#39; or (votes &gt; 100 and title&nbsp;&lt;&gt; &#39;Admin&#39;)</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">　　Exists Statements</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">　　DB::table(&#39;users&#39;)</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">　　-&gt;whereExists(function($query)</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">　　{</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">　　$query-&gt;select(DB::raw(1))</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">　　-&gt;from(&#39;orders&#39;)</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">　　-&gt;whereRaw(&#39;orders.user_id = users.id&#39;);</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">　　})</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">　　-&gt;get();</span></span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 14px;\">上面的查询将产生以下SQL:</span></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\"><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">select * from userswhere exists (</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">select 1 from orders where orders.user_id = users.id</span><br/><span style=\"background-color: rgb(215, 227, 188); color: rgb(34, 34, 34); font-family: tahoma, arial, \">)</span></span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">4.聚合</span></strong></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 14px;\">查询构建器还提供了各种聚合方法,如统计,max,min,avg和总和。</span></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;count();<br/>&nbsp;&nbsp;&nbsp;&nbsp;$price = DB::table(&#39;orders&#39;)-&gt;max(&#39;price&#39;);<br/>&nbsp;&nbsp;&nbsp;&nbsp;$price = DB::table(&#39;orders&#39;)-&gt;min(&#39;price&#39;);<br/>&nbsp;&nbsp;&nbsp;&nbsp;$price = DB::table(&#39;orders&#39;)-&gt;avg(&#39;price&#39;);<br/>&nbsp;&nbsp;&nbsp;&nbsp;$total = DB::table(&#39;users&#39;)-&gt;sum(&#39;votes&#39;);</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 14px;\">有时您可能需要使用一个原始表达式的查询。这些表达式将注入的查询字符串,所以小心不要创建任何SQL注入点!创建一个原始表达式,可以使用DB:rawmethod:</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 14px;\">Using A Raw Expression</span></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)<br/>&nbsp;&nbsp;&nbsp;&nbsp;-&gt;select(DB::raw(&#39;count(*) as user_count, status&#39;))<br/>&nbsp;&nbsp;&nbsp;&nbsp;-&gt;where(&#39;status&#39;, &#39;&lt;&gt;&#39;, 1)<br/>&nbsp;&nbsp;&nbsp;&nbsp;-&gt;groupBy(&#39;status&#39;)<br/>&nbsp;&nbsp;&nbsp;&nbsp;-&gt;get();</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">5.递增或递减一个列的值</span></strong></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;increment(&#39;votes&#39;);<br/>&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;increment(&#39;votes&#39;, 5);<br/>&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;decrement(&#39;votes&#39;);<br/>&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;decrement(&#39;votes&#39;, 5);</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">6.您还可以指定额外的列更新:</span></strong></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;increment(&#39;votes&#39;, 1, array(&#39;name&#39; =&gt; &#39;John&#39;));</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 20px; color: rgb(255, 0, 0);\">插入语句</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">1.将记录插入表</span></strong></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;insert(array(&#39;email&#39; =&gt; &#39;john@example.com&#39;, &#39;votes&#39; =&gt; 0));</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">2.将记录插入表自动增加的ID</span></strong></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 14px;\">如果表,有一个自动递增的id字段使用insertGetId插入一个记录和检索id:</span></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;$id = DB::table(&#39;users&#39;)-&gt;insertGetId(array(&#39;email&#39; =&gt; &#39;john@example.com&#39;, &#39;votes&#39; =&gt; 0));</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 14px;\">注意:当使用PostgreSQL insertGetId方法预计,自增列被命名为“id”。</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">3.多个记录插入到表中</span></strong><span style=\"font-size: 14px;\"><br/></span></p><p><span style=\"background-color: rgb(215, 227, 188); font-size: 14px;\">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;insert(array(array(&#39;email&#39; =&gt; &#39;taylor@example.com&#39;, &#39;votes&#39; =&gt; 0),array(&#39;email&#39; =&gt; &#39;dayle@example.com&#39;, &#39;votes&#39; =&gt; 0),));</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 20px; color: rgb(255, 0, 0);\">更新语句</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"color: rgb(0, 0, 0);\"><strong><span style=\"font-size: 14px;\">1.更新一个表中的记录</span></strong></span></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;where(&#39;id&#39;, 1)-&gt;update(array(&#39;votes&#39; =&gt; 1));</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 20px; color: rgb(255, 0, 0);\">删除语句</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">1.删除表中的记录</span></strong></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;where(&#39;votes&#39;, &#39;</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><strong><span style=\"font-size: 14px;\">2.删除表中的所有记录</span></strong></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"background-color: rgb(215, 227, 188); font-family: sans-serif;\">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;delete();</span></p><p><strong><span style=\"font-size: 14px; background-color: rgb(255, 255, 255);\">3.删除一个表</span></strong></p><p><span style=\"font-size: 14px; background-color: rgb(215, 227, 188);\">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;truncate();</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 20px; color: rgb(255, 0, 0);\">Unions语句</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 14px;\">查询构建器还提供了一种快速的方法来“联盟”两个查询:</span></p><p><span style=\"font-size: 14px; background-color: rgb(195, 214, 155);\">　$first = DB::table(&#39;users&#39;)-&gt;whereNull(&#39;first_name&#39;);</span></p><p><span style=\"font-size: 14px; background-color: rgb(195, 214, 155);\">&nbsp; &nbsp;$users =&nbsp;DB::table(&#39;users&#39;)-&gt;whereNull(&#39;last_name&#39;)-&gt;union($first)-&gt;get();</span><span style=\"font-size: 14px;\"><br/></span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \">unionAll方法也可以,有相同的方法签名。</p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \">Pessimistic Locking</p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 14px;\">查询构建器包括一些“悲观锁定”功能来帮助你做你的SELECT语句。运行SELECT语句“共享锁”,你可以使用sharedLock方法查询:</span></p><p><span style=\"font-size: 14px; background-color: rgb(195, 214, 155);\">&nbsp;&nbsp;&nbsp;&nbsp;DB::table(&#39;users&#39;)-&gt;where(&#39;votes&#39;, &#39;&gt;&#39;,&nbsp;100)-&gt;sharedLock()-&gt;get();</span></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">更新“锁”在一个SELECT语句,您可以使用lockForUpdate方法查询:</span></p><p><span style=\"background-color: rgb(195, 214, 155);\">&nbsp;&nbsp;&nbsp;&nbsp;<span style=\"background-color: rgb(195, 214, 155); font-size: 14px;\">DB::table(&#39;users&#39;)-&gt;where(&#39;votes&#39;, &#39;&gt;&#39;, 100)-&gt;lockForUpdate()-&gt;get();</span></span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 20px; color: rgb(255, 0, 0);\">缓存查询语句</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, \"><span style=\"font-size: 14px;\">你可以轻松地缓存查询的结果使用记忆法:</span></p><p><span style=\"font-size: 14px; background-color: rgb(195, 214, 155);\">&nbsp;&nbsp;&nbsp;&nbsp;$users = DB::table(&#39;users&#39;)-&gt;remember(10)-&gt;get();</span><span style=\"font-size: 14px;\"><br/></span></p><p><br/><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">在本例中,查询的结果将为十分钟被缓存。查询结果缓存时,不会对数据库运行,结果将从默认的缓存加载驱动程序指定您的应用程序。　　</span></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \">如果您使用的是支持缓存的司机,还可以添加标签来缓存:<br/></span></p><p><span style=\"font-size: 14px; background-color: rgb(195, 214, 155);\">$users = DB::table(&#39;users&#39;)-&gt;cacheTags(array(&#39;people&#39;, &#39;authors&#39;))-&gt;remember(10)-&gt;get();</span><span style=\"font-size: 14px;\"><br/></span></p><p><span style=\"color: rgb(34, 34, 34); font-family: tahoma, arial, \"><br/><br/></span></p>');
  INSERT INTO `article_content` VALUES (27, '<p style=\"line-height: 1.5em; margin-bottom: 10px; text-align: justify; text-indent: 0em;\"><span style=\"font-family: 微软雅黑, \"><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">在做web前端开发时，我们必须要知道客户端和服务端是如何通信的，通俗简单点就是 &nbsp;请求（客户端） &nbsp;R11;&gt; 响应 （服务端）的过程，可是客户端又是如何向服务端如何请求的呢？而服务端又是如何响应的呢，响应的信息又是不是我们想要的呢？带着问题往下看吧。</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">HTTP(HyperText Transfer Protocol)是一套计算机通过网络进行通信的规则。计算机专家设计出HTTP，使HTTP客户（如Web浏览器）能够从HTTP服务器(Web服务器)请求信息和服务，HTTP协议目前的版本是1.1.HTTP是一种无状态的协议，无状态是指Web浏览器和Web服务器之间不需要建立持久的连接，这意味着当一个客户端向服务器端发出请求，然后Web服务器返回响应(response)，连接就被关闭了，在服务器端不保留连接的有关信息.HTTP遵循请求(Request)/应答(Response)模型。Web浏览器向Web服务器发送请求，Web服务器处理请求并返回适当的应答。所有HTTP连接都被构造成一套请求和应答。</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">HTTP使用内容类型，是指Web服务器向Web浏览器返回的文件都有与之相关的类型。所有这些类型在MIMEInternet邮件协议上模型化，即Web服务器告诉Web浏览器该文件所具有的种类，是HTML文档、GIF格式图像、声音文件还是独立的应用程序。大多数Web浏览器都拥有一系列的可配置的辅助应用程序，它们告诉浏览器应该如何处理Web服务器发送过来的各种内容类型。</span></span></p><p style=\"line-height: 1.5em; margin-bottom: 10px; text-align: justify; text-indent: 0em;\"><span style=\"font-family: 微软雅黑, \"><span style=\"color:#333333\"><br/></span><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">HTTP通信机制是在一次完整的HTTP通信过程中，Web浏览器与Web服务器之间将完成下列7个步骤：</span><br/><span style=\"font-family: 微软雅黑, \">（1）&nbsp;建立TCP连接</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">在HTTP工作开始之前，Web浏览器首先要通过网络与Web服务器建立连接，该连接是通过TCP来完成的，该协议与IP协议共同构建Internet，即著名的TCP/IP协议族，因此Internet又被称作是TCP/IP网络。HTTP是比TCP更高层次的应用层协议，根据规则，只有低层协议建立之后才能，才能进行更层协议的连接，因此，首先要建立TCP连接，一般TCP连接的端口号是80</span><br/><span style=\"font-family: 微软雅黑, \">（2）&nbsp;Web浏览器向Web服务器发送请求命令</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">一旦建立了TCP连接，Web浏览器就会向Web服务器发送请求命令</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">例如：GET/sample/hello.jsp HTTP/1.1</span><br/><span style=\"font-family: 微软雅黑, \">（3）&nbsp;Web浏览器发送请求头信息</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">浏览器发送其请求命令之后，还要以头信息的形式向Web服务器发送一些别的信息，之后浏览器发送了一空白行来通知服务器，它已经结束了该头信息的发送。</span><br/><span style=\"font-family: 微软雅黑, \">（4）&nbsp;Web服务器应答</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">客户机向服务器发出请求后，服务器会客户机回送应答，</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">HTTP/1.1 200 OK</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">应答的第一部分是协议的版本号和应答状态码</span><br/><span style=\"font-family: 微软雅黑, \">（5）&nbsp;Web服务器发送应答头信息</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">正如客户端会随同请求发送关于自身的信息一样，服务器也会随同应答向用户发送关于它自己的数据及被请求的文档。</span><br/><span style=\"font-family: 微软雅黑, \">（6）&nbsp;Web服务器向浏览器发送数据</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Web服务器向浏览器发送头信息后，它会发送一个空白行来表示头信息的发送到此为结束，接着，它就以Content-Type应答头信息所描述的格式发送用户所请求的实际数据</span><br/><span style=\"font-family: 微软雅黑, \">（7）&nbsp;Web服务器关闭TCP连接</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">一般情况下，一旦Web服务器向浏览器发送了请求数据，它就要关闭TCP连接，然后如果浏览器或者服务器在其头信息加入了这行代码</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Connection:keep-alive</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">TCP连接在发送后将仍然保持打开状态，于是，浏览器可以继续通过相同的连接发送请求。保持连接节省了为每个请求建立新连接所需的时间，还节约了网络带宽。</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">HTTP请求格式</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">当浏览器向Web服务器发出请求时，它向服务器传递了一个数据块，也就是请求信息，HTTP请求信息由3部分组成：</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">l&nbsp;请求方法URI协议/版本</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">l&nbsp;请求头(Request Header)</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">l&nbsp;请求正文</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">下面是一个HTTP请求的例子：</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">GET/sample.jspHTTP/1.1</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Accept:image/gif.image/jpeg,</span><span style=\"box-sizing: border-box; color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">/</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Accept-Language:zh-cn</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Connection:Keep-Alive</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Host:localhost</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">User-Agent:Mozila/4.0(compatible;MSIE5.01;Window NT5.0)</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Accept-Encoding:gzip,deflate</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">username=jinqiao&amp;password=1234</span><br/><span style=\"font-family: 微软雅黑, \">（1）&nbsp;请求方法URI协议/版本</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">请求的第一行是“方法URL议/版本”：GET/sample.jsp HTTP/1.1</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">以上代码中“GET”代表请求方法，“/sample.jsp”表示URI，“HTTP/1.1代表协议和协议的版本。</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">根据HTTP标准，HTTP请求可以使用多种请求方法。例如：HTTP1.1支持7种请求方法：GET、POST、HEAD、OPTIONS、PUT、DELETE和TARCE。在Internet应用中，最常用的方法是GET和POST。</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">URL完整地指定了要访问的网络资源，通常只要给出相对于服务器的根目录的相对目录即可，因此总是以“/”开头，最后，协议版本声明了通信过程中使用HTTP的版本。</span><br/><span style=\"font-family: 微软雅黑, \">（2）请求头(Request Header)</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">请求头包含许多有关的客户端环境和请求正文的有用信息。例如，请求头可以声明浏览器所用的语言，请求正文的长度等。</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Accept:image/gif.image/jpeg.</span><span style=\"box-sizing: border-box; color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">/</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Accept-Language:zh-cn</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Connection:Keep-Alive</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Host:localhost</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">User-Agent:Mozila/4.0(compatible:MSIE5.01:Windows NT5.0)</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Accept-Encoding:gzip,deflate.</span><br/><span style=\"font-family: 微软雅黑, \">（3）请求正文</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">请求头和请求正文之间是一个空行，这个行非常重要，它表示请求头已经结束，接下来的是请求正文。请求正文中可以包含客户提交的查询字符串信息：</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">username=jinqiao&amp;password=1234</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">在以上的例子的HTTP请求中，请求的正文只有一行内容。当然，在实际应用中，HTTP请求正文可以包含更多的内容。</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">HTTP请求方法我这里只讨论GET方法与POST方法</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">l&nbsp;GET方法</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">GET方法是默认的HTTP请求方法，我们日常用GET方法来提交表单数据，然而用GET方法提交的表单数据只经过了简单的编码，同时它将作为URL的一部分向Web服务器发送，因此，如果使用GET方法来提交表单数据就存在着安全隐患上。例如</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Http://127.0.0.1/login.jsp?Name=zhangshi&amp;Age=30&amp;Submit=%cc%E+%BD%BB</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">从上面的URL请求中，很容易就可以辩认出表单提交的内容。（？之后的内容）另外由于GET方法提交的数据是作为URL请求的一部分所以提交的数据量不能太大</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">l&nbsp;POST方法</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">POST方法是GET方法的一个替代方法，它主要是向Web服务器提交表单数据，尤其是大批量的数据。POST方法克服了GET方法的一些缺点。通过POST方法提交表单数据时，数据不是作为URL请求的一部分而是作为标准数据传送给Web服务器，这就克服了GET方法中的信息无法保密和数据量太小的缺点。因此，出于安全的考虑以及对用户隐私的尊重，通常表单提交时采用POST方法。</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">从编程的角度来讲，如果用户通过GET方法提交数据，则数据存放在QUERY＿STRING环境变量中，而POST方法提交的数据则可以从标准输入流中获取。</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">HTTP应答与HTTP请求相似，HTTP响应也由3个部分构成，分别是：</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">l&nbsp;协议状态版本代码描述</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">l&nbsp;响应头(Response Header)</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">l&nbsp;响应正文</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">下面是一个HTTP响应的例子：</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">HTTP/1.1 200 OK</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Server:Apache Tomcat/5.0.12</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Date:Mon,6Oct2003 13:23:42 GMT</span><br/><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Content-Length:112</span></span></p>');
  INSERT INTO `article_content` VALUES (28, '<p>tp5框架public里面，编写.htaccess文件</p><pre style=\"background-color: rgb(255, 255, 255); font-family: 宋体; font-size: 9pt;\">&lt;IfModule&nbsp;mod_rewrite.c&gt;\r\n&nbsp;&nbsp;Options&nbsp;+FollowSymlinks&nbsp;-Multiviews\r\n&nbsp;&nbsp;RewriteEngine&nbsp;On\r\n&nbsp;&nbsp;RewriteCond&nbsp;%{REQUEST_FILENAME}&nbsp;!-d\r\n&nbsp;&nbsp;RewriteCond&nbsp;%{REQUEST_FILENAME}&nbsp;!-f\r\n&nbsp;&nbsp;RewriteRule&nbsp;^(.*)$&nbsp;index.php&nbsp;[L,E=PATH_INFO:$1]\r\n&lt;/IfModule&gt;</pre><p>修改配置文件即可</p>');
  INSERT INTO `article_content` VALUES (29, '<p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \">示例时间戳1483203661：2017.01.01 01:01:01</p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;Y&#39;,1483203661)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;&nbsp;&nbsp; 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">年，四位数</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;y&#39;,1483203661)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">年，后两位数</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;m&#39;,1483203661)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;&nbsp;&nbsp; 01 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">月，两位数，不足两位前面补零</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;n&#39;,1483203661)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">月，不足两位不补零</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;M&#39;,1483203661);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;&nbsp;&nbsp; Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">月，英文三个字母</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;F&#39;,1483203661);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt;&nbsp;&nbsp; January&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">月，英文全名</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;d&#39;,1483203661)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">日，不足两位前面补零</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">8.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;j&#39;,1483203661)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">日，不足两位前面不补零</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">9.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;H&#39;,1483203661)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">时，</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">24</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">小时制，不足两位数前面补零</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">10.&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;h’,1483203661)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">时，</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">12</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">小时制，不足两位数前面补零</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">11.&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;G&#39;,1483203661)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">时，</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">24</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">小时制，不足两位数前面不补零</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">12.&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;g’,1483203661)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">时，</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">12</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">小时制，不足两位数前面不补零</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">13.&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;i’,1483203661)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">分，不足两位数前面补零</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">14.&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;s’,1483203661)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">秒，不足两位数前面补零</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">15.&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;a&#39;,1483203661)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;&nbsp;&nbsp; am&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; am</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">或</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">pm</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">，以</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">12:00:00</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">为分界</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">16.&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;A&#39;,1483203661)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;&nbsp;&nbsp; AM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AM</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">或</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">PM</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">，以</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">12:00:00</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">为分界</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">17.&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;D&#39;,1483203661);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;&nbsp;&nbsp; SUN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">英文星期，三个字母</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">18.&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;l&#39;,1483203661);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;&nbsp;&nbsp; Sunday&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">英文星期，全名（小写</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">L</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">）</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">19.&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;w&#39;,1483203661)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">数字星期，</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">0</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">（星期天）</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">-&gt;6</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">（星期六）</span></p><p style=\"box-sizing: border-box; outline: 0px; padding: 0px; margin-top: 0px; margin-bottom: 16px; color: rgb(79, 79, 79); line-height: 26px; text-align: justify; word-break: break-all; font-family: \"><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">20.&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">date(&#39;t&#39;,1483203661)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt;&nbsp;&nbsp; 31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"box-sizing: border-box; outline: 0px; word-break: break-all; color: rgb(68, 68, 68);\">指定月份的天数</span></p><p><br/></p>');
  INSERT INTO `article_content` VALUES (30, '<p><span style=\"color: rgb(255, 0, 0);\"><strong><span style=\"font-family: 宋体; font-size: 24px;\">CSS常用命名</span></strong></span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">头部：</span>header </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">内容：</span>content/container</span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">尾：</span>footer</span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">导航：</span>nav </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">侧栏：</span>sidebar </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">栏目：</span>column </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">页面外围控制整体布局宽度：</span>wrapper </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">左右中：</span>left right center </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">登录条：</span>loginbar </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">标志：</span>logo </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">广告：</span>banner </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">页面主体：</span>main </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">热点：</span>hot </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">新闻：</span>news </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">下载：</span>download </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">子导航：</span>subnav </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">菜单：</span>menu </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">子菜单：</span>submenu </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">搜索：</span>search </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">友情链接：</span>friendlink </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">页脚：</span>footer </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">版权：</span>copyright </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">滚动：</span>scroll </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">标签页：</span>tab </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">文章列表：</span>list </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">提示信息：</span>msg </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">小技巧：</span>tips </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">栏目标题：</span>title </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">加入：</span>joinus </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">指南：</span>guild </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">服务：</span>service </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">注册：</span>regsiter </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">状态态：</span>status </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">投票：</span>vote </span></p><p><span style=\";font-family:&#39;Times New Roman&#39;;font-size:14px\"><span style=\"font-family:宋体\">合作伙伴：</span>partner</span></p><p><strong><span style=\"font-family: &quot;Times New Roman&quot;; font-size: 24px; color: rgb(255, 0, 0);\">页面结构常用命名</span></strong></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">容器</span>: container </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">页头：</span>header</span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">内容：</span>content/container </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">页面主体：</span>main </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">页尾：</span>footer </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">导航：</span>nav </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">侧栏：</span>sidebar </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">栏目：</span>column </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">页面外围控制整体布局宽度：</span>wrapper </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">左右中：</span>left right center</span></p><p><span style=\"color: rgb(255, 0, 0);\"><strong><span style=\"font-family: &quot;Times New Roman&quot;; font-size: 24px;\">导航命名</span></strong></span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">导航：</span>nav </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">主导航：</span>mainbav </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">子导航：</span>subnav </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">顶导航：</span>topnav </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">边导航：</span>sidebar </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">左导航：</span>leftsidebar </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">右导航：</span>rightsidebar </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">菜单：</span>menu </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">子菜单：</span>submenu </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">标题</span>: title </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">摘要</span>: summary</span></p><p><strong><span style=\"font-family: &quot;Times New Roman&quot;; font-size: 24px; color: rgb(255, 0, 0);\">功能命名</span></strong></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">标志：</span>logo </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">广告：</span>banner </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">登陆：</span>login </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">登录条：</span>loginbar </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">注册：</span>regsiter </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">搜索：</span>search </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">功能区：</span>shop </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">标题：</span>title </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">加入：</span>joinus</span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">关于我们：</span>aboutus</span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">状态：</span>status </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">按钮：</span>btn </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">滚动：</span>scroll </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">标签页：</span>tab </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">文章列表：</span>list </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">提示信息：</span>msg </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">当前的</span>: current </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">小技巧：</span>tips </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">图标</span>: icon </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">注释：</span>note </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">指南：</span>guild </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">服务：</span>service </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">热点：</span>hot </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">新闻：</span>news </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">下载：</span>download </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">投票：</span>vote </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">合作伙伴：</span>partner </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">友情链接：</span>link </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">版权：</span>copyright</span></p><p><strong><span style=\"font-family: 宋体; font-size: 24px; color: rgb(255, 0, 0);\">CSS文件常用命名</span></strong></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">首页：</span> index.css</span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">主要的：</span> master.css &nbsp;main.css</span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">模块：</span> module.css </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">基本共用：</span> base.css </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">布局，版面：</span> layout.css </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">主题：</span> themes.css </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">专栏：</span> columns.css </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">文字：</span> font.css </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">表单：</span> forms.css </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">补丁：</span> mend.css </span></p><p><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">打印：</span> print.css</span></p><p><br/></p>');
  INSERT INTO `article_content` VALUES (31, '<p><br/></p><table width=\"553\"><tbody><tr class=\"firstRow\"><td width=\"179\" valign=\"center\" style=\"padding: 0px 7px; border-width: 1px; border-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\"font-family:&#39;Courier New&#39;;font-size:14px\"><a href=\"mk:@MSITStore:E:\\文档\\电子书\\w3school-2014.CHM::/met_win_alert.asp.htm\">alert()</a></span></p></td><td width=\"374\" valign=\"center\" style=\"padding: 0px 7px; border-left: none; border-right-width: 1px; border-right-color: windowtext; border-top-width: 1px; border-top-color: windowtext; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\";font-family:&#39;Courier New&#39;;font-size:14px\">显示带有一段消息和一个确认按钮的警告框。</span></p></td></tr><tr><td width=\"179\" valign=\"center\" style=\"padding: 0px 7px; border-left-width: 1px; border-left-color: windowtext; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\"font-family:&#39;Courier New&#39;;font-size:14px\"><a href=\"mk:@MSITStore:E:\\文档\\电子书\\w3school-2014.CHM::/met_win_confirm.asp.htm\">confirm()</a></span></p></td><td width=\"374\" valign=\"center\" style=\"padding: 0px 7px; border-left: none; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\";font-family:&#39;Courier New&#39;;font-size:14px\">显示带有一段消息以及确认按钮和取消按钮的对话框。</span></p></td></tr><tr><td width=\"179\" valign=\"center\" style=\"padding: 0px 7px; border-left-width: 1px; border-left-color: windowtext; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\"font-family:&#39;Courier New&#39;;font-size:14px\"><a href=\"mk:@MSITStore:E:\\文档\\电子书\\w3school-2014.CHM::/met_win_prompt.asp.htm\">prompt()</a></span></p></td><td width=\"374\" valign=\"center\" style=\"padding: 0px 7px; border-left: none; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\";font-family:&#39;Courier New&#39;;font-size:14px\">显示可提示用户输入的对话框。</span></p></td></tr><tr><td width=\"179\" valign=\"center\" style=\"padding: 0px 7px; border-left-width: 1px; border-left-color: windowtext; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\"font-family:&#39;Courier New&#39;;font-size:14px\"><a href=\"mk:@MSITStore:E:\\文档\\电子书\\w3school-2014.CHM::/met_win_setinterval.asp.htm\">setInterval()</a></span></p></td><td width=\"374\" valign=\"center\" style=\"padding: 0px 7px; border-left: none; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\";font-family:&#39;Courier New&#39;;font-size:14px\">按照指定的周期（以毫秒计）来调用函数或计算表达式。</span></p></td></tr><tr><td width=\"179\" valign=\"center\" style=\"padding: 0px 7px; border-left-width: 1px; border-left-color: windowtext; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\"font-family:&#39;Courier New&#39;;font-size:14px\"><a href=\"mk:@MSITStore:E:\\文档\\电子书\\w3school-2014.CHM::/met_win_settimeout.asp.htm\">setTimeout()</a></span></p></td><td width=\"374\" valign=\"center\" style=\"padding: 0px 7px; border-left: none; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\";font-family:&#39;Courier New&#39;;font-size:14px\">在指定的毫秒数后调用函数或计算表达式。</span></p></td></tr><tr><td width=\"179\" valign=\"center\" style=\"padding: 0px 7px; border-left-width: 1px; border-left-color: windowtext; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\"font-family:&#39;Courier New&#39;;font-size:14px\"><a href=\"mk:@MSITStore:E:\\文档\\电子书\\w3school-2014.CHM::/met_win_clearinterval.asp.htm\">clearInterval()</a></span></p></td><td width=\"374\" valign=\"center\" style=\"padding: 0px 7px; border-left: none; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\";font-family:&#39;Courier New&#39;;font-size:14px\">取消由 <span style=\"font-family:Courier New\">setInterval() </span><span style=\"font-family:宋体\">设置的 </span><span style=\"font-family:Courier New\">time</span></span><span style=\";font-family:宋体;font-size:14px\">ID</span><span style=\"font-family:&#39;Courier New&#39;;font-size:14px\">。</span></p></td></tr><tr><td width=\"179\" valign=\"center\" style=\"padding: 0px 7px; border-left-width: 1px; border-left-color: windowtext; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\"font-family:&#39;Courier New&#39;;font-size:14px\"><a href=\"mk:@MSITStore:E:\\文档\\电子书\\w3school-2014.CHM::/met_win_cleartimeout.asp.htm\">clearTimeout()</a></span></p></td><td width=\"374\" valign=\"center\" style=\"padding: 0px 7px; border-left: none; border-right-width: 1px; border-right-color: windowtext; border-top: none; border-bottom-width: 1px; border-bottom-color: windowtext;\"><p style=\"margin-top:2px;margin-bottom:2px;text-indent:0\"><span style=\";font-family:&#39;Courier New&#39;;font-size:14px\">取消由 <span style=\"font-family:Courier New\">setTimeout() </span><span style=\"font-family:宋体\">方法设置的 </span><span style=\"font-family:Courier New\">time</span></span><span style=\";font-family:宋体;font-size:14px\">ID</span></p></td></tr></tbody></table><p><br/></p><p style=\"text-indent:28px\"><strong><span style=\"font-family: 宋体;color: rgb(255, 0, 0);font-size: 19px\">setInterval</span></strong><strong><span style=\"font-family: &#39;Times New Roman&#39;;color: rgb(255, 0, 0);font-size: 19px\"><span style=\"font-family:宋体\">语法</span></span></strong></p><p style=\"margin-top:15px;border-top:1px dotted rgb(119,136,85);border-right:1px dotted rgb(119,136,85);border-bottom:1px dotted rgb(119,136,85);border-left:1px dotted rgb(119,136,85);padding:9px 20px 20px 0 ;background:rgb(245,245,245)\"><span style=\"font-family: Consolas;font-size: 14px\">setInterval(code,millisec)&nbsp;<span style=\"font-family: Consolas; font-size: 14px; background-color: rgb(245, 245, 245);\">code:调用代码,<span style=\"font-family: Consolas; font-size: 14px; background-color: rgb(245, 245, 245);\">millisec:时间</span></span></span></p><p><strong><span style=\"font-family: &#39;Times New Roman&#39;;color: rgb(255, 0, 0);font-size: 19px\"></span></strong></p><p style=\"text-indent:28px\"><strong><span style=\"font-family: &#39;Times New Roman&#39;;color: rgb(255, 0, 0);font-size: 19px\">setTimeou<span style=\"font-family:宋体\">语法</span></span></strong></p><p><strong><span style=\"font-family: &#39;Times New Roman&#39;;color: rgb(255, 0, 0);font-size: 19px\"></span></strong></p><p style=\"margin-top:15px;border-top:1px dotted rgb(119,136,85);border-right:1px dotted rgb(119,136,85);border-bottom:1px dotted rgb(119,136,85);border-left:1px dotted rgb(119,136,85);padding:20px 20px 20px 0 ;background:rgb(245,245,245)\"><span style=\"font-family: Consolas;font-size: 14px\">setTimeout(code,millisec) 同上</span></p><p style=\"text-indent:28px\"><strong><span style=\"font-family: 宋体;color: rgb(255, 0, 0);font-size: 19px\"><span style=\"font-family:宋体\">清除计时器：</span></span></strong></p><p style=\"text-indent:28px\"><span style=\";font-family:宋体;font-size:14px\">clearInterval(timeId)</span> <span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">取消由</span> setInterval() <span style=\"font-family:宋体\">设置的 </span><span style=\"font-family:Times New Roman\">timeId</span><span style=\"font-family:宋体\">。</span></span></p><p style=\"text-indent:28px\"><span style=\";font-family:宋体;font-size:14px\">clearTimeout(timeId)</span> <span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">取消由</span> setTimeout() <span style=\"font-family:宋体\">方法设置的 </span><span style=\"font-family:Times New Roman\">timeId</span><span style=\"font-family:宋体\">。</span></span></p><p><br/></p>');
  
  -- ----------------------------
  -- Table structure for article_img
  -- ----------------------------
  DROP TABLE IF EXISTS `article_img`;
  CREATE TABLE `article_img`  (
    `article_id` int(11) NOT NULL,
    `article_img_stats` int(1) NOT NULL COMMENT '封面图状态(0:没有图片,1:普通图片,2:多张图片,3:大图片)',
    `article_img_path` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '封面图路径',
    PRIMARY KEY (`article_id`) USING BTREE
  ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of article_img
  -- ----------------------------
  INSERT INTO `article_img` VALUES (23, 3, '/Style/upload_img/img/20190110/25220_060512_9031.png');
  INSERT INTO `article_img` VALUES (30, 2, '/Style/upload_img/img/20190308/25220_080358_6366.png,/Style/upload_img/img/20190308/25220_080358_6682.png,/Style/upload_img/img/20190308/25220_080358_5997.png');
  INSERT INTO `article_img` VALUES (29, 1, '/Style/upload_img/img/20190110/25220_060455_1194.png');
  INSERT INTO `article_img` VALUES (31, 1, '/Style/upload_img/img/20190110/25220_063312_9912.png');
  
  -- ----------------------------
  -- Table structure for article_reply
  -- ----------------------------
  DROP TABLE IF EXISTS `article_reply`;
  CREATE TABLE `article_reply`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `article_id` int(11) NULL DEFAULT NULL COMMENT '文章id',
    `reply_cont` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of article_reply
  -- ----------------------------
  INSERT INTO `article_reply` VALUES (1, 31, 'xiexie');
  
  -- ----------------------------
  -- Table structure for banner
  -- ----------------------------
  DROP TABLE IF EXISTS `banner`;
  CREATE TABLE `banner`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `banner_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
    `banner_sort` int(1) NOT NULL COMMENT '排序',
    `banner_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首页轮播图',
    `articlelink` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章链接',
    `interlink` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '友情链接',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of banner
  -- ----------------------------
  INSERT INTO `banner` VALUES (8, 'window对象的属性和方法', 3, '/Style/upload_img/img/20190110/25220_060347_6743.png', '31', NULL);
  INSERT INTO `banner` VALUES (6, 'Laravel框架常用的CURD操作', 1, '/Style/upload_img/img/20190110/25220_060333_4158.png', '26', NULL);
  INSERT INTO `banner` VALUES (9, 'PHP时间戳的各种类型与格式', 2, '/Style/upload_img/img/20190110/25220_060220_8023.png', '29', NULL);
  
  -- ----------------------------
  -- Table structure for config
  -- ----------------------------
  DROP TABLE IF EXISTS `config`;
  CREATE TABLE `config`  (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '配置项id',
    `cnname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置项中文名',
    `enname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置项英文名',
    `type` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '配置类型 1:单行文本框 2:文本域 3单选按钮 4:复选按钮 5:下拉菜单',
    `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '255' COMMENT '配置项值 ',
    `values` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '可选值',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of config
  -- ----------------------------
  INSERT INTO `config` VALUES (10, '博主头像', 'Blogger_img', '4', '', '/Style/upload_img/img/20190125/25220_024641_9032.png');
  INSERT INTO `config` VALUES (6, '网站简介', 'description', '2', '', '李小杰个人博客，是一个PHP程序员的网站,用于分享一下日常生活的点滴和一下IT开发的技术');
  INSERT INTO `config` VALUES (5, '启用验证码', 'code', '3', '是,否', '否');
  INSERT INTO `config` VALUES (8, '允许评论', 'comment', '3', '是,否', '否');
  INSERT INTO `config` VALUES (9, '网站关键词', 'keywords', '1', '', '个人博客,李双杰,PHP开发,个人网站,个人主页,PHP个人博客');
  
  -- ----------------------------
  -- Table structure for lable
  -- ----------------------------
  DROP TABLE IF EXISTS `lable`;
  CREATE TABLE `lable`  (
    `id` int(12) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
    `link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of lable
  -- ----------------------------
  INSERT INTO `lable` VALUES (1, 'H-ui前端框架', 'http://www.h-ui.net/');
  INSERT INTO `lable` VALUES (2, 'swiper滑动插件', 'http://www.swiper.com.cn/');
  INSERT INTO `lable` VALUES (3, '阿里云', 'https://www.aliyun.com/');
  INSERT INTO `lable` VALUES (4, '七牛云CDN', 'https://www.qiniu.com/');
  INSERT INTO `lable` VALUES (5, 'IEbug', 'http://www.h-ui.net/bug.shtml/');
  INSERT INTO `lable` VALUES (6, 'web工具箱', 'http://www.h-ui.net/tools/jsformat.shtml');
  INSERT INTO `lable` VALUES (8, '17素材网', 'http://www.17sucai.com/');
  INSERT INTO `lable` VALUES (9, '弹出层插件', 'http://www.h-ui.net/easydialog-v2.0/index.html');
  INSERT INTO `lable` VALUES (10, 'SuperSlide插件', 'http://www.h-ui.net/SuperSlide2.1/demo.html');
  INSERT INTO `lable` VALUES (11, 'layui前端框架', 'https://www.layui.com/');
  
  -- ----------------------------
  -- Table structure for life
  -- ----------------------------
  DROP TABLE IF EXISTS `life`;
  CREATE TABLE `life`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `catename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类名称',
    `sort` int(30) NULL DEFAULT NULL COMMENT '排序号',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of life
  -- ----------------------------
  INSERT INTO `life` VALUES (1, '日记', 1);
  INSERT INTO `life` VALUES (3, '日常', 2);
  INSERT INTO `life` VALUES (4, '程序人生', 3);
  
  -- ----------------------------
  -- Table structure for mt4_auth_group
  -- ----------------------------
  DROP TABLE IF EXISTS `mt4_auth_group`;
  CREATE TABLE `mt4_auth_group`  (
    `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
    `title` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
    `status` tinyint(1) NOT NULL DEFAULT 1,
    `rules` char(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;
  
  -- ----------------------------
  -- Records of mt4_auth_group
  -- ----------------------------
  INSERT INTO `mt4_auth_group` VALUES (1, '超级管理员', 1, '12,11,18,5,6,7,8,9,10,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32');
  INSERT INTO `mt4_auth_group` VALUES (4, '管理员', 0, '12,11,5,6,7,8,9,10,13,14,15,16');
  INSERT INTO `mt4_auth_group` VALUES (3, '小管理', 0, '11,5,6,7,8,9');
  
  -- ----------------------------
  -- Table structure for mt4_auth_group_access
  -- ----------------------------
  DROP TABLE IF EXISTS `mt4_auth_group_access`;
  CREATE TABLE `mt4_auth_group_access`  (
    `uid` mediumint(8) UNSIGNED NOT NULL,
    `group_id` mediumint(8) UNSIGNED NOT NULL,
    UNIQUE INDEX `uid_group_id`(`uid`, `group_id`) USING BTREE,
    INDEX `uid`(`uid`) USING BTREE,
    INDEX `group_id`(`group_id`) USING BTREE
  ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;
  
  -- ----------------------------
  -- Records of mt4_auth_group_access
  -- ----------------------------
  INSERT INTO `mt4_auth_group_access` VALUES (5, 4);
  INSERT INTO `mt4_auth_group_access` VALUES (12, 1);
  INSERT INTO `mt4_auth_group_access` VALUES (13, 3);
  
  -- ----------------------------
  -- Table structure for mt4_auth_rule
  -- ----------------------------
  DROP TABLE IF EXISTS `mt4_auth_rule`;
  CREATE TABLE `mt4_auth_rule`  (
    `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` char(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
    `title` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
    `type` tinyint(1) NOT NULL DEFAULT 1,
    `status` tinyint(1) NOT NULL DEFAULT 1,
    `condition` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `name`(`name`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 33 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;
  
  -- ----------------------------
  -- Records of mt4_auth_rule
  -- ----------------------------
  INSERT INTO `mt4_auth_rule` VALUES (12, 'Type/sort', '栏目查看', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (11, 'Article/add', '文章添加', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (18, 'User/delete', '管理员删除', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (5, 'Index/index', '主页首页', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (6, 'Index/zy', '主页详情', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (7, 'Article/lst', '文章查看', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (8, 'Article/article_content', '文章详情', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (9, 'Article/edit', '文章编辑', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (10, 'Article/del', '文章删除', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (13, 'Type/edit', '栏目编辑', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (14, 'Type/del', '栏目删除', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (15, 'Type/add', '栏目新增', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (16, 'User/lst', '管理员查看', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (17, 'User/add', '管理员新增', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (19, 'AuthGroup/lst', '用户组查看', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (20, 'AuthGroup/edit', '用户组修改', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (21, 'AuthGroup/del', '用户组删除', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (22, 'AuthGroup/add', '用户组新增', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (23, 'AuthRule/lst', '权限查看', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (24, 'AuthRule/edit', '权限修改', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (25, 'AuthRule/del', '权限删除', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (26, 'AuthRule/add', '权限新增', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (27, 'Conf/conf', '系统配置', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (28, 'Conf/lst', '系统配置查看', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (29, 'Mood/add', '每日留言', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (30, 'Mood/del', '留言删除', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (31, 'Mood/edit', '留言修改', 1, 1, '');
  INSERT INTO `mt4_auth_rule` VALUES (32, 'Mood/lst', '留言列表', 1, 1, '');
  
  -- ----------------------------
  -- Table structure for rmend
  -- ----------------------------
  DROP TABLE IF EXISTS `rmend`;
  CREATE TABLE `rmend`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `article_id` int(11) NULL DEFAULT NULL,
    `img_auth` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of rmend
  -- ----------------------------
  INSERT INTO `rmend` VALUES (3, 28, '/Style/upload_img/img/20190308/25220_055852_2639.png', 'laravel框架基础篇');
  INSERT INTO `rmend` VALUES (2, 26, '/Style/upload_img/img/20190308/25220_055256_1876.png', 'laravel框架基础篇');
  
  -- ----------------------------
  -- Table structure for type
  -- ----------------------------
  DROP TABLE IF EXISTS `type`;
  CREATE TABLE `type`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `catename` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `sort` mediumint(50) NULL DEFAULT 50 COMMENT '排序',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of type
  -- ----------------------------
  INSERT INTO `type` VALUES (1, 'php', 2);
  INSERT INTO `type` VALUES (2, '前端心得', 1);
  INSERT INTO `type` VALUES (3, 'cms', 3);
  INSERT INTO `type` VALUES (4, 'linux', 4);
  
  SET FOREIGN_KEY_CHECKS = 1;
  