Advertisement
Guest User

Untitled

a guest
Dec 2nd, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.79 KB | None | 0 0
  1. <html>
  2. <meta charset="UTF-8">
  3.     <body>
  4. <?php
  5.     $morada = $_REQUEST['morada'];
  6.     try
  7.     {
  8.         $host = "db.ist.utl.pt";
  9.         $user ="ist182055";
  10.         $password = "dcnv7318";
  11.         $dbname = $user;
  12.    
  13.         $db = new PDO("mysql:host=$host;dbname=$dbname", $user, $password);
  14.         $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  15.    
  16.         $sql1 = "SELECT * FROM espaco WHERE morada = $morada;";
  17.    
  18.         $result = $db->query($sql1);
  19.    
  20.         echo("<table border=\"0\" cellspacing=\"5\">\n");
  21.  
  22.         echo("</table>\n");
  23.        
  24.         echo("<h4><a href=\"menu1.php\">Voltar ao Menu Principal</a></h4>\n");
  25.    
  26.         $db = null;
  27.     }
  28.     catch (PDOException $e)
  29.     {
  30.         echo("<p>ERROR: {$e->getMessage()}</p>");
  31.     }
  32. ?>
  33.     </body>
  34. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement