'rcp_no'に置換 $where = sprintf(" rcp_nm like '%%%s%%' ",$key); $ret = cs4_select($db,"bsc_r_new",$where); $line = array(); while($row = cs4_fetch_row($ret)){ foreach($row as $k => $value){ $tmp[$k] = $value; } $line = array( 'rcp_no' => $tmp['uniq_id'], 'rcp_nm' => $tmp['rcp_nm'], 'rcp_time' => $tmp['rcp_time'], 'rcp_num' => $tmp['rcp_num'] ); $list_rcp[] = $line; } $where = sprintf(" mtr_nm = '%s' ",$key); $ret = cs4_select($db,"bsc_mtr_gnr_s",$where); $line = array(); while($row = cs4_fetch_row($ret)){ foreach($row as $k => $value){ $tmp[$k] = $value; } $line = array( 'rcp_no' => $tmp['rcp_no'], 'mtr_nm' => $tmp['mtr_nm'] ); $list_mtr[] = $line; } //-- 2テーブルからヒットしたレシピをマージする $rcp_list = array_merge_recursive($list_rcp,$list_mtr); } break; case "quick": $where = sprintf(" pdc_no = %s ",$pdc_no); $ret = cs4_select($db,"bsc_p_pdc",$where); break; case "ing": $where = sprintf(" pdc_no = %s ",$pdc_no); $ret = cs4_select($db,"bsc_p_pdc",$where); break; } return $rcp_list; } /************************************************************* -------------------------------------------------------------- -------------------------------------------------------------- **************************************************************/ function get_rcp_list_gnr($db,$p){ $where = ""; switch($p['mode']){ // ジャンル指定 case 'genre': $where = " rcp_dlt=0 and rcp_gnr!=29000000"; break; } $ret = cs4_select($db,"bsc_r_new",$where); $tmp = array(); $i=0; while($row = cs4_fetch_row($ret)){ foreach($row as $key => $val){ $tmp[$i][$key] = $val; } $i++; } } /************************************************************* selectで使用する単位一覧HTMLを作成 -------------------------------------------------------------- 引　数：なし -------------------------------------------------------------- 戻り値：表示用HTML **************************************************************/ function get_select_unit(){ $select_unit = ""; $select_unit .= "g"; $select_unit .= "ml"; $select_unit .= "カップ"; $select_unit .= "杯"; $select_unit .= "適量"; $select_unit .= "少々"; $select_unit .= "個"; $select_unit .= "本"; $select_unit .= "片"; $select_unit .= "切"; $select_unit .= "袋"; $select_unit .= "cc"; $select_unit .= "把"; return $select_unit; } /************************************************************* デフォルト値のセットされたSELECTを作成する関数(材料単位用) -------------------------------------------------------------- 引　数：nameで使用する文字列 デフォルト値 valueと文字列の配列 $arr = array( 1 => "g", 2 => "ml", 3 => "本" ); -------------------------------------------------------------- 戻り値：表示用HTML **************************************************************/ function bbs_create_select($name,$default,$arr){ $list = ""; $list .= "\n"; /* if(constant('BBS_DEBUG_MODE')){ print "
name => ".$name; print "
default => ".$default; } */ foreach($arr as $key => $val){ /* if(constant('BBS_DEBUG_MODE')){ print "
key => ".$key; print "
val => ".$val; } */ if($name == "unit" && ($key == "4" || $key == "5")){continue;} $checked = ""; if($key == $default){ $checked = " selected"; } $list .= "".$val."\n"; } $list .= "
\n"; return $list; } /************************************************************* selectで使用する単位配列 -------------------------------------------------------------- 引　数：なし -------------------------------------------------------------- 戻り値：表示用HTML **************************************************************/ function get_select_unit_arr($all=0){ $select_unit_arr = array( 1 => "g", 2 => "ml", 3 => "杯", // 4 => "適量", // 5 => "少々", 6 => "個", 7 => "本", 8 => "片", 9 => "切", 10 => "袋", 11 => "cc", 12 => "把" ); if($all){ $select_unit_arr[4] = "適量"; $select_unit_arr[5] = "少々"; } return $select_unit_arr; } ?>