Silverlight JSON (PHP4)

PHP-4.4.1 MySQLSJIS の場合

JSON.php
http://sourceforge.jp/projects/sfnet_preports/downloads/json.php/
jonson_encode が使用できない点、と、コード変換が必要




<?
$envhost = file("envhost.txt");
mysql_connect(trim($envhost[0]),trim($envhost[1]),trim($envhost[2])) or die("mysql_connect_error");
mysql_select_db(trim($envhost[3]));

$sql = "select * from tb_gr1mst";
$sql .= " order by g1code";
$result1 = mysql_query($sql);
if ( $result1 == $FALSE )
{
die($sql);
}
$num1 = mysql_num_rows($result1);

for ($idx1=0; $idx1<$num1; $idx1++)
{
$row1 = mysql_fetch_array($result1);
$g1code = $row1[G1Code];
$g1name = $row1[G1Name];
//Gr2
$sql = "select * from tb_gr2mst";
$sql .= " where g1code = '".$g1code."'";
$sql .= " order by g1code,g2code";

$result2 = mysql_query($sql);
if ( $result2 == $FALSE )
{
die($sql);
}
$num2 = mysql_num_rows($result2);

for ($idx2=0; $idx2<$num2; $idx2++)
{
$row2 = mysql_fetch_array($result2);
$g2code = $row2[G2Code];
$g2name = $row2[G2Name];
//Gr3
$sql = "select * from tb_gr3mst";
$sql .= " where g1code = '".$g1code."'";
$sql .= " and g2code = '".$g2code."'";
$sql .= " order by g1code,g2code,g3code";

$result3 = mysql_query($sql);
if ( $result3 == $FALSE )
{
die($sql);
}
$num3 = mysql_num_rows($result3);

$array = array();

for ($idx3=0; $idx3<$num3; $idx3++)
{
$row3 = mysql_fetch_array($result3);
$g3code = $row3[G3Code];
$g3name = mb_convert_encoding($row3[G3Name],"UTF-8","SJIS");
$wtdate = $row3[WtDate];
$tacode = $row3[TaCode];

$array[] = array("G3Code"=>$g3code,"G3Name"=>$g3name);
}
}
}
mysql_close;
//JSON
$returnItems = array("returnType"=>"tableItems","results"=>$returnItems);
//$JSONresult = json_encode($array);
require_once("JSON.php");
$json = new Services_JSON();
$JSONresult = $json->encode($array);
echo $JSONresult;
?>



AX

TYKYUNC index