nce/nc_query_attributes_db.php

   1 <?php
   2 /*
   3  nce (ntch cloud environment.)
   4  name: nc_query_board_attributes_db.php
   5  author: Akira Ohta (akohta001.gmail.com)
   6  date: 2013-dec-26th
   7  description:
   8  License: GPLv3
   9  */
  10 include_once "env.php";
  11 include_once "account.php";
  12 include_once "preference.php";
  13 include_once "database.php";
  14 include_once "log.php";
  15 include_once "http_util.php";
  16 include_once "error_code.php";
  17
  18 $user_id = $_POST['user'];
  19 $token = $_POST['token'];
  20
  21 if(isset($_POST['last_query']))
  22         $last_query = $_POST['last_query'];
  23
  24 //--- authorization ---
  25 $user = chk_passwd( $user_id, $token);
  26 if(FALSE === $user){
  27         echo $ERROR_MSG;
  28         exit;
  29 }
  30 $extra_filter = "";
  31 //--- parameter check start ---
  32 if(isset($last_query)){
  33         $extra_filter = " WHERE last_update > '{$last_query}'";
  34
  35 }
  36 //--- parameter check end ---
  37
  38 $table_name = TABLE_PREFIX."tbl{$user->home_dir}";
  39 $query1 = <<< QUERY1
  40 select record_type, res_number, dat_name, board_name, last_update from $table_name {$extra_filter}
  41 QUERY1;
  42
  43 try{
  44         $db->open();
  45         //echo $query1."\n";
  46         $result = $db->execute($query1);
  47
  48         if(!$result){
  49                 echo ERROR503;
  50                 exit;
  51         }
  52         $db->close();
  53 }catch(Exception $e){
  54         $error = __FILE__."(".__LINE__.
  55                 ") An error occured during query.";
  56         nc_logging($error, $e);
  57         echo ERROR500;
  58         exit;
  59 }
  60
  61 echo SUCCESS100;
  62 echo date("Y-m-d H:i:s");
  63 echo "\n";
  64 for($i = 0; $i < $result->num_rows; $i++){
  65         $row = $result->fetch_assoc();
  66         echo $row['board_name'].",".$row['dat_name'].",".$row['res_number'].
  67         ",".$row['record_type'].",".$row['last_update']."\n";
  68 }
  69
  70 ?>