php连接access
先切换到php5.2
<?php header("Content-type:text/html;charset=utf-8"); $con2 = mysqli_connect("localhost", "root", "root", "hengsheng"); if (!$con2) { die('Could not connect: ' . mysqli_error()); } mysqli_query($con2, 'SET NAMES UTF8'); $db = new PDO("odbc:driver={microsoft access driver (*.mdb)};dbq=".realpath("a.mdb")) or die("Connect Error"); $rs = $db->query('select * from Product where Bigclassid = 2 order by articleID'); foreach ($rs as $v) { $title = iconv('gb2312', 'utf-8', $v['Title']); $content = str_replace(array('http://www.yyhssp.com/image/'), array('/image/'), addslashes( iconv('gb2312', 'utf-8', $v['content']) ) ); $litpic = '/'.$v['DefaultPicUrl']; $add_time = strtotime($v['UpdateTime']); $click = intval($v['Hits']); $sql = "insert into hengsheng_archives(typeid,title,channel,is_litpic,litpic,click,arcrank,seo_title,seo_keywords,seo_description,sort_order,lang,add_time,update_time) values(3, '$title', 34, 1, '$litpic','$click',0,'$title','$title','$title','1000','cn','$add_time','$add_time');"; $r = mysqli_query($con2, $sql); if (!$r) { die('Could not connect: ' . mysqli_error()); } $id = mysqli_insert_id($con2); $sql = "insert into hengsheng_pics_content(aid,content,add_time,update_time) values($id,'$content','$add_time','$add_time')"; mysqli_query($con2, $sql); }