吴伟贤のBlog

Feed Rss

存档:六月, 2010

查看到目标IP经过的路由traceroute tracert

06.29.2010, 查看到目标IP经过的路由traceroute tracert已关闭评论, windows, by .

linux下使用:traceroute 192.168.1.1

windows下使用:tracert  192.168.1.1

查看到目标IP经过的路由

了解更多

phpexcelreader 导入mysql

06.27.2010, phpexcelreader 导入mysql已关闭评论, php, by .

下载

sourceforge.net/projects/phpexcelreader/

一:修改reader.php内

require_once ‘Spreadsheet/Excel/Reader/OLERead.php’;

require_once ‘Excel/oleread.inc’;

 

 

二:数据库utf-8编码

 

三:php执行程序

$data = new Spreadsheet_Excel_Reader();
            $data->setOutputEncoding(‘UTF-8’);//设置编码
            $data->read(‘test.xls’);//excel,csv文件位置
            error_reporting(E_ALL ^ E_NOTICE);

            for ($i = 2; $i <= $data->sheets[0][‘numRows’]; $i++) {//插入数据库开始
                    $sql="INSERT INTO {$table}kehu (userid,sortid,danwei,xingming,zuncheng,tel,mobile,fax,email,website,qq,address,postcode,sex,beizhu,addtime) values(‘$_COOKIE[WECMS_user_id]’,’$sortid’,
                                    ‘".$data->sheets[0][‘cells’][$i][1]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][2]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][3]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][4]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][5]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][6]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][7]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][8]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][9]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][10]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][11]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][12]."’,
                                    ‘".$data->sheets[0][‘cells’][$i][13]."’,
                                    ‘$nowtime’)";
                    $res=$db->query($sql);

//插入数据库结束
            }

 

成功

了解更多