<?php /** * 修改专业热度 * User: ren * Date: 15-10-23 * Time: 下午5:11 */ header('content-type:text/html;charset=utf-8'); use Phalcon\Db\Adapter\Pdo\Mysql; $db = new Mysql(['host' => 'localhost', 'username' => 'root', 'password' => 'root', 'dbname' => 'yxk_51']); $db->execute('set names utf8'); //获取所有省份 $sql = 'select name from site_province'; $provinces = $db->fetchAll($sql); //获取所有专业id $sql = 'select maj_id from major'; $majors = $db->fetchAll($sql); //修改专业数据 $db->begin(); foreach ($majors as $val) { //格式省份数据 $tmp = array_map(function ($argc) { $argc['value'] = mt_rand(0, 100); return preg_replace('/[省市]/u', '', $argc); }, array_slice($provinces, 0, 31)); $tmp = serialize($tmp); $sql = "update major set maj_area='{$tmp}' where maj_id='{$val['maj_id']}'"; $db->execute($sql); } $db->commit();