<맨 위로>

php main page 메인페이지

메인 페이지용 PHP

<style type="text/css">
	img{
		width:300px;
	}
</style>
										
<?php

	$dbc = mysqli_connect('localhost', 'root', '', 'media_programming_2', '3306') or die('Error connecting to MySQL server.');
	//데이터 베이스 접속

	$query = "SELECT * FROM `content`";
	//쿼리문
	echo $query."<br />";

	$result = mysqli_query($dbc, $query) or die ('Error querying database');
	//쿼리문 수행하기

	mysqli_close($dbc);
	//데이터 베이스 닫기

	echo "<table>";
	while($row = mysqli_fetch_row($result)){
	   echo "<tr>";
	   echo "<td>".$row[0]."</td>";
	   echo "<td>".$row[1]."</td>";
	   echo "<td>".$row[2]."</td>";
	   echo "<td>".$row[3]."</td>";
	   echo "<td><img src='".$row[4]."' /></td>";
	   echo "<td><img src='".$row[5]."' /></td>";
	   echo "<td>".$row[6]."</td>";
	   echo "<td>".$row[7]."</td>";
	   echo "</tr>";
	}
	echo "</table>";
?>

JOIN을 이용한 데이터 연결

  • site_main.php
$query = 
"SELECT
        `content`.id,
        `content`.price,
        `category1`.content,
        `category2`.content,
        `content`.image_url,
        `content`.thumb_url,
        `content`.name,
        `content`.content 
FROM `content`,`category1`,`category2` 
WHERE 
    `content`.category1_code=`category1`.code 
    AND 
    `content`.category2_code=`category2`.code";

검색 form 추가

  • site_main.php
<form method="GET" action="site_main.php">
	<input type="text" name="search_value" />
	<input type="submit" value="search" />
</form>

쿼리문 수정

  • site_main.php
$query = 	
"SELECT
    `content`.id,
    `content`.price,
    `category1`.content,
    `category2`.content,
    `content`.image_url,
    `content`.thumb_url,
    `content`.name,
    `content`.content 
FROM `content`,`category1`,`category2`
WHERE
    `content`.category1_code=`category1`.code 
    AND 
    `content`.category2_code=`category2`.code
    AND
    `content`.content LIKE '%".$_GET['search_value']."%'";

쿼리문 수정 (제목 검색도 포함하기)

  • site_main.php
$query = 	
"SELECT
    `content`.id,
    `content`.price,
    `category1`.content,
    `category2`.content,
    `content`.image_url,
    `content`.thumb_url,
    `content`.name,
    `content`.content 
FROM `content`,`category1`,`category2`
WHERE
    `content`.category1_code=`category1`.code 
    AND 
    `content`.category2_code=`category2`.code
    AND
                            (
    `content`.content LIKE '%".$_GET['search_value']."%'
                            OR
                            `content`.name LIKE '%".$_GET['search_value']."%')";

출력 순서

ORDER BY `content`.id ASC;

undefined 에러 벗어나기

  • site_main.php
if(!isset($_GET['search_value'])){
		$_GET['search_value'] = "";
	}

조건 필터링

필터링용 form

<form method="GET" action="site_main.php" id="if_form"></form>
<table id="if_table">
	<tr>
		<th>제조사</th>
										
<?php

	$dbc = mysqli_connect('localhost', 'root', '', 'media_programming_2', '3306') or die('Error connecting to MySQL server.');
	//데이터 베이스 접속
	$category1_query = "SELECT id,code,content FROM `category1`";
	//쿼리문
	$category1_result = mysqli_query($dbc, $category1_query) or die ('Error querying database');

	$category2_query = "SELECT id,code,content FROM `category2`";
	//쿼리문
	$category2_result = mysqli_query($dbc, $category2_query) or die ('Error querying database');
?>

										
<?php

	while($category1_row=mysqli_fetch_row($category1_result)){
		echo "<td>";
		echo "<input form='if_form' type='checkbox' name='category1_check[]'";
		//*
		echo " value='".$category1_row[1]."'/>".$category1_row[2];
		echo "</td>";
	}
