線上書籍

Home

[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; }