파싱의 신

http://jung9451.godomall.com/goods/goods_list.php?cateCd=001

\n"; if($fileName=="." || $fileName=="..") continue; $fullFileUrl=""; $fullFileUrl=$xml_url.$fileName; $submit_vars["data_url"]=$fullFileUrl; $without_extension = substr($fileName, 0, strrpos($fileName, ".")); //print_r($submit_vars); //$r = $snoopy->submit($submit_url,$submit_vars); //$r="http://localhost/godo/result.php"; //print_r($r); $snoopy->fetch("http://localhost/godo/result.php"); $obj=$snoopy->results; //print_r($obj); $xmlObj=simplexml_load_string($obj); //print_r($xmlObj); $goodsno=$xmlObj->return->goods_data->data->goodsno; //print_r($goodsno); echo "godo goodsno=".$goodsno; echo " \n"; //godo_srl 이 있으면 업데이트. 없으면 신규등록 $sql=" UPDATE $tbl_name ...

srl 상품명 생성일 수정일 0) { // output data of each row while($row = mysqli_fetch_assoc($result)) { ?> no result srl 고도몰 상품코드 고도몰 카테고리 코드 상품명 생성일 수정일 0) { // output data of each row while($row = mysqli_fetch_assoc($result)) { ?> no result

"; $result = mysqli_query($conn, $sql); $cnt=0; if (mysqli_num_rows($result) > 0) { // output data of each row while($row = mysqli_fetch_assoc($result)) { $xml=" "; $xml.=" "; $xml.=" \n"; $srl=$row["srl"]; $cateCd=$row["cateCd"]; $goodsNm=$row["goodsNm"]; $xml.=" ".$cateCd." "; $xml.=" ".$goodsNm." "; $xml.=" d \n"; $xml.=" \n"; $xml.=" \n"; $xml.=" \n"; $xml.=" y \n"; $xml.=" y \n"; $xml.=" y \n"; $xml.=" y \n"; $xml.=" 1 \n"; $xml.=" \n"; $xml.=" \n"; $xml.=" \n"; $xml.=" \n"; $xml.=" n \n"; $...

\n"; if(mysqli_query($conn, $sql)){ echo " New record created successfully \n"; }else{ echo "Error: " . $sql . " " . mysqli_error($conn); } mysqli_close($conn);

\n"; if(mysqli_query($conn, $sql)){ echo " New record created successfully \n"; }else{ echo "Error: " . $sql . " " . mysqli_error($conn); } mysqli_close($conn);

\n"; echo "row MAX_CNT=".MAX_CNT; echo " \n"; if($rowCnt > MAX_CNT ){ $sql=" delete from godo_item_zappos where srl not in (select srl from godo_item_zappos_temp) "; echo $sql; echo " \n"; if(mysqli_query($conn, $sql)){ echo " Record deleted successfully \n"; }else{ echo "Error: " . $sql . " " . mysqli_error($conn); } }else{ echo "최소 갯수보다 row count가 적습니다.\n"; } mysqli_close($conn);

\n"; }else{ echo "Error: " . $sql . " " . mysqli_error($conn); } $randArr = mt_rand(0, 12); $randNum = mt_rand(0, 100); $title=$arr_item[$randArr]." ".$randNum; $srl=rand(); $sql=" INSERT INTO $tbl_name_temp (srl,goodsNm,create_at) VALUES ($srl,'$title',now())"; if(mysqli_query($conn, $sql)){ echo "$title New record created successfully \n"; }else{ echo "Error: " . $sql . " " . mysqli_error($conn); } mysqli_close($conn);

\n"; }else{ echo "Error dropping table: ".mysqli_error($conn); } $sql="create table $tbl_name_temp( srl varchar(50) ,goodsNm varchar(500) ,create_at timestamp null default null ,updated_at timestamp null default null )"; echo " \n".$sql; if(mysqli_query($conn, $sql)){ echo " \nTable $tbl_name_temp created successfully"; }else{ echo " \nError creating table: ".mysqli_error($conn); } $sql = "ALTER TABLE $tbl_name_temp ADD PRIMARY KEY (`srl`)"; echo " \n".$sql; if(mysqli_query($conn, $sql)){ echo " \nTable $tbl_name_temp setting Key successfully"; }else{ echo " \nError setting key table: ".mysqli_error($conn); } mysqli_close($conn);

\n".$sql; if(mysqli_query($conn, $sql)){ echo " \nTable $tbl_name created successfully"; }else{ echo " \nError creating table: ".mysqli_error($conn); } $sql = "ALTER TABLE $tbl_name ADD PRIMARY KEY (`srl`)"; echo " \n".$sql; if(mysqli_query($conn, $sql)){ echo " \nTable $tbl_name setting Key successfully"; }else{ echo " \nError setting key table: ".mysqli_error($conn); } mysqli_close($conn);

\n"; }

index.html http://xemaker.kr/godo zappos 테이블 생성 (신규생성)(create_table.php) temp 테이블 생성 (drop 후 신규생성)(create_table_temp.php) 테스트 데이터 생성(insert_test_data.php) delete update insert xml 파일 생성(make_xml.php) DB 조회(select.php) xml 파일 전송(send_xml.php) 고도 확인 xml 보기 xml insert