수정 입력

<div class='basic_form_div'>
	<form name='basic_form' method='post' action='' target='data_exec_frame'>
		<input type='text' class='basic_input_class' name='room_no' value='$room_no'>
		<input type='text' class='basic_input_class' name='member_no' value='$member_no'>
		<input type='text' class='basic_input_class' name='title' value='$title'>
		<input type='text' class='basic_input_class' name='created' value='$created'>
		<input type='text' class='basic_input_class' name='status' value='$status'>
	</form>
</div>

인서트문(INSERT/CREATE)
$insert_query="insert into `talk_room`( `room_no`, `member_no`, `title`, `created`, `status`) values( '$room_no', '$member_no', '$title', '$created', '$status')";
mysqli_query($connect,$insert_query);

업데이트문(UPDATE/MODIFY)
$update_query="update `talk_room` set `member_no`='$member_no', `title`='$title', `created`=now(), `status`='$status' where `room_no` like '$room_no'";
mysqli_query($connect,$update_query);

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

$records_query="select * from `talk_room` 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 `talk_room` 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 `talk_room` where `NO` like '$no'";
mysqli_query($connect,$delete_query);