施設名五十音順はこちら
「歯科」=「歯」 「歯科口腔外科」=「外」 「小児歯科」=「小」 「矯正歯科」=「矯」
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 = '3' AND chiku_name<>‘0’ ORDER BY adr_furigana “, $conn);
$sw101 = “0”;
$exp_sw = “0”;
//1件ずつとりだす
while( $rec = mysql_fetch_array( $rs, MYSQL_ASSOC) ){
if($exp_sw == “0”){
$exp_sw = “1”;
//タイトル表示
echo ““; “;
echo ““.”施設名”.” “;
echo ““.”電話番号”.” “;
echo ““.”住 所”.” “;
echo ““.”診療科目”.” “;
echo “
}
if($sw101 == “0”){
$sw101 = “1”;
echo ““;
}else{
$sw101 = “0”;
echo ““; “;
}
echo ““.$rec[“iin_name”].” “;
$sw1001 = $rec[“denwa_bango”];
if($sw1001 == “”){
echo “
}else{
$sw1002 = mb_strcut( $rec[“denwa_bango”],0,3);
$sw1003 = mb_strcut( $rec[“denwa_bango”],0,4);
if(($sw1002 == “090”) or ($sw1002 == “080”) or ($sw1002 == “070”) or ($sw1002 == “060”) or ($sw1002 == “050”)){
//携帯電話
echo ““.$rec[“denwa_bango”].” “;
}else{
if ($sw1003 == “0120”){
//フリーダイヤル
echo ““.$rec[“denwa_bango”].” “;
}else{
//通常電話
echo ““.$rec[“denwa_bango”].” “;
}
}
}
echo ““.$rec[“iin_adr”].” “;
echo ““.$rec[“kamoku”].” “;
echo “
}
//結果セットの開放
mysql_free_result($rs);
//切断
mysql_close($conn);
?>