Advertisement
Guest User

Untitled

a guest
May 9th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.74 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="UTF-8">
  5. <style>
  6. table, th, td {
  7.     border: 1px solid black;
  8.     border-collapse: collapse;
  9.     text-align:left;
  10. }
  11. </style>
  12. </head>
  13. <body>
  14. <table>
  15. <tbody>
  16. <?php
  17.     $user = 'std-43';
  18.     $password = 'dssp4141';
  19.     $link = sqlsrv_connect('172.20.180.239', array( "Database"=>"pubs", "UID"=>$user, "PWD"=>$password, "CharacterSet" => "UTF-8" ));
  20.     if ($link === false){
  21.         die( print_r( sqlsrv_errors(), true));
  22.     }
  23.     $stmt = sqlsrv_query($link, 'SELECT title, price FROM titles');
  24.     while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
  25.         echo '<tr><td>' . $row['title'] . '</td><td>' . $row['price'] . '</td></tr>';
  26.     }
  27. ?>
  28. </tbody>
  29. </table>
  30. </body>
  31. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement