<?php
//mysql连接
require_once('../admin/mysql.php');
require_once('../admin/class/mysql.php');
$db = new DB_MySQL;
$mysql = $db->connect($mysql_add,$mysql_user,$mysql_pass,$mysql_dbname);

/*
$sql = "SELECT * FROM cn_blog";
$query = $db->query($sql);
while($row = $db->fetch_array($query)) {
    echo $row['title']."<br/>";
}
*/

//excel连接
$conn = new com("adodb.connection");
//$connstr = "driver = {microsoft access driver(*.mdb)};dbq = ".realpath("jacking_data.mdb");
//$connstr = "driver = {microsoft access driver(*.mdb)};dbq = ".realpath("jacking_data.mdb");
$connstr = "provider = microsoft.jet.oledb.4.0;data source = ".realpath("jacking_data.mdb");
$conn->open($connstr);
//连接数据库……
$sql = "SELECT * FROM AS_Log";
$rs = new com("adodb.recordset");
$rs->open($sql,$conn,1,3);
while(!$rs->eof) {
    $Log_Title = $rs->fields("Log_Title");
    $Log_Content = $rs->fields("Log_Content");
    $Log_Time = $rs->fields("Log_Time");
    //echo $Log_Title->value."<br/>";
    //echo $Log_Content->value."<br/>";
    $time1 = explode(' ',$Log_Time->value);
    $time2 = explode('/',$time1[0]);
    $time3 = explode(':',$time1[1]);
    $times = mktime($time3[0],$time3[1],$time3[2],$time2[1],$time2[2],$time2[0]);
    //$Log_Title = quotemeta($Log_Title);
    $Log_Title = addslashes($Log_Title);
    //$Log_Content = quotemeta($Log_Content);
    $Log_Content = addslashes($Log_Content);
    $Log_Content = str_replace('<font face="Verdana">','',$Log_Content);
    $Log_Content = str_replace('</font>','',$Log_Content);
    //$Log_Content = str_replace('"','\"',$Log_Content);
    //$Log_Content = str_replace(''','/'',$Log_Content);

    //echo $time[0].$time2[0]."<br/>";
   
    $sql = $db->query("SELECT * FROM cn_blog WHERE title = '$Log_Title'");
    $countblog = $db->num_rows($sql);
    if($countblog < 1)    {
        $m++;
        //echo $Log_Title."<br/>";
        //if($m ==1 ){
        //    echo $Log_Content;
        //}
        $query = $db->query("INSERT INTO `cn_blog` (`date`, `title`, `content`, `trackbackurl`, `filename`, `author`, `classid`, `top`, `allow_remark`, `allow_face`, `draft`, `viewcount`) VALUES('$times','$Log_Title','$Log_Content','','','jacking', '3', '0', '1', '1', '0', '0')");
    }
    $rs->movenext;
}
echo "总共更新了".$m."条记录";
?>