File "data_delete.php"

Full path: /www/shimooguni/recv/data_delete.php
File size: 1.11 KiB (1138 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back

<?php
/////////////////////////////////////////////////////////////////////////////////////	
//最新データのパス(DBへINSERT用)

$HOST = "192.168.100.153";
$DB = "shimooguni";
$USER = "postgres";
$PASS = "postgres";

$DATA_TABLE = "weather.data_log";
$DATA_TABLE_1H = "weather.data_log_1h";
$DATA_TABLE_DAY = "weather.data_log_day";
$DATA_TABLE_WEEK = "weather.data_log_week";
$DATA_TABLE_MONTH = "weather.data_log_month";
$DATA_TABLE_NEW = "weather.data_log_new";

//================================================
//	データベース接続
//	備考		：	
//	更新		：	2013/03/12 KMK-Yokosuka
//================================================
$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");


if($argv[1])
{
	switch($argv[1])
	{
		case 1:
			$DELETE_= "DELETE FROM " .$DATA_TABLE_1H .";";
			$res = pg_query($conn,$DELETE_);
			break;
		case 2:
			$DELETE_ = "DELETE FROM " .$DATA_TABLE_DAY .";";
			$res = pg_query($conn,$DELETE_);
			break;
		case 3:
			$DELETE_ = "DELETE FROM " .$DATA_TABLE_MONTH .";";
			$res = pg_query($conn,$DELETE_);
			break;
	}
}

?>