Advertisement
Guest User

Untitled

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