Ejemplos de DBManager::db_query2 en PHP

Ejemplo n.º 1

Archivo: make_xml_table.php Proyecto: smoper0916/Project

<?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]);
        }

Ejemplo n.º 2

Archivo: show_national_weather.php Proyecto: smoper0916/Project

<?php

/**
 * Created by PhpStorm.
 * User: 재혁
 * Date: 2015-12-05
 * Time: 오후 8:58
 */
include 'xml_maker.php';
include 'db_manager.php';
$db = new DBManager();
// 디버깅용 db정보
$today = date("Y-m-d");
// 전국날씨 대상 기준코드 추출
$std_arr = $db->db_query2("select std_code from se_all_region where big is NULL and name='서울특별시'");
$seoul_std_code = $std_arr[0]['std_code'];
echo $seoul_std_code . "nation!";
$std_arr = $db->db_query2("select std_code from se_all_region where big is NULL and name='인천광역시'");
$incheon_std_code = $std_arr[0]['std_code'];
$std_arr = $db->db_query2("select std_code from se_all_region where big is NULL and name='대전광역시'");
$daejeon_std_code = $std_arr[0]['std_code'];
$std_arr = $db->db_query2("select std_code from se_all_region where big is NULL and name='대구광역시'");
$daegu_std_code = $std_arr[0]['std_code'];
$std_arr = $db->db_query2("select std_code from se_all_region where big is NULL and name='광주광역시'");
$kwangju_std_code = $std_arr[0]['std_code'];
$std_arr = $db->db_query2("select std_code from se_all_region where big is NULL and name='울산광역시'");
$ulsan_std_code = $std_arr[0]['std_code'];
$std_arr = $db->db_query2("select std_code from se_all_region where big is NULL and name='부산광역시'");
$busan_std_code = $std_arr[0]['std_code'];
$std_arr = $db->db_query2("select std_code from se_all_region where big='제주특별자치도' and name='제주시'");
$jeju_std_code = $std_arr[0]['std_code'];

Ejemplo n.º 3

Archivo: visit_time_forecast.php Proyecto: smoper0916/Project

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

Ejemplo n.º 4

Archivo: visit_search_result.php Proyecto: smoper0916/Project

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

Ejemplo n.º 5

Archivo: show_week_weather.php Proyecto: smoper0916/Project

 * Created by PhpStorm.
 * User: 재혁
 * Date: 2015-12-05
 * Time: 오후 5:56
 */
include 'xml_maker.php';
include 'db_manager.php';
$db = new DBManager();
//광역시면 mid만 있으면 되고 일반 시이면 big, mid 둘 다 있어야 함
$big = $_GET['big'];
if (!$_GET['mid']) {
} else {
    $mid = $_GET['mid'];
}
if (strpos($big, '광역시') !== false || strpos($big, '특별시') !== false) {
    $std_arr = $db->db_query2("select std_code from se_all_region where big is NULL and name='" . $big . "'");
} else {
    $std_arr = $db->db_query2("select std_code from se_all_region where big='" . $big . "' and name='" . $mid . "'");
}
$std_code = $std_arr[0]['std_code'];
$today = date("Y-m-d");
$total = $db->db_query2("select * from  se_day_forecast where region_code='" . $std_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);

Ejemplo n.º 6

Archivo: show_current_weather.php Proyecto: smoper0916/Project

 * Time: 오전 1:30
 */
include 'xml_maker.php';
include 'db_manager.php';
$db = new DBManager();
$today = date("Y-m-d");
//echo $code;
$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'];
echo "[1]" . $region_code;
$s_big = $big;
if (strpos($big, '광역시') !== false || strpos($big, '특별시') !== false) {
    $std_arr = $db->db_query2("select std_code from se_all_region where big is NULL and name='" . $big . "'");
} else {
    if (strlen($mid) >= 15) {
        $pos = strpos($mid, '시');
        $newMid = substr($mid, 0, $pos + 3);
        $std_arr = $db->db_query2("select std_code from se_all_region where big='" . $big . "' and name='" . $newMid . "'");
    } else {
        $std_arr = $db->db_query2("select std_code from se_all_region where big='" . $big . "' and name='" . $mid . "'");
    }
}
$std_code = $std_arr[0]['std_code'];
//$std_code = 17;
$day_total = $db->db_query2("select tmn, tmx, sky from  se_day_forecast where region_code='" . $std_code . "' and date>='" . $today . "';");
$tmx = $day_total[0]['tmx'];
$tmn = $day_total[0]['tmn'];
$t_tmx = $day_total[1]['tmx'];