Simple PHP ? - Match words in a string

In article <1056842111.207624.RemoveThis@halkan.kabelfoon.nl>, John Bokma says...
 > Daniel Ruscoe wrote:
 >
  > > This is a simple one.
  > >
  > > I have a string a few hundred characters long being fed to a php script.
[..]
  > > The database I can do, but I'm having a problem getting the script to
  > > recognise words from the original string.
[..]
 > check out the explode function.

That's exactly what I'm stuck on

I'll write bit of inaccurate code to show what I'm thinking:

$tablename = animals_in_the_zoo;

$animal_search = "lion tiger zebra monkey football-hooligan"
$animals = explode(" ", $animal_search);

So we've broken up the original string, but still need to match it to the
database. This isn't done properly, but...

select * from $tablename where animal = $animals[0];

Then printing the result of that query will show up any matches to "lion"
in the table "animals_in_the_zoo". I think.

So how would I go about executing that query for every string, uping the
number in the [] by one each time?

Thanks for the help. With any luck, I'll get this cracked tonight

- Dan<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Simple PHP ? - Match words in a string 

With total disregard for any kind of safety measures Daniel Ruscoe
<null.DeleteThis@null.null> leapt forth and uttered:

 > That's exactly what I'm stuck on
 >
 > I'll write bit of inaccurate code to show what I'm thinking:
 >
 > $tablename = animals_in_the_zoo;
 >
 > $animal_search = "lion tiger zebra monkey football-hooligan"
 > $animals = explode(" ", $animal_search);
 >
 > So we've broken up the original string, but still need to match
 > it to the database. This isn't done properly, but...
 >
 > select * from $tablename where animal = $animals[0];
 >
 > Then printing the result of that query will show up any matches
 > to "lion" in the table "animals_in_the_zoo". I think.
 >
 > So how would I go about executing that query for every string,
 > uping the number in the [] by one each time?
 >
 > Thanks for the help. With any luck, I'll get this cracked
 > tonight
 >
 > - Dan

Hows about tring:

"SELECT FROM $tablename WHERE anaimal LIKE %$animals[0]%";

--
There is no signature.....<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Simple PHP ? - Match words in a string 

Daniel Ruscoe wrote:

 > In article <1056842111.207624.TakeThisOut@halkan.kabelfoon.nl>, John Bokma says...
 >
  >>Daniel Ruscoe wrote:
  >>
  >>
   >>>This is a simple one.
   >>>
   >>>I have a string a few hundred characters long being fed to a php script.
 >
 > [..]
 >
   >>>The database I can do, but I'm having a problem getting the script to
   >>>recognise words from the original string.
 >
 > [..]
 >
  >>check out the explode function.
 >
 >
 > That's exactly what I'm stuck on
 >
 > I'll write bit of inaccurate code to show what I'm thinking:
 >
 > $tablename = animals_in_the_zoo;
 >
 > $animal_search = "lion tiger zebra monkey football-hooligan"
 > $animals = explode(" ", $animal_search);
 >
 > So we've broken up the original string, but still need to match it to the
 > database. This isn't done properly, but...
 >
 > select * from $tablename where animal = $animals[0];
 >
 > Then printing the result of that query will show up any matches to "lion"
 > in the table "animals_in_the_zoo". I think.
 >
 > So how would I go about executing that query for every string, uping the
 > number in the [] by one each time?

for ($index = 0; $index < $animals; $index++) {

select... $animals[$index];

}

I no zero to nothing about PHP (but I know Perl . It is also possible
to build the query with: animal = $animals[0] OR animal = $animals[1]
.... (with join if PHP supports that) and do the query in one go. It is
faster and less load on the database (I think)

John

--
email: mail(at)johnbokma.com (or reply) home: <a style='text-decoration: underline;' href="http://johnbokma.com/" target="_blank">http://johnbokma.com/</a>
website design tips: <a style='text-decoration: underline;' href="http://johnbokma.com/websitedesign/" target="_blank">http://johnbokma.com/websitedesign/</a> (preliminary)<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Simple PHP ? - Match words in a string 

Daniel Ruscoe wrote:

 > In article <1056842111.207624.DeleteThis@halkan.kabelfoon.nl>, John Bokma says...
 >
  >>Daniel Ruscoe wrote:
  >>
  >>
   >>>This is a simple one.
   >>>
   >>>I have a string a few hundred characters long being fed to a php script.
 >
 > [..]
 >
   >>>The database I can do, but I'm having a problem getting the script to
   >>>recognise words from the original string.
 >
 > [..]
 >
  >>check out the explode function.
 >
 >
 > That's exactly what I'm stuck on
 >
 > I'll write bit of inaccurate code to show what I'm thinking:
 >
 > $tablename = animals_in_the_zoo;
 >
 > $animal_search = "lion tiger zebra monkey football-hooligan"
 > $animals = explode(" ", $animal_search);
 >
 > So we've broken up the original string, but still need to match it to the
 > database. This isn't done properly, but...
 >
 > select * from $tablename where animal = $animals[0];
 >
 > Then printing the result of that query will show up any matches to "lion"
 > in the table "animals_in_the_zoo". I think.
 >
 > So how would I go about executing that query for every string, uping the
 > number in the [] by one each time?
 >
 > Thanks for the help. With any luck, I'll get this cracked tonight

This, perhaps?

Using in_array():
<a style='text-decoration: underline;' href="http://au.php.net/manual/en/function.in-array.php" target="_blank">http://au.php.net/manual/en/function.in-array.php</a>

<?php
// To get words
$animal_search = "lion tiger zebra monkey football-hooligan"
$animals = explode(" ", $animal_search);

// Set up sql
$sql = "SELECT * FROM $tablename";

$result = mysql_query($sql,$cnx)
or die("Couldn't execute sql query.");

// Process sql against words
while ($row = @mysql_fetch_array($result)) {
  if (in_array($row,$animals)) {
  // Yes, it is in the database. Now do stuff!
  break 1;
  }
  else {
  // Continue on, ye lost traveller.
  }
}
?>

HTH<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Simple PHP ? - Match words in a string 

David Venn-Brown wrote:
 > Daniel Ruscoe wrote:
 >
  >> In article <1056842111.207624 RemoveThis @halkan.kabelfoon.nl>, John Bokma says...
  >>
   >>> Daniel Ruscoe wrote:
   >>>
   >>>
   >>>> This is a simple one.
   >>>>
   >>>> I have a string a few hundred characters long being fed to a php
   >>>> script.
  >>
  >>
  >> [..]
  >>
   >>>> The database I can do, but I'm having a problem getting the script
   >>>> to recognise words from the original string.
  >>
  >>
  >> [..]
  >>
   >>> check out the explode function.
  >>
  >>
  >>
  >> That's exactly what I'm stuck on
  >>
  >> I'll write bit of inaccurate code to show what I'm thinking:
  >>
  >> $tablename = animals_in_the_zoo;
  >>
  >> $animal_search = "lion tiger zebra monkey football-hooligan"
  >> $animals = explode(" ", $animal_search);
  >>
  >> So we've broken up the original string, but still need to match it to
  >> the database. This isn't done properly, but...
  >>
  >> select * from $tablename where animal = $animals[0];
  >>
  >> Then printing the result of that query will show up any matches to
  >> "lion" in the table "animals_in_the_zoo". I think.
  >>
  >> So how would I go about executing that query for every string, uping
  >> the number in the [] by one each time?
  >>
  >> Thanks for the help. With any luck, I'll get this cracked tonight
 >
 >
 > This, perhaps?
 >
 > Using in_array():
<font color=purple> > <a style='text-decoration: underline;' href="http://au.php.net/manual/en/function.in-array.php</font" target="_blank">http://au.php.net/manual/en/function.in-array.php</font</a>>
 >
 > <?php
 > // To get words
 > $animal_search = "lion tiger zebra monkey football-hooligan"
 > $animals = explode(" ", $animal_search);
 >
 > // Set up sql
 > $sql = "SELECT * FROM $tablename";

oops, you mean pulling *all* rows from the database??

 > $result = mysql_query($sql,$cnx)
 > or die("Couldn't execute sql query.");
 >
 > // Process sql against words
 > while ($row = @mysql_fetch_array($result)) {
 > if (in_array($row,$animals)) {

^^^^^^^^^^^^^^^^ and testing here?

Let the database do *as much as possible*. It is specialised in data
handling. Imagine pulling 100.000 records from the database and
*testing* them in PHP...

John

--
email: mail(at)johnbokma.com (or reply) home: <a style='text-decoration: underline;' href="http://johnbokma.com/" target="_blank">http://johnbokma.com/</a>
website design tips: <a style='text-decoration: underline;' href="http://johnbokma.com/websitedesign/" target="_blank">http://johnbokma.com/websitedesign/</a> (preliminary)<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Simple PHP ? - Match words in a string 

John Bokma wrote:

 > David Venn-Brown wrote:
 >
  >> Daniel Ruscoe wrote:
  >>
   >>> In article <1056842111.207624.TakeThisOut@halkan.kabelfoon.nl>, John Bokma says...
   >>>
   >>>> Daniel Ruscoe wrote:
   >>>>
   >>>>
   >>>>> This is a simple one.
   >>>>>
   >>>>> I have a string a few hundred characters long being fed to a php
   >>>>> script.
   >>>
   >>>
   >>>
   >>> [..]
   >>>
   >>>>> The database I can do, but I'm having a problem getting the script
   >>>>> to recognise words from the original string.
   >>>
   >>>
   >>>
   >>> [..]
   >>>
   >>>> check out the explode function.
   >>>
   >>>
   >>>
   >>>
   >>> That's exactly what I'm stuck on
   >>>
   >>> I'll write bit of inaccurate code to show what I'm thinking:
   >>>
   >>> $tablename = animals_in_the_zoo;
   >>>
   >>> $animal_search = "lion tiger zebra monkey football-hooligan"
   >>> $animals = explode(" ", $animal_search);
   >>>
   >>> So we've broken up the original string, but still need to match it to
   >>> the database. This isn't done properly, but...
   >>>
   >>> select * from $tablename where animal = $animals[0];
   >>>
   >>> Then printing the result of that query will show up any matches to
   >>> "lion" in the table "animals_in_the_zoo". I think.
   >>>
   >>> So how would I go about executing that query for every string, uping
   >>> the number in the [] by one each time?
   >>>
   >>> Thanks for the help. With any luck, I'll get this cracked tonight
  >>
  >>
  >>
  >> This, perhaps?
  >>
  >> Using in_array():
<font color=green>  >> <a style='text-decoration: underline;' href="http://au.php.net/manual/en/function.in-array.php</font" target="_blank">http://au.php.net/manual/en/function.in-array.php</font</a>>
  >>
  >> <?php
  >> // To get words
  >> $animal_search = "lion tiger zebra monkey football-hooligan"
  >> $animals = explode(" ", $animal_search);
  >>
  >> // Set up sql
  >> $sql = "SELECT * FROM $tablename";
 >
 >
 > oops, you mean pulling *all* rows from the database??
 >
  >> $result = mysql_query($sql,$cnx)
  >> or die("Couldn't execute sql query.");
  >>
  >> // Process sql against words
  >> while ($row = @mysql_fetch_array($result)) {
  >> if (in_array($row,$animals)) {
 >
 >
 > ^^^^^^^^^^^^^^^^ and testing here?
 >
 > Let the database do *as much as possible*. It is specialised in data
 > handling. Imagine pulling 100.000 records from the database and
 > *testing* them in PHP...

It's simply another option. For a small number of records, it would
probably be faster because there is only one call to the database.

Depending on what Dan wants to do, this could be useful. No need to
flame me for it...<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Simple PHP ? - Match words in a string 

"Daniel Ruscoe" <null RemoveThis @null.null> wrote in message
news:MPG.19683c9dad2eff75989687@news.btopenworld.com...

 > $animal_search = "lion tiger zebra monkey football-hooligan"

There's a mistake in your code Daniel.

"football-hooligan" should be "England-fan"

<gets coat>
--
Charles Sweeney
<a style='text-decoration: underline;' href="http://www.CharlesSweeney.com" target="_blank">www.CharlesSweeney.com</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Simple PHP ? - Match words in a string 

On Sun, 29 Jun 2003 15:42:10 +0100 "Charles Sweeney"
<me.DeleteThis@charlessweeney.com> broke off from drinking a cup of tea at to
write:

 >"Daniel Ruscoe" <null.DeleteThis@null.null> wrote in message
 >news:MPG.19683c9dad2eff75989687@news.btopenworld.com...
 >
  >> $animal_search = "lion tiger zebra monkey football-hooligan"
 >
 >There's a mistake in your code Daniel.
 >
 >"football-hooligan" should be "England-fan"
 >
 ><gets coat>

No need to get your coat. That was a fair comment.

Matt

--
A massive matrix of concise, interlinked encyclopaedia information.
For when you just want to know, quickly and easily.
<a style='text-decoration: underline;' href="http://www.probertencyclopaedia.com" target="_blank">http://www.probertencyclopaedia.com</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Simple PHP ? - Match words in a string 

"Matt Probert" <www DeleteThis @probertencyclopaedia.com> wrote in message
news:3eff18bb.94953156@news.ntlworld.com...
 > On Sun, 29 Jun 2003 15:42:10 +0100 "Charles Sweeney"
 > <me DeleteThis @charlessweeney.com> broke off from drinking a cup of tea at to
 > write:
 >
  > >"Daniel Ruscoe" <null DeleteThis @null.null> wrote in message
  > >news:MPG.19683c9dad2eff75989687@news.btopenworld.com...
  > >
   > >> $animal_search = "lion tiger zebra monkey football-hooligan"
  > >
  > >There's a mistake in your code Daniel.
  > >
  > >"football-hooligan" should be "England-fan"
  > >
  > ><gets coat>
 >
 > No need to get your coat. That was a fair comment.
 >
 > Matt
 >

#1 Google result for the word "Football" - <a style='text-decoration: underline;' href="http://nfl.com/" target="_blank">http://nfl.com/</a>

'nuff said!

<grabs keys>


--
Karl Core

Charles Sweeney says my sig is fine as it is.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Simple PHP ? - Match words in a string 

Matt Probert wrote:
 > On Sun, 29 Jun 2003 15:42:10 +0100 "Charles Sweeney"
 > <me.TakeThisOut@charlessweeney.com> broke off from drinking a cup of tea at to
 > write:
 >
  >> "Daniel Ruscoe" <null.TakeThisOut@null.null> wrote in message
  >> news:MPG.19683c9dad2eff75989687@news.btopenworld.com...
  >>
   >>> $animal_search = "lion tiger zebra monkey football-hooligan"
  >>
  >> There's a mistake in your code Daniel.
  >>
  >> "football-hooligan" should be "England-fan"
  >>
  >> <gets coat>
 >
 > No need to get your coat. That was a fair comment.
 >

No it wasn't. Funny - yes. In the way that picking out any stereotype is
funny. I strongly object to the association between fans of any
sport/event/person/place being confused with the perpetrators of mindless
violence and intimidation except within the context of humour.

"Not in my name" is an expression which has been given a good airing in
recent times. It is appropriate here. Thugs may be wearing my colours but
they do not represent me or my clan/group/party/society.

Furthermore, I am not responsible for them or their actions (in the same way
that you are not responsible for any spam that pretends to come from one of
your domains) nor do I give a hoot about the severity of their treatment
when apprehended and convicted in your juristriction.

But please, whether they are fans or not is irrelevant - remember Barry
George was a big fan of Jill Dando.
--
William Tasso - <a style='text-decoration: underline;' href="http://www.WilliamTasso.com" target="_blank">http://www.WilliamTasso.com</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Simple PHP ? - Match words in a string