HTML FORM CODE 관리 : member_artist
수정 입력
<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='access_code' value='$access_code'>
<input type='text' class='basic_input_class' name='member' value='$member'>
<input type='text' class='basic_input_class' name='name' value='$name'>
<input type='text' class='basic_input_class' name='nationality' value='$nationality'>
<input type='text' class='basic_input_class' name='residence' value='$residence'>
<input type='text' class='basic_input_class' name='birth' value='$birth'>
<input type='text' class='basic_input_class' name='bith_year' value='$bith_year'>
<input type='text' class='basic_input_class' name='pass_year' value='$pass_year'>
<input type='text' class='basic_input_class' name='academy_record' value='$academy_record'>
<input type='text' class='basic_input_class' name='activity_record' value='$activity_record'>
<input type='text' class='basic_input_class' name='prize_record' value='$prize_record'>
<input type='text' class='basic_input_class' name='engage' value='$engage'>
<input type='text' class='basic_input_class' name='nickname' value='$nickname'>
<input type='text' class='basic_input_class' name='profile_image' value='$profile_image'>
<input type='text' class='basic_input_class' name='avatar_image' value='$avatar_image'>
<input type='text' class='basic_input_class' name='digital_stamp' value='$digital_stamp'>
<textarea class='basic_textarea_class' name='introduction'>$introduction</textarea>
<input type='text' class='basic_input_class' name='phone_number' value='$phone_number'>
<input type='text' class='basic_input_class' name='mobile_number' value='$mobile_number'>
<input type='text' class='basic_input_class' name='email_address' value='$email_address'>
<input type='text' class='basic_input_class' name='social_link' value='$social_link'>
<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'];
$access_code=$_POST['access_code'];
$member=$_POST['member'];
$name=$_POST['name'];
$nationality=$_POST['nationality'];
$residence=$_POST['residence'];
$birth=$_POST['birth'];
$bith_year=$_POST['bith_year'];
$pass_year=$_POST['pass_year'];
$academy_record=$_POST['academy_record'];
$activity_record=$_POST['activity_record'];
$prize_record=$_POST['prize_record'];
$engage=$_POST['engage'];
$nickname=$_POST['nickname'];
$profile_image=$_POST['profile_image'];
$avatar_image=$_POST['avatar_image'];
$digital_stamp=$_POST['digital_stamp'];
$introduction=$_POST['introduction'];
$phone_number=$_POST['phone_number'];
$mobile_number=$_POST['mobile_number'];
$email_address=$_POST['email_address'];
$social_link=$_POST['social_link'];
$memo=$_POST['memo'];
$saved=$_POST['saved'];
인서트문(INSERT/CREATE)
$insert_query="insert into `member_artist`( `no`, `code`, `access_code`, `member`, `name`, `nationality`, `residence`, `birth`, `bith_year`, `pass_year`, `academy_record`, `activity_record`, `prize_record`, `engage`, `nickname`, `profile_image`, `avatar_image`, `digital_stamp`, `introduction`, `phone_number`, `mobile_number`, `email_address`, `social_link`, `memo`, `saved`) values( '$no', '$code', '$access_code', '$member', '$name', '$nationality', '$residence', '$birth', '$bith_year', '$pass_year', '$academy_record', '$activity_record', '$prize_record', '$engage', '$nickname', '$profile_image', '$avatar_image', '$digital_stamp', '$introduction', '$phone_number', '$mobile_number', '$email_address', '$social_link', '$memo', '$saved')";
mysqli_query($connect,$insert_query);
업데이트문(UPDATE/MODIFY)
$update_query="update `member_artist` set `code`='$code', `access_code`='$access_code', `member`='$member', `name`='$name', `nationality`='$nationality', `residence`='$residence', `birth`='$birth', `bith_year`='$bith_year', `pass_year`='$pass_year', `academy_record`='$academy_record', `activity_record`='$activity_record', `prize_record`='$prize_record', `engage`='$engage', `nickname`='$nickname', `profile_image`='$profile_image', `avatar_image`='$avatar_image', `digital_stamp`='$digital_stamp', `introduction`='$introduction', `phone_number`='$phone_number', `mobile_number`='$mobile_number', `email_address`='$email_address', `social_link`='$social_link', `memo`='$memo', `saved`=now() where `no` like '$no'";
mysqli_query($connect,$update_query);
셀렉트문(READ/VIEW) : Multi-values
$records_query="select * from `member_artist` 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` 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` where `NO` like '$no'";
mysqli_query($connect,$delete_query);