질문드립니다~
본문
이렇게넣었는데 출력이 안되네요 ㅠㅠ 이유가 뭘까요??
<?php
header("content-type:text/html; charset=utf-8");
$connect = mysql_connect("localhost","root","1234"); // DB 연결
mysql_select_db("ex1", $connect); // DB 선택
$mode=$_GET['mode'];
$name=$_POST['name'];
$sub1=$_POST['sub1'];
$sub2=$_POST['sub2'];
$sub3=$_POST['sub3'];
$sub4=$_POST['sub4'];
$sub5=$_POST['sub5'];
if ($mode == "insert") // 데이터 입력 모드
{
$sum = $sub1 + $sub2 + $sub3 + $sub4 + $sub5; // 합계 구하기
$avg = $sum/5; // 평균 구하기
$sql = "insert into stud_score (name, sub1, sub2, sub3, sub4, sub5, sum, avg) values
('$name', $sub1, $sub2, $sub3, $sub4, $sub4, $sum, $avg)";
$result = mysql_query($sql, $connect);
}
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<h3>1) 성적 입력 하기</h3>
<form action="score_list.php?mode=insert" method='post'>
<table width="720" border="1" cellpadding="5">
<tr><td> 이름 : <input type="text" size="6" name="name">
과목1 : <input type="text" size="3" name="sub1">
과목2 : <input type="text" size="3" name="sub2">
과목3 : <input type="text" size="3" name="sub3">
과목4 : <input type="text" size="3" name="sub4">
과목5 : <input type="text" size="3" name="sub5">
</td>
<td align="center">
<input type="submit" value="입력하기">
</td>
</tr>
</table>
</form>
<p>
<h3>2) 성적 출력 하기</h3>
<p><a href ="score_list.php?mode=big_first">[성적순 정렬]</a>
<a href ="score_list.php?mode=small_first">[성적역순 정렬]</a></p>
<p>
<!-- 제목 표시 시작 -->
<table width="720" border="1" cellpadding="5">
<tr align="center" bgcolor="#eeeeee">
<td>번호</td>
<td>이름</td>
<td>과목1</td>
<td>과목2</td>
<td>과목3</td>
<td>과목4</td>
<td>과목5</td>
<td>합계</td>
<td>평균</td>
<td> </td>
</tr>
<!-- 제목 표시 끝 -->
<?
// select 문 수행
if ($mode == "big_first") // 성적순 정렬(내림차순)
$sql = "select * from stud_score order by sum desc";
else if ($mode == "small_first") // 성적순 정렬(오름차순)
$sql = "select * from stud_score order by sum";
else
$sql = "select * from stud_score";
$result = mysql_query($sql);
$count = 1; // 화면 출력 시 일렬번호
// DB 데이터 출력 시작
while ($row = mysql_fetch_array($result))
{
$avg = round($row[avg], 1);
$num = $row[num];
echo "<tr align='center'>
<td> $count </td>
<td> $row[name] </td>
<td> $row[sub1] </td>
<td> $row[sub2] </td>
<td> $row[sub3] </td>
<td> $row[sub4] </td>
<td> $row[sub5] </td>
<td> $row[sum] </td>
<td> $avg </td>
<td> <a href='score_delete.php?num=$num'>[삭제]</a></td>
</tr>
";
$count++;
}
// DB 데이터 출력 끝
mysql_close(); // DB 접속 끊기
?>
</table>
Notice: Undefined index: mode in C:\xampp\htdocs\source\7��\score_list.php on line 6
Notice: Undefined index: name in C:\xampp\htdocs\source\7��\score_list.php on line 7
Notice: Undefined index: sub1 in C:\xampp\htdocs\source\7��\score_list.php on line 8
Notice: Undefined index: sub2 in C:\xampp\htdocs\source\7��\score_list.php on line 9
Notice: Undefined index: sub3 in C:\xampp\htdocs\source\7��\score_list.php on line 10
Notice: Undefined index: sub4 in C:\xampp\htdocs\source\7��\score_list.php on line 11
Notice: Undefined index: sub5 in C:\xampp\htdocs\source\7��\score_list.php on line 12
1) 성적 입력 하기
이름 : 과목1 : 과목2 : 과목3 : 과목4 : 과목5 : |
2) 성적 출력 하기
"; $count++; } // DB 데이터 출력 끝 mysql_close(); // DB 접속 끊기 ?>
번호 | 이름 | 과목1 | 과목2 | 과목3 | 과목4 | 과목5 | 합계 | 평균 | |
$count | $row[name] | $row[sub1] | $row[sub2] | $row[sub3] | $row[sub4] | $row[sub5] | $row[sum] | $avg | [삭제] |