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