Guest User

Untitled

a guest
Jan 25th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1.  
  2. //if you want to require one of them
  3. if(trim($_REQUEST['username']) || $_REQUEST['date'] || $_REQUEST['employee'])
  4. {
  5.  
  6. $dbhost = "localhost";
  7. $dbuser = "root";
  8. $dbpass = "p4ssw0rd";
  9. $dbname = "webcall";
  10. //Connect to MySQL Server
  11. mysql_connect($dbhost, $dbuser, $dbpass);
  12. //Select Database
  13. mysql_select_db($dbname) or die(mysql_error());
  14. // Retrieve data from Query String
  15.  
  16.  
  17. $where="";
  18.  
  19. $query = "SELECT * FROM LS_webcall";
  20. if(trim($_REQUEST['username'])
  21. $where.= " and webcall_username='" . mysql_real_escape_string($_REQUEST['username']) ."' ");
  22.  
  23. if(trim($_REQUEST['date'])
  24. $where.= " and `webcall_date='" . mysql_real_escape_string($_REQUEST['date']) ."' ");
  25.  
  26. if(trim($_REQUEST['employee'])
  27. $where.= " and webcall_employee='" . mysql_real_escape_string($_REQUEST['employee']) ."' ");
  28.  
  29. $query.= trim($where, ' and');
  30.  
  31. $qry_result = mysql_query($query) or die(mysql_error());
  32.  
  33.  
  34. ////////////////BLAH
  35.  
  36. }
  37. else
  38. die('submit something');
Add Comment
Please, Sign In to add comment