Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if ($_SERVER['REQUEST_METHOD'] === 'GET') {
- if (isset($_GET['table']) && isset($_GET['id'])) {
- $table = trim($_GET['table']);
- $id = trim($_GET['id']);
- $host = "localhost";
- $user = "root";
- $pass = "coderslab";
- $db = "cinemas_ex"; //nazwa bazy
- try {
- $conn = new PDO( //Łączenie sie z bazą danych
- "mysql:host=$host;dbname=$db;charset=UTF8",
- $user, //root
- $pass,//coderslab
- [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC //domyslny sposob pobierania danych
- ]
- );
- switch ($table) {
- case 'movies': {
- $sql = "SELECT * FROM Movies WHERE id=:id;";
- break;
- }
- case 'tickets': {
- $sql = "SELECT * FROM Tickets WHERE id=:id;";
- break;
- }
- case 'payments': {
- $sql = "SELECT * FROM Payments WHERE id=:id;";
- break;
- }
- case 'cinemas': {
- $sql = "SELECT * FROM Cinemas WHERE id=:id;";
- break;
- }
- default: {
- echo 'Spadaj oszuście! Pały już po Ciebie jadą!';
- die;
- }
- }
- $stmt = $conn->prepare($sql);
- $stmt->execute(['id' => $id]);
- $row = $stmt->fetch();
- foreach ($row as $key => $value) {
- echo $key . '<br>';
- echo $value . '<br>';
- }
- } catch (PDOException $e) { //Odebranie błędu i komunikat
- echo $e->getMessage();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement