MySQL

Tregimi i të dhënave me stile CSS

Mr Vain

Culture Beat (1993)

Wooden Heart

Elvis Presley (1961)

As Long As You Love Me

The Backstreet Boys (1997)

You Won't See Me Cry

Wilson Phillips (1992)

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;
}