Silverlight XML

索引サイト表示
PHP にて MySQL データを橋渡しする。XML 使用

サーバー側 PHP





<?php

//require_once "inc/db.inc";

require_once "XML/Serializer.php";

$options = array(

    "indent"         => " ",

    "linebreak"      => "\n",

    "typeHints"      => false,

    "addDecl"        => true,

    "encoding"       => "UTF-8",

    "rootName"       => "result",

    "defaultTagName" => "item",

);

$serializer = new XML_Serializer($options);
$p_table = 'table444';

$p_sql = 'SELECT * from '.$p_table.' order by code';
$conn = mysql_connect('server', 'user', 'password') or die(mysql_error());  

mysql_select_db('database') or die(mysql_error());  

$res = mysql_query($p_sql) or die(mysql_error());  
$assoc = array();

while($val = mysql_fetch_assoc($res))

{

    $assoc[] = $val;

}

mysql_free_result($res);

mysql_close($conn);
// XML作成

$status = $serializer->serialize($assoc);

if($status === true)

{

    $xml = $serializer->getSerializedData();

    header ("Content-Type: text/xml; charset=UTF-8");

    echo $xml;

}

?>

XML より抽出





void wc_DownloadStringCompleted(object sender, System.Net.DownloadStringCompletedEventArgs e)

{

    MessageBox.Show(e.Result);

    string xmlString = e.Result;

    label1.Content = xmlString;
    XDocument xmlDoc = XDocument.Parse(xmlString);

    var query = from mb in xmlDoc.Descendants("item")

              select new

              {

                  code = mb.Element("code").Value,

                  name = mb.Element("name").Value,

                  data = mb.Element("data").Value,

              };

    List myList = new List();

    foreach (var item in query)

    {

        string wCode = item.code;

        string wName = item.name;

        string wData = item.data;

        myList.Add(new webItem {code=wCode , name=wName , data=wData});
    }

    xnDataGrid.ItemsSource = myList;

}



AX

TYKYUNC index