Advertisement
Guest User

Untitled

a guest
Apr 29th, 2016
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.60 KB | None | 0 0
  1. <ul>
  2.             <?
  3.             $user = "";
  4.             $pass = "!";
  5.             $table = "music";
  6.            
  7.             $pdo = new PDO("mysql:host=localhost;dbname=sphinx-music", $user, $pass );
  8.            
  9.             $stmt = $pdo->prepare("SELECT title, interpret FROM $table WHERE ROWMNUM <= 10 ORDER BY hits");
  10.             $stmt->execute();
  11.            
  12.             $result = $stmt->fetchAll();
  13.            
  14.             foreach ($result as $row)
  15.             {?>
  16.                 <li><?= htmlspecialchars($row["title"], ENT_QUOTES, "UTF-8") ?></li>
  17.             <?}
  18.             ?>
  19.         </ul>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement