DB – 도서관리 테이블
HTML에서 Form태그 안에 있는 name 속성의 데이터들은 submit버튼을 클릭하면 form의 action 속성에 기재한 링크로 파라미터를 전송한다
도서관리 입력 HTML – book_register_form.html
<head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <style> </style> </head> 도서 저장<br> <form action="book_register.php" method="GET"> <table width=300> <tr> <td>title : </td><td><input type="text" name="title"/></td> </tr> <tr> <td>price : </td><td><input type="number" name="price"/></td> </tr> <tr> <td>publ : </td><td><input type="text" name="publ"/></td> </tr> <tr align=center> <td><input type="submit" value="저장" /></td> <td> <input type="reset" value="취소"/></td> </tr> </table> </form>
도서관리 입력 PHP – book_register.php
<?php
header("Content-Type: text/html; charset=UTF-8");
$title = $_GET['title'];
$price = $_GET['price'];
$publ = $_GET['publ'];
// echo "책제목 : ".$title;
//echo "책가격 : ".$price;
// echo "저 자 : ".$publ;
$sql = "INSERT INTO book(title,pric,publ) VALUES('$title',$price,'$publ');";
echo $sql;
?>
유저관리 입력 HTML- member_register_form.html
<head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <form action="member_register.php" method="GET"> <table width=300 > <tr> <td>학번 : </td><td><input type="text" name="hakbun"/></td> </tr> <tr> <td>이름 : </td><td><input type="text" name="name"/></td> </tr> <tr> <td>학과 : </td><td><input type="text" name="dept"/></td> </tr> <tr> <td>학년 : </td><td><input type="number" name="grade"/></td> </tr> <tr align="center"> <td><input type="submit" value="저장" /></td> <td><input type="reset" value="취소"/></td> </tr> </table> </form>
유저관리 입력 PHP – member_register.php
<?php
header("charset=UTF-8");
$hakbun = $_GET['hakbun'];
$name = $_GET['name'];
$dept = $_GET['dept'];
$grade = $_GET['grade'];
$conn = mysqli_connect('localhost','DB_ID','DB_PASSWORD','DB_NAME');
if(!$conn){
echo "MySQL can't connected";
exit;
}
if(strlen($hakbun)>0 and strlen($name)>0 and strlen($dept)>0 and strlen($grade)>0){
$sql = "INSERT INTO amember(hakbun,name,dept,grade) VALUES('$hakbun','$name','$dept','$grade');";
echo "SQL : ".$sql."<br>";
$result = mysqli_query($conn,$sql);
if(strlen($result)>0){
echo "Result : ".$result;
}else{
echo "Fail INSERT";
}
}
mysqli_close($conn);
?>