HTML FORM CODE 관리 : discuss_proposal_vote
수정 입력
<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='discuss_no' value='$discuss_no'>
<input type='text' class='basic_input_class' name='proposal_no' value='$proposal_no'>
<input type='text' class='basic_input_class' name='member_no' value='$member_no'>
<input type='text' class='basic_input_class' name='vote_choice' value='$vote_choice'>
<input type='text' class='basic_input_class' name='vote_score' value='$vote_score'>
<input type='text' class='basic_input_class' name='vote_text' value='$vote_text'>
<input type='text' class='basic_input_class' name='recorded' value='$recorded'>
</form>
</div>
생성된 테이블 목록 :
BLANK$no=$_POST['no'];
$discuss_no=$_POST['discuss_no'];
$proposal_no=$_POST['proposal_no'];
$member_no=$_POST['member_no'];
$vote_choice=$_POST['vote_choice'];
$vote_score=$_POST['vote_score'];
$vote_text=$_POST['vote_text'];
$recorded=$_POST['recorded'];
인서트문(INSERT/CREATE)
$insert_query="insert into `discuss_proposal_vote`( `no`, `discuss_no`, `proposal_no`, `member_no`, `vote_choice`, `vote_score`, `vote_text`, `recorded`) values( '$no', '$discuss_no', '$proposal_no', '$member_no', '$vote_choice', '$vote_score', '$vote_text', '$recorded')";
mysqli_query($connect,$insert_query);
업데이트문(UPDATE/MODIFY)
$update_query="update `discuss_proposal_vote` set `discuss_no`='$discuss_no', `proposal_no`='$proposal_no', `member_no`='$member_no', `vote_choice`='$vote_choice', `vote_score`='$vote_score', `vote_text`='$vote_text', `recorded`=now() where `no` like '$no'";
mysqli_query($connect,$update_query);
셀렉트문(READ/VIEW) : Multi-values
$records_query="select * from `discuss_proposal_vote` 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 `discuss_proposal_vote` 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 `discuss_proposal_vote` where `NO` like '$no'";
mysqli_query($connect,$delete_query);