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

TEST FUNCTION : [ADD_TRANSACTION] [LIST_TRANSACTIONS]

HTML FORM CODE 관리 : CONSTITUTION_COMPARE
수정 입력
<div class='basic_form_div'>
<form name='basic_form' method='post' action='' target='data_exec_frame'>
<input type='text' class='basic_input_class' name='a' value='$a'>
<textarea class='basic_textarea_class' name='b'>$b</textarea>
<textarea class='basic_textarea_class' name='c'>$c</textarea>
<textarea class='basic_textarea_class' name='d'>$d</textarea>
<textarea class='basic_textarea_class' name='e'>$e</textarea>
<textarea class='basic_textarea_class' name='f'>$f</textarea>
<input type='text' class='basic_input_class' name='on' value='$on'>
<input type='text' class='basic_input_class' name='candis' value='$candis'>
<textarea class='basic_textarea_class' name='addition'>$addition</textarea>
</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

$a=$_POST['a'];
$b=$_POST['b'];
$c=$_POST['c'];
$d=$_POST['d'];
$e=$_POST['e'];
$f=$_POST['f'];
$on=$_POST['on'];
$candis=$_POST['candis'];
$addition=$_POST['addition'];
인서트문(INSERT/CREATE)
$insert_query="insert into `CONSTITUTION_COMPARE`( `A`, `B`, `C`, `D`, `E`, `F`, `ON`, `CANDIS`, `ADDITION`) values( '$a', '$b', '$c', '$d', '$e', '$f', '$on', '$candis', '$addition')";
mysqli_query($connect,$insert_query);
업데이트문(UPDATE/MODIFY)
$update_query="update `CONSTITUTION_COMPARE` set `B`='$b', `C`='$c', `D`='$d', `E`='$e', `F`='$f', `ON`='$on', `CANDIS`='$candis', `ADDITION`='$addition' where `A` like '$a'";
mysqli_query($connect,$update_query);
셀렉트문(READ/VIEW) : Multi-values
$records_query="select * from `CONSTITUTION_COMPARE` 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 `CONSTITUTION_COMPARE` 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 `CONSTITUTION_COMPARE` where `NO` like '$no'";
mysqli_query($connect,$delete_query);