Search Results substring

[Nel]

Hi all,

I have been searching for some clues as to how to show a substring from a
database search.

$pagetitle = "Page Title";
$pagetext = "This is <b>a typical</b> string that would be stored<br>in the
database.";
Search for "that"

results would look like

1. Page Title
...string that would...
2. Another page
...computers that can...
3. Further Page
...languages that are...

At the moment the search results just show the page title. The idea is that
in the set of results I can show the user the context of each result, a bit
like a search engine does. Ideall I would like up to 10 words either side
of the search keyword.

BTW php+ mysql

Nel.

[Erwin Moller]

Nel wrote:

Hi all,

I have been searching for some clues as to how to show a substring from a
database search.

$pagetitle = "Page Title";
$pagetext = "This is <b>a typical</b> string that would be stored<br>in
the database.";
Search for "that"

results would look like

1. Page Title
...string that would...
2. Another page
...computers that can...
3. Further Page
...languages that are...

At the moment the search results just show the page title. The idea is
that in the set of results I can show the user the context of each result,
a bit
like a search engine does. Ideall I would like up to 10 words either side
of the search keyword.

BTW php+ mysql

Nel.

Hi Nel,

use LIKE

SELECT pagetext FROM tblpagetext WHERE (pagetext LIKE '%that%');

Because we don't know how your database is designed it is impossible to say
how the pagetitle should be retrieved.
I expect you reference a foreign key in tblpagetext on the PK in
tblpagetitle??

Anyway, if you have the pagetext in it is easy to get some words around it.
use explode on space and find the location of the first 'that' and get 5
before and 5 after (if possible).
go to www.php.net and browse a little for explode and count and the like.
I am quite sure somebody handy with regexpressions codes this in 1 line. :-)

Good luck!

Regards,
Erwin Moller

[Nel]

"Erwin Moller"
<si******************************************@spam yourself.com> wrote in
message news:41***********************@news.xs4all.nl...

Nel wrote:

Hi all,

I have been searching for some clues as to how to show a substring from a database search.

$pagetitle = "Page Title";
$pagetext = "This is <b>a typical</b> string that would be stored<br>in
the database.";
Search for "that"

results would look like

1. Page Title
...string that would...
2. Another page
...computers that can...
3. Further Page
...languages that are...

At the moment the search results just show the page title. The idea is
that in the set of results I can show the user the context of each result, a bit
like a search engine does. Ideall I would like up to 10 words either side of the search keyword.

BTW php+ mysql

Nel.

Hi Nel,

use LIKE

SELECT pagetext FROM tblpagetext WHERE (pagetext LIKE '%that%');

Because we don't know how your database is designed it is impossible to

say how the pagetitle should be retrieved.
I expect you reference a foreign key in tblpagetext on the PK in
tblpagetitle??

Anyway, if you have the pagetext in it is easy to get some words around it. use explode on space and find the location of the first 'that' and get 5
before and 5 after (if possible).
go to www.php.net and browse a little for explode and count and the like.
I am quite sure somebody handy with regexpressions codes this in 1 line. :-)
Good luck!

Regards,
Erwin Moller

Thanks Erwin. I have no problem with the SQL side, just not expereinced in
arrays too much.

If I explode(" ",$pagetext) this will only give me full words. the search
string could be part of a word.

Is there a regex that could just take (up to 40 chars)(searchterm)(up to 40
chars)?

Thanks.

Nel.

[Nel]

"Nel" <ne***@ne14.co.NOSPAMuk> wrote in message
news:41***********************@ptn-nntp-reader01.plus.net...

"Erwin Moller"
<si******************************************@spam yourself.com> wrote in
message news:41***********************@news.xs4all.nl...

Nel wrote:

Hi all,

I have been searching for some clues as to how to show a substring from

a

database search.

$pagetitle = "Page Title";
$pagetext = "This is <b>a typical</b> string that would be

stored<br>in the database.";
Search for "that"

results would look like

1. Page Title
...string that would...
2. Another page
...computers that can...
3. Further Page
...languages that are...

At the moment the search results just show the page title. The idea is that in the set of results I can show the user the context of each result, a bit
like a search engine does. Ideall I would like up to 10 words either side of the search keyword.

BTW php+ mysql

Nel.

Hi Nel,

use LIKE

SELECT pagetext FROM tblpagetext WHERE (pagetext LIKE '%that%');

Because we don't know how your database is designed it is impossible to

say

how the pagetitle should be retrieved.
I expect you reference a foreign key in tblpagetext on the PK in
tblpagetitle??

Anyway, if you have the pagetext in it is easy to get some words around

it.

use explode on space and find the location of the first 'that' and get 5
before and 5 after (if possible).
go to www.php.net and browse a little for explode and count and the

like. I am quite sure somebody handy with regexpressions codes this in 1 line.

:-)

Good luck!

Regards,
Erwin Moller

Thanks Erwin. I have no problem with the SQL side, just not expereinced

in arrays too much.

If I explode(" ",$pagetext) this will only give me full words. the search
string could be part of a word.

Is there a regex that could just take (up to 40 chars)(searchterm)(up to 40 chars)?

Thanks.

Nel.

I have been messing with
..{0,30}[:alnum: ]($search)[:alnum: ].{0,40}

but this only gives words surrounded by spaces, not part of word or word
followed by , or .

HELP!!!!!!!

Nel.