纠错记录

[mysql] text类型字段提示:doesn't have a default value

解决方法:修改/etc/my.cnf.d/server.cnf文件,在[mysqld]下面添加一行:

[mysqld]
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

[小程序] 无法解析html实体

小程序无法解析html实体,例如:기회의 뒷면这种韩文编码,故封装js方法解决:

function parseEntity(str) {
let str_ary = str.match(/&#\d*?;/g);
if (!str_ary) {
return str;
}
for (s of str_ary) {
let rs = String.fromCharCode(s.replace(/[&#;]/g, ''));
str = str.replace(s, rs);
}
return str;
}
let str = '你好기회의뒷면';
console.log(parseEntity(str));

mac多版本php安装扩展

  1. pecl.php.net下载扩展

  2. 命令:

    tar zxvf zendopcache-7.0.4.tgz
    cd zendopcache-7.0.4
    /usr/local/Cellar/php/7.2.4/bin/phpize
    ./configure --with-php-config=/usr/local/Cellar/php/7.2.4/bin/php-config
    make && make install
  3. 添加配置文件:/usr/local/etc/php/7.2/conf.d/opcache.ini

    [opcache]
    zend_extension=opcache.so
    opcache.enable=1
    opcache.interned_strings_buffer=8
    opcache.max_accelerated_files=10000
    opcache.max_wasted_percentage=5
    opcache.use_cwd=0
    opcache.revalidate_freq=600
    opcache.save_comments=0
    opcache.fast_shutdown=1