야구 기록 관리 메인 프로그램 만들기(php + mysql)(2)

input2.php 출력예상

input2.php 코드

 

<?
	echo("
		<style type='text/css'>
			td {text-align:center;}
		</style>
		<table border=0 width=600 align=center>
		<tr>
			<td>소속</td>
			<td>이름</td>
			<td>타수</td>
			<td>안타</td>
			<td></td>
		</tr>
		<form method=post action=process2.php>
		<tr>
			<td>
			<select name=iteam>
				<option>선택하세요</option>
				<option value='NC'>NC</option>
				<option value='LG'>LG</option>
				<option value='두산'>두산</option>
				<option value='롯데'>롯데</option>
				<option value='삼성'>삼성</option>
			</select>
			</td>
			<td><input type=text size=10 name=iplayer></td>
			<td><input type=text size=10 name=ibatting></td>
			<td><input type=text size=10 name=ihit></td>
			<td><input type=submit value=입력></td>
		</tr>
		</form>
		</table>
	");
?>

<? // db에 입력된 값들 화면에 렌더링
	$con = mysql_connect("localhost","root","apmsetup");
	mysql_select_db("class2",$con);
	
	echo("
	<table border=1 width=600 align=center>
		<tr>
		<td align=center>소속</td>
		<td align=center>이름</td>
		<td align=center>타수</td>
		<td align=center>안타</td>
		<td align=center>타율</td>
		<td align=center>수정/삭제</td>
		</tr>
	
	");
	
	$result = mysql_query("select * from baseball order by player",$con);
	$total = mysql_num_rows($result);
	
	$i=0;
	while($i<$total):
		//mysql_result 데이터베이스에서 특정 행과 열에 위치한 값을 추출하는 함수
		$oteam = mysql_result($result,$i,"team");
		$oplayer = mysql_result($result,$i,"player");
		$obatting = mysql_result($result,$i,"batting");
		$ohit = mysql_result($result,$i,"hit");
		$oaverage = mysql_result($result,$i,"average");
		
		echo("
			<tr>
				<td align=center>$oteam</td>
				<td align=center>$oplayer</td>
				<td align=center>$obatting</td>
				<td align=center>$ohit</td>
				<td align=center>$oaverage</td>
				<td align=center>O/X</td>
			</tr>
		");
		$i++;
	endwhile;
	echo("</table>");
?>

<?
	// 팀 모두의 타수, 안타를 모두 합쳐 나타내는 표를 위한 변수 초기화
	$i=0;
	$NC_batting=0;
	$NC_hit=0;
	$DS_batting=0;
	$DS_hit=0;
	$LG_batting=0;
	$LG_hit=0;
	$LD_batting=0;
	$LD_hit=0;
	$SS_batting=0;
	$SS_hit=0;
	
	while($i<$total):
		$oteam = mysql_result($result,$i,"team");
		$obatting = mysql_result($result,$i,"batting");
		$ohit = mysql_result($result,$i,"hit");
		
		switch($oteam){ // 받아온 oteam의 팀이름마다 case분리
			case "NC":
				$NC_batting = $NC_batting + $obatting;
				$NC_hit = $NC_hit + $ohit;
				break;
			case "두산":
				$DS_batting = $DS_batting + $obatting;
				$DS_hit = $DS_hit + $ohit;
				break;
			case "LG":
				$LG_batting = $LG_batting + $obatting;
				$LG_hit = $LG_hit + $ohit;
				break;
			case "롯데":
				$LD_batting = $LD_batting + $obatting;
				$LD_hit = $LD_hit + $ohit;
				break;
			case "삼성":
					$SS_batting = $SS_batting + $obatting;
				$SS_hit = $SS_hit + $ohit;
				break;
				
		}
		$i++;
		endwhile;
		
		mysql_close($con);
?>

---