Changeset 11729 for branches/comu/html/inquiry/index.php
- Timestamp:
- 2007/03/10 21:35:02 (19 years ago)
- File:
-
- 1 edited
-
branches/comu/html/inquiry/index.php (modified) (10 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/comu/html/inquiry/index.php
r15 r11729 26 26 27 27 28 // ÅÔÆ»Éܸ©¥×¥ë¥À¥¦¥óÍÑÇÛÎó28 // 都道府県プルダウン用配列 29 29 $objPage->arrPref = $arrPref; 30 30 31 // CSV Êݸ¹àÌÜ32 //---- ÅÐÏ¿ÍÑ¥«¥é¥àÇÛÎó ¥ª¥×¥·¥ç¥ó°Ê³°31 // CSV保存項目 32 //---- 登録用カラム配列 オプション以外 33 33 $arrRegistColumn = array( 34 34 array( "column" => "name01", "convert" => "aKV" ), … … 51 51 52 52 if ( ( ! $_POST['mode'] == 'confirm' ) && ( ! is_numeric($_REQUEST['question_id']) ) ){ 53 echo " ÉÔÀµ¥¢¥¯¥»¥¹";53 echo "不正アクセス"; 54 54 exit; 55 55 } 56 56 57 // ¥Æ¥ó¥×¥ì¡¼¥ÈÅÐÏ¿¹àÌܼèÆÀ57 // テンプレート登録項目取得 58 58 $sql = "SELECT question_id, question FROM dtb_question WHERE question_id = ?"; 59 59 $result = $conn->getAll( $sql, array($_REQUEST['question_id']) ); … … 71 71 } elseif( $_POST['mode'] == "confirm" ) { 72 72 73 //-- ¡¡ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯73 //-- 入力エラーチェック 74 74 $objPage->arrForm = $_POST; 75 75 $objPage->arrForm = lfConvertParam($objPage->arrForm, $arrRegistColumn); … … 87 87 }elseif( $_POST['mode'] == "regist" ) { 88 88 89 //-- ¡¡ÆþÎÏʸ»ú¡¦ÊÑ´¹¡õ¥¨¥é¡¼¥Á¥§¥Ã¥¯89 //-- 入力文字・変換&エラーチェック 90 90 $objPage->arrForm = $_POST; 91 91 $objPage->arrForm = lfConvertParam($objPage->arrForm, $arrRegistColumn); … … 96 96 if( ! $objPage->arrErr ) { 97 97 98 // ´°Î»²èÌÌ98 //完了画面 99 99 $objPage->tpl_mainpage = "inquiry/complete.tpl"; 100 100 101 101 102 //--------- ¢§SQL ---------//102 //--------- ▼ SQL ---------// 103 103 104 // ¥Æ¡¼¥Ö¥ë¤ËÆþ¤ì¤ë¤è¤¦¤ËÀ°·Á¤¹¤ë104 // テーブルに入れるように整形する 105 105 $arrOption = $objPage->arrForm['option']; 106 106 unset ($objPage->arrForm['email02']); … … 123 123 } 124 124 $objPage->arrForm['create_date'] = "now()"; 125 // £Ä£ÂÅÐÏ¿125 // DB登録 126 126 $objQuery = new SC_Query(); 127 127 $objQuery->insert("dtb_question_result", $objPage->arrForm ); 128 128 129 //--------- ¢¥SQL ---------//129 //--------- ▲ SQL ---------// 130 130 131 131 } … … 137 137 138 138 139 //---- ¡¡¥Ú¡¼¥¸É½¼¨139 //---- ページ表示 140 140 $objView->_smarty->register_function("lfArray_Search_key_Smarty","lfArray_Search_key_Smarty"); 141 141 $objView->assignobj($objPage); 142 142 $objView->display($objPage->tpl_mainpage); 143 143 144 // ------------ ¥¨¥é¡¼¥Á¥§¥Ã¥¯½èÍýÉô------------144 // ------------ エラーチェック処理部 ------------ 145 145 function lfErrorCheck($array) { 146 146 147 147 $objErr = new SC_CheckError($array); 148 148 149 $objErr->doFunc(array(" ¤ªÌ¾Á°¡ÊÀ«¡Ë", 'name01', STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK","MAX_LENGTH_CHECK"));150 $objErr->doFunc(array(" ¤ªÌ¾Á°¡Ê̾¡Ë", 'name02', STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));151 $objErr->doFunc(array(" ¥Õ¥ê¥¬¥Ê(¥»¥¤¡Ë", 'kana01', STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK"));152 $objErr->doFunc(array(" ¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", 'kana02', STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK"));153 $objErr->doFunc(array(" Í¹ÊØÈÖ¹æ1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));154 $objErr->doFunc(array(" Í¹ÊØÈÖ¹æ2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));155 $objErr->doFunc(array(" Í¹ÊØÈÖ¹æ", "zip01", "zip02"), array("ALL_EXIST_CHECK"));156 $objErr->doFunc(array(" ÅÔÆ»Éܸ©", 'pref'), array("SELECT_CHECK","NUM_CHECK"));157 $objErr->doFunc(array(" ¤´½»½ê1", "addr01", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));158 $objErr->doFunc(array(" ¤´½»½ê2", "addr02", MTEXT_LEN), array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));159 $objErr->doFunc(array(" ¤ªÅÅÏÃÈÖ¹æ1", 'tel01'), array("EXIST_CHECK", "NUM_CHECK"));160 $objErr->doFunc(array(" ¤ªÅÅÏÃÈÖ¹æ2", 'tel02'), array("EXIST_CHECK", "NUM_CHECK"));161 $objErr->doFunc(array(" ¤ªÅÅÏÃÈÖ¹æ3", 'tel03'), array("EXIST_CHECK", "NUM_CHECK"));162 $objErr->doFunc(array(' ¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", MTEXT_LEN) ,array("EXIST_CHECK", "SPTAB_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));163 $objErr->doFunc(array(' ¥á¡¼¥ë¥¢¥É¥ì¥¹(³Îǧ)', "email02", MTEXT_LEN) ,array("EXIST_CHECK", "SPTAB_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));164 $objErr->doFunc(array(' ¥á¡¼¥ë¥¢¥É¥ì¥¹', '¥á¡¼¥ë¥¢¥É¥ì¥¹(³Îǧ)', "email", "email02") ,array("EQUAL_CHECK"));149 $objErr->doFunc(array("お名前(姓)", 'name01', STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK","MAX_LENGTH_CHECK")); 150 $objErr->doFunc(array("お名前(名)", 'name02', STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 151 $objErr->doFunc(array("フリガナ(セイ)", 'kana01', STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); 152 $objErr->doFunc(array("フリガナ(メイ)", 'kana02', STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); 153 $objErr->doFunc(array("郵便番号1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); 154 $objErr->doFunc(array("郵便番号2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); 155 $objErr->doFunc(array("郵便番号", "zip01", "zip02"), array("ALL_EXIST_CHECK")); 156 $objErr->doFunc(array("都道府県", 'pref'), array("SELECT_CHECK","NUM_CHECK")); 157 $objErr->doFunc(array("ご住所1", "addr01", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 158 $objErr->doFunc(array("ご住所2", "addr02", MTEXT_LEN), array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 159 $objErr->doFunc(array("お電話番号1", 'tel01'), array("EXIST_CHECK", "NUM_CHECK")); 160 $objErr->doFunc(array("お電話番号2", 'tel02'), array("EXIST_CHECK", "NUM_CHECK")); 161 $objErr->doFunc(array("お電話番号3", 'tel03'), array("EXIST_CHECK", "NUM_CHECK")); 162 $objErr->doFunc(array('メールアドレス', "email", MTEXT_LEN) ,array("EXIST_CHECK", "SPTAB_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 163 $objErr->doFunc(array('メールアドレス(確認)', "email02", MTEXT_LEN) ,array("EXIST_CHECK", "SPTAB_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 164 $objErr->doFunc(array('メールアドレス', 'メールアドレス(確認)', "email", "email02") ,array("EQUAL_CHECK")); 165 165 166 166 $objErr->arrErr["option"] = array_map( "lfCheckNull", (array)$_POST['option'] ); … … 169 169 } 170 170 171 //---- ¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹171 //---- 取得文字列の変換 172 172 function lfConvertParam($array, $arrRegistColumn) { 173 173 174 // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó174 // カラム名とコンバート情報 175 175 foreach ($arrRegistColumn as $data) { 176 176 $arrConvList[ $data["column"] ] = $data["convert"]; 177 177 } 178 // ʸ»úÊÑ´¹178 // 文字変換 179 179 $new_array = array(); 180 180 foreach ($arrConvList as $key => $val) { … … 185 185 } 186 186 187 // ¥ª¥×¥·¥ç¥óÇÛÎóÍÑ187 // オプション配列用 188 188 for ($i=0; $i<count($array['option']); $i++){ 189 189 if ( is_array($array['option'][$i]) ){ … … 200 200 201 201 function lfGetArrInput( $arr ){ 202 // Ãͤ¬ÆþÎϤµ¤ì¤¿ÇÛÎó¤Î¤ß¤òÊÖ¤¹202 // 値が入力された配列のみを返す 203 203 204 204 if ( is_array($arr) ){
Note: See TracChangeset
for help on using the changeset viewer.
