IF $ResumeUp is the actual path and filename to the file you want to search,
then that can work.
For each file retrieved from your table, you can search the file for the
keywords.
Pretend you have the table called resume ( I am also assuming you are using
mysql database )
create table resume(id int not null auto_increment primary key, filename
varchar(50), subdate datetime);
------------------------------------
<?
## do your code to connect to the db, etc....i'' leave this out since you
shoudl know what to do anyway. if not, let me know.
## now do the query
$query = "select filename from resume"; ## assuming resume is the name of
table that stores name of the files of resumes posted
$result = mysql_query($query);
if ( $result )
{
if ( $numrows = mysql_num_rows($result) > 0 )
{
while( $row = mysql_fetch_array($row)
{
$filename = $row["filename"]; ## this is the name of the field
returned from the query result.
## next, search through this file for the keywords
$fd = fopen($filename, "r");
$contents = fread($fd, filesize($filename));
fclose($fd);
$keyword = "$words"; /// $words = the search word(s) from the form
if(eregi($keyword, $contents))
echo "The word <b>$keywords</b> has been found in the resume " .
basename($filename) . "<br>";
}
}
else {
echo "There are no resumes posted yet.";
}
}
else {
echo "Error performing the query.";
}
?>
----------------------------------
Of course, you can modify this code to how you want your output to be. You
can also do a count to see how many resumes were found in the database that
have that word existing in the resume. And so on ....
Need anymore help? Just let me know ....
Nicole Amashta
www.aeontrek.com
========================
"Todd Williamsen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> ok... so for me I would do this... just wanted to confirm it.....
>
> $filename = "$ResumeUp"; /// the file name variable stored in the DB
> $fd = fopen($filename, "r");
> $contents = fread($fd, filesize($filename));
> fclose($fd);
> $keyword = "$words"; /// $words = the search word(s) from the form
>
> if(eregi($keyword, $contents))
> echo "The Word $keywords has been found";
>
>
> Now I am trying to figure out how to structure the query to where it
> searches all resumes that are posted...
>
> $sql = "SELECT * FROM $table WHERE ResumeUp = \"$ResumeUp\""; ///location
of
> file
>
> right?
>
>
> "Nicole Amashta" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Here is an example:
> >
> > ------------------------------------------
> >
> > $filename = "thefile.doc";
> > $fd = fopen ( $filename, "r" );
> > $contents = fread ( $fd, filesize($filename) ); ## contents of file
are
> > now in a string
> > fclose ($fd);
> >
> > ## now, since you have contents of file in string $contents, you can use
> > regex to search for keywords
> >
> > $keyword = "name";
> >
> > ## eregi is the non-case-sensitive way to search strings.
> > ## you can also use the perl regex: preg_match so that you can use
> perl-like
> > regexes ( /$pattern/i ), etc.
> >
> > if( eregi( $keyword, $contents ) )
> > echo "The word \"name\" has been found.<br>";
> > else
> > echo "The word \"name\" has not been found.<br>";
> >
> > ------------------------------------------
> >
> > Again, go to php.net and look up all the possible ways to search
strings.
> >
> > good luck,
> > Nicole Amashta
> > www.aeontrek.com
> >
> > "Todd Williamsen" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > interesting... cool eh?
> > >
> > > i will give it a whirl...
> > >
> > > now I got to figure out the regex function
> > >
> > >
> > > "Nicole Amashta" <[EMAIL PROTECTED]> wrote in message
> > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > I made a test file in word. It's funky, but it still has the actual
> text
> > > in
> > > > ascii. You should - just an assumption - be able to open the doc
with
> > php
> > > > and read through the file doing a keyword search.
> > > >
> > > > Can't hurt to experiment with it.
> > > >
> > > > good luck,
> > > > Nicole Amashta
> > > > www.aeontrek.com
> > > >
> > > >
> > > > "Todd Williamsen" <[EMAIL PROTECTED]> wrote in message
> > > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > > Nicole,
> > > > >
> > > > > I have no idea if its ASCII formatted or not. I wonder if there
is
> a
> > > way
> > > > to
> > > > > find out?
> > > > >
> > > > >
> > > > > "Nicole Amashta" <[EMAIL PROTECTED]> wrote in message
> > > > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > > > OK, I am not exactly sure of the format of word docs off hand.
But
> > if
> > > > they
> > > > > > are an ascii format, you can just read through the file using
PHP
> > and
> > > > use
> > > > > > regular expressions to search for the words. Just a suggestion.
> > > > > >
> > > > > > That's just if it's ascii format. Read the whole file into a
> string,
> > > > then
> > > > > > search the string with a regular expression function.
> > > > > >
> > > > > >
> > > > > > http://www.php.net/manual/en/ref.regex.php
> > > > > >
> > > > > > Here is some help on regex's if you don't know already.
> > > > > >
> > > > > > Nicole Amashta
> > > > > > Web App. Dev.
> > > > > > www.aeontrek.com
> > > > > >
> > > > > > "Todd Williamsen" <[EMAIL PROTECTED]> wrote in message
> > > > > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > > > > I have an application in which I would like to search MS Word
> docs
> > > > with
> > > > > > PHP
> > > > > > > and I am assuming with COM to perform this. The Documents
> reside
> > on
> > > a
> > > > > > Linux
> > > > > > > box(for now). Now I want to be able to search these documents
> > with
> > > > > > > keywords.
> > > > > > >
> > > > > > > Is this possible? Where do I look to do perform this? Will
COM
> > run
> > > > on
> > > > > > > Linux or will php, mySQL will have to reside on a Windows
> > > application?
> > > > > > >
> > > > > > > Thanks!
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
