xzhan96.github.io/index_security.html at master · xzhan96/xzhan96.github.io · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
<html>
<body>
<pre id="output"></pre>
<script src="//cdn.jsdelivr.net/jquery/2.1.1/jquery.js"></script>
<script>
var $output = $('#output');
var db = openDatabase('fts_demo', 1, 'fts_demo', 5000000);
db.transaction(function (tx){
  function onReady() {
    var content = 'WebSQL has full-text search!';
    $output.append('\nText is: "' + content + '"');
    tx.executeSql('insert into doc values (?)', [content], function () {
      var terms = ['websql', 'text', 'search', 'searches', 'searching', 'indexeddb']
      terms.forEach(function (term) {
        tx.executeSql('select count(*) as count from doc where content match ?',
            [term], function (tx, res) {
          var count = res.rows.item(0).count;
          $output.append('\nTerm "' + term + '" matches: ' + !!count);
        });
      });
    });
  }
  tx.executeSql('create virtual table doc using fts3(content text, tokenize=porter);', [], onReady, onReady);
});
</script>
</body>
</html>