Databases
StackOverflow2013
Postsdbo
POIs there a good PHP library available to parse boolean search operators to MySQL fulltext operators?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIs there a good PHP library available to parse boolean search operators to MySQL fulltext operators?
    primarykey
    data
    text
    <p>We have been using MySQL Fulltext search for several years now, but the requirements have changed. We want to parse the AND/OR/NOT parameters to the form that MySQL does understand. I've written a unit test and it became clear that this is quite complicated.</p> <p>I'm sure more people run into this problem, so I suppose there must be some kind of library that is able to do this for me. I've tried Google, but unfortunately, I was not able to find such a library. Does anybody know a good one?</p> <p>The library should be able to handle quotes, parenthesis, AND/OR/NOT operators, and in our case it should default to AND instead of OR (if no operator is set). Here are some of my expected results:</p> <ul> <li>'ict' becomes '+ict'</li> <li>'ict it' becomes '+ict +it'</li> <li>'ict OR it' becomes 'ict it'</li> <li>'NOT ict' becomes '-ict'</li> <li>'it NOT ict' becomes '+it -ict'</li> <li>'web AND (ict OR it)' becomes '+web +(ict it)'</li> <li>'ict OR (it AND web)' becomes 'ict (+it +web)'</li> <li>'ict NOT (ict AND it AND web)' becomes '+ict -(+ict +it +web)'</li> <li>'php OR (NOT web NOT embedded ict OR it)' becomes 'php (-web -embedded ict it)'</li> <li>'(web OR embedded) (ict OR it)' becomes '+(web embedded) +(ict it)'</li> <li>develop AND (web OR (ict AND php))' becomes '+develop +(web (+ict +php))'</li> <li>'"ict' becomes '+"ict"'</li> <li>'"ict OR it"' <em>stays</em> '+"ict OR it"'</li> </ul> <p>This is the function we used in the last years (which does not work properly):</p> <pre><code>/** * Parses search string. * @param string $s The unparsed search string. * @return string $s The parsed search string. */ public function parseSearchString( $s ) { // Place a space at the beginning. $s = ' ' . $s; // AND - Remove multiple spaces, AND, &amp;. $s = preg_replace( '/\s\s+/', ' ', $s ); $s = preg_replace( '/\sAND\s/i', ' ', $s ); $s = preg_replace( '/\s&amp;\s/', ' ', $s ); // OR - Make replacements. Execute double, so we replace all occurences. $s = preg_replace( '/(\w+)\s(?:OR|\|)\s(\|?\w+)/i', '|\\1|\\2', $s ); $s = preg_replace( '/(\w+)\s(?:OR|\|)\s(\|?\w+)/i', '|\\1|\\2', $s ); $s = preg_replace( '/(\w+)\s*(?:\\\|\\/)\s*(\|?\w+)/i', '|\\1|\\2', $s ); $s = preg_replace( '/(\w+)\s*(?:\\\|\\/)\s*(\|?\w+)/i', '|\\1|\\2', $s ); // NOT $s = preg_replace( '/\bNOT\s(\w+)/i', '|-\\1', $s ); // Quoted strings. $s = preg_replace( '/\s"/', ' +"', $s ); // Place + in front of words. $s = preg_replace( '/\s(\w+)/', ' +\\1', $s ); // Replace | to spaces. $s = preg_replace( '/\|/', ' ', $s ); return trim( $s ); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USdbroeks
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POIs there a good PHP library available to parse boolean search operators to MySQL fulltext operators?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POIs there a good PHP library available to parse boolean search operators to MySQL fulltext operators?
      1. This table or related slice is empty.
      1. VTClose
    3. VO
      singulars
      1. POIs there a good PHP library available to parse boolean search operators to MySQL fulltext operators?
      1. This table or related slice is empty.
      1. VTClose
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload