Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $dsn = "mysql:host=127.0.0.1;port=9306;charset=utf8;";
- $options = [PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'];
- $pdo = new \PDO($dsn, '', '', $options);
- $query = $pdo->prepare("
- SELECT *
- FROM news_index WHERE MATCH (:search)
- LIMIT 1, 3
- OPTION ranker=matchany
- ");
- $query->bindValue(':search', 'Локомотив', PDO::PARAM_STR);
- $query->execute();
- var_dump($query->fetchAll(PDO::FETCH_ASSOC));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement