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

TEST FUNCTION : [ADD_TRANSACTION] [LIST_TRANSACTIONS]

HTML FORM CODE 관리 : ddf_article
수정 입력
<div class='basic_form_div'>
<form name='basic_form' method='post' action='' target='data_exec_frame'>
<input type='text' class='basic_input_class' name='article_no' value='$article_no'>
<input type='text' class='basic_input_class' name='article_id' value='$article_id'>
<input type='text' class='basic_input_class' name='article_code' value='$article_code'>
<input type='text' class='basic_input_class' name='member_no' value='$member_no'>
<input type='text' class='basic_input_class' name='collect_no' value='$collect_no'>
<input type='text' class='basic_input_class' name='subject' value='$subject'>
<input type='text' class='basic_input_class' name='title' value='$title'>
<input type='text' class='basic_input_class' name='subtitle' value='$subtitle'>
<input type='text' class='basic_input_class' name='brief' value='$brief'>
<input type='text' class='basic_input_class' name='poster' value='$poster'>
<input type='text' class='basic_input_class' name='video' value='$video'>
<input type='text' class='basic_input_class' name='contents' value='$contents'>
<input type='text' class='basic_input_class' name='tag' value='$tag'>
<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='hits' value='$hits'>
<input type='text' class='basic_input_class' name='likes' value='$likes'>
<input type='text' class='basic_input_class' name='replies' value='$replies'>
<input type='text' class='basic_input_class' name='notice' value='$notice'>
<input type='text' class='basic_input_class' name='notice_limit' value='$notice_limit'>
<input type='text' class='basic_input_class' name='front' value='$front'>
<input type='text' class='basic_input_class' name='front_limit' value='$front_limit'>
</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

$article_no=$_POST['article_no'];
$article_id=$_POST['article_id'];
$article_code=$_POST['article_code'];
$member_no=$_POST['member_no'];
$collect_no=$_POST['collect_no'];
$subject=$_POST['subject'];
$title=$_POST['title'];
$subtitle=$_POST['subtitle'];
$brief=$_POST['brief'];
$poster=$_POST['poster'];
$video=$_POST['video'];
$contents=$_POST['contents'];
$tag=$_POST['tag'];
$saved=$_POST['saved'];
$updated=$_POST['updated'];
$hits=$_POST['hits'];
$likes=$_POST['likes'];
$replies=$_POST['replies'];
$notice=$_POST['notice'];
$notice_limit=$_POST['notice_limit'];
$front=$_POST['front'];
$front_limit=$_POST['front_limit'];
인서트문(INSERT/CREATE)
$insert_query="insert into `ddf_article`( `article_no`, `article_id`, `article_code`, `member_no`, `collect_no`, `subject`, `title`, `subtitle`, `brief`, `poster`, `video`, `contents`, `tag`, `saved`, `updated`, `hits`, `likes`, `replies`, `notice`, `notice_limit`, `front`, `front_limit`) values( '$article_no', '$article_id', '$article_code', '$member_no', '$collect_no', '$subject', '$title', '$subtitle', '$brief', '$poster', '$video', '$contents', '$tag', '$saved', '$updated', '$hits', '$likes', '$replies', '$notice', '$notice_limit', '$front', '$front_limit')";
mysqli_query($connect,$insert_query);
업데이트문(UPDATE/MODIFY)
$update_query="update `ddf_article` set `article_id`='$article_id', `article_code`='$article_code', `member_no`='$member_no', `collect_no`='$collect_no', `subject`='$subject', `title`='$title', `subtitle`='$subtitle', `brief`='$brief', `poster`='$poster', `video`='$video', `contents`='$contents', `tag`='$tag', `saved`=now(), `updated`=now(), `hits`='$hits', `likes`='$likes', `replies`='$replies', `notice`='$notice', `notice_limit`='$notice_limit', `front`='$front', `front_limit`='$front_limit' where `article_no` like '$article_no'";
mysqli_query($connect,$update_query);
셀렉트문(READ/VIEW) : Multi-values
$records_query="select * from `ddf_article` 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_article` 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_article` where `NO` like '$no'";
mysqli_query($connect,$delete_query);