<?php

header("Content-Type:text/html;charset=utf-8");

include_once('./mysql.php');

$filename = "F:/heyu.txt";

$handle = fopen($filename, "r");//读取二进制文件时，需要将第二个参数设置成'rb'

//通过filesize获得文件大小，将整个文件一下子读到一个字符串中

$contents = fread($handle, filesize ($filename));

$arr = json_decode($contents,true);

$arr=$arr['weibosearchcontent'];

$str_target='';

$str_data='';

$conndb=new ConnDB();

foreach($arr as $i=>$msg){

    echo $i.'<br>';

    foreach($msg as $key=>$val){

            //echo $key.'=>'.$val.'<br>';

            $str_target.=$key.',';

            if($key=='uid'){

                $val=str_replace('1001030103','',$val);

                }

            if($key=='titles'){//遍历moods数组

                    $tmp='';

                    foreach($val as $t=>$v){

                        $tmp.=$v.',';

                    }

                    $tmp=rtrim($tmp,",");

                    $str_data.='\''.$tmp.'\',';

            }

            else if($key=='pics'){//遍历moods数组

                    $tmp='';

                    foreach($val as $t=>$v){

                        $tmp.=$v.',';

                    }

                    $tmp=rtrim($tmp,",");

                    $str_data.='\''.$tmp.'\',';

            }

            else if($key=='moods'){//遍历moods数组

                    $tmp='';

                    foreach($val as $t=>$v){

                        $tmp.=$v.',';

                    }

                    $tmp=rtrim($tmp,",");

                    $str_data.='\''.$tmp.'\',';

            }

            else{

                $str_data.='\''.$val.'\',';

            }

        }

        //去掉最后的逗号

        $str_target=rtrim($str_target, ",");

        $str_data=rtrim($str_data, ",");

        echo $str_target.'<br>';

        echo $str_data.'<br>';

        $sql='insert into keyword_weibo('.$str_target.') values('.$str_data.')';

        $conndb->query($sql);

        $str_target='';

        $str_data='';

    }

fclose($handle);

?>