2010php/방명록만들기 - Revision history

imported>rlaace423 at 10:18, 9 September 2010

2010-09-09T10:18:48Z

imported>talin0528 at 07:01, 9 September 2010

2010-09-09T07:01:40Z

← Older revision		Revision as of 07:01, 9 September 2010
Line 344:		Line 344:
	?>		?>

	===요거 되나 확인점 ㅠ.ㅠ(print.php)===		=== 요거 되나 확인점 ㅠ.ㅠ(print.php) ===
	<?		<?
	$query = "select * from guest ORDER BY no DESC";		$query = "select * from guest ORDER BY no DESC";

imported>talin0528 at 07:00, 9 September 2010

2010-09-09T07:00:37Z

← Older revision		Revision as of 07:00, 9 September 2010
Line 341:		Line 341:


			}
			?>

			===요거 되나 확인점 ㅠ.ㅠ(print.php)===
			<?
			$query = "select * from guest ORDER BY no DESC";
			$result = mysql_query($query, $dbconn);
			$record_number = mysql_num_rows($result);
			$scale = 10;//한 페이지당 글 수

			//전체 페이지( $total_page ) 계산
			if( $record_number % $scale == 0)
			$total_page = floor($record_number / $scale );
			else
			$total_page = floor($record_number / $scale) + 1;

			if(!$page) $page = 1;

			//페이지에 따라 $start 계산
			$start = ($page -1) * $scale;


			for( $i = $start; $i < $start + $scale && $i < $record_number; $i++){
			include "get_record.php";

			echo("기본정보 : $name $no $pw $status $date <br>");
			echo("내 용 : $contents <br><br>");

			}

			for( $i=1; $i<=$total_page; $i++){
			if($page == $i){
			echo" <b>[$i]</b>";
			}
			else{
			echo"<a href='index.php?page=$i'>[$i]</a>";
			}
	}		}
	?>		?>

imported>rlaace423 at 08:30, 8 September 2010

2010-09-08T08:30:35Z

← Older revision		Revision as of 08:30, 8 September 2010
Line 352:		Line 352:
	$date=mysql_result($result,$i,5);		$date=mysql_result($result,$i,5);
	?>		?>
			== 계층도랄까.. ==
			[http://cfile231.uf.daum.net/image/166494114C8748111943D9 클릭하셈]
	----		----
	[[2010PHP]]		[[2010PHP]]

imported>rlaace423 at 05:16, 8 September 2010

2010-09-08T05:16:33Z

← Older revision		Revision as of 05:16, 8 September 2010
Line 239:		Line 239:

	?>		?>
	== ~~디비가 연결된 새로운 방명록 아래부터 시작~~~ ==		== 입출력 최종 완성 (9월 8일) ==
	= 메인화면 ( index.php ) =		= 메인화면 ( index.php ) =
	<html>		<html>
	<head>		<head>
	<META charset='utf-8'>		<META http-equiv="Content-Type" content="text/html; charset=utf-8">
	<title>방명록</title>		<title>방명록</title>
	<?		<?php
	include "dbconnect.php";		include "dbconnect.php";
	?>		?>
	<head>		<head>
	<body>		<body>
	<form method='post' action='~~index~~.php'>		<form method='post' action='process.php'>

	이름&nbsp;&nbsp;<input type='text' name='input_name' maxlength='10' size='10'>&nbsp;&nbsp;&nbsp;&nbsp;		이름&nbsp;&nbsp;<input type='text' name='input_name' maxlength='10' size='10'>&nbsp;&nbsp;&nbsp;&nbsp;
Line 257:		Line 257:
	<textarea name='context' rows='4' cols='50'></textarea>		<textarea name='context' rows='4' cols='50'></textarea>
	<br>		<br>
	<input type='submit' value=' 전송 '>		<input type='submit' value='전송'>

	</form>		</form>

	<?		<?
	~~include "make_query.php";~~
	~~include "process.php";~~
	include "print.php";		include "print.php";
	?>		?>
Line 268:		Line 269:
	</html>		</html>
	== 데이터베이스에 연결 ( dbconnect.php ) ==		== 데이터베이스에 연결 ( dbconnect.php ) ==
	<?		<?php
	$dbconn = mysql_connect("intra.zeropage.org", "csephp", "2010php");		$dbconn = mysql_connect("intra.zeropage.org", "csephp", "2010php");
	$tableconn = mysql_select_db("csephp_db", $dbconn);		$tableconn = mysql_select_db("csephp_db", $dbconn);


	~~if($dbconn) {~~
	~~echo("db 연결 성공 <br>");~~
	}
	~~else~~
	{
	~~echo("db 연결 실패 <br>");~~
	}

	~~if($tableconn) {~~
	~~echo("table 연결 성공 <br>");~~
	}
	~~else~~
	{
	~~echo("table 연결 실패 <br>");~~
	}
	~~echo("<br>"." ------------------------------------------"."<br>");~~
	?>		?>
	== ~~입력받은 내용을 쿼리로 만들어서 쏜다!~~ ( ~~make_query~~.php ) ==		== 쿼리를 만들때 시간을 저장하기 위해.. ( get_time.php ) ==
	<?		<?php
			$unix_ts=mktime();
			$date=date('Y-m-d', $unix_ts);
			?>
			== 모든 처리는 여기서... ( process.php ) ==
			<?php
			include "dbconnect.php";
			/*********************
			* 쿼리를
			* 만듭니다.
			*********************/
	//이름 입력의 처리		//이름 입력의 처리
	if (strlen($_POST['input_name']) > 10 )		if (strlen($_POST['input_name']) > 10 )
Line 323:		Line 316:
	include "get_time.php";		include "get_time.php";
	$query = "insert into guest (name, pw, contents, date) values ('$posted_name', '$posted_pw', '$posted_context', '$date')";		$query = "insert into guest (name, pw, contents, date) values ('$posted_name', '$posted_pw', '$posted_context', '$date')";
			/*********************
	~~?>~~		* 쿼리를 전송
	~~== 쿼리를 만들때 시간을 저장하기 위해~~.~~. ( get_time.php ) ==~~		* 합니다.
	~~<?~~		*********************/
	~~echo~~(~~'<br>');~~		if(($posted_name!="")&&($posted_pw!="")&&($posted_pw!=""))
	~~$unix_ts=mktime~~();
	$~~date~~=~~date('Y-m-d', $unix_ts~~);
	?>
	=~~= 입력 받은거 쿼리 던지기 ( process.php~~ ) ==
	<~~META charset='utf-8'~~>

	~~<?~~

	$~~result~~ = ~~mysql_query($query, $dbconn~~);



	~~if($result~~)

	{		{
			$result = mysql_query($query, $dbconn);
	~~echo~~(~~"send success <br>"~~);

	}		}
			header("location:index.php");
	~~else~~

	{

	~~echo~~("~~send fail <br>~~");

	}

	?>		?>
	== 입력을 받고, 이제 전체 테이블 출력! ( print.php ) ==		== 입력을 받고, 이제 전체 테이블 출력! ( print.php ) ==

imported>rlaace423 at 08:58, 23 August 2010

2010-08-23T08:58:41Z

@@ Line 330: / Line 330: @@
   $unix_ts=mktime();
   $date=date('Y-m-d', $unix_ts);
   ?&gt;
 == 입력을 받고, 이제 전체 테이블 출력! ( print.php ) ==

imported>rlaace423 at 07:28, 23 August 2010

2010-08-23T07:28:46Z

← Older revision		Revision as of 07:28, 23 August 2010
Line 264:		Line 264:
	include "process.php";		include "process.php";
	include "print.php";		include "print.php";
	~~include "get_time.php";~~
	?>		?>
	</body>		</body>

imported>rlaace423 at 07:27, 23 August 2010

2010-08-23T07:27:59Z

← Older revision		Revision as of 07:27, 23 August 2010
Line 348:		Line 348:

	}		}
			?>
			== 출력을 위해 필요함 ( get_record.php ) ==
			<?
			$name=mysql_result($result,$i,0);
			$no=mysql_result($result,$i,1);
			$pw=mysql_result($result,$i,2);
			$contents=mysql_result($result,$i,3);
			$status=mysql_result($result,$i,4);
			$date=mysql_result($result,$i,5);
	?>		?>
	----		----
	[[2010PHP]]		[[2010PHP]]

imported>rlaace423 at 07:26, 23 August 2010

2010-08-23T07:26:52Z

← Older revision		Revision as of 07:26, 23 August 2010
Line 334:		Line 334:
	== 입력을 받고, 이제 전체 테이블 출력! ( print.php ) ==		== 입력을 받고, 이제 전체 테이블 출력! ( print.php ) ==
	<?		<?
	$query = "select * from guest";		$query = "select * from guest ORDER BY no DESC";
	$result = mysql_query($query, $dbconn);		$result = mysql_query($query, $dbconn);
	$record_number = mysql_num_rows($result);		$record_number = mysql_num_rows($result);

imported>rlaace423 at 07:24, 23 August 2010

2010-08-23T07:24:38Z

← Older revision		Revision as of 07:24, 23 August 2010
Line 333:		Line 333:
	?>		?>
	== 입력을 받고, 이제 전체 테이블 출력! ( print.php ) ==		== 입력을 받고, 이제 전체 테이블 출력! ( print.php ) ==
	<?		<?
	$query = "select * from guest";		$query = "select * from guest";
	$result = mysql_query($query, $dbconn);		$result = mysql_query($query, $dbconn);
	$record_number = mysql_num_rows($result);		$record_number = mysql_num_rows($result);

	for($i=0 ; $i < $record_number ; $i ++)		for($i=0 ; $i < $record_number ; $i ++)
	{		{
	include "get_record.php";		include "get_record.php";

	echo("기본정보 : $name $no $pw $status $date <br>");		echo("기본정보 : $name $no $pw $status $date <br>");
	echo("내 용 : $contents <br><br>");		echo("내 용 : $contents <br><br>");



	}		}
	?>		?>
	~~}}}~~
	----		----
	[[2010PHP]]		[[2010PHP]]