Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <style>
- .naujiena {
- font-size: 20px;
- color: red;
- }
- </style>
- <?php
- // Prisijungiame prie duobazes
- $servername = "localhost";
- $username = "root";
- $password = "root";
- try {
- $conn = new PDO("mysql:host=$servername;dbname=naujienos", $username, $password);
- // set the PDO error mode to exception
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- // echo "Connected successfully";
- }
- catch(PDOException $e)
- {
- echo "Connection failed: " . $e->getMessage();
- }
- // Surasome savo sql uzklausa
- $sql = "SELECT * FROM naujienos";
- // Nusiunciame uzklausa i mysql serveri
- $result = $conn->query($sql);
- // Paprasome gauti rezultatus is mysql serverio
- $naujienos = $result->fetchAll();
- // pre($naujienos);
- // Spausiname visus gautus rezultatus is duombazes
- for($i = 0; $i < count($naujienos); $i++) {
- echo "<div class='naujiena'>";
- echo $naujienos[$i]['antraste'];
- echo "</div>";
- }
- ?>
- <!-- Pasiziurejimui duomenu -->
- <pre>
- <?php print_r($naujienos); ?>
- </pre>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement