DB초보입니다.
DB왕초보라 공부 하려고 짰는데...
DB에 입력이 안되네요... 짠 프로그램상 오류는 없구요.
소스입니다.
config.php
[code]
<?
// DB 좁속 및 뿌려주기
function dbconn(){
$connect = mysql_connect("localhost","아이디","비번");
mysql_select_db("test",$connect);
return $connect;
}
?>
[/code]
index.php
[code]
<?
include "config.php";
$connect = dbconn();
?>
<head>
<title>테스트</title>
<link rel=stylesheet href=style.css type=text/css>
</head>
<div align=center>
<table width=600 border=1>
<tr>
<td>테스트1</td>
<td>테스트2</td>
<td>테스트3</td>
<td>테스트4</td>
<td>테스트5</td>
</tr>
</table>
<table width=600 border=1>
<tr>
<td align=right>[<a href="write.php">글쓰기</a>]</td>
</tr>
</table>
</div>
[/code]
write.php
[code]
<?
include "config.php";
$connect = dbconn();
?>
<head>
<title>DB입력하기</title>
<link rel=stylesheet href="style.css" type=text/css>
</head>
<div align=center>
<form action="write_ok.php" method=post>
<table width=600 border=1>
<tr>
<td colspan=2 align=center>DB입력하기</td>
</tr>
<tr>
<td>테스트 1</td>
<td><input type=text name=test1 size=60></td>
</tr>
<tr>
<td>테스트 2</td>
<td><input type=text name=test2 size=60></td>
</tr>
<tr>
<td>테스트 3</td>
<td><input type=text name=test3 size=60></td>
</tr>
<tr>
<td>테스트 4</td>
<td><input type=text name=test4 size=60></td>
</tr>
<tr>
<td>테스트 5</td>
<td><textarea name=test5 cols=59 rows=8></textarea></td>
</tr>
<tr>
<td colspan=2 align=right><input type=submit value="쓰기"></td>
</tr>
</table>
</form>
[/code]
write_ok.php
[code]
<?
include "config.php";
$connect = dbconn();
$query = "insert into test(test1, test2, test3, test4, test5)
values('$test1','$test2','$test3','$test4','$test5') ";
mysql_query($query, $connect);
?>
<script>
location.href='index.php';
</script>
[/code]
왜? 안되는걸까요?
DB에 입력이 안되네요... 짠 프로그램상 오류는 없구요.
소스입니다.
config.php
[code]
<?
// DB 좁속 및 뿌려주기
function dbconn(){
$connect = mysql_connect("localhost","아이디","비번");
mysql_select_db("test",$connect);
return $connect;
}
?>
[/code]
index.php
[code]
<?
include "config.php";
$connect = dbconn();
?>
<head>
<title>테스트</title>
<link rel=stylesheet href=style.css type=text/css>
</head>
<div align=center>
<table width=600 border=1>
<tr>
<td>테스트1</td>
<td>테스트2</td>
<td>테스트3</td>
<td>테스트4</td>
<td>테스트5</td>
</tr>
</table>
<table width=600 border=1>
<tr>
<td align=right>[<a href="write.php">글쓰기</a>]</td>
</tr>
</table>
</div>
[/code]
write.php
[code]
<?
include "config.php";
$connect = dbconn();
?>
<head>
<title>DB입력하기</title>
<link rel=stylesheet href="style.css" type=text/css>
</head>
<div align=center>
<form action="write_ok.php" method=post>
<table width=600 border=1>
<tr>
<td colspan=2 align=center>DB입력하기</td>
</tr>
<tr>
<td>테스트 1</td>
<td><input type=text name=test1 size=60></td>
</tr>
<tr>
<td>테스트 2</td>
<td><input type=text name=test2 size=60></td>
</tr>
<tr>
<td>테스트 3</td>
<td><input type=text name=test3 size=60></td>
</tr>
<tr>
<td>테스트 4</td>
<td><input type=text name=test4 size=60></td>
</tr>
<tr>
<td>테스트 5</td>
<td><textarea name=test5 cols=59 rows=8></textarea></td>
</tr>
<tr>
<td colspan=2 align=right><input type=submit value="쓰기"></td>
</tr>
</table>
</form>
[/code]
write_ok.php
[code]
<?
include "config.php";
$connect = dbconn();
$query = "insert into test(test1, test2, test3, test4, test5)
values('$test1','$test2','$test3','$test4','$test5') ";
mysql_query($query, $connect);
?>
<script>
location.href='index.php';
</script>
[/code]
왜? 안되는걸까요?
|
댓글을 작성하시려면 로그인이 필요합니다.
댓글 2개
test DB가 아니라 text1~text5였습니다.
포인트는 가장먼저 댓글 다시는분에게