예제 #1
2
파일: searchz.php 프로젝트: reiheng/myweb
<?php 
$orz = $_POST['orz'];
?>

<form method="post" action="update.php">
	<b>ID:</b>
	<input type="text" size="40" name="id" value="<?php 
echo $orz;
?>
" readonly="value">
	<br>

	<?php 
require "dbconnect.php";
$aa = "select * from testtable where id='{$orz}'";
$result = pg_query(utf8_encode($aa)) or die(pg_error());
if (($row = pg_fetch_array($result)) != 0) {
    $bb = $row['name'];
    $cc = $row['age'];
    $dd = $row['memo'];
} else {
    $bb = ' ';
    $cc = ' ';
    $dd = ' ';
}
?>
	<b>Name:</b>
	<input type="text" size="40" name="name" value="<?php 
echo $bb;
?>
">
예제 #2
1
<?php

require_once "config.php";
$auth_host = $GLOBALS['auth_host'];
$auth_user = $GLOBALS['auth_user'];
$auth_pass = $GLOBALS['auth_pass'];
$auth_port = $GLOBALS['auth_port'];
$strConn = "host={$auth_host} port={$auth_port} dbname={$auth_dbase} user={$auth_user} password={$auth_pass}";
$db = pg_connect($strConn) or die("Error connection: " . pg_last_error());
$user_name = $_POST['name'];
$user_password = $_POST['password'];
$sql = pg_query($db, "SELECT * FROM account WHERE user_id = '{$user_name}' AND password = MD5('" . $user_password . "') ") or die(pg_error());
$rows = pg_num_rows($sql);
if ($rows > 0) {
    echo "true";
} else {
    echo "false";
}
pg_close($db);
?>
 
예제 #3
0
 function conectar($server = IP_SERVER, $user = USER_DB, $pass = PASSWORD_DB, $based = DB, $puerto = PORT, $tipo_conexion = "N")
 {
     try {
         switch ($tipo_conexion) {
             case "N":
                 // Conexion a B.D no persistente
                 $this->id_conexion = @pg_connect("host={$server} port={$puerto} dbname={$based} user={$user} password={$pass}");
                 break;
             case "P":
                 // Conexion a B.D persistente
                 $this->id_conexion = @pg_pconnect("host={$server} port={$puerto} dbname={$based} user={$user} password={$pass}");
                 break;
             default:
                 // Otros casos
                 $this->id_conexion = @pg_connect("host={$server} port={$puerto} dbname={$based} user={$user} password={$pass}");
                 break;
         }
         if ($this->id_conexion) {
             //$this->id_conexion->set_charset(CODEC);
             return $this->id_conexion;
         } else {
             throw new Exception("Error 01: " . ($this->id_conexion ? pg_error($this->id_conexion) : 'Servidor o B.D. no disponible'));
         }
     } catch (Exception $e) {
         $this->error1 = $e->getMessage();
         return null;
     }
 }
예제 #4
0
 public static function getUsers($id)
 {
     $id = MyUtil::parseInt($id);
     if (!$id) {
         $id = 0;
     }
     $stm = "SELECT id, " . " creation_dt," . " email," . " facebook_id," . " first_name," . " google_id," . " img_file_path," . " img_url," . " instagram_id," . " last_name," . " phone_nbr," . " tumblr_id," . " twitter_id," . " updated_ts," . " user_type_nbr," . " username " . " FROM " . self::$table_name . " WHERE id = {$id} OR 0 = {$id}";
     $result = ConnDB::query_db($stm);
     if (!$result) {
         return MyUtil::fnOk(false, pg_error(), null);
     }
     $retArray = [];
     while ($row = pg_fetch_assoc($result)) {
         array_push($retArray, $row);
     }
     if (sizeof($retArray) > 0) {
         return MyUtil::fnOk(true, "Found Users", $retArray);
     } else {
         return MyUtil::fnOk(false, "No Results", $retArray);
     }
 }
예제 #5
0
<?php

// Lecture du fichier de conf
$config = parse_ini_file("/etc/house-on-wire/house-on-wire.ini", true);
$db = pg_connect("host=" . $config['bdd']['host'] . " port=" . $config['bdd']['port'] . " dbname=" . $config['bdd']['dbname'] . " user="******" password="******" options='--client_encoding=UTF8'") or die("Erreur de connexion au serveur SQL");
$nb_points = $_GET['nb'];
$query = "SELECT ROUND(1000*EXTRACT(EPOCH from date)) AS when, papp FROM teleinfo ORDER BY date DESC LIMIT {$nb_points};";
$result = pg_query($db, $query) or die("Erreur SQL : " . pg_error());
$points = array();
while ($row = pg_fetch_array($result)) {
    $point = array($row['when'], $row['papp']);
    $points[] = $point;
}
header("Content-type: text/json");
echo json_encode(array_reverse($points), JSON_NUMERIC_CHECK);
예제 #6
0
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php 
require "dbconnect.php";
if ($_POST['submit']) {
    $query = "select * from testtable where id=" . $_POST['id'];
    $result = pg_query(utf8_encode($query)) or die(pg_error());
    if (($row = pg_fetch_array($result)) == 0) {
        $qq = "update testtable set name = '" . $_POST['name'] . "', age = '" . $_POST['age'] . "',memo = '" . $_POST['memo'] . "'WHERE id ='" . $_POST['id'] . "'";
        pg_query(utf8_encode($qq)) or die(pg_error());
    }
}
예제 #7
0
파일: getdata.php 프로젝트: ibnoe/appymz
    public function listtable($field, $sql, $link1, $link2, $par = "all")
    {
        $sColumns[0] = 'to_char(id,\'999999\')';
        $qColumns[0] = 'id';
        $x = 1;
        foreach ($field as $vs) {
            $sColumns[$x] = 'upper(' . $vs . ')';
            if ($vs[0] == '#') {
                $vs = substr($vs, 1);
                $sColumns[$x] = 'to_char(' . $vs . ',\'999999999999\')';
            }
            $aColumns[$x] = $vs;
            $qColumns[$x] = $vs;
            $x++;
        }
        $aColumns[$x] = 'id';
        $qColumns[$x] = 'id';
        /*
        		$aColumns = array( 'nik', 'nama_pegawai', 'id' );
        		$sColumns = array( 'to_char(id,\'999\')','upper(nik)', 'upper(nama_pegawai)');
        		$qColumns = array( 'id', 'nik','nama_pegawai', 'id' );
        */
        $sIndexColumn = "id";
        $sOrder = "";
        $sql1 = "";
        /* DB table to use */
        $sTable = "tb_pegawai";
        $sLimit = "";
        if (isset($_GET['iDisplayStart']) && $_GET['iDisplayLength'] != '-1') {
            $sLimit = "LIMIT " . pg_escape_string($_GET['iDisplayLength']) . " OFFSET " . pg_escape_string($_GET['iDisplayStart']);
        }
        if (isset($_GET['iSortCol_0'])) {
            $sOrder = "ORDER BY  ";
            for ($i = 0; $i < intval($_GET['iSortingCols']); $i++) {
                if ($_GET['bSortable_' . intval($_GET['iSortCol_' . $i])] == "true") {
                    $sOrder .= $qColumns[intval($_GET['iSortCol_' . $i])] . "\n\n\t\t\t\t\t\t" . pg_escape_string($_GET['sSortDir_' . $i]) . ", ";
                }
            }
            $sOrder = substr_replace($sOrder, "", -2);
            if ($sOrder == "ORDER BY") {
                $sOrder = "";
            }
        }
        $sWhere = "";
        if (isset($_GET['sSearch'])) {
            $sWhere = "WHERE (";
            for ($i = 0; $i < count($sColumns); $i++) {
                $sWhere .= $sColumns[$i] . " LIKE '%" . pg_escape_string(strtoupper($_GET['sSearch'])) . "%' OR ";
            }
            $sWhere = substr_replace($sWhere, "", -3);
            $sWhere .= ')';
        }
        for ($i = 0; $i < count($sColumns); $i++) {
            if (isset($_GET['bSearchable_' . $i]) || isset($_GET['sSearch_' . $i])) {
                if ($_GET['bSearchable_' . $i] == "true" && $_GET['sSearch_' . $i] != '') {
                    if ($sWhere == "") {
                        $sWhere = "WHERE ";
                    } else {
                        $sWhere .= " AND ";
                    }
                    $sWhere .= $sColumns[$i] . " LIKE '%" . pg_escape_string(strtoupper($_GET['sSearch_' . $i])) . "%' ";
                }
            }
        }
        $sQuery = "\n\n\t\t\tSELECT * FROM(\n\t\t\t" . $sql . ") as tbx\n\t\t\t{$sWhere}\n\n\t\t\t{$sOrder}\n\t\t\t{$sLimit}\n\n\t\t\t";
        $rResult = $this->db->query($sQuery) or die(pg_error());
        /* Data set length after filtering */
        $sQuery = "\n\n\t\t\tSELECT count(*) as jml FROM(\n\t\t\t" . $sql . ") as tbx\n\t\t\t{$sWhere}\n\n\t\t\t\t\n\n\t\t";
        #exit($sQuery);
        $rResultFilterTotal = $query = $this->db->query($sQuery) or die("Gagal");
        foreach ($query->result() as $row) {
            $iFilteredTotal = $row->jml;
        }
        /* Total data set length */
        $sQuery = "\n\n\t\t\tSELECT count(*) as jml FROM(\n\t\t\t" . $sql . ") as tbx";
        $rResultTotal = $query = $this->db->query($sQuery) or die("Gagal");
        foreach ($query->result() as $row) {
            $iTotal = $row->jml;
        }
        $sEcho = "";
        if (isset($_GET['sEcho'])) {
            $sEcho = $_GET['sEcho'];
        }
        $output = array("sEcho" => intval($sEcho), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array());
        foreach ($rResult->result() as $r) {
            $row = array();
            $jd = count($qColumns) - 1;
            $i = 0;
            foreach ($qColumns as $v) {
                if ($i == $jd) {
                    $act = '';
                    if ($par == 'all') {
                        $act .= '<a href="' . base_url() . $link1 . '/' . $r->{$v} . '">
							  	<img src="' . base_url() . 'img/edit.gif" alt="Edit Data"></a>';
                        $act .= '<a href="#" onClick="confirmationDel(' . $r->{$v} . ',\'' . base_url() . $link2 . '\');">
								<img src="' . base_url() . 'img/del.gif" alt="Delete Data"></a>';
                    }
                    if ($par == 'edit') {
                        $act .= '<a href="' . base_url() . $link1 . '/' . $r->{$v} . '">
							  	<img src="' . base_url() . 'img/edit.gif" alt="Edit Data"></a>';
                    }
                    if ($par == 'delete') {
                        $act .= '<a href="#" onClick="confirmationDel(' . $r->{$v} . ',\'' . base_url() . $link2 . '\');">
								<img src="' . base_url() . 'img/del.gif" alt="Delete Data"></a>';
                    }
                    if ($par != 'report') {
                        $row[] = $act;
                    }
                } else {
                    $row[] = $r->{$v};
                }
                $i++;
            }
            $output['aaData'][] = $row;
        }
        echo json_encode($output);
    }
