<?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();
