Guest User

Untitled

a guest
May 25th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.12 KB | None | 0 0
  1. <?php
  2. if(isset($_POST['search'])) {
  3.     $s_robot    = $_POST['searchRobot'];
  4.     $s_date     = $_POST['searchDate'];
  5.     $s_code     = $_POST['searchErrorcode'];
  6.     $s_position     = $_POST['searchCoordinate'];
  7.     $s_nick     = $_POST['searchLoggedBy'];
  8.                            
  9.     //Check witch query to select. Can be made simplier, not priority
  10.     if(!empty($s_robot)) {
  11.         $searchQuery = mysql_query("SELECT * FROM robot_error WHERE robot = '$s_robot' ORDER BY id DESC");
  12.     }
  13.     elseif(!empty($s_date)) {
  14.         $searchQuery = mysql_query("SELECT * FROM robot_error WHERE date = '$s_date' ORDER BY id DESC");
  15.     }
  16.     elseif(!empty($s_code)) {
  17.         $searchQuery = mysql_query("SELECT * FROM robot_error WHERE error_code = '$s_code' ORDER BY id DESC");
  18.     }
  19.     elseif(!empty($s_position)) {
  20.         $searchQuery = mysql_query("SELECT * FROM robot_error WHERE position = '$s_position' ORDER BY id DESC");
  21.     }
  22.     elseif(!empty($s_nick)) {
  23.         $searchQuery = mysql_query("SELECT * FROM robot_error WHERE logged_by = '$s_nick' ORDER BY id DESC");
  24.     }
  25.                            
  26.     if($s_robot != "") {
  27.         $search_robot = $s_robot;
  28.     }
  29.     else {
  30.         $inf = mysql_fetch_array($searchSQL);
  31.         $search_robot = $inf['robot'];
  32.     }
  33. }
  34. ?>
Add Comment
Please, Sign In to add comment