Advertisement
JonathanTL96

PHP code

Dec 31st, 2020 (edited)
496
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.67 KB | None | 0 0
  1. <?php
  2. $user_id = $_POST['user_id'];
  3. $shift = $_POST['text'];
  4. $conn = mysqli_connect();
  5. $sql = "SELECT Position FROM tablename WHERE UserID=?";
  6. $stmt = mysqli_prepare($conn, $sql);
  7. mysqli_stmt_bind_param($stmt, "s", $user_id);
  8. mysqli_stmt_execute($stmt);
  9. $result = mysqli_stmt_bind_result($stmt);
  10. while ($row = mysqli_fetch_row($result)) {
  11.     $position = $row[0];
  12. }
  13. mysqli_stmt_close($stmt);
  14. $sqlfirst = "SELECT Code,Day,Work,Comments,Shift,Position,UserID FROM tablename2 WHERE Command = 'Request' AND UserID != :userID";
  15. switch ($position) {
  16.     case "Office":
  17.         $sql1 = " AND Position IN ('Office', 'OfficeManager') AND Comments NOT LIKE '%manage%'";
  18.         break;
  19.     case "OfficeManager":
  20.         $sql1 = " AND Comments NOT LIKE '%Exam%'";
  21.         break;
  22.     case "Manager":
  23.         $sql1 = " AND ((Position = 'OfficeManager' AND Comments LIKE '%Manager%') OR (Position LIKE 'Manager%' AND          Comments NOT LIKE '%exam%'))";
  24.         break;
  25.     case "ExamManager":
  26.         $sql1 = " AND (Position LIKE 'Manager%') OR (Position = 'OfficeManager' AND Comments LIKE '%manager%')";
  27.         break;
  28. }
  29. switch ($shift) { // This variable comes straight from user input
  30.     case "E":
  31.     case "Earlies":
  32.         $sql2 = " AND Shift='Earlies'";
  33.         $shift = "earlies";
  34.         break;
  35.     case "L":
  36.     case "Lates":
  37.         $sql2 = " AND Shift='Lates'";
  38.         $shift = "lates";
  39.         break;
  40.     case "":
  41.         $sql2 = "";
  42.         $shift = "earlies and lates";
  43.         break;
  44.     default:
  45.         $err = "You can only choose between early and late shifts.\nIf you *do not* have a preference, please leave the field blank";
  46.         break;
  47. }
  48. $sqlsecond = " ORDER BY Day ASC";
  49. $sqlfinal = $sqlfirst . $sql1 . $sql2 . $sqlsecond;
  50. ?>
  51.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement