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

TEST FUNCTION : [ADD_TRANSACTION] [LIST_TRANSACTIONS]

HTML FORM CODE 관리 : POLICIES
수정 입력
<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='title' value='$title'>
<input type='text' class='basic_input_class' name='members' value='$members'>
<input type='text' class='basic_input_class' name='term1' value='$term1'>
<input type='text' class='basic_input_class' name='term1_ok1' value='$term1_ok1'>
<input type='text' class='basic_input_class' name='term1_ok2' value='$term1_ok2'>
<input type='text' class='basic_input_class' name='term2' value='$term2'>
<input type='text' class='basic_input_class' name='term3' value='$term3'>
<input type='text' class='basic_input_class' name='term3_ok' value='$term3_ok'>
<input type='text' class='basic_input_class' name='term4' value='$term4'>
<input type='text' class='basic_input_class' name='term5' value='$term5'>
<input type='text' class='basic_input_class' name='term6' value='$term6'>
<input type='text' class='basic_input_class' name='term6_ok1' value='$term6_ok1'>
<input type='text' class='basic_input_class' name='term6_ok2' value='$term6_ok2'>
</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'];
$title=$_POST['title'];
$members=$_POST['members'];
$term1=$_POST['term1'];
$term1_ok1=$_POST['term1_ok1'];
$term1_ok2=$_POST['term1_ok2'];
$term2=$_POST['term2'];
$term3=$_POST['term3'];
$term3_ok=$_POST['term3_ok'];
$term4=$_POST['term4'];
$term5=$_POST['term5'];
$term6=$_POST['term6'];
$term6_ok1=$_POST['term6_ok1'];
$term6_ok2=$_POST['term6_ok2'];
인서트문(INSERT/CREATE)
$insert_query="insert into `POLICIES`( `NO`, `TITLE`, `MEMBERS`, `TERM1`, `TERM1_OK1`, `TERM1_OK2`, `TERM2`, `TERM3`, `TERM3_OK`, `TERM4`, `TERM5`, `TERM6`, `TERM6_OK1`, `TERM6_OK2`) values(null, '$title', '$members', '$term1', '$term1_ok1', '$term1_ok2', '$term2', '$term3', '$term3_ok', '$term4', '$term5', '$term6', '$term6_ok1', '$term6_ok2')";
mysqli_query($connect,$insert_query);
업데이트문(UPDATE/MODIFY)
$update_query="update `POLICIES` set `TITLE`='$title', `MEMBERS`='$members', `TERM1`='$term1', `TERM1_OK1`='$term1_ok1', `TERM1_OK2`='$term1_ok2', `TERM2`='$term2', `TERM3`='$term3', `TERM3_OK`='$term3_ok', `TERM4`='$term4', `TERM5`='$term5', `TERM6`='$term6', `TERM6_OK1`='$term6_ok1', `TERM6_OK2`='$term6_ok2' where `NO` like '$no'";
mysqli_query($connect,$update_query);
셀렉트문(READ/VIEW) : Multi-values
$records_query="select * from `POLICIES` 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 `POLICIES` 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 `POLICIES` where `NO` like '$no'";
mysqli_query($connect,$delete_query);