메뉴 카테고리 XML PHP코드

이거 만드는데 힘들어 죽는줄 알았네..
그래도 해결해서 다행이다..

[ db_conn.php 코드 ]
<? Require("function.php"); $db_host = "localhost"; $db_user = "air****"; $db_pw = "air****"; $db_database = "airflex"; $db_conn = mysql_connect($db_host, $db_user, $db_pw); mysql_select_db($db_database, $db_conn); ?>


[function.php 코드]
<? ##### (ExistCheck 함수) DB내에 필드값의 존재여부를 알아내는 쏘스(시작) ##### Function ExistCheck($Db_name, $Table_name, $Field_name, $Exist_YesNo_name) { $result = mysql_query("SELECT count(" . $Field_name . ") FROM " . $Table_name . " WHERE " . $Field_name . " ='". $Exist_YesNo_name . "'"); if (!$result) { error("QUERY_ERROR"); exit; } $rows = mysql_result($result, 0, 0); if ($rows) { //# 만약 중복된 값이 존재하면 Return 1; } else { // # 만약 중복된 값이 존재하지 않으면 Return 0; } } ################# ExistCheck 함수 닫기 ################# ?>


[Setting.php코드]
<? Require("function.php"); $db_host = "localhost"; $db_user = "unhwa"; $db_pw = "unhwa2677"; $db_database = "unhwa"; $db_conn = mysql_connect($db_host, $db_user, $db_pw); mysql_select_db($db_database, $db_conn); $PATH = "/~order"; ?>



[ xml 구현 부분인 leftMenu.php코드]
<? $path_url=".."; include_once("$path_url/inc/db_conn.php"); /* $query =" select A.name as First, A.code as Code, B.name as Second, C.name as Third from (select * from category where part is null) A left join category B on A.code =B.part left join category C on B.code = C.part order by code ASC "; */ $query =" select * from category where part is null "; $result=mysql_query($query); //$ii=11; function method($value){ global $num1, $num2, $sNum; $query1=" select A.name as First, A.code as Code, B.name as Second, C.name as Third from (select * from category where code=$value) A left join category B on A.code =B.part left join category C on B.code = C.part "; $result1=mysql_query($query1); $num1 = mysql_num_rows($result1); $query2=" select B.name as Second, B.code as NumSecond, C.name as Third, count(*) as Num from (select*from category where code =$value) A left join category B on A.code=B.part left join category C on B.code = C.part group by B.name order by B.code asc "; $result2=mysql_query($query2); $num2 = mysql_num_rows($result2); $sNum = array(); while($data=mysql_fetch_array($result2)) { $sNum[] = array('num' => $data[Num],'num2' => $data[NumSecond],'name2' => $data[Second]); } } //$tNum = array(); //$ttNum = array(); ?> <? header("Content-type: application/xml; charset=utf-8"); echo "<?xml version='1.0' encoding='utf-8'?>"; echo " <Mos>"; while($data=mysql_fetch_array($result)) { method($data[code]); $data[name] = iconv( "euc-kr", "UTF-8", $data[name] ); //$num = iconv( "euc-kr", "UTF-8", $num ); //if($data[part]== "" ){ echo "<node label='$data[name]' num='".$num."' >"; for($i=0; $i<$num2; $i++){ if($sNum[$i][num] >= 1){ $sNum[$i][name2] = iconv( "euc-kr", "UTF-8", $sNum[$i][name2] ); $query3=" select B.name as Third2 from (select*from category where code =".$sNum[$i][num2].") A left join category B on A.code=B.part where B.name is not null order by B.code asc "; $result3=mysql_query($query3); $num3 = mysql_num_rows($result3); //$data3 = mysql_fetch_array($result3); //$tNum = array(); if($num3){ echo " <node label='".$sNum[$i][name2]."' nam='".$sNum[$i][num2]."'>"; for($v=0; $v<$num3; $v++){ $data3 = mysql_fetch_array($result3); $data3[Third2] = iconv( "euc-kr", "UTF-8",$data3[Third2] ); echo " <node label='".$data3[Third2]."' nam='".$sNum[$i][num2]."'/>"; } echo " </node>"; }else{ if($sNum[$i][name2]){ echo " <node label='".$sNum[$i][name2]."' data='여기는메뉴가 하나 ' />"; } } }else{ $sNum[$i][name2] = iconv( "euc-kr", "UTF-8", $sNum[$i][name2] ); if($sNum[$i][name2]){ echo " <node label='".$sNum[$i][name2]."' data='여기는메뉴가 하나 ' />"; } } } echo " <node label='전체보기'/>"; echo "</node>"; //} } echo " </Mos>"; ?>


그리고 메뉴 DB테디블은 재귀용법으로 포린키를 자신을 참조시킨 테이블을 생성시켜
값을 입력 시킨다...

머 대충 이런식이다...

CREATE TABLE category

(

    code INTEGER NOT NULL,

    part INTEGER NULL,

    name CHAR(18) NULL

);

 

ALTER TABLE category

ADD PRIMARY KEY (code);

 

ALTER TABLE category

ADD FOREIGN KEY R_1 (part) REFERENCES category (code);

 

 

 

insert into category values(1,null,'소품류');

insert into category values(2,null,'임산물');

insert into category values(3,null,'박제류');

insert into category values(4,null,'표본류');

insert into category values(5,null,'모형');

insert into category values(6,null,'패널');

insert into category values(7,null,'사진');

insert into category values(8,null,'민속생활용품');

insert into category values(9,null,'고서적');

insert into category values(10,null,'공예품');

insert into category values(11,null,'기타');

 

 

insert into category values(101,1,'나무');

insert into category values(102,1,'한지');

 

insert into category values(201,2,'목재');

insert into category values(202,2,'석재');

insert into category values(203,2,'화석');

 

insert into category values(301,3,'야생동물박제');

 

insert into category values(401,4,'곤충');

insert into category values(402,4,'토사');

insert into category values(403,4,'버섯');

insert into category values(404,4,'약용,씨앗');

insert into category values(405,4,'야생화 꽃누루미');

insert into category values(406,4,'파충류');

insert into category values(407,4,'석엽');

insert into category values(408,4,'종자');

insert into category values(409,4,'목재');

insert into category values(410,4,'나뭇잎');

insert into category values(411,4,'기타');

 

insert into category values(701,7,'야생화');

insert into category values(901,9,'서적류');

 

쿼리문

 

select A.name as First, B.name as Second, C.name as Third from

(select * from category where part is null) A left join

category B on A.code =B.part left join

category C on B.code = C.part;

 

============추가 쿼리문 ==========================

 

select A.name as First, A.code as Code, B.name as Second, C.name as Third from

(select * from category where part is null) A left join

category B on A.code =B.part left join

category C on B.code = C.part;

 

이상. 끝