Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You could split the string into "sentences" (split on a full stop (what about exclamation marks, question marks, ...)).</p> <p>Then find the sentence with the matching word.</p> <p>Then split that sentence into "words" and add some tags in two words before and after the matching word. Since you only have one sentence to work on, you'd include a check to make sure you didn't go out of bounds of the word array.</p> <p>Then join the words back together, and join all the sentences back together.</p> <hr> <p>Alternatively, you could use regex and <a href="http://www.php.net/manual/en/function.preg-replace.php"><code>preg_replace</code></a> (although that may not be a road you want to go down, especially if you have an option such as splitting on plaintext - there's a quote that goes something like "You have a problem and you want to use regex for it. Now you have two problems."):</p> <pre><code>$string = preg_replace("/\\b(\\w+ +){0,2}$query( +\\w+){0,2}\\b/i", '&lt;strong&gt;$0&lt;/strong&gt;', $string); </code></pre> <p>The regex works like this (backslashes are escaped above):</p> <pre><code>\b | match a word boundary (ie match whole words) (\w+ +) | match a "word" followed by spaces (to separate it from the next word) {0,2} | match 0 to 2 of these such words (it will match as many as possible | up to 2) $query | match the '$query' string ( +\w+) | regex for space (separating $query) followed by a word {0,2} | match 0 to 2 of these words (as many as possible up to 2) \b | match a word boundary (ie match whole words) </code></pre> <p>The <code>/i</code> at the end means "case insensitive".</p> <p>The replacement string, <code>&lt;strong&gt;$0&lt;/strong&gt;</code>, means to replace with all the matched words surrounded by the 'strong' tags.</p> <p>The reason this works is that <strong>the regular expression does not allow a full stop to be matched</strong>. So it will grab <em>up to</em> 2 words either side of <code>$query</code> but is forbidden from going over full stops.</p> <p>There are the usual caveats (that you would have with any method you used) -- do you want the bolding to go over question marks? exclamation marks? Is an apostrophe allowed in a word? What will you do about non-full-stop punctuation between words? etc.</p> <p>I'd recommend refining the above regex (if you want to use regex, that is) to:</p> <ul> <li>allow apostrophes in a word: change <code>\w+</code> to <code>[\w']+</code> (escape your for PHP backslashes too)</li> <li>allow various punctuation symbols <em>between</em> words: change the <code>+</code> to something like <code>[\s\-&amp;,]+</code> (means "space", "-", "&amp;", "," are allowed between words -- add more to your liking, but don't put "." in to prevent the bold-ing from going over full stops).</li> </ul>
    singulars
    1. This table or related slice is empty.
    1. POHow can I bold two words around a string within a string, but not overlap sentences?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USmathematical.coffee
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow can I bold two words around a string within a string, but not overlap sentences?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYour answer works perfectly without the added refinements in your last two bullets. But for the life of me I cannot make the added refinements work. Would you mind demonstrating how they would work in the pattern? Thanks. Here's my blank pattern that works (as above) : $pattern = "/\\b(\\w+ +){0,2}$needle( +\\w+){0,2}\\b/i"; I've tried all sorts of combinations of /\\b([\w']+ +){0,2} and /\\b([\w'][\s\-&,]+ +){0,2}. Thanks for your help.
      singulars
      1. PO
      1. USRyan
    2. COBasically you would change the ` +` in the regex to `[\s\-&]+` and all the `\w+` to `[\w']+` -- additionally, you need to escape your backslashes since you're using PHP! You can experiment with regex [here](http://regexr.com?303ma) (regexr is a very handy site). Good luck!
      singulars
      1. PO
      1. USmathematical.coffee
    3. COGotcha, thanks. Actually it was the double backslashes that were getting me in trouble. Singles worked fine. Working snippet: $pattern = "/\b(['\w]+[&,\-\s]+){0,2}$needle([&,\-\s]+['\w]+){0,2}\b/i"; echo preg_replace($pattern,'<strong>$0</strong>',$string);
      singulars
      1. PO
      1. USRyan
 

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