<?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();
<?php /** * 修改幼儿园,小学,初中,高中热度 * User: ren * Date: 15-10-23 * Time: 上午11:31 */ use Phalcon\Db\Adapter\Pdo\Mysql; $db = new Mysql(['host' => 'localhost', 'username' => 'root', 'password' => 'root', 'dbname' => 'yxk_51']); //修改幼儿园,小学,初中,高中热度 $sql = 'select sch_id,public_type,sch_logo,sch_thumb from school'; $school = $db->fetchAll($sql); $basic = 1; $db->begin(); foreach ($school as $key => $val) { //公办,基本点击率+1 if ($val['public_type'] > 0) { $basic += 1; } //有logo图片,基本点击率+1 if ($val['sch_logo']) { $basic += 1; } //有缩略图,基本点击率+1 if ($val['sch_thumb']) { $basic += 2; } $click = $basic * mt_rand(80, 100); $hot = $click * mt_rand(5, 9) + mt_rand(0, 10); //修改热度
<?php /** * 修改大学,大专,高职热度 * User: ren * Date: 15-10-23 * Time: 上午11:31 */ use Phalcon\Db\Adapter\Pdo\Mysql; $db = new Mysql(['host' => 'localhost', 'username' => 'root', 'password' => 'root', 'dbname' => 'yxk_51']); //修改大学,大专,高职热度 $sql = 'select col_id,col_type,public_type,col_rank,col_logo,col_thumb from college'; $college = $db->fetchAll($sql); $basic = 1; $db->begin(); foreach ($college as $key => $val) { //本科,基本点击率+1 if ($val['col_type'] == 1) { $basic += 1; } //公办,基本点击率+1 if ($val['public_type'] == 1) { $basic += 1; } //有logo图片,基本点击率+1 if ($val['col_logo']) { $basic += 1; } //有缩略图,基本点击率+1 if ($val['col_thumb']) { $basic += 1;
<?php /** * 新闻关键字列表生成 * User: ren * Date: 15-10-23 * Time: 上午11:31 */ use Phalcon\Db\Adapter\Pdo\Mysql; $db = new Mysql(['host' => 'localhost', 'username' => 'root', 'password' => 'root', 'dbname' => 'yxk_51']); //新闻tags $str = '<ul>'; $sql = "select news_key,news_id from news order by news_date desc"; $data = $db->fetchAll($sql); foreach ($data as $val) { $str .= "<li><a href='/news/detail_" . $val['news_id'] . ".html'>" . $val['news_key'] . "</a></li>"; } $str .= '</ul>'; file_put_contents($str, APP_PATH);