实现取出数据库中生成的XML 并POST 出去

时间：2010-12-03 来源：a464008972

<?php
/********设置连接数据库的用户和密码***********/
$mysql_servername="XXXXXXXX";
$mysql_username="XXXXXXXX";
$mysql_password="XXXXXXXX";
$mysql_database="XXXXXXXX";
/******XML文件以字符串的行式声明XML变量**********/
$xmlhead = "<?xml version='1.0' encoding='utf-8'?>
<pwd_message_list version='3.0'>";
$xmlend = "</pwd_message_list>";

/****连接数据库*******/
$con=mysql_connect($mysql_sername,$mysql_username,$mysql_password)or die('connect mysql error');
mysql_select_db($mysql_database,$con);
$count=0;
/********查询数据库*************/
$sql = mysql_query("select * from table where 条件='' ");
if (!$sql){
    echo "Error:" . mysql_error();
}else{
   while($row=mysql_fetch_array($sql) and $count <= 30)
   {
    $xml_data['节点名']="";         $xml_data['节点名']=$row['数据字段'];
     $count++;
    foreach($xml_data as $key => $value){         // 把XML 数据遍历到一个数组中
     if ($key == "节点"){
      $values[]="<"."$key".">";    //判断这个XML开始节点
     }else{

      $values[]="<"."$key".">" .$value. "</"."$key".">";
     }
     if ($key == "节点"){
           $values[]="</message>"; // 判断XML结束节点
     }
       $xmlbody = implode("\r\n",$values);
   }

    $xml = $xmlhead . $xmlbody. $xmlend; // 合成一个XML 文件

   }
    /********POST XML ********/
            $url = "http://localhost/post2.php";
            $header[] = "Content-type: text/xml";//定义content-type为xml
            $ch = curl_init($url);
            curl_setopt($ch, CURLOPT_URL, $url);
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
            curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
            curl_setopt($ch, CURLOPT_POST, 1);
            curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
            $response = curl_exec($ch);
            if(curl_errno($ch))
           {
           print curl_error($ch);
           }else{
               echo "0";
           }
          curl_close($ch);
   }

相关阅读更多 +