<?php /** * Created by PhpStorm. * User: 재혁 * Date: 2015-11-25 * Time: 오후 11:06 */ include "db_manager.php"; include 'xml_maker.php'; $db = new DBManager(); $table_name = $_GET["table"]; $file_name = $_GET["filename"]; //$total = $db->db_query2("select * from se_region_list"); $total = $db->db_query2("select * from " . $table_name); $XmlConstruct = new XmlConstruct('table'); $count = 0; foreach ($total as $row) { $XmlConstruct->startElement('row'); $XmlConstruct->startAttribute('id'); $XmlConstruct->text($count); $XmlConstruct->endAttribute(); //echo "row[0] : ".$row[0]." row[1] : ".$row[1]." row[2] : "; //print_r($row); for ($i = 0; $i < count($row) / 2; $i++) { $XmlConstruct->startElement('att'); if (!$row[$i]) { $XmlConstruct->text('NULL'); } else { $XmlConstruct->text($row[$i]); }
/** * Formats the return response based upon the content types. * * @param string $contents An array where keys are nodes and values are the node data * @return array */ public function return_response($contents) { switch ($this->format) { case 'xml': if (preg_match('/<response>/', $contents)) { return $contents; } else { $xml = new XmlConstruct('response'); $xml->fromArray($contents); return $xml->getDocument(); return $xml->output(); } break; case 'json': if (preg_match('/response :/', $contents)) { return $contents; } else { $jsonData = json_encode($contents); return json_decode($jsonData); } break; case 'html': if (preg_match('/\\<dt\\>response_code\\<\\/dt\\>/', $contents)) { return $contents; } else { $htmlOut = ''; foreach ($contents as $key => $val) { $htmlOut .= "<ul>{$key}<li>{$val}</li></ul>\n"; } return $htmlOut; } break; } }
$kwangju_sky = $korea_arr[4][sky]; $kwangju_pop = $korea_arr[4][pop]; $kwangju_reh = $korea_arr[4][reh]; $ulsan_temp = $korea_arr[5][temp]; $ulsan_sky = $korea_arr[5][sky]; $ulsan_pop = $korea_arr[5][pop]; $ulsan_reh = $korea_arr[5][reh]; $busan_temp = $korea_arr[6][temp]; $busan_sky = $korea_arr[6][sky]; $busan_pop = $korea_arr[6][pop]; $busan_reh = $korea_arr[6][reh]; $jeju_temp = ($korea_arr[7][temp] + $korea_arr[8][temp]) / 2; $jeju_sky = $korea_arr[7][sky]; $jeju_pop = ($korea_arr[7][pop] + $korea_arr[8][pop]) / 2; $jeju_reh = ($korea_arr[7][reh] + $korea_arr[8][reh]) / 2; $XmlConstruct = new XmlConstruct('the_national_weather'); $XmlConstruct->startElement('seoul'); $XmlConstruct->startElement('tmx'); $XmlConstruct->text($seoul_tmx); $XmlConstruct->endElement(); $XmlConstruct->startElement('tmn'); $XmlConstruct->text($seoul_tmn); $XmlConstruct->endElement(); $XmlConstruct->startElement('temp'); $XmlConstruct->text($seoul_temp); $XmlConstruct->endElement(); $XmlConstruct->startElement('sky'); $XmlConstruct->text($seoul_sky); $XmlConstruct->endElement(); $XmlConstruct->startElement('pop'); $XmlConstruct->text($seoul_pop);
public static function array2xml(array $data) { $obj = new XmlConstruct(); $obj->fromArray($data); $result = trim($obj->getDocument()); return $result; }
function MakeXML() { $XmlConstruct = new \XmlConstruct('kit'); $count = 0; if (is_null($this->files)) { $XmlConstruct->text("null"); } else { foreach ($this->files as $row) { $XmlConstruct->startElement('file'); $XmlConstruct->startAttribute('id'); $XmlConstruct->text($count); $XmlConstruct->endAttribute(); $XmlConstruct->startElement('name'); $XmlConstruct->text($row['name']); $XmlConstruct->endElement(); $XmlConstruct->startElement('url'); $XmlConstruct->text($row['url']); $XmlConstruct->endElement(); $XmlConstruct->endElement(); $count++; } } $XmlConstruct->output($GLOBALS["RESULT_XML_PATH"]); }
function MakeXML() { $XmlConstruct = new \XmlConstruct('kit'); $count = 0; $XmlConstruct->startElement('total_count'); $XmlConstruct->text($this->totalCnt); $XmlConstruct->endElement(); foreach ($this->postArray as $row) { $XmlConstruct->startElement('post'); $XmlConstruct->startAttribute('id'); $XmlConstruct->text($count); $XmlConstruct->endAttribute(); $XmlConstruct->startElement('board_no'); $XmlConstruct->text($row->board_no); $XmlConstruct->endElement(); $XmlConstruct->startElement('module_no'); $XmlConstruct->text($row->module_no); $XmlConstruct->endElement(); $XmlConstruct->startElement('title'); $XmlConstruct->text($row->title); $XmlConstruct->endElement(); $XmlConstruct->startElement('date'); $XmlConstruct->text($row->date); $XmlConstruct->endElement(); $XmlConstruct->endElement(); $count++; } $XmlConstruct->output($GLOBALS["RESULT_HTML_PATH"]); }
<?php include 'xml_maker.php'; include 'db_manager.php'; $db = new DBManager(); $big = $_GET['big']; $mid = $_GET['mid']; $small = $_GET['small']; $table1 = $db->db_select_full("se_region_list", "code, x, y", "big='" . $big . "' and mid='" . $mid . "' and sm='" . $small . "'"); $region_code = $table1[0]['code']; $today = date("Y-m-d"); $total = $db->db_query2("select * from se_time_forecast where region_code='" . $region_code . "' and date='" . $today . "';"); $XmlConstruct = new XmlConstruct('time_weather'); $count = 0; foreach ($total as $row) { $XmlConstruct->startElement('section'); $XmlConstruct->startAttribute('id'); $XmlConstruct->text($count); $XmlConstruct->endAttribute(); $XmlConstruct->startElement('day'); $XmlConstruct->text($row[day]); $XmlConstruct->endElement(); $XmlConstruct->startElement('hour'); $XmlConstruct->text($row[hour]); $XmlConstruct->endElement(); $XmlConstruct->startElement('temp'); $XmlConstruct->text($row[temp]); $XmlConstruct->endElement(); $XmlConstruct->startElement('sky'); $XmlConstruct->text($row[sky]); $XmlConstruct->endElement();
<?php include 'xml_maker.php'; include 'db_manager.php'; $db = new DBManager(); if (!$_GET['city'] && $_GET['code']) { $code = $_GET['code']; } else { $city = $_GET['city']; $tmp = $db->db_select_full("se_std_region_list", "code", "name='" . $city . "'"); $code = $tmp[0]['code']; } $today = date("Y-m-d"); $total = $db->db_query2("select * from se_day_forecast where region_code='" . $code . "' and date>='" . $today . "';"); $XmlConstruct = new XmlConstruct('week_weather'); $count = 0; foreach ($total as $row) { if ($count > 5) { break; } $XmlConstruct->startElement('section'); $XmlConstruct->startAttribute('id'); $XmlConstruct->text($count); $XmlConstruct->endAttribute(); $XmlConstruct->startElement('date'); $XmlConstruct->text($row[date]); $XmlConstruct->endElement(); $XmlConstruct->startElement('tmx'); $XmlConstruct->text($row[tmx]); $XmlConstruct->endElement(); $XmlConstruct->startElement('tmn');
//$board_no = $onclick; $board_no = preg_replace("/[^0-9]*/", "", $i->children[1]->onclick); $title = $i->title; $date = $i->children[3]->plaintext; } $title = addslashes($title); array_push($postArray, new post($board_no, $module_no, $title, $date)); //$db->db_query("INSERT INTO kit_board_list(board_no, module_no, title, date) VALUES('$board_no','$module_no','$title','$date');"); //갓재혁을 찬양하라 Made By JaeHyeok } $XmlConstruct = new XmlConstruct('kit'); $count = 0; foreach($postArray as $row) { echo ' module_no : '; echo $row->module_no; echo ' title : '; echo $row->title; echo 'date : '; echo $row->date; $XmlConstruct->startElement('post'); $XmlConstruct->startAttribute('id'); $XmlConstruct->text($count); $XmlConstruct->endAttribute();
<?php /** * Created by PhpStorm. * User: 재혁 * Date: 2015-11-25 * Time: 오후 10:10 */ include "db_manager.php"; include 'xml_maker.php'; $lat = $_GET["lat"]; $lon = $_GET["lon"]; $db = new DBManager(); $total = $db->db_query2("select code, lat, lon from se_region_list where lat BETWEEN '" . $lat . "'-0.2 and '" . $lat . "'+0.2 and lon BETWEEN '" . $lon . "'-0.2 and '" . $lon . "'+0.2"); $XmlConstruct = new XmlConstruct('search_result'); $count = 0; foreach ($total as $row) { $XmlConstruct->startElement('row'); $XmlConstruct->startAttribute('id'); $XmlConstruct->text($count); $XmlConstruct->endAttribute(); //echo "row[0] : ".$row[0]." row[1] : ".$row[1]." row[2] : "; //print_r($row); for ($i = 0; $i < count($row) / 2; $i++) { //echo $att." "; $XmlConstruct->startElement('att'); $XmlConstruct->text($row[$i]); //echo "값 : ".$att." count".$count." "; $XmlConstruct->endElement(); } $XmlConstruct->endElement();
include 'xml_maker.php'; include 'db_manager.php'; /* $s = mysql_connect("localhost", "smoper0916", "hyeok3096") or die("Failed"); print "Success"; mysql_select_db("smoper0916", $s); $sql="select * from se_current_weather_info where x=86 and y=96;"; print " 1 "; $result=mysql_query($sql); print " 2 "; if($result){ while($row = mysql_fetch_array($result)) $total[]=$row; print_r($total); }else echo "데이터출력 실패"; mysql_close($s); */ $db = new DBManager(); $x = $_GET[x]; $y = $_GET[y]; //$total = $db->db_select('se_current_weather_info', 'x='.$x.' and y='.$y.';'); $row = $db->db_query('select * from se_current_weather_info where x=' . $x . ' and y=' . $y . ';'); //echo "$row[x]"; //print_r($row); //echo "$total[0][0][0]"; $contents = array('x' => $row[x], 'y' => $row[y], 'hour' => $row[hour], 'temp' => $row[temp], 'tmx' => $row[tmx], 'tmn' => $row[tmn], 'sky' => $row[sky], 'pty' => $row[pty], 'pop' => $row[pop], 'ws' => $row[ws], 'wd' => $row[wd], 'reh' => $row[reh]); $XmlConstruct = new XmlConstruct('current_info'); $XmlConstruct->fromArray($contents); $XmlConstruct->output(); header("Location: ./result.xml"); die;
} else { $dinner_sky = $today_arr[5][sky]; } echo "[5-4-1]" . $dinner_sky; //$t_early_temp = ($tomorrow_arr[0][temp] + $tomorrow_arr[1][temp])/2; $t_early_temp = $tomorrow_arr[0][temp]; echo "[5-5]" . $t_early_temp; /* if($sky_code_to_0 < $sky_code_to_1) $t_early_sky = $tomorrow_arr[1][sky]; else $t_early_sky = $tomorrow_arr[0][sky]; echo "[6]".$dinner_sky; */ $t_early_sky = $tomorrow_arr[0][sky]; $XmlConstruct = new XmlConstruct('current_weather'); if ($cur_time == 0 || $cur_time == 1 || $cur_time == 2) { $cur_time = 3; } $XmlConstruct->startElement('today'); // 먼저 오늘 날씨의 최고, 최저 온도를 보여줌 $XmlConstruct->startElement('tmx'); $XmlConstruct->text($tmx); $XmlConstruct->endElement(); $XmlConstruct->startElement('tmn'); $XmlConstruct->text($tmn); $XmlConstruct->endElement(); $XmlConstruct->startElement('temp'); $XmlConstruct->text($today_arr[$cur_time / 3 - 2][temp]); $XmlConstruct->endElement(); $XmlConstruct->startElement('sky');