"; // exit; //} // **************************************************** // Include ******************************************** require ("../lib/dbConn.inc"); require ("../lib/messages.inc"); // **************************************************** // DBConn Class Instance ****************************** $oci = new DBCONN(); // **************************************************** /* // ÀÌ¿ëÀÚ Á¤º¸ load *********************************** $qry = "SELECT name, civil_no, home_address, business_address, home_zip_code, business_zip_code, home_tel, business_tel, e_mail, mail_send_area "; $qry .= "FROM co_user_tbl "; $qry .= "WHERE UPPER(user_id) = UPPER('$id') "; if (!$oci->select($qry)) { MessagePage("DB Connect Error !!"); exit; } if (!$oci->fetchInto(&$col)) { MessagePage("DB Connect Error !!"); exit; } $oci->parsefree(); // **************************************************** // ÁֹιøÈ£ ******************************************* $nPos = strpos($col[CIVIL_NO], "-"); if ($nPos >= 0) { $civil_no1 = substr($col[CIVIL_NO], 0, $nPos); $civil_no2 = substr($col[CIVIL_NO], $nPos + 1, strlen($col[CIVIL_NO]) - $nPos - 1); } else { $civil_no1 = $col[CIVIL_NO]; $civil_no2 = ""; } // **************************************************** // ÁÖ¼Ò¿Í ¿ìÆí¹øÈ£ ¼±Åà ******************************* if ($col[MAIL_SEND_AREA] == "H") { // ÀÚÅà $address = $col[HOME_ADDRESS]; $zip1 = substr($col[HOME_ZIP_CODE], 0, 3); if (strlen($col[HOME_ZIP_CODE]) > 4) $zip2 = substr($col[HOME_ZIP_CODE], 4, 3); $tel = $col[HOME_TEL]; } else { // ȸ»ç $address = $col[BUSINESS_ADDRESS]; $zip1 = substr($col[BUSINESS_ZIP_CODE], 0, 3); if (strlen($col[BUSINESS_ZIP_CODE]) > 4) $zip2 = substr($col[BUSINESS_ZIP_CODE], 4, 3); $tel = $col[BUSINESS_TEL]; } // **************************************************** */ ?>

½ÅûÀÏÀÚ È¸¿øÁ¶È¸ * ½ÅûÀÚ * ÁֹιøÈ£ - ¿ìÆí¹øÈ£ - ÁÖ¼Ò * ÀüÈ­¹øÈ£ * E-Mail * Èñ¸Áµµ¼­¸í ÀúÀÛÀÚ ÃâÆÇ»ç * ÃâÆdzâ ÃßõÀÇ°ß (ÃÖ´ë100ÀÚ)