$tableName = "mobilenewlist1009"; $boysExist = 0; $girlsExist = 0; $gameExist = 0; $cardgameExist = 0; $lifeExist = 0; $babyExist = 0; $gamesoftExist = 0; header ("Content-type: application/xhtml+xml"); header ("xml version='1.0' encoding='Shift_JIS'"); echo("\n"); class clsDB{ var $srv,$id,$passwd; function clsDB($strSrv="localhost",$strID="root",$strPasswd="_23kzMFjq"){ $this->srv=$strSrv; $this->id=$strID; $this->passwd=$strPasswd; } } $query = "SELECT ctglyname FROM ".$tableName; //print($query); $db=mysql_connect("t2web-db01","root","t2dbpwapp30"); mysql_select_db("products",$db); mysql_query("SET NAMES ujis;"); $rs=mysql_db_query("products",$query); $num=mysql_num_rows($rs); while($row=mysql_fetch_array($rs)){ $ctglynameTxtSJIS = mb_convert_encoding($row["ctglyname"], "SJIS","ASCII,JIS,UTF-8,EUC-JP,SJIS"); if ($ctglyname != $ctglynameTxtSJIS ) { switch ($ctglynameTxtSJIS) { case "男の子": $boysExist = 1; break; case "女の子": $girlsExist = 1; break; case "ゲーム": $gameExist = 1; break; case "カードゲーム": $cardgameExist = 1; break; case "ライフ&リラックス": $lifeExist = 1; break; case "ベビー・プリスクール": $babyExist = 1; break; case "ゲームソフト": $gamesoftExist = 1; break; } } $ctglyname = $ctglynameTxtSJIS; } ?>