Advertisement
sanjiisan

Untitled

Apr 13th, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.89 KB | None | 0 0
  1. <?php
  2.  
  3. if ($_SERVER['REQUEST_METHOD'] === 'GET') {
  4. if (isset($_GET['table']) && isset($_GET['id'])) {
  5.  
  6. $table = trim($_GET['table']);
  7. $id = trim($_GET['id']);
  8.  
  9.  
  10. $host = "localhost";
  11. $user = "root";
  12. $pass = "coderslab";
  13. $db = "cinemas_ex"; //nazwa bazy
  14.  
  15. try {
  16. $conn = new PDO( //Łączenie sie z bazą danych
  17. "mysql:host=$host;dbname=$db;charset=UTF8",
  18. $user, //root
  19. $pass,//coderslab
  20. [
  21. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  22. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC //domyslny sposob pobierania danych
  23. ]
  24. );
  25.  
  26.  
  27. switch ($table) {
  28. case 'movies': {
  29. $sql = "SELECT * FROM Movies WHERE id=:id;";
  30. break;
  31. }
  32. case 'tickets': {
  33. $sql = "SELECT * FROM Tickets WHERE id=:id;";
  34. break;
  35. }
  36. case 'payments': {
  37. $sql = "SELECT * FROM Payments WHERE id=:id;";
  38. break;
  39. }
  40. case 'cinemas': {
  41. $sql = "SELECT * FROM Cinemas WHERE id=:id;";
  42. break;
  43. }
  44. default: {
  45. echo 'Spadaj oszuście! Pały już po Ciebie jadą!';
  46. die;
  47. }
  48. }
  49.  
  50. $stmt = $conn->prepare($sql);
  51. $stmt->execute(['id' => $id]);
  52.  
  53. $row = $stmt->fetch();
  54.  
  55. foreach ($row as $key => $value) {
  56. echo $key . '<br>';
  57. echo $value . '<br>';
  58. }
  59.  
  60. } catch (PDOException $e) { //Odebranie błędu i komunikat
  61. echo $e->getMessage();
  62. }
  63. }
  64. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement