- <?php
- if(!defined('IN_SUPESITE')) {
- exit('Access Denied');
- }
- ///创建文件
- function substr_cut($str_cut,$length = 30){
- if (strlen($str_cut) > $length){
- for($i=0; $i < $length; $i++)
- if (ord($str_cut[$i]) > 128) $i++;
- $str_cut = substr($str_cut,0,$i) . "...";
- }
- return $str_cut;
- }
- function creat_file($PATH,$file_name,$data){
- $fp= fopen($PATH.$file_name,"w");
- if (fwrite($fp, $data) === FALSE) {
- echo "不能写入到文件 $filename";
- exit;
- fclose($fp);
- }
- return $sFile;
- }
- $data="<?xml version="1.0" encoding="GBK"?>\n<document>\n";
- include_once(S_ROOT."/config.php");
- $link = mysql_connect($dbhost, $dbuser, $dbpw)
- or die('Could not connect: ' . mysql_error());
- //echo 'Connected successfully';
- mysql_select_db($dbname) or die('Could not select database');
- $query="SELECT a.itemid,a.subject,c.filepath,b.message FROM supe_spaceitems a inner join supe_spacenews b on b.itemid=a.itemid inner join supe_attachments c on (c.itemid = b.itemid and c.aid = a.picid) WHERE a.haveattach = 1 and c.isimage = 1 and a.digest = 2 ORDER BY a.dateline desc limit 0 ,5 ";
- echo "$query";
- mysql_query("SET names 'GBK'",$link);
- $result=mysql_query($query,$link);
- while($arr_result=mysql_fetch_array($result,MYSQL_ASSOC)){
- //$arr_pro[]=array("pro_id"=>$arr_result["filepath"]);
- $data=$data."<item>\n"."<image>/attachments/".$arr_result["filepath"]."</image>\n"."<smallimage>media/01s.jpg</smallimage>\n"."<video>"."http://www.un739.com/?action-viewnews-itemid-".$arr_result["itemid"]."</video>\n"."<captionlines>4</captionlines>\n"."<headline><a href="/?action-viewnews-itemid-".$arr_result["itemid"]."""." target="_blank">".substr_cut(strip_tags($arr_result["subject"]),42)."</a></headline>\n"."<caption>".substr_cut(str_replace("\r\n","",str_replace(" ","",strip_tags($arr_result["message"]))),100)."...</caption>\n<photocaption></photocaption>\n</item>\n";
- }
- //print_r ($arr_pro);
- $data=$data."</document>";
- creat_file("./","41.xml",$data);
- ?>
复制代码 放在后台后,点立即执行,提示完成,但是根目录下的41.xml根本没有写进数据,注:41.xml权限是777的 |