MySQL

Tregimi i të dhënave me stile CSS

Everybody Wants to Rule the World

Tears For Fears (1985)

Africa

Toto (1983)

To Each His Own

Freddy Martin (1946)

Good Thing

Fine Young Cannibals (1989)

PHP
<div class="mbajtesi-me-demonstrim">
<?php
// lidhja me serverin:
$lidhja = new mysqli ("adresa-e-serverit", "perdoruesi", "fjalekalimi", "baza_e_te_dhenave");
mysqli_set_charset ($lidhja, "utf8");
if ($lidhja -> connect_error) {die ("Error: " . $lidhja->connect_error);}
// tregimi i të dhënave nga tabela:
$kerkesa = "SELECT * FROM kenget_top_5000 ORDER BY RAND() LIMIT 0, 6";
$rezultati = $lidhja -> query($kerkesa);
if ($rezultati -> num_rows > 0) {
while ($rreshti = $rezultati -> fetch_assoc()) {
echo "<h1>" . $rreshti["titulli"] . "</h1>";
echo "<h2>" . $rreshti["artisti"] . " (" . $rreshti["viti"] . ")" . "</h2>"; 
}
} 
else {
echo "Nuk mund të tregohet asnjë e dhënë.";
}
$lidhja -> close(); // mbylle lidhjen
?>
</div>
CSS
.mbajtesi-me-demonstrim {
  font-family: "Roboto Condensed", sans-serif;
  font-weight: 400;
  font-style: normal;
  padding: 2rem 1rem 1rem 1rem;
  line-height: 1em;
  color: rgba(0, 0, 0, 0.64); 
} 

.mbajtesi-me-demonstrim h1 {
  font-size: 1.2em;
  font-weight: 400;
  background-color: rgba(255, 255, 255, 1);
  margin: 0;
  padding: 4px 10px;
}

.mbajtesi-me-demonstrim h2 {
  font-size: 1em;
  font-weight: normal;
  background-color: rgba(129, 209, 180, 1);
  color: rgba(255, 255, 255, 1);
  margin: 0 0 20px 0;
  padding: 4px 10px;
  text-align: right;
}