Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbd = [
- 'host' => 'localhost',
- 'db' => 'test_dbs',
- 'user' => '****',
- 'pass' => '****',
- 'charset' => 'utf8mb4',
- 'attrs' => [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,
- PDO::MYSQL_ATTR_FOUND_ROWS => true,
- PDO::ATTR_EMULATE_PREPARES => true,
- ]
- ];
- $pdo = new PDO(
- "mysql:host={$dbd['host']};dbname={$dbd['db']};charset={$dbd['charset']}",
- $dbd['user'],
- $dbd['pass'],
- $dbd['attrs']
- );
- $search = ['"tiger mouse" @4'];
- $stmt = 'select sText FROM fts_test WHERE MATCH (sText) AGAINST (? IN BOOLEAN MODE)';
- $stmt = $pdo->prepare($stmt);
- $stmt->execute($search);
- $result = $stmt->fetchAll();
- print_r($result);
- /* ==== Schema SQL ====
- CREATE TABLE fts_test (
- sText text,
- FULLTEXT INDEX (sText)
- );
- INSERT INTO test(sText) VALUES
- ('tiger mouse'),
- ('tiger foo bar mouse'),
- ('tiger foo bar baz mouse');
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement