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