SQLite’s MATCHINFO() function<\/a> provides metrics that are useful for filtering or sorting results of a query according to relevance. The function returns a binary string representing a variable number of 32-bit unsigned integers in machine byte-order. It can be read into an array of integers using the PHP unpack() function<\/a> passing The code below re-creates the example and output from the FTS3\/FTS4 documentation. First of all, we construct the Next, we query the data in the table Printed output: 'L*'<\/code> as the format parameter.<\/p>\n\n\n\n\n\n\n\nsample.sqlite<\/code> database file and create the virtual FTS4 table t1<\/code> with the two columns a<\/code> and b<\/code>. Secondly, we populate the table with data from the example:<\/p>\n\n\n\n\n\/\/ create the SQLite database example.sqlite\ntry {\n $db = new PDO('sqlite:example.sqlite');\n} catch (PDOException $error) {\n echo $error->getMessage();\n}\n\n\/\/ populate the database with data\ntry {\n $db->exec(\"CREATE VIRTUAL TABLE t1 USING fts4(a, b);\n INSERT INTO t1 VALUES('transaction default models default', 'Non transaction reads');\n INSERT INTO t1 VALUES('the default transaction', 'these semantics present');\n INSERT INTO t1 VALUES('single request', 'default data');\");\n\n} catch (PDOException $error) {\n echo $error->getMessage().'
';\n}\n<\/code><\/pre>\n\n\n\nt1<\/code> using the matchinfo(t1, 'pcx')<\/code> function with the default parameters 'pcx'<\/code> for the second function argument (shown for clarity, can be omitted). Then we print the result of the query in a while loop using unpack('L*', $row['info1'])<\/code> to convert the binary blob into an array of integers $arrInt32<\/code>. Finally, we format the array of integers with our function formatOutput($arrInt32)<\/code> in groups of three using the modulo %<\/code>:<\/p>\n\n\n\n\n\/\/ query the database using the matchinfo() function\n$data = $db->query(\"SELECT MATCHINFO(t1, 'pcx') info1 FROM t1 WHERE t1 MATCH 'default transaction \\\"these semantics\\\"'\");\n\n\/\/ convert, format and print the output of the query\nwhile ($row = $data->fetch(PDO::FETCH_ASSOC)) {\n \/\/ matchinfo returns a blob of 32-bit unsigned integers in machine byte-order\n \/\/ note: returned array starts with index 1 and not 0\n $arrInt32 = unpack('L*', $row['info1']);\n echo formatOutput($arrInt32).\"
\";\n}\n\n\/**\n * Formats the array of integers with spaces.\n * Formats the output with spaces according to the example in the SQLite FTS documentation.\n * @param array $arrInt32\n *\/\nfunction formatOutput($arrInt32)\n{\n foreach ($arrInt32 as $i => $int) {\n if ($i % 3 === 0) {\n echo ' ';\n }\n echo $int;\n }\n}\n<\/code><\/pre>\n\n\n\n32 132 011 122 011 000 111<\/code><\/p>\n\n\n\n