<?php
header("content-type:text/html;charset=utf-8");
$url = "http://www.csdn.net";
$one=file_get_contents($url);
// var_dump($one);die;
$type = "/<li\sclass=\S*><a\shref=\"\S*\">(.*)<\/a><\/li>/";
preg_match_all($type,$one,$arr);
// $type ="/<li\sclass=\S*><a\shref=\"\S*\">(.*)<\/a><\/li>/";
$title ="/<div\sclass=\"title\">\s*<h2\sclass=\"\S*\"\sdata-mod=\"\S*\"\sdata-poputype=\"\S*\"\s*data-feed-show=\"\S*\"\sdata-dsm=\"\S*\">\s*<a\sstrategy=\"\S*\"\shref=\"\S*\" target=\"\S*\">\s*(.*)\s*<\/a>\s*<\/h2>/";
preg_match_all($title,$one,$data);
$xinxi ="/<dd\sclass=\"name\">\s*<a\shref=\"\S*\"\starget=\"_blank\">\s*(.*)\s*<\/a>\s*<\/dd>\s*<div\sclass=\"interval\"><\/div>\s*<dd\sclass=\"time\">\s*(.*)\s*<\/dd>/";
preg_match_all($xinxi,$one,$date);
// var_dump($arr);
// var_dump($data);
// var_dump($date);
$pdo = new PDO('mysql:host=127.0.0.1;dbname=demo;charset=utf8','root','');
for ($i=1; $i <count($arr[1]) ; $i++) {
$sql = "insert into cai(`title`,`user`,`time`,`type`) value('".$data[1][$i]."','".$date[1][$i]."','".$date[2][$i]."','".$arr[1][$i]."')";
echo $sql;
// $db = $pdo->exec($sql);
// echo "<script>location.href='./show.php';</script>";
}
header("content-type:text/html;charset=utf-8");
$url = "http://www.csdn.net";
$one=file_get_contents($url);
// var_dump($one);die;
$type = "/<li\sclass=\S*><a\shref=\"\S*\">(.*)<\/a><\/li>/";
preg_match_all($type,$one,$arr);
// $type ="/<li\sclass=\S*><a\shref=\"\S*\">(.*)<\/a><\/li>/";
$title ="/<div\sclass=\"title\">\s*<h2\sclass=\"\S*\"\sdata-mod=\"\S*\"\sdata-poputype=\"\S*\"\s*data-feed-show=\"\S*\"\sdata-dsm=\"\S*\">\s*<a\sstrategy=\"\S*\"\shref=\"\S*\" target=\"\S*\">\s*(.*)\s*<\/a>\s*<\/h2>/";
preg_match_all($title,$one,$data);
$xinxi ="/<dd\sclass=\"name\">\s*<a\shref=\"\S*\"\starget=\"_blank\">\s*(.*)\s*<\/a>\s*<\/dd>\s*<div\sclass=\"interval\"><\/div>\s*<dd\sclass=\"time\">\s*(.*)\s*<\/dd>/";
preg_match_all($xinxi,$one,$date);
// var_dump($arr);
// var_dump($data);
// var_dump($date);
$pdo = new PDO('mysql:host=127.0.0.1;dbname=demo;charset=utf8','root','');
for ($i=1; $i <count($arr[1]) ; $i++) {
$sql = "insert into cai(`title`,`user`,`time`,`type`) value('".$data[1][$i]."','".$date[1][$i]."','".$date[2][$i]."','".$arr[1][$i]."')";
echo $sql;
// $db = $pdo->exec($sql);
// echo "<script>location.href='./show.php';</script>";
}