Of course, I was quick to send w/out checking for errors, so here again is
corrected:
==================
<?
## 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"];
$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.";
}
?>
==================
"Nicole Amashta" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
