HTML FORM CODE 관리 : member_artist_works
수정 입력
<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='category' value='$category'>
<input type='text' class='basic_input_class' name='origin' value='$origin'>
<input type='text' class='basic_input_class' name='number' value='$number'>
<input type='text' class='basic_input_class' name='artist' value='$artist'>
<input type='text' class='basic_input_class' name='width' value='$width'>
<input type='text' class='basic_input_class' name='height' value='$height'>
<input type='text' class='basic_input_class' name='material' value='$material'>
<input type='text' class='basic_input_class' name='method' value='$method'>
<input type='text' class='basic_input_class' name='base' value='$base'>
<input type='text' class='basic_input_class' name='frame' value='$frame'>
<input type='text' class='basic_input_class' name='image_large' value='$image_large'>
<input type='text' class='basic_input_class' name='image_normal' value='$image_normal'>
<input type='text' class='basic_input_class' name='manif_path' value='$manif_path'>
<input type='text' class='basic_input_class' name='certification_path' value='$certification_path'>
<input type='text' class='basic_input_class' name='certification_code' value='$certification_code'>
<input type='text' class='basic_input_class' name='dna' value='$dna'>
<input type='text' class='basic_input_class' name='copyright' value='$copyright'>
<input type='text' class='basic_input_class' name='presented' value='$presented'>
<input type='text' class='basic_input_class' name='location' value='$location'>
<input type='text' class='basic_input_class' name='possession' value='$possession'>
<input type='text' class='basic_input_class' name='price' value='$price'>
<input type='text' class='basic_input_class' name='tags' value='$tags'>
<textarea class='basic_textarea_class' name='description'>$description</textarea>
<input type='text' class='basic_input_class' name='social_links' value='$social_links'>
<input type='text' class='basic_input_class' name='memo' value='$memo'>
<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'];
$category=$_POST['category'];
$origin=$_POST['origin'];
$number=$_POST['number'];
$artist=$_POST['artist'];
$width=$_POST['width'];
$height=$_POST['height'];
$material=$_POST['material'];
$method=$_POST['method'];
$base=$_POST['base'];
$frame=$_POST['frame'];
$image_large=$_POST['image_large'];
$image_normal=$_POST['image_normal'];
$manif_path=$_POST['manif_path'];
$certification_path=$_POST['certification_path'];
$certification_code=$_POST['certification_code'];
$dna=$_POST['dna'];
$copyright=$_POST['copyright'];
$presented=$_POST['presented'];
$location=$_POST['location'];
$possession=$_POST['possession'];
$price=$_POST['price'];
$tags=$_POST['tags'];
$description=$_POST['description'];
$social_links=$_POST['social_links'];
$memo=$_POST['memo'];
$saved=$_POST['saved'];
인서트문(INSERT/CREATE)
$insert_query="insert into `member_artist_works`( `no`, `code`, `member`, `title`, `category`, `origin`, `number`, `artist`, `width`, `height`, `material`, `method`, `base`, `frame`, `image_large`, `image_normal`, `manif_path`, `certification_path`, `certification_code`, `dna`, `copyright`, `presented`, `location`, `possession`, `price`, `tags`, `description`, `social_links`, `memo`, `saved`) values( '$no', '$code', '$member', '$title', '$category', '$origin', '$number', '$artist', '$width', '$height', '$material', '$method', '$base', '$frame', '$image_large', '$image_normal', '$manif_path', '$certification_path', '$certification_code', '$dna', '$copyright', '$presented', '$location', '$possession', '$price', '$tags', '$description', '$social_links', '$memo', '$saved')";
mysqli_query($connect,$insert_query);
업데이트문(UPDATE/MODIFY)
$update_query="update `member_artist_works` set `code`='$code', `member`='$member', `title`='$title', `category`='$category', `origin`='$origin', `number`='$number', `artist`='$artist', `width`='$width', `height`='$height', `material`='$material', `method`='$method', `base`='$base', `frame`='$frame', `image_large`='$image_large', `image_normal`='$image_normal', `manif_path`='$manif_path', `certification_path`='$certification_path', `certification_code`='$certification_code', `dna`='$dna', `copyright`='$copyright', `presented`='$presented', `location`='$location', `possession`='$possession', `price`='$price', `tags`='$tags', `description`='$description', `social_links`='$social_links', `memo`='$memo', `saved`=now() where `no` like '$no'";
mysqli_query($connect,$update_query);
셀렉트문(READ/VIEW) : Multi-values
$records_query="select * from `member_artist_works` 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` 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` where `NO` like '$no'";
mysqli_query($connect,$delete_query);