PHP updateVodPic Examples

Example #1

File: update_vod_captialName.php Project: andyongithub/joyplus-cms

<?php

ob_implicit_flush(true);
ini_set('max_execution_time', '0');
require_once "../admin_conn.php";
require_once "collect_fun.php";
updateVodPic(1);
function updateVodPic($pagenum)
{
    global $db;
    $sql = "SELECT count(*)  FROM {pre}vod where  d_capital_name IS NULL OR d_capital_name = ''";
    $nums = $db->getOne($sql);
    $app_pagenum = 10;
    $pagecount = ceil($nums / $app_pagenum);
    //	 $pagecount=2;
    for ($i = $pagenum; $i <= $pagecount; $i++) {
        $sql = "SELECT d_name,d_id FROM {pre}vod where  d_capital_name IS NULL OR d_capital_name = '' limit " . $app_pagenum * ($i - 1) . "," . $app_pagenum;
        //	    var_dump($sql);
        $rs = $db->query($sql);
        parseVodPad($rs, $scoreDouban);
        unset($rs);
    }
}
function parseVodPad($rs, $scoreDouban)
{
    global $db;
    while ($row = $db->fetch_array($rs)) {
        $name = Hanzi2PinYin_Captial($row["d_name"]);
        $d_id = $row["d_id"];
        $db->Update("{pre}vod", array("d_capital_name"), array($name), "d_id=" . $d_id);
    }

Example #2

File: vodType.php Project: andyongithub/joyplus-cms

<?php

ob_implicit_flush(true);
ini_set('max_execution_time', '0');
require_once "../admin_conn.php";
require_once "collect_fun.php";
require_once "../score/DouBanParseScore.php";
updateVodPic();
function updateVodPic()
{
    global $db;
    $scoreDouban = new DouBanParseScore();
    $sql = "SELECT count(*)  FROM {pre}vod WHERE d_pic_ipad IS NULL OR d_pic_ipad = '' ";
    $nums = $db->getOne($sql);
    $app_pagenum = 50;
    $pagecount = ceil($nums / $app_pagenum);
    //	 $pagecount=2;
    for ($i = 1; $i <= $pagecount; $i++) {
        writetofile("updateVodPic.txt", 'check item for vod type{=}' . $nums . '{=}Total{=}' . $pagecount . '{=}' . $i);
        $sql = "SELECT d_name,d_area, d_year,d_id,d_type  FROM {pre}vod WHERE d_pic_ipad IS NULL OR d_pic_ipad = '' order by d_type asc limit " . $app_pagenum * ($i - 1) . "," . $app_pagenum;
        //	    var_dump($sql);
        $rs = $db->query($sql);
        parseVodPad($rs, $scoreDouban);
        unset($rs);
    }
}
function parseVodPad($rs, $scoreDouban)
{
    global $db;
    while ($row = $db->fetch_array($rs)) {
        $name = $row["d_name"];

Example #3

File: cj_vod_pic.php Project: andyongithub/joyplus-cms

<?php

ob_implicit_flush(true);
ini_set('max_execution_time', '0');
require_once "../admin_conn.php";
require_once "collect_fun.php";
require_once "../score/AutoDouBanParseScore.php";
$pagenum = be("all", "pagenum");
if (!isNum($pagenum)) {
    $pagenum = 1;
} else {
    $pagenum = intval($pagenum);
}
updateVodPic($pagenum);
writetofile("mac_cj_vod.txt", 'finish');
function updateVodPic($pagenum)
{
    global $db;
    $scoreDouban = new AutoDouBanParseScore();
    $sql = "SELECT count(*)  FROM ( SELECT m_name\nFROM mac_cj_vod\nWHERE m_pid =180 AND m_typeid =131\nGROUP BY m_name) as c";
    $nums = $db->getOne($sql);
    $app_pagenum = 10;
    $pagecount = ceil($nums / $app_pagenum);
    //	 $pagecount=2;
    $flag = true;
    for ($i = $pagenum; $i <= $pagecount && $flag; $i++) {
        writetofile("mac_cj_vod.txt", 'check item for vod type{=}' . $nums . '{=}Total{=}' . $pagecount . '{=}' . $i);
        $sql = "SELECT m_name, m_pic, m_pic_ipad, m_year,m_language \nFROM mac_cj_vod\nWHERE m_pid =180 \nAND m_typeid =131\nGROUP BY m_name order by m_name asc  limit " . $app_pagenum * ($i - 1) . "," . $app_pagenum;
        //	    var_dump($sql);
        $rs = $db->query($sql);
        $flag = parseVodPad($rs, $scoreDouban);