http://makand.tistory.com/entry/PHP-Mysql-insert-into-%EA%B5%AC%EB%AC%B8
person.php
<html>
<body>
<form action = "insert.php" method = "post">
이름 : <input type = "text" name = "user_name">
나이 : <input type = "text" name = "age">
<input type = "submit">
</form>
</body>
</html>
insert.php
<?php
$user_name = $_POST['user_name'];
$age = $_POST['age'];
$conn = mysqli_connect("localhost","root","","test_db");
//Check connection
if(mysqli_connect_errno()){
echo "MySQL 연결에 실패하였습니다 : " .mysqli_connect_error();
}
echo "insert";
echo $user_name;
echo "</br>";
echo $age;
mysqli_query($conn, "INSERT INTO persons (user_name, age) values ('$user_name','$age')");
mysqli_close($conn);
//person.php 페이지로 이동
echo "close";
echo("<meta http-equiv='Refresh' content='1'; URL=person.php;>");
?>
insert.php (수정 버전)
<?php
$user_name = $_POST['user_name'];
$age = $_POST['age'];
$conn = mysqli_connect("localhost","root","","test_db");
//Check connection
if(mysqli_connect_errno()){
echo "MySQL 연결에 실패하였습니다 : " .mysqli_connect_error();
}
mysqli_query($conn, "INSERT INTO persons (user_name, age) values ('$user_name','$age')");
mysqli_close($conn);
//person.php 페이지로 이동
echo("<meta URL=person.php;>");
echo $user_name;
echo "<br>";
echo $age;
echo "<br>";
?>
댓글 0
| 번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
|---|---|---|---|---|
| 11 | PHP MySQL DELETE | admin | 2018.04.11 | 1 |
| 10 | PHP MySQL UPDATE | admin | 2018.04.10 | 1 |
| 9 | PHP MySQL SELECT | admin | 2018.04.09 | 1 |
| 8 | PHP POST | admin | 2018.04.09 | 1 |
| » | PHP MySQL INSERT | admin | 2018.04.09 | 3 |
| 6 | PHP MySQL 연동 | admin | 2018.04.09 | 4 |
| 5 | 도움이 될것 같은 사이트 | admin | 2018.04.04 | 1 |
| 4 | TCP School에 적혀있는 간단한 설명 | admin | 2018.04.04 | 0 |
| 3 | TCP School MySQL | admin | 2018.04.03 | 0 |
| 2 | TCP School, 생활코딩 | admin | 2018.04.03 | 3 |
| 1 | 시장 | admin | 2018.03.27 | 1 |