Oops! I sent this to the wrong list last night. This is what happens when
we answer emails @ 4:18 AM...
> 4- I want when echo the return $row["address"] to highlight the entered
> keyword (that the user has entered in the search form) in the output with a
> different font backcolor or by just another color... to let the user see
> what he was searching for
<?
$length = strlen( $keyword );
$position = strpos( $row["address"], $keyword );
$row["address"] = substr_replace( $row["address"],
"<span class=\"yourclass\">$keyword</span>,
$position,
$length );
?>
You must specify 'yourclass' in a stylesheet, obviously. While this is not
nearly as eloquent as Cristian's suggested use of regular expressions, it seems
better suited to your level of experience. As they say, if you need to ask...
Edward Dudlik
Becoming Digital
www.becomingdigital.com
----- Original Message -----
From: "nabil" <nabil.attar@aws-syria.com>
To: <php-db@lists.php.net>
Sent: Wednesday, 18 June, 2003 10:11
Subject: Re: PLS Advise, Highlighted Text from a Query
Yes please that is what i want.. if it possible to give em the code..
thanks in advance for you and for George Pitcher
"Cristian Marin" <cristic@iakt.rdsnet.ro> wrote in message
20030618075554.73634.qmail@pb1.pair.com">news:20030618075554.73634.qmail@pb1.pair.com...
> Yes it is posible using the preg_replace substituing the text with </b>the
> text</b> or to what ever you want.
>
> If you are not advanced in php you could do it with substr_replace()
> function.
>
> The first solution is more dificult to be used but you have the advantage
> you can search for each word used in the %search_words% and highlight them
> even if they are not positioned in the same order in the text searched.
(But
> in this case you have to use the MySQL 'match against' with the full text
> indexing in place of like).
>
> The result is something like this: http://www.interakt.ro/search.php. Try
> searching 'mysql adodb'
>
> If this is what you want I can help you with a code block
>
>
>
> --
> -------------------------------------------------
> Cristian MARIN - Developer
> InterAKT Online (www.interakt.ro)
> Tel: +4021 312.53.12
> Tel/Fax: +4021 312.51.91
> cristic@interakt.ro
> "Nabil" <nabil.attar@aws-syria.com> wrote in message
> 20030618064522.21569.qmail@pb1.pair.com">news:20030618064522.21569.qmail@pb1.pair.com...
> > Dear all,
> >
> > 1- I have a form with an input text : keyword
> > 2- the field address is in my MySQL as TEXT field.
> > 3- I select * from db where address like '%keyword%'
> > 4- I want when echo the return $row["address"] to highlight the entered
> > keyword (that the user has entered in the search form) in the output
with
> a
> > different font backcolor or by just another color... to let the user see
> > what he was searching for
> > 5- and if it possible to echo how accurate (percentage) the return rows
> has
> > fit his search...
> >
> > Please Advise how to do it...
> >
> >
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
