Re: Searching MS Word Docs

>>while ($row = mysql_fetch_array($row)) Sorry, that should be: while ($row = mysql_fetch_array($result)) =[ "Todd Williamsen" <todd@williamsen.net> wrote in message news:20020208210540.52564.qmail@pb1.pair.com... > Nicole > > It doesn't like this line: > > while ($row = mysql_fetch_array($row)) > > Aren't you suppose to do the array before doing the $numrows? > > > "Nicole Amashta" <430ntr3k@bellsouth.net> wrote in message > news:20020208202629.26635.qmail@pb1.pair.com... > > 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" <430ntr3k@bellsouth.net> wrote in message > > news:20020208202309.21514.qmail@pb1.pair.com... > > > 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" <todd@williamsen.net> wrote in message > > > news:20020208200723.4947.qmail@pb1.pair.com... > > > > 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" <430ntr3k@bellsouth.net> wrote in message > > > > news:20020208195906.99187.qmail@pb1.pair.com... > > > > > 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" <todd@williamsen.net> wrote in message > > > > > > > > > > news:20020208195034.90279.qmail@pb1.pair.com... > > > > > > interesting... cool eh? > > > > > > > > > > > > i will give it a whirl... > > > > > > > > > > > > now I got to figure out the regex function > > > > > > > > > > > > > > > > > > "Nicole Amashta" <430ntr3k@bellsouth.net> wrote in > > > > > > message > > > > > > > > > > > > news:20020208194711.83171.qmail@pb1.pair.com... > > > > > > > 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" <todd@williamsen.net> wrote in > > > > > > > message > > > > > > > > > > > > > > news:20020208193739.67610.qmail@pb1.pair.com... > > > > > > > > Nicole, > > > > > > > > > > > > > > > > I have no idea if its ASCII formatted or not. I wonder if > there > > > is > > > > a > > > > > > way > > > > > > > to > > > > > > > > find out? > > > > > > > > > > > > > > > > > > > > > > > > "Nicole Amashta" <430ntr3k@bellsouth.net> > > > > > > > > wrote in message > > > > > > > > Kº > > > > > > > > ¥³£íÔ@½¨N=+{news:20020208193201.49760.qmail@pb1.pair.com... > > > > > > > > > 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" <todd@williamsen.net> > > > > > > > > > wrote in message > > > > > > > > > > > > > > > > > > news:20020208192757.41472.qmail@pb1.pair.com... > > > > > > > > > > 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! > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >