페이지코드 관리 : [Y_SCRIPTS] 데이터베이스 관리 : [PHPMYADMIN]

TEST FUNCTION : [ADD_TRANSACTION] [LIST_TRANSACTIONS]

HTML FORM CODE 관리 : ddf_member
수정 입력
<div class='basic_form_div'>
<form name='basic_form' method='post' action='' target='data_exec_frame'>
<input type='text' class='basic_input_class' name='member_no' value='$member_no'>
<input type='text' class='basic_input_class' name='member_id' value='$member_id'>
<input type='text' class='basic_input_class' name='name' value='$name'>
<input type='text' class='basic_input_class' name='email' value='$email'>
<input type='text' class='basic_input_class' name='email_confirm' value='$email_confirm'>
<input type='text' class='basic_input_class' name='email_confirm_code' value='$email_confirm_code'>
<input type='text' class='basic_input_class' name='passwd' value='$passwd'>
<input type='text' class='basic_input_class' name='join_type' value='$join_type'>
<input type='text' class='basic_input_class' name='nick' value='$nick'>
<input type='text' class='basic_input_class' name='mobile' value='$mobile'>
<input type='text' class='basic_input_class' name='mobile_confirmed' value='$mobile_confirmed'>
<input type='text' class='basic_input_class' name='mobile_confirm_code' value='$mobile_confirm_code'>
<input type='text' class='basic_input_class' name='outer_certification_service' value='$outer_certification_service'>
<input type='text' class='basic_input_class' name='outer_certification_return' value='$outer_certification_return'>
<input type='text' class='basic_input_class' name='outer_certification_date' value='$outer_certification_date'>
<input type='text' class='basic_input_class' name='birth_year' value='$birth_year'>
<input type='text' class='basic_input_class' name='gender' value='$gender'>
<input type='text' class='basic_input_class' name='avatar_path' value='$avatar_path'>
<input type='text' class='basic_input_class' name='hello' value='$hello'>
<input type='text' class='basic_input_class' name='agreement' value='$agreement'>
<input type='text' class='basic_input_class' name='joined' value='$joined'>
<input type='text' class='basic_input_class' name='updated' value='$updated'>
<input type='text' class='basic_input_class' name='level' value='$level'>
<input type='text' class='basic_input_class' name='status' value='$status'>
</form>
</div>
생성된 테이블 목록 : BLANK
ARTICLES
ARTICLES_GROUP
ARTICLE_CANDIDATES
ARTICLE_REPLIES
ARTICLE_VOTE_CANDIDATES
ARTICLE_VOTE_DATA
ATTACHED_FILES
CONSTITUTION
CONSTITUTION_COMPARE
CONSTITUTION_S
CONSTITUTION_S_CANDIS
CONSTITUTION_S_OPINION
CONSTITUTION_S_VOTE
CONSTITUTION_S_VOTES
DELIBERATIONS
DELIBERATIONS_GROUP
DELIBERATIONS_REPLY
DELIBERATIONS_VOTE
DEMONSTRATION
MEMBER
POLICIES
RESPONDINGS
RESPONDINGS_REPLY
TEST_VOTE
UNITS
UNITS_MEMBERS
ddf_article
ddf_attachment
ddf_collect
ddf_likes
ddf_member
ddf_reply

$member_no=$_POST['member_no'];
$member_id=$_POST['member_id'];
$name=$_POST['name'];
$email=$_POST['email'];
$email_confirm=$_POST['email_confirm'];
$email_confirm_code=$_POST['email_confirm_code'];
$passwd=$_POST['passwd'];
$join_type=$_POST['join_type'];
$nick=$_POST['nick'];
$mobile=$_POST['mobile'];
$mobile_confirmed=$_POST['mobile_confirmed'];
$mobile_confirm_code=$_POST['mobile_confirm_code'];
$outer_certification_service=$_POST['outer_certification_service'];
$outer_certification_return=$_POST['outer_certification_return'];
$outer_certification_date=$_POST['outer_certification_date'];
$birth_year=$_POST['birth_year'];
$gender=$_POST['gender'];
$avatar_path=$_POST['avatar_path'];
$hello=$_POST['hello'];
$agreement=$_POST['agreement'];
$joined=$_POST['joined'];
$updated=$_POST['updated'];
$level=$_POST['level'];
$status=$_POST['status'];
인서트문(INSERT/CREATE)
$insert_query="insert into `ddf_member`( `member_no`, `member_id`, `name`, `email`, `email_confirm`, `email_confirm_code`, `passwd`, `join_type`, `nick`, `mobile`, `mobile_confirmed`, `mobile_confirm_code`, `outer_certification_service`, `outer_certification_return`, `outer_certification_date`, `birth_year`, `gender`, `avatar_path`, `hello`, `agreement`, `joined`, `updated`, `level`, `status`) values( '$member_no', '$member_id', '$name', '$email', '$email_confirm', '$email_confirm_code', '$passwd', '$join_type', '$nick', '$mobile', '$mobile_confirmed', '$mobile_confirm_code', '$outer_certification_service', '$outer_certification_return', '$outer_certification_date', '$birth_year', '$gender', '$avatar_path', '$hello', '$agreement', '$joined', '$updated', '$level', '$status')";
mysqli_query($connect,$insert_query);
업데이트문(UPDATE/MODIFY)
$update_query="update `ddf_member` set `member_id`='$member_id', `name`='$name', `email`='$email', `email_confirm`='$email_confirm', `email_confirm_code`='$email_confirm_code', `passwd`='$passwd', `join_type`='$join_type', `nick`='$nick', `mobile`='$mobile', `mobile_confirmed`='$mobile_confirmed', `mobile_confirm_code`='$mobile_confirm_code', `outer_certification_service`='$outer_certification_service', `outer_certification_return`='$outer_certification_return', `outer_certification_date`=now(), `birth_year`='$birth_year', `gender`='$gender', `avatar_path`='$avatar_path', `hello`='$hello', `agreement`='$agreement', `joined`=now(), `updated`=now(), `level`='$level', `status`='$status' where `member_no` like '$member_no'";
mysqli_query($connect,$update_query);
셀렉트문(READ/VIEW) : Multi-values
$records_query="select * from `ddf_member` where `NO` like '$no'";
$records_result=mysqli_query($connect,$records_query);
$records_num=mysqli_affected_rows($connect);
for($i=0;$i<$records_num;$i++) {
$record_row=mysqli_fetch_array($records_result);
//your code for table record value
}
셀렉트문(READ/VIEW) : Specific-value
$record_query="select * from `ddf_member` where `NO` like '$no'";
$record_result=mysqli_query($connect,$record_query);
$record_row=mysqli_fetch_array($record_result);
//your code for table record value
델리트문(DELETE/ERASE)
$delete_query="delete from `ddf_member` where `NO` like '$no'";
mysqli_query($connect,$delete_query);