MYSQL-PHP CODE PRESETS

수정 입력

<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='artwork_image' value='$artwork_image'>
		<input type='text' class='basic_input_class' name='profile_image' value='$profile_image'>
		<input type='text' class='basic_input_class' name='artwork_info' value='$artwork_info'>
		<textarea class='basic_textarea_class' name='artwork_description'>$artwork_description</textarea>
		<input type='text' class='basic_input_class' name='artist_name' value='$artist_name'>
		<input type='text' class='basic_input_class' name='artist_name_eng' value='$artist_name_eng'>
		<input type='text' class='basic_input_class' name='artist_email' value='$artist_email'>
		<input type='text' class='basic_input_class' name='artist_mobile' value='$artist_mobile'>
		<input type='text' class='basic_input_class' name='artist_birth' value='$artist_birth'>
		<input type='text' class='basic_input_class' name='artist_address' value='$artist_address'>
		<textarea class='basic_textarea_class' name='artist_history'>$artist_history</textarea>
		<input type='text' class='basic_input_class' name='agree' value='$agree'>
		<input type='text' class='basic_input_class' name='access_code' value='$access_code'>
		<input type='text' class='basic_input_class' name='collect' value='$collect'>
		<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

article

article_reply_complains

member_artist_works_simple

member_artwork

member_mailing

member_visitor

$no=$_POST['no'];
$code=$_POST['code'];
$member=$_POST['member'];
$artwork_image=$_POST['artwork_image'];
$profile_image=$_POST['profile_image'];
$artwork_info=$_POST['artwork_info'];
$artwork_description=$_POST['artwork_description'];
$artist_name=$_POST['artist_name'];
$artist_name_eng=$_POST['artist_name_eng'];
$artist_email=$_POST['artist_email'];
$artist_mobile=$_POST['artist_mobile'];
$artist_birth=$_POST['artist_birth'];
$artist_address=$_POST['artist_address'];
$artist_history=$_POST['artist_history'];
$agree=$_POST['agree'];
$access_code=$_POST['access_code'];
$collect=$_POST['collect'];
$memo=$_POST['memo'];
$saved=$_POST['saved'];

인서트문(INSERT/CREATE)
$insert_query="insert into `member_artwork`( `no`, `code`, `member`, `artwork_image`, `profile_image`, `artwork_info`, `artwork_description`, `artist_name`, `artist_name_eng`, `artist_email`, `artist_mobile`, `artist_birth`, `artist_address`, `artist_history`, `agree`, `access_code`, `collect`, `memo`, `saved`) values( '$no', '$code', '$member', '$artwork_image', '$profile_image', '$artwork_info', '$artwork_description', '$artist_name', '$artist_name_eng', '$artist_email', '$artist_mobile', '$artist_birth', '$artist_address', '$artist_history', '$agree', '$access_code', '$collect', '$memo', '$saved')";
mysqli_query($connect,$insert_query);

업데이트문(UPDATE/MODIFY)
$update_query="update `member_artwork` set `code`='$code', `member`='$member', `artwork_image`='$artwork_image', `profile_image`='$profile_image', `artwork_info`='$artwork_info', `artwork_description`='$artwork_description', `artist_name`='$artist_name', `artist_name_eng`='$artist_name_eng', `artist_email`='$artist_email', `artist_mobile`='$artist_mobile', `artist_birth`='$artist_birth', `artist_address`='$artist_address', `artist_history`='$artist_history', `agree`='$agree', `access_code`='$access_code', `collect`='$collect', `memo`='$memo', `saved`=now() where `no` like '$no'";
mysqli_query($connect,$update_query);

셀렉트문(READ/VIEW) : Multi-values

$records_query="select * from `member_artwork` 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
}