Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <ul>
- <?
- $user = "";
- $pass = "!";
- $table = "music";
- $pdo = new PDO("mysql:host=localhost;dbname=sphinx-music", $user, $pass );
- $stmt = $pdo->prepare("SELECT title, interpret FROM $table WHERE ROWMNUM <= 10 ORDER BY hits");
- $stmt->execute();
- $result = $stmt->fetchAll();
- foreach ($result as $row)
- {?>
- <li><?= htmlspecialchars($row["title"], ENT_QUOTES, "UTF-8") ?></li>
- <?}
- ?>
- </ul>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement