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

TEST FUNCTION : [ADD_TRANSACTION] [LIST_TRANSACTIONS]

HTML FORM CODE 관리 : ddf_reply
수정 입력
<div class='basic_form_div'>
<form name='basic_form' method='post' action='' target='data_exec_frame'>
<input type='text' class='basic_input_class' name='reply_no' value='$reply_no'>
<input type='text' class='basic_input_class' name='reply_id' value='$reply_id'>
<input type='text' class='basic_input_class' name='parent_id' value='$parent_id'>
<input type='text' class='basic_input_class' name='parent_origin' value='$parent_origin'>
<input type='text' class='basic_input_class' name='member_no' value='$member_no'>
<input type='text' class='basic_input_class' name='reply_text' value='$reply_text'>
<input type='text' class='basic_input_class' name='reply_option' value='$reply_option'>
<input type='text' class='basic_input_class' name='reply_score' value='$reply_score'>
<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='likes' value='$likes'>
</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

$reply_no=$_POST['reply_no'];
$reply_id=$_POST['reply_id'];
$parent_id=$_POST['parent_id'];
$parent_origin=$_POST['parent_origin'];
$member_no=$_POST['member_no'];
$reply_text=$_POST['reply_text'];
$reply_option=$_POST['reply_option'];
$reply_score=$_POST['reply_score'];
$saved=$_POST['saved'];
$updated=$_POST['updated'];
$likes=$_POST['likes'];
인서트문(INSERT/CREATE)
$insert_query="insert into `ddf_reply`( `reply_no`, `reply_id`, `parent_id`, `parent_origin`, `member_no`, `reply_text`, `reply_option`, `reply_score`, `saved`, `updated`, `likes`) values( '$reply_no', '$reply_id', '$parent_id', '$parent_origin', '$member_no', '$reply_text', '$reply_option', '$reply_score', '$saved', '$updated', '$likes')";
mysqli_query($connect,$insert_query);
업데이트문(UPDATE/MODIFY)
$update_query="update `ddf_reply` set `reply_id`='$reply_id', `parent_id`='$parent_id', `parent_origin`='$parent_origin', `member_no`='$member_no', `reply_text`='$reply_text', `reply_option`='$reply_option', `reply_score`='$reply_score', `saved`=now(), `updated`=now(), `likes`='$likes' where `reply_no` like '$reply_no'";
mysqli_query($connect,$update_query);
셀렉트문(READ/VIEW) : Multi-values
$records_query="select * from `ddf_reply` 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_reply` 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_reply` where `NO` like '$no'";
mysqli_query($connect,$delete_query);