<?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');
