导入MySQL数据库时报错1067 – Invalid default value for ‘字段名’

这种报错多是你 MySQL 升级到 5.7 而引起的默认值不兼容的问题。看看你的字段名是什么,我的是时间字段,类型是 datetime。想到可能是类型的默认值被限制了,查看 sql_mode。果然:NO_ZERO_IN_DATE,NO_ZERO_DATE 这两个参数限制时间不能为0

Continue reading 导入MySQL数据库时报错1067 – Invalid default value for ‘字段名’

做个记录 symfony/dom-crawler 使用入门

做个记录

symfony/dom-crawler 使用入门

> composer require "symfony/dom-crawler"
<?php
use Symfony\Component\DomCrawler\Crawler;
require 'vendor/autoload.php';

$html = <<<'HTML'
<!DOCTYPE html>
<html>
    <body>
        <p class="message">Hello World!</p>
        <p>Hello Crawler!</p>
    </body>
</html>
HTML;

$crawler = new Crawler($html);

foreach ($crawler as $domElement) {
    var_dump($domElement->nodeName);
}

http://symfony.com/doc/current/components/dom_crawler.html

https://segmentfault.com/q/1010000009019518