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

TEST FUNCTION : [ADD_TRANSACTION] [LIST_TRANSACTIONS]

HTML FORM CODE 관리 : DELIBERATIONS
수정 입력
<div class='basic_form_div'>
<form name='basic_form' method='post' action='' target='data_exec_frame'>
<input type='text' class='basic_input_class' name='no' value='$no'>
<input type='text' class='basic_input_class' name='a_code' value='$a_code'>
<input type='text' class='basic_input_class' name='subject' value='$subject'>
<input type='text' class='basic_input_class' name='upper' value='$upper'>
<input type='text' class='basic_input_class' name='link' value='$link'>
<input type='text' class='basic_input_class' name='title' value='$title'>
<textarea class='basic_textarea_class' name='body'>$body</textarea>
<textarea class='basic_textarea_class' name='body2'>$body2</textarea>
<input type='text' class='basic_input_class' name='tags' value='$tags'>
<input type='text' class='basic_input_class' name='member_no' value='$member_no'>
<input type='text' class='basic_input_class' name='policy_no' value='$policy_no'>
<input type='text' class='basic_input_class' name='status' value='$status'>
<input type='text' class='basic_input_class' name='saved' value='$saved'>
<input type='text' class='basic_input_class' name='updated' value='$updated'>
<input type='text' class='basic_input_class' name='start' value='$start'>
<input type='text' class='basic_input_class' name='finish' value='$finish'>
</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

$no=$_POST['no'];
$a_code=$_POST['a_code'];
$subject=$_POST['subject'];
$upper=$_POST['upper'];
$link=$_POST['link'];
$title=$_POST['title'];
$body=$_POST['body'];
$body2=$_POST['body2'];
$tags=$_POST['tags'];
$member_no=$_POST['member_no'];
$policy_no=$_POST['policy_no'];
$status=$_POST['status'];
$saved=$_POST['saved'];
$updated=$_POST['updated'];
$start=$_POST['start'];
$finish=$_POST['finish'];
인서트문(INSERT/CREATE)
$insert_query="insert into `DELIBERATIONS`( `NO`, `A_CODE`, `SUBJECT`, `UPPER`, `LINK`, `TITLE`, `BODY`, `BODY2`, `TAGS`, `MEMBER_NO`, `POLICY_NO`, `STATUS`, `SAVED`, `UPDATED`, `START`, `FINISH`) values(null, '$a_code', '$subject', '$upper', '$link', '$title', '$body', '$body2', '$tags', '$member_no', '$policy_no', '$status', '$saved', '$updated', '$start', '$finish')";
mysqli_query($connect,$insert_query);
업데이트문(UPDATE/MODIFY)
$update_query="update `DELIBERATIONS` set `A_CODE`='$a_code', `SUBJECT`='$subject', `UPPER`='$upper', `LINK`='$link', `TITLE`='$title', `BODY`='$body', `BODY2`='$body2', `TAGS`='$tags', `MEMBER_NO`='$member_no', `POLICY_NO`='$policy_no', `STATUS`='$status', `SAVED`=now(), `UPDATED`=now(), `START`=now(), `FINISH`=now() where `NO` like '$no'";
mysqli_query($connect,$update_query);
셀렉트문(READ/VIEW) : Multi-values
$records_query="select * from `DELIBERATIONS` 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 `DELIBERATIONS` 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 `DELIBERATIONS` where `NO` like '$no'";
mysqli_query($connect,$delete_query);