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