예제 #8
0
    <script type="text/javascript" src="/js/dygraph-combined.js"></script>

<style type='text/css'>
     #labels > span.highlight { border: 1px solid grey; }
    </style>
</head>
<body>
<div id="graphdiv" style="width:800px; height:600px; float:left;"></div>
<div id="labels"></div>
<p>
<b>Sondes : </b>
<?php 
// Lecture du fichier de conf
$config = parse_ini_file("/etc/house-on-wire/house-on-wire.ini", true);
$db = pg_connect("host=" . $config['bdd']['host'] . " port=" . $config['bdd']['port'] . " dbname=" . $config['bdd']['dbname'] . " user="******" password="******" options='--client_encoding=UTF8'") or die("Erreur de connexion au serveur SQL");
$result = pg_query($db, "SELECT * from onewire where type ='temperature' and id in ('10.22E465020800', '10.28BD65020800', '10.380166020800', '10.A8EB65020800', '10.D6F865020800', '10.EDFA65020800', '28.BB1A53030000') order by id") or die("Erreur SQL sur recuperation des valeurs: " . pg_error());
$i = 0;
$labels = array();
array_push($labels, '"Date"');
while ($row = pg_fetch_array($result)) {
    echo '<input id="' . $i . '" type="checkbox" checked="" onclick="change(this)">';
    echo '<label for="' . $i . '"> ' . $row['name'] . '</label>';
    array_push($labels, '"' . $row['name'] . '"');
    $i++;
}
?>
</p>