?>
	</tr>
	<tr>
		<th>타입</th>
										
<?php

	while($category2_row=mysqli_fetch_row($category2_result)){
		echo "<td>";
		echo "<input form='if_form' type='checkbox' name='category2_check[]'";
		//*
		echo " value='".$category2_row[1]."'/>".$category2_row[2];
		echo "</td>";
	}
?>
	</tr>
</table>
<input type="submit" form="if_form" value="조건 적용"/>

채크 기능 추가

<form method="GET" action="site_main.php" id="if_form"></form>
<table id="if_table">
	<tr>
		<th>
			제조사
		</th>
										
<?php

	$c1_counter = 0; //*
	while($category1_row=mysqli_fetch_row($category1_result)){
		echo "<td>";
		echo "<input form='if_form' type='checkbox' name='category1_check[]'";
		if(isset($_GET['category1_check'])){
			if(in_array($category1_row[1], $_GET['category1_check'])){
				echo "checked='checked'";
			}
		}//*
		echo " value='".$category1_row[1]."'/>".$category1_row[2];
		echo "</td>";
		$c1_counter++; //*
	}
?>
	</tr>
	<tr>
		<th>
			타입
		</th>
										
<?php

	$c2_counter = 0; //*
	while($category2_row=mysqli_fetch_row($category2_result)){
		echo "<td>";
		echo "<input form='if_form' type='checkbox' name='category2_check[]'";
		if(isset($_GET['category2_check'])){
			if(in_array($category2_row[1], $_GET['category2_check'])){
				echo "checked='checked'";
			}
		}//*
		echo " value='".$category2_row[1]."'/>".$category2_row[2];
		echo "</td>";
		$c2_counter++; //*
	}
?>
	</tr>
</table>
<input type="submit" form="if_form" value="조건 적용"/>

쿼리추가

$if_query = "";
	if(isset($_GET['category1_check'])){
		echo "****";
		$if_query = $if_query." AND (";
		for($i=0; $i<count($_GET['category1_check']); $i++){
			$if_query = $if_query."`category1`.code = '".$_GET['category1_check'][$i]."'";
			$if_query = $if_query." OR ";
		}
		$if_query = substr($if_query, 0, -3);
		$if_query = $if_query.")";
	}
	$query = $query.$if_query;

	$if_query = "";
	if(isset($_GET['category2_check'])){
		echo "****";
		$if_query = $if_query." AND (";
		for($i=0; $i<count($_GET['category2_check']); $i++){
			$if_query = $if_query."`category2`.code = '".$_GET['category2_check'][$i]."'";
			$if_query = $if_query." OR ";
		}
		$if_query = substr($if_query, 0, -3);
		$if_query = $if_query.")";
	}
	$query = $query.$if_query;

가격순 정렬

  • 정렬용 form
<form method="GET" action="site_main.php" id="sort_form"></form>
<table id="sort_table">
	<tr>
		<th>정렬방식</th>
	</tr>
	<tr>
		<td>
			낮은가격부터
			<input type="radio" name="money_sort" value="ASC" form="sort_form"
<?php if (isset($_GET['money_sort']) && $_GET['money_sort']=="ASC") echo "checked='checked'";?>		
			/> <!--오름차순-->
		</td>
		<td>
			높은가격부터
			<input type="radio" name="money_sort" value="DESC" form="sort_form"
<?php if (isset($_GET['money_sort']) && $_GET['money_sort']=="DESC") echo "checked='checked'";?>
			/> <!--내림차순-->
		</td>
		<td>
			<input type="submit" value="sort" form="sort_form"/>
		</td>
	</tr>
</table>

쿼리문 추가

$sort_query = "";
if(isset($_GET['money_sort'])){
	$sort_query = $sort_query."ORDER BY ";
	switch ($_GET['money_sort']) {
		case 'DESC':
			$sort_query = $sort_query."price DESC;";
		break;

		case 'ASC':
			$sort_query = $sort_query."price ASC;";
		break;
		
		default:
			# code...
		break;
	}
}
$query = $query.$sort_query;