// ###################################### // 居酒屋(飲食店)予約 ( original 病院予約) // 2001/05 // ###################################### // 予約フォーム表示(step1) function step1($shop_no,$shop_no2,$ninzu,$prod_name,$office,$namae,$tel,$email,$value_month,$value_day,$hour,$min,$mukae,$taxi_ninzu,$taxi_hour,$taxi_hour,$taxi_min,$taxi_kobou){ global $PHP_SELF; $database = pg_connect("dbname=mall"); pg_set_client_encoding($database,"SJIS"); if (!$database){ echo "Can't connect to database...."; } if($shop_no != ""){ $result = pg_exec ($database,"select * from shop_info where (tmp2='3'or tmp2='0') and shop_no='$shop_no' and chk='1'"); }else{ $result = pg_exec ($database,"select * from shop_info where (tmp2='3'or tmp2='0') and tmp1='$shop_no2' and chk='1'"); } // tmp2 が3なら居酒屋 // tmp2 が2なら病院 // 1は美容院 $rows = pg_numrows($result); if ($rows == 0){ echo("該当する店舗がありません。"); pg_freeresult($result); exit; } $arr = pg_fetch_array($result,0); $shop_no = $arr["shop_no"]; $shopname = $arr["shop_name"]; $name = $arr["$name"]; $zip = $arr["zip"]; $path = $arr["path"]; $address = $arr["address"]; $tel_no = $arr["tel_no"]; $fax_no = $arr["fax_no"]; $url = $arr["url"]; $mail = $arr["mail"]; $holiday = $arr["holiday"]; $start_time = $arr["start_time"]; $end_time = $arr["end_time"]; pg_freeresult($result); $year = date("Y"); // 今は何年? $t_month = date("m"); // 今は何月? $t_day = date("d"); // 今は何日? $plus_day = 0; // いつから予約可能か? 今日からだと0 $limit_min2 = date("Y年m月d日",mktime(0,0,0,$t_month,$t_day+$plus_day,$year)); // 今日+0の日付(表示用) $limit_max2 = date("Y年m月d日",mktime(0,0,0,$t_month,$t_day+60,$year)); // 今から、60日後の日付(表示用) // yoyaku_detailから $sqlstr = "select info from yoyaku_detail where shop_no='$shop_no' and chk='1'"; $result = pg_exec ($database,$sqlstr); $rows = pg_numrows($result); if ($rows == 0){ $info = ""; pg_freeresult($result); }else{ $data = pg_fetch_array($result,0); $info = $data[info]; pg_freeresult($result); } ?>
echo $info;?> |
ご予約希望の情報をお店へ送信いたします。
上記の説明を良く読み、必要事項を入力し、「次へ」をクリックしてください。