<script type="text/javascript">

  g = new Dygraph(
예제 #9
0
<?php

require_once "config.php";
$auth_host = $GLOBALS['auth_host'];
$auth_user = $GLOBALS['auth_user'];
$auth_pass = $GLOBALS['auth_pass'];
$auth_dbase = $GLOBALS['auth_dbase'];
$db = pg_connect($auth_host, $auth_user, $auth_pass) or die(pg_error());
pg_select_db($auth_dbase, $db);
$username = pg_real_escape_string($_POST['name']);
$password = pg_real_escape_string($_POST['password']);
$email = pg_real_escape_string($_POST['email']);
$sql = pg_query("SELECT * FROM account WHERE user = '******'");
$rows = pg_num_rows($sql);
if ($rows > 0) {
    echo "false";
} else {
    $activation = md5(uniqid(rand(), true));
    pg_query("INSERT INTO account(user,password,email) VALUES ('{$username}',MD5('" . $password . "'),'{$email}')");
    echo "true";
}
pg_close($db);
?>
 
 
예제 #10
0
<?php

// Lecture du fichier de conf
$config = parse_ini_file("/etc/house-on-wire/house-on-wire.ini", true);
$db = pg_connect("host=" . $config['bdd']['host'] . " port=" . $config['bdd']['port'] . " dbname=" . $config['bdd']['dbname'] . " user="******" password="******" options='--client_encoding=UTF8'") or die("Erreur de connexion au serveur SQL");
$query = "SELECT\n                220 * isousc as papp_max\n        FROM\n                teleinfo\n\torder by date desc\nlimit 1\n                ";
$result = pg_query($db, $query) or die("Erreur SQL sur recuperation des valeurs: " . pg_error());
// On prend les infos de la premiere sonde
$papp = pg_fetch_array($result);
$result = pg_query($db, "SELECT date, papp from teleinfo where date > current_timestamp - interval '1 minute' order by date asc") or die("Erreur SQL sur recuperation des valeurs: " . pg_error());
?>
    <script type="text/javascript">
      var data = [];
      <?php 
while ($row = pg_fetch_array($result)) {
    echo "data.push([new Date(\"" . $row["date"] . "\"), " . $row["papp"] . "]);\n";
}
?>

      var g = new Dygraph(
		document.getElementById("div_g"), 
                data,
                {
                    stepPlot: true,
                    fillGraph: true,
                    stackedGraph: true,
                  valueRange: [0, <?php 
echo $papp['papp_max'];
?>
],
//		    includeZero: true,
예제 #11
0
<?php

ini_set('display_errors', 1);
//database login info
$host = 'localhost';
$port = '5432';
$dbname = 'ward';
$user = '******';
$password = '******';
$conn = pg_connect("host={$host} port={$port} dbname={$dbname} user={$user} password={$password}");
if (!$conn) {
    echo "Not connected : " . pg_error();
    exit;
}
//if a query, add those to the sql statement
if (isset($_GET['nx'])) {
    $nx = $_GET['nx'];
    $ny = $_GET['ny'];
    $ts = $_GET['ts'];
    $alfa = $_GET['alfa'];
    $sql = "UPDATE not_spatial_param SET\n          nx = {$nx},\n          ny = {$ny},\n          ts = {$ts},\n          alfa = {$alfa};";
}
$calculus = "DROP TABLE tempo;\nCREATE TABLE tempo (res float[][]);\nINSERT INTO tempo(res) values (interpol());\nDELETE FROM rasters WHERE rid = 1;\nSELECT DROPRasterConstraints ('rasters'::name, 'rast'::name);\nINSERT INTO rasters (rid, rast) VALUES (1, st_setvalues(st_addband(st_makeemptyraster((SELECT nx FROM not_spatial_param),(SELECT ny FROM not_spatial_param),(select st_xmin(geometry) from bounding_box),(select st_ymax(geometry) from bounding_box),\n(((select st_xmax(geometry) from bounding_box)-(select st_xmin(geometry) from bounding_box))/(SELECT nx FROM not_spatial_param)),(((select st_ymin(geometry) from bounding_box)-(select st_ymax(geometry) from bounding_box))/(SELECT ny FROM not_spatial_param)),0,0,3857), 1, '32BF', 1, 0), 1,1,1,(select compound_array(array[res]) from tempo)));\n        SELECT ADDRasterConstraints ('rasters'::name, 'rast'::name);\nselect * from not_spatial_param;\nselect (st_summarystats(rast)).* FROM rasters where rid = 1;";
if (!($response = pg_query($conn, $sql))) {
    echo "A query error occured.\n";
    exit;
}
if (!($response = pg_query($conn, $calculus))) {
    echo "A query error occured.\n";
    exit;
}
예제 #12
0
 while ($row = pg_fetch_array($result)) {
     ncurses_mvwaddstr($bl, $ligne, 2, sprintf("%-18s", $row['name'] . " : "));
     if ($row['last_value'] == 1) {
         ncurses_wcolor_set($bl, 2);
         ncurses_mvwaddstr($bl, $ligne, 24, sprintf("%15s", "Fermée"));
         ncurses_wcolor_set($bl, 0);
     } else {
         ncurses_wattron($bl, NCURSES_A_BOLD);
         ncurses_wcolor_set($bl, 1);
         ncurses_mvwaddstr($bl, $ligne, 24, sprintf("%15s", "Ouverte"));
         ncurses_wattroff($bl, NCURSES_A_BOLD);
         ncurses_wcolor_set($bl, 0);
     }
     $ligne++;
 }
 $result = pg_query($db, "select count(*) as nb_sonde, sum(case when date_trunc('minute', last_update) = (select date_trunc('minute', max(last_update)) from onewire) then 1 else 0 end ) as nb_sonde_ok,  sum(case when date_trunc('minute', last_update) != (select date_trunc('minute', max(last_update)) from onewire) then 1 else 0 end ) as nb_sonde_ko, date_trunc('minute', max(last_update)) as last_update, case when (select date_trunc('minute', max(last_update)) from onewire) < current_timestamp - interval '1 min' then 1 else 0 end as alerte, current_timestamp - interval '1 min' from onewire;") or die('Erreur SQL sur recuperation des valeurs: ' . pg_error());
 $maj = pg_fetch_array($result);
 if ($maj['nb_sonde_ok'] == $maj['nb_sonde']) {
     ncurses_mvwaddstr($bl, 13, 2, "Maj : ");
     ncurses_wcolor_set($bl, 2);
     ncurses_mvwaddstr($bl, 13, 8, $maj['last_update'] . " " . $maj['nb_sonde_ok'] . "/" . $maj['nb_sonde'] . " sondes");
     ncurses_wcolor_set($bl, 0);
 } else {
     ncurses_mvwaddstr($bl, 13, 2, "Maj : ");
     ncurses_wattron($bl, NCURSES_A_BOLD);
     ncurses_wcolor_set($bl, 1);
     ncurses_mvwaddstr($bl, 13, 8, $maj['last_update'] . " " . $maj['nb_sonde_ok'] . "/" . $maj['nb_sonde'] . " sondes");
     ncurses_wattroff($bl, NCURSES_A_BOLD);
     ncurses_wcolor_set($bl, 0);
 }
 // nb_sonde | nb_sonde_ok | nb_sonde_ko |     last_update     | alerte |           ?column?
예제 #13
0
<?php

session_start();
require "dbconnect.php";
// Connect to server and select databse.
$connection = pg_connect("dbname={$database} user={$user} password={$password} host={$host}");
if (!$connection) {
    die("Not connected : " . pg_error());
}
// username and password sent from form
$username = $_POST['username'];
$password = $_POST['password'];
$hashpass = md5($mypassword);
// To protect against SQL injection
$username = stripslashes($username);
$password = stripslashes($password);
$query = "SELECT * FROM public.\"Registered_Users\" WHERE username = '******' AND password = '******'";
$result = pg_exec($connection, $query);
// Count matching rows returned
$count = pg_numrows($result);
// If result matched $username and $password, table row must be 1 row
if ($count == 1) {
    // Register $username session and redirect to file "index.php"
    $_SESSION["username"] = $username;
    header("location:index.php");
} else {
    header("location:login_fail.php");
}
예제 #14
0
    $cari2 = "{$d}-{$b}";
    $storeinit = pg_fetch_array(pg_query("select inisial_store from master_store where id={$_SESSION['id_storeee']}"));
    $rowid = pg_fetch_array(pg_query("select max(cast(substr(id_bongkar,1,5) as integer)) as id from trans_bongkar where id_bongkar like '%{$cari}%'"));
    $idbaru = $rowid[0] + 1;
    $init_jenis = pg_fetch_array(pg_query("select init_jenis from master_artikel_jenis where id=35"));
    if ($idbaru < 10) {
        $idbongkar = "0000{$idbaru}/{$storeinit['0']}-{$init_jenis['0']}/{$cari2}";
    } elseif ($idbaru >= 10 && $idbaru < 100) {
        $idbongkar = "000{$idbaru}/{$storeinit['0']}-{$init_jenis['0']}/{$cari2}";
    } elseif ($idbaru >= 100 && $idbaru < 1000) {
        $idbongkar = "00{$idbaru}/{$storeinit['0']}-{$init_jenis['0']}/{$cari2}";
    } elseif ($idbaru >= 1000 && $idbaru < 10000) {
        $idbongkar = "0{$idbaru}/{$storeinit['0']}-{$init_jenis['0']}/{$cari2}";
    }
    $qry1 = "INSERT INTO trans_bongkar(id_bongkar, id_store, id_item, tgl_bongkar,type_bongkar,created_date,created_by) VALUES ('{$idbongkar}', '{$id_store}','{$id_item}', '{$tgl_rongsok}', '{$type_bongkar}','{$created_date}','{$created_by}')";
    $rslt = pg_query($qry1) or die(pg_error());
    $row2 = pg_fetch_array(pg_query("select id from trans_bongkar where id_bongkar='{$idbongkar}'"));
    for ($i = 0; $i < count($data_building_bongkar); $i++) {
        "</br>";
        $q2 = pg_query("INSERT INTO trans_bongkar_detail(id_bongkar, data_building_bongkar, data_exception_bongkar, jumlah_building_bongkar) VALUES ('{$row2['0']}','{$data_building_bongkar[$i]}','{$data_exception_bongkar[$i]}','{$jumlah_building_bongkar[$i]}')");
    }
    echo '<script language="javascript">';
    echo 'alert("Tambah Data Berhasil");';
    echo 'document.location="trans_destruction.php"';
    echo '</script>';
}
?>
<div class="row">
	<div class="col-lg-12">
		<div class="panel panel-default">
			<div class="span12">
예제 #15
0
</head>
<body>
<div id="graphdiv" style="width:800px; height:300px;"></div>
<div id="graphdiv2" style="width:800px; height:300px;"></div>
<?php 
// Lecture du fichier de conf
$config = parse_ini_file("/etc/house-on-wire/house-on-wire.ini", true);
$db = pg_connect("host=" . $config['bdd']['host'] . " port=" . $config['bdd']['port'] . " dbname=" . $config['bdd']['dbname'] . " user="******" password="******" options='--client_encoding=UTF8'") or die("Erreur de connexion au serveur SQL");
$query = "SELECT\n                *\n        FROM\n                onewire\n        WHERE\n                id = ANY ( case\n                        when exists(select 1 from onewire where id = '" . $_GET['id'] . "')\n                        then (select array_agg(id) from onewire where id = '" . $_GET['id'] . "')\n                        else (select array_agg(id) from onewire_meta where regroupement = '" . $_GET['id'] . "' )\n                end )";
$result = pg_query($db, $query) or die("Erreur SQL sur recuperation des valeurs: " . pg_error());
// On prend les infos de la premiere sonde
$info_sonde = pg_fetch_array($result);
if (pg_num_rows($result) > 1) {
    $info_sonde['name'] = $_GET['id'];
}
$result = pg_query($db, "SELECT extract(epoch from current_timestamp)*1000  as finish_date, extract( epoch from current_date - interval '10 days')*1000 as start_date") or die("Erreur SQL sur recuperation des valeurs: " . pg_error());
$date = pg_fetch_array($result);
?>

<script type="text/javascript">

g = new Dygraph(
    // containing div
    document.getElementById("graphdiv"),
    '/php/get_data_csv.php?type=last_days&sonde=<?php 
echo $_GET['id'];
?>
',
    {
        customBars: true,
        title: '<?php 
예제 #16
0
파일: display.php 프로젝트: reiheng/myweb
    //取得上傳檔案資訊
    $filename = $_FILES['image']['name'];
    $tmpname = $_FILES['image']['tmp_name'];
    $filetype = $_FILES['image']['type'];
    $filesize = $_FILES['image']['size'];
    $file = NULL;
    if (isset($_FILES['image']['error'])) {
        if ($_FILES['image']['error'] == 0) {
            $instr = fopen($tmpname, "rb");
            $file = addslashes(fread($instr, filesize($tmpname)));
        }
    }
    //新增圖片到資料庫
    pg_query("insert into testtable (id,name,age,memo, img) values ('{$id}','{$name}','{$age}','{$memo}', '{$file}')");
}
?>
 

<?php 
$result = pg_query("select * from testtable ") or die(pg_error());
$xx = pg_fetch_all($result);
foreach ($xx as $row) {
    echo "<b>ID:</b>" . $row['id'] . "<br><b>Name:</b>" . $row['name'] . "<br><b>Age:</b>" . $row['age'] . "<br><b>Memo:</b>" . $row['memo'] . "<br><br><br>";
}
pg_free_result($result);
?>

<h2><a href="search.php">修改</a></h2>
<h2><a href="delete.php">刪除</a></h2>
<h2><a href="insert.php">新增</a></h2>
</form>
예제 #17
0
            </li>
<?php 
}
?>
            <li data-role="list-divider" role="heading">
                Energie
            </li>
            <li data-theme="c">
                    EDF
                    <span class="ui-li-count">
<?php 
$result = pg_query($db, " select * from (select extract(EPOCH FROM date) as ts, (hchp+hchc) as conso  from teleinfo where date >= (current_timestamp - interval '5min') order by date asc) a limit 1; ") or die("Erreur SQL sur recuperation des valeurs: " . pg_error());
$row = pg_fetch_array($result);
$ts_prec = $row["ts"];
$conso_prec = $row["conso"];
$result = pg_query($db, " select extract(EPOCH FROM date) as ts, (hchp+hchc) as conso  from teleinfo order by date desc limit 1; ") or die("Erreur SQL sur recuperation des valeurs: " . pg_error());
$row = pg_fetch_array($result);
$ts_now = $row["ts"];
$conso_now = $row["conso"];
echo round(3600 * ($conso_now - $conso_prec) / ($ts_now - $ts_prec));
?>
 W
                    </span>
            </li>
        </ul>
    </div>
</div>

</body>
</html>
예제 #18
0
    } else {
        $selected = "";
        $hidden = "hidden";
    }
    $tabsbuttons .= "<div class=\"tab " . $row['level'] . " {$selected}\" data-tab-name=\"" . $row['level'] . "\">\n";
    $tabsbuttons .= $row['name'] . "\n";
    $tabsbuttons .= "</div>\n";
    $tabscontainers .= "<div class=\"tabBody " . $row['level'] . " {$hidden}\">\n";
    $tabscontainers .= "<div id=\"" . $row['level'] . "\" class=\"widgets\"></div>\n";
    if ($row['level'] == "meteo") {
        $tabscontainers .= "<a href='http://house.vitre.info/php/chart_rain_total.php?year=2013-01-01'>Graph pluviometrie</a><br/>";
    }
    $tabscontainers .= "</div>\n";
}
// Récupération des sondes
$result = pg_query($db, 'select id, coalesce(o.name, om.name) as name, coalesce(o.unity, om.unity) as unity , top, "left", level, coalesce(o.type, om.type) as type from onewire_meta om left join onewire o using (id)') or die('Erreur SQL sur recuperation des valeurs: ' . pg_error());
$widgetsData = array();
while ($row = pg_fetch_array($result)) {
    $widgetsData[] = array('id' => $row['id'], 'title' => $row['name'], 'unit' => $row['unity'], 'top' => $row['top'], 'left' => $row['left'], 'level' => $row['level'], 'type' => $row['type']);
}
?>

