Esempio n. 1
0
 public static function GetServerDate()
 {
     $sqlCommand = " SELECT NOW() AS NOW ";
     $result = DA_Helper::ExecuteNonParametricQuery($sqlCommand);
     $row = mysql_fetch_assoc($result);
     return $row['NOW'];
 }
Esempio n. 2
0
 public static function GetAllData()
 {
     $sqlCommand = "SELECT " . "entry_id," . "app_id," . "value_label," . "value," . "value_type_code," . "captured_datetime," . "created_datetime " . "FROM generic_value_log " . "ORDER BY entry_id desc ";
     $result = DA_Helper::ExecuteNonParametricQuery($sqlCommand);
     $arrayResult = [];
     while ($row = mysql_fetch_assoc($result)) {
         $arrayResult[] = $row;
     }
     return $arrayResult;
 }