Advertisement
eimkasp

PHP mySQL select

Jul 16th, 2018
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.06 KB | None | 0 0
  1. <style>
  2.     .naujiena {
  3.         font-size: 20px;
  4.         color: red;
  5.     }
  6. </style>
  7. <?php
  8.  
  9. // Prisijungiame prie duobazes
  10. $servername = "localhost";
  11. $username = "root";
  12. $password = "root";
  13.  
  14. try {
  15.     $conn = new PDO("mysql:host=$servername;dbname=naujienos", $username, $password);
  16.     // set the PDO error mode to exception
  17.     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  18.    // echo "Connected successfully";
  19.     }
  20. catch(PDOException $e)
  21.     {
  22.     echo "Connection failed: " . $e->getMessage();
  23.     }
  24.  
  25.  
  26.     // Surasome savo sql uzklausa
  27.     $sql = "SELECT * FROM naujienos";
  28.  
  29.     // Nusiunciame uzklausa i mysql serveri
  30.     $result = $conn->query($sql);
  31.  
  32.     // Paprasome gauti rezultatus is mysql serverio
  33.     $naujienos = $result->fetchAll();
  34.  
  35.     // pre($naujienos);
  36.  
  37.     // Spausiname visus gautus rezultatus is duombazes
  38.     for($i = 0; $i < count($naujienos); $i++) {
  39.         echo "<div class='naujiena'>";
  40.         echo $naujienos[$i]['antraste'];
  41.         echo "</div>";
  42.     }
  43.    
  44.  
  45. ?>
  46.  
  47.  
  48. <!--  Pasiziurejimui duomenu -->
  49. <pre>
  50.     <?php print_r($naujienos); ?>
  51. </pre>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement