[1042] XOOPS模組開發進階
<?php
/**
* Phone Book module
*
* You may not change or alter any portion of this comment or credits
* of supporting developers from this source code or any supporting source code
* which is considered copyrighted (c) material of the original comment or credit authors.
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
*
* @copyright The XOOPS Project http://sourceforge.net/projects/xoops/
* @license http://www.fsf.org/copyleft/gpl.html GNU public license
* @package Phone Book
* @since 2.5
* @author tad
* @version $Id $
**/
/*-----------引入檔案區--------------*/
include "header.php";
/*-----------功能函數區--------------*/
$content=file_get_contents("http://gis.taiwan.net.tw/XMLReleaseALL_public/restaurant_C_f.json");
$content=removeBOM($content);
$arr=json_decode($content,true);
$myts = MyTextSanitizer::getInstance();
foreach ($arr['Infos']['Info'] as $key => $value) {
foreach ($value as $k => $v) {
$$k=$myts->addSlashes($v);
}
$sql="insert into `" . $xoopsDB->prefix("restaurant") . "` (`Zipcode`, `Name` ,`Description` ,`Add` ,`Website`) values('$Zipcode', '$Name' , '$Description', '$Add' ,'$Website')";
$xoopsDB->queryF($sql) or web_error($sql);
}
echo "ok";
//移除BOM
function removeBOM($str = '')
{
if (substr($str, 0,3) == pack("CCC",0xef,0xbb,0xbf))
$str = substr($str, 3);
return $str;
}