Advertisement
Guest User

Untitled

a guest
Jan 28th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.42 KB | None | 0 0
  1. $connection = new \PDO("mysql:host=$host;dbname=$db;charset=$charset", $db_user, $db_pass, array(
  2.     \PDO::ATTR_ERRMODE            => \PDO::ERRMODE_EXCEPTION,
  3.     \PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC
  4. ));
  5. $statement = $connection->query("SELECT * articles ORDER BY id DESC LIMIT 10");
  6. while ($row = $statement->fetch()) {
  7.    echo mb_substr($row['content'], 0, 300, mb_detect_encoding($row['content']));
  8. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement