Advertisement
Guest User

Untitled

a guest
Dec 27th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  1. <select name="storeselect" class="form-control" required="" size="1">
  2. <option value=''>
  3. Select Store
  4. </option><?php
  5. $servername = "localhost";
  6. $username = "root";
  7. $password = "";
  8. $db = "storeinfo";
  9.  
  10. // Create connection
  11. $conn = new mysqli($servername, $username, $password, $db);
  12.  
  13. // Check connection
  14. if ($conn->connect_error) {
  15. die("Connection failed: " . $conn->connect_error);
  16. }
  17.  
  18. $db = new mysqli($servername, $username, $password, $db);
  19. $queryusers = "SELECT * FROM `information` WHERE `storelist` !='Security' ORDER BY `storelist` ASC";
  20. $db = mysqli_query($db, $queryusers);
  21. while ( $d=mysqli_fetch_assoc($db)) {
  22. $manager = $d['manager'];
  23. $director = $d['director'];
  24. $sdirector = $d['sdirector'];
  25. if ($manager == "none"){
  26. $email = $director."?CC=".$sdirector;}
  27. elseif ($director == "none") {
  28. $email = $manager."?CC=".$sdirector;
  29. }
  30. else {
  31. $email = $manager."; ".$director."?CC=".$sdirector;
  32. }
  33. echo "
  34. <option value ='".$d['storelist']."' title ='".$d['name']."' id='".$email."'>".$d['storelist']."</option>";
  35. }
  36. ?>
  37. </select>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement