Re: Re: PLS Advise, Highlighted Text from a Query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> what about the percentage how much accurate the result returned??

Let's see... Since you're on the list, I'll give you a discounted rate of
$80.00/hr.  I accept Credit Cards, Money Orders, PayPal, and cash.

Seriously, you can't expect us to do your work for you.  I know quite little
about string manipulation, yet I managed to put that script together for you in
a few minutes.  All it took was a glimpse at the manual...

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:39
Subject: Re:  Re: PLS Advise, Highlighted Text from a Query


Edward , what about the percentage how much accurate the result returned??


"Becoming Digital" <subs@becomingdigital.com> wrote in message
001b01c335a5$cff2aed0$f5fa5044@becomingadmin">news:001b01c335a5$cff2aed0$f5fa5044@becomingadmin...
> 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





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux