心身障害児診療協力医療機関

$t_count = "0"; $pend="1";
//---------------------------------------------------------
//横浜歯科医師会　心身障害児診療協力機関　一覧表示ＰＲＧ（住所５０音順）
//　　２０１１年８月２９日　作成
//---------------------------------------------------------

//SQl発行（ｃｈｉｋｕ＿ｃｏｄｅ＝’ｘｘ’）
//
//　　　１　青葉区　　／　　２　旭区　　／　　３　泉区　　／　　４　磯子区
//　　　５　神奈川区　／　　６　金沢区　／　　７　港南区　／　　８　港北区
//　　　９　栄区　　　／　１０　瀬谷区　／　１１　都筑区　／　１２　鶴見区
//　　１３　戸塚区　　／　１４　中区　　／　１５　西区　　／　１６　保土ヶ谷区
//　　１７　緑区　　　／　１８　南区

$c_id[1] = "naka"; $c_no[1] = "14"; $c_name[1] = "中　区　";
$c_id[2] = "nishi"; $c_no[2] = "15"; $c_name[2] = "西　区　";
$c_id[3] = "minami"; $c_no[3] = "18"; $c_name[3] = "南　区　";
$c_id[4] = "kounan"; $c_no[4] = "7"; $c_name[4] = "港南区　";
$c_id[5] = "isogo"; $c_no[5] = "4"; $c_name[5] = "磯子区　";
$c_id[6] = "kana"; $c_no[6] = "6"; $c_name[6] = "金沢区　";
$c_id[7] = "hodo"; $c_no[7] = "16"; $c_name[7] = "保土ケ谷区　";
$c_id[8] = "asahi"; $c_no[8] = "2"; $c_name[8] = "旭　区　";
$c_id[9] = "totsuka"; $c_no[9] = "13"; $c_name[9] = "戸塚区　";
$c_id[10] = "sakae"; $c_no[10] = "9"; $c_name[10] = "栄　区　";
$c_id[11] = "izumi"; $c_no[11] = "3"; $c_name[11] = "泉　区　";
$c_id[12] = "seya"; $c_no[12] = "10"; $c_name[12] = "瀬谷区　";
$c_id[13] = "kanag"; $c_no[13] = "5"; $c_name[13] = "神奈川区　";
$c_id[14] = "kouhoku"; $c_no[14] = "8"; $c_name[14] = "港北区　";
$c_id[15] = "midori"; $c_no[15] = "17"; $c_name[15] = "緑　区　";
$c_id[16] = "aoba"; $c_no[16] = "1"; $c_name[16] = "青葉区　";
$c_id[17] = "tsuduki"; $c_no[17] = "11"; $c_name[17] = "都筑区　";
$c_id[18] = "tsurumi"; $c_no[18] = "12"; $c_name[18] = "鶴見区　";

while ( $pend < '19' ){
echo "“;
$count = “0”;

//———————————————————
//データベース設定
//———————————————————
define( “_DB_SERVER”, “localhost”);
define( “_DB_UID”, “test-db” );
define( “_DB_PASS”, “area110823” );
define( “_DB_NAME”, “test-db” );
//mysql接続
if(! $conn = mysql_connect(_DB_SERVER, _DB_UID, _DB_PASS)){
die( ‘Mysql接続失敗’);
}
//db選択
mysql_select_db(_DB_NAME, $conn );
$sql=’SET NAMES utf8′;
mysql_query( $sql,$conn );
//結果の解放
mysql_free_result($rs);
//SQl発行　
$rs= mysql_query(“select * from kaiin WHERE chiku_code = $c_no[$pend] ORDER BY iin_furigana “, $conn);
$sw101 = “0”;$exp_sw = “0”;
//1件ずつとりだす
while( $rec = mysql_fetch_array( $rs, MYSQL_ASSOC) ){
if($rec[“sinsin”] == “1”){
$count = $count+1;$t_count = $t_count+1;
}
}
//結果セットの開放
mysql_free_result($rs);
//切断
mysql_close($conn);
echo ““.”“.$c_name[$pend].$count.”　医療機関”.”“;
//
//echo ““;
echo “

“;
echo ““;
//
define(“_CHARSET”,”utf8″);
//include(“inc.php”)
//
//———————————————————
//データベース設定
//———————————————————
define( “_DB_SERVER”, “localhost”);
define( “_DB_UID”, “test-db” );
define( “_DB_PASS”, “area110823” );
define( “_DB_NAME”, “test-db” );
//mysql接続
if(! $conn = mysql_connect(_DB_SERVER, _DB_UID, _DB_PASS)){
die( ‘Mysql接続失敗’);
}
//db選択
mysql_select_db(_DB_NAME, $conn );
$sql=’SET NAMES utf8′;
mysql_query( $sql,$conn );
//結果の解放
mysql_free_result($rs);
//SQl発行　
$rs= mysql_query(“select * from kaiin WHERE chiku_code = $c_no[$pend] ORDER BY iin_furigana “, $conn);
$sw101 = “0”;$exp_sw = “0”;
//1件ずつとりだす
while( $rec = mysql_fetch_array( $rs, MYSQL_ASSOC) ){
if($rec[“sinsin”] == “1”){
if($exp_sw == “0”){
$exp_sw = “1”;
//タイトル表示
echo ““;
echo ““;
echo ““;
echo ““;
echo ““;
echo ““;
}
if($sw101 == “0”){
$sw101 = “1”;
echo ““;
}else{
$sw101 = “0”;
echo ““;
}
echo ““;
echo ““;
echo ““;
echo ““;
echo ““;
}
}
//結果セットの開放
mysql_free_result($rs);
//切断
mysql_close($conn);
$pend = $pend +1;
//
echo ““;
echo “

“.”医療機関名”.”	“.”診療所住所”.”	“.”ＴＥＬ”.”	“.”ＦＡＸ”.”
“.$rec[“iin_name”].”	“.$rec[“iin_adr”].”	“.$rec[“denwa_bango”].”	“.$rec[“fax_bango”].”

“;
echo “

“.”“.”▲TOPへ戻る”.”“.”

“;
}
//
echo “合　計　　　”.$t_count.”　協力医療機関”;
?>

横浜市歯科医師会｜横浜市 歯科医師会 歯医者 歯科

横浜市歯科医師会｜横浜市歯科医師会歯医者歯科