홈페이지 : [HOMEPAGE] 페이지 스크립트 : [Y_SCRIPTS] 데이터베이스 관리 : [PHPMYADMIN]

TEST FUNCTION : [ADD_TRANSACTION] [LIST_TRANSACTIONS]

HTML FORM CODE 관리 : books
수정 입력
<div class='basic_form_div'>
<form name='basic_form' method='post' action='' target='data_exec_frame'>
<input type='text' class='basic_input_class' name='id' value='$id'>
<input type='text' class='basic_input_class' name='name' value='$name'>
<input type='text' class='basic_input_class' name='author' value='$author'>
<input type='text' class='basic_input_class' name='created_at' value='$created_at'>
<input type='text' class='basic_input_class' name='updated_at' value='$updated_at'>
</form>
</div>
생성된 테이블 목록 : BLANK
BOARD
books
fair_articles
fair_articles_like
fair_articles_replies
fair_category
fair_contacts
fair_contacts_chat
fair_contents
fair_members
fair_members_mailing

$id=$_POST['id'];
$name=$_POST['name'];
$author=$_POST['author'];
$created_at=$_POST['created_at'];
$updated_at=$_POST['updated_at'];
인서트문(INSERT/CREATE)
$insert_query="insert into `books`( `id`, `name`, `author`, `created_at`, `updated_at`) values( '$id', '$name', '$author', '$created_at', '$updated_at')";
mysqli_query($connect,$insert_query);
업데이트문(UPDATE/MODIFY)
$update_query="update `books` set `name`='$name', `author`='$author', `created_at`='$created_at', `updated_at`='$updated_at' where `id` like '$id'";
mysqli_query($connect,$update_query);
셀렉트문(READ/VIEW) : Multi-values
$records_query="select * from `books` 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 `books` 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 `books` where `NO` like '$no'";
mysqli_query($connect,$delete_query);