iapt-platform
/
mint
spogulis no https://github.com/iapt-platform/mint.git


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
							<html>
  <head>
    <title>Pali Full Text Search Example @ PostgreSQL</title>
    <style>
     * {
         font-family: "Noto Sans", "Noto Sans SC", "Noto Sans TC", "Padauk", "ATaiThamKHNewV3-Normal", Arial, Verdana;
     }
     td {
         border-right-style: solid;
         border-top-style: solid;
     }
     table {
         border-style: solid;
     }
     table span {
         background-color: yellow;
         font-size: 1.2em;
     }
     th {
         font-weight: bold;
     }
     input[name="q"] {
         width: 70%;
     }
    </style>
  </head>
  
  <body>
    <?php
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
      // collect value of input field
      $q = $_POST['q'];
    }
    ?>
    <form method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
      Text: <input type="text" name="q" value="<?php echo $q ?>">
      <input type="submit" value="Query">
    </form>
    <?php
    require_once '../path.php';

    if (empty($q)) {
      echo "Query is empty";
    } else {
      // Connecting, selecting database
      $dbconn = pg_connect("host="._DB_HOST_." dbname="._DB_NAME_." user="._DB_USERNAME_." password="._DB_PASSWORD_)
      or die('Could not connect: ' . pg_last_error());

      // Performing SQL query
      $query = "SELECT
                 ts_rank('{0.1, 0.2, 0.4, 1}',
                     full_text_search_weighted,
                     websearch_to_tsquery('pali', '$q')) +
                 ts_rank('{0.1, 0.2, 0.4, 1}',
                     full_text_search_weighted_unaccent,
                     websearch_to_tsquery('pali_unaccent', '$q'))
                 AS rank,
                 ts_headline('pali', content,
                              websearch_to_tsquery('pali', '$q'),
                              'StartSel = <span>, StopSel = </span>')
                 AS highlight,
                 *
                 FROM fts_texts
                 WHERE
                     full_text_search_weighted
                     @@ websearch_to_tsquery('pali', '$q') OR
                     full_text_search_weighted_unaccent
                     @@ websearch_to_tsquery('pali_unaccent', '$q')
                 ORDER BY rank DESC
                 LIMIT 20;";
      $result = pg_query($query) or die('Query failed: ' . pg_last_error());

      // Printing results in HTML
      echo "<table>\n";
      echo "<tr>
                 <th>rank</th>
                 <th>highlight</th>
                 <th>paragraph</th>
                 <th>book</th>
                 <th>wid</th>
                 <th>bold_single</th>
                 <th>bold_double</th>
                 <th>bold_multiple</th>
                 <th>content</th>
                 <th>TSVECTOR</th>
                 <th>TSVECTOR (unaccent)</th>
              </tr>";
      while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
        echo "\t<tr>\n";
        foreach ($line as $col_value) {
          echo "\t\t<td><div class='cell'>$col_value</div></td>\n";
        }
        echo "\t</tr>\n";
      }
      echo "</table>\n";

      // Free resultset
      pg_free_result($result);

      // Closing connection
      pg_close($dbconn);
    }
    ?>
  </body>
</html>