<!DOCTYPE html>
<html>
    <head>
        <!--[if IE]>
            <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
        <![endif]-->
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <link rel="shortcut icon" type="image/x-icon" href="/favicon.ico" />
        <link rel="stylesheet" type="text/css" href="/css/main.css" />
예제 #19
0
<?php

// Lecture du fichier de conf
$config = parse_ini_file("/etc/house-on-wire/house-on-wire.ini", true);
$db = pg_connect("host=" . $config['bdd']['host'] . " port=" . $config['bdd']['port'] . " dbname=" . $config['bdd']['dbname'] . " user="******" password="******" options='--client_encoding=UTF8'") or die("Erreur de connexion au serveur SQL");
$query = "SELECT MIN(papp) as min FROM teleinfo WHERE date >= ( current_timestamp - interval '24h' );";
$result = pg_query($db, $query) or die("Erreur SQL sur selection MIN() et MAX() de PAPP: " . pg_error());
$row = pg_fetch_array($result);
$papp_min_24h = $row['min'];
// Recuperation du plus vieux timestamp auquel le MIN des dernieres 24h a ete atteint
$query = "SELECT ROUND( 1000*EXTRACT( EPOCH FROM date ) ) AS when FROM teleinfo WHERE papp = " . $papp_min_24h . " AND date >= ( current_timestamp - interval '24h' ) ORDER BY date ASC LIMIT 1";
$result = pg_query($db, $query) or die("Erreur SQL sur selection MIN() et MAX() de PAPP: " . pg_error());
$row = pg_fetch_array($result);
$when_papp_min_24h = $row['when'];
echo $_GET["jqueryCallback"] . "(";
echo "{ x: {$when_papp_min_24h}, title: 'Mini 24h', text: 'Mini des dernieres 24h : {$papp_min_24h} W' })";
예제 #20
0
 public static function error($err = null)
 {
     if ($err === null) {
         return pg_error();
     } else {
         return pg_error($err);
     }
 }
예제 #21
0
<?php

include "header.php";
extract($_GET);
extract($_POST);
if ($posting == 1) {
    $sql = "insert into master_user\r\n(id_user,nama_user,password,id_store,userho,id_role) values \r\n('{$id_user}','{$nama_user}','{$password}',{$id_store},'{$userho}','{$id_role}') ";
    $rslt = pg_query($sql) or die(pg_error());
    echo pg_fetch_array($rslt);
    echo '<script language="javascript">';
    echo 'alert("Tambah Data Berhasil");';
    echo 'document.location="master_users.php"';
    echo '</script>';
}
?>
<div class="row">
<div class="col-lg-12">
<div class="panel panel-default">
<div class="span12">
		<!-- BEGIN PAGE TITLE & BREADCRUMB-->		
		<ul class="breadcrumb">
			<li>
				<i class="glyphicon glyphicon-home"></i>
				<a href="inside.php">Home</a> 
				<i class="icon-angle-right"></i>
			</li>
			<li>
				<a href="master_users.php" onClick="ShowListDiv();">Master Users</a>
			</li>

예제 #22
0
<?php

// Lecture du fichier de conf
$config = parse_ini_file("/etc/house-on-wire/house-on-wire.ini", true);
$db = pg_connect("host=" . $config['bdd']['host'] . " port=" . $config['bdd']['port'] . " dbname=" . $config['bdd']['dbname'] . " user="******" password="******" options='--client_encoding=UTF8'") or die("Erreur de connexion au serveur SQL");
$query = "SELECT ROUND( EXTRACT(EPOCH FROM date) ), papp FROM teleinfo WHERE ptec='HC';";
$result = pg_query($db, $query) or die("Erreur SQL " . pg_error());
if (!$result) {
    echo "Erreur SQL: " . pg_error();
    exit;
}
echo $_GET["callback"] . "(";
$first = TRUE;
echo "[";
while ($row = pg_fetch_row($result)) {
    echo '[' . $row[0] . ',' . $row[1] . ']';
    if ($first == FALSE) {
        echo ',';
        $first = FALSE;
    }
}
echo "]);";
<?php

function validaValor($cadena)
{
    // Funcion utilizada para validar el dato a ingresar recibido por GET
    if (eregi('^[a-zA-Z0-9._αινσϊρ‘!Ώ? -]{1,40}$', $cadena)) {
        return TRUE;
    } else {
        return FALSE;
    }
}
$valor = trim($_GET['dato']);
$campo = trim($_GET['actualizar']);
if (validaValor($valor) && validaValor($campo)) {
    // Si los campos son validos, se procede a actualizar los valores en la DB
    include 'conexion.php';
    conectar();
    // Actualizo el campo recibido por GET con la informacion que tambien hemos recibido
    pg_query("UPDATE cliente SET valor='{$valor}' WHERE id='{$campo}'") or die(pg_error());
    desconectar();
}
// No retorno ninguna respuesta
예제 #24
0
		</tr>
		<tr class="entete">
                        <td>H. Pleines</td><td>H. Creuses</td><td>Total</td><td>Cout</td>
		</tr>
	</thead>
<?php 
foreach ($months as $month) {
    $result = pg_query($db, 'select to_char(\'' . $month . '\'::timestamptz, \'Month YYYY\') as month_string;') or die('Erreur SQL sur recuperation des valeurs: ' . pg_error());
    $row = pg_fetch_array($result);
    echo "                <tr class=\"content\">\n                        <td class=\"libelle\">" . $row['month_string'] . "</td>";
    foreach ($stats_ids as $id => $name) {
        $result = pg_query($db, 'select round(min_value::numeric, 1) as min_value, round(avg_value::numeric, 1) as avg_value, round(max_value::numeric, 1) as max_value from statistiques where id = \'' . $id . '\' and mois = \'' . $month . '\'') or die('Erreur SQL sur recuperation des valeurs: ' . pg_error());
        $row = pg_fetch_array($result);
        echo "            <td><div class=\"moy\">" . $row['avg_value'] . " °C</div><div class=\"delta\"><div class=\"max\">" . $row['max_value'] . " °C</div><div class=\"min\">" . $row['min_value'] . " °C</div></div></td>";
    }
    $result = pg_query($db, 'select sum(hchc)/1000 as hchc, sum(hchp)/1000 as hchp, sum(hchc+hchp)/1000 as hc, round(sum(cout_hc+cout_hp+cout_abo)::numeric, 2) as cout from teleinfo_cout where date_trunc(\'month\', date) = \'' . $month . '\' group by date_trunc(\'month\', date)') or die('Erreur SQL sur recuperation des valeurs: ' . pg_error());
    $row = pg_fetch_array($result);
    echo "                        <td>" . $row['hchc'] . "</td>\n                        <td>" . $row['hchp'] . "</td>\n                        <td>" . $row['hc'] . "</td>\n                        <td>" . $row['cout'] . "</td>\n\n                </tr>";
}
?>
	</table>
</div>

<script type="text/javascript">

  g = new Dygraph(

    // containing div
    document.getElementById("graphdiv"),
'/php/get_data_csv.php?type=temp_full&sonde=all',
{
예제 #25
0
파일: Pgsql.php 프로젝트: glial/glial
 public function _error()
 {
     return pg_error($this->link);
 }
예제 #26
-1
 public static function deleteVote($session_id, $user_id)
 {
     //id must be an integer
     $orig_sess_id = $session_id;
     $orig_user_id = $user_id;
     //get parsed integers
     $session_id = MyUtil::parseInt($session_id);
     $user_id = MyUtil::parseInt($user_id);
     //check
     if ($session_id == null || $user_id == null) {
         return MyUtil::fnOk(false, "Must be valid ids - session:{$orig_sess_id}, user:{$orig_user_id}", null);
     }
     $stm = "DELETE FROM " . self::$table_name . " WHERE session_id = {$session_id} AND user_id = {$user_id}";
     $result = ConnDB::query_db($stm);
     if (!$result) {
         return MyUtil::fnOk(false, pg_error(), null);
     }
     return MyUtil::fnOk(true, "", $result);
 }
예제 #27
-1
function db_query($rlt)
{
    global $base, $debug, $sql_query, $conn;
    $sql_query = $rlt;
    //echo $rlt;
    //	if (strlen($debug) > 0) { echo '<HR>'.$rlt; }
    ////////////////////////////// PostGre
    if ($base == 'pgsql') {
        if (strlen($debug) > 0) {
            $xxx = pg_query($rlt) or die($rlt . pg_email_erro($rlt));
        } else {
            $xxx = pg_query($rlt) or die('Erro de base <BR>' . pg_email_erro($rlt));
        }
    }
    ////////////////////////////// MySQL
    if ($base == 'mysqlPDO') {
        $xxx = $conn->query($rlt);
        //if (strlen($debug) > 0) { $xxx = mysql_query($rlt) or die(mysql_error() . '<BR>'.$rlt); }
        //else {  $xxx = mysql_query($rlt) or die('Erro de base'); }
    }
    if ($base == 'mysql') {
        if (strlen($debug) > 0) {
            $xxx = mysql_query($rlt) or die(mysql_error() . '<BR>' . $rlt);
        } else {
            $xxx = mysql_query($rlt) or die('Erro de base');
        }
    }
    if ($base == 'mssql') {
        $rlt = sql_convert($rlt);
        $sql_query = $rlt;
        if (strlen($debug) > 0) {
            $xxx = mssql_query($rlt) or die(pg_error() . '<BR>' . $rlt);
        } else {
            $xxx = mssql_query($rlt);
        }
    }
    if ($base == 'sybase') {
        $xxx = sybase_query($rlt) or die(pg_error() . '<BR>' . $rlt);
    }
    return $xxx;
}