Advertisement
Guest User

index.php

a guest
Dec 13th, 2019
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.88 KB | None | 0 0
  1.  
  2.  <h1><center>Spėjimų istorija</center></h1>
  3.  
  4.   <style>
  5.  
  6.     #atsakymai {
  7.        font-family: Arial; border-collapse: collapse; width: 70%;
  8.     }
  9.    
  10.     #atsakymai td {
  11.        border: 1px solid #ddd; padding: 8px;
  12.     }
  13.    
  14.     #atsakymai tr:nth-child(even){
  15.     background-color: #f2f2f2;
  16.    
  17.     #atsakymai tr:hover {
  18.     background-color: #ddd;
  19.     }
  20.    
  21.   </style>
  22.  
  23.  <table style = "margin: 0px auto;" id = "atsakymai">
  24.  <?php
  25.  
  26.     $myPDO = new PDO('sqlite:C:\Users\Vytenis\Desktop\Newfolder\spejimai.db');
  27.    
  28.     $result = $myPDO -> query("SELECT * FROM atsakymai");
  29.    
  30.     echo "<td><b>"."ID"."</b></td>
  31.          <td><b>"."Data"."</b></td>
  32.         <td><b>"."Spėjimo rezultatas"."</b></td>
  33.  
  34.        ";
  35.  
  36.    
  37.     foreach($result as $row)
  38.     {
  39.           echo "<tr>
  40.           <td>".$row['id']."</td>
  41.           <td>".$row['data']."</td>
  42.           <td>".$row['atsakymas']."</td>
  43.  
  44.        
  45.         </tr>";  }  
  46.    
  47.    
  48.          
  49.    
  50. ?>
  51. </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement