Web_Study-1

by

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);
?>

Leave a Comment