http://dev.mysql.com/doc/mysql/en/fulltext-search.html also.. i just use a LIKE in you sql statement On 8/11/05, Yui Hiroaki <yui@xxxxxxxxxxxxxxxxxxxx> wrote: > > I have a question about full text search using mysql and php. > There is text or html file data inside mysql, then I would like > to search text from these file. when I filed some text inside text box > in web site. > > mysql colum has below > > b_col_id, b_col, file_name > > > I have wrote the code; > > -------header.html--------------------------- > <img src="img/seek.gif"style="position:absolute;top:95px;left:600px" > alt="search"> > <form method="get"action="documentview.php"> > <input type="text" name="pattern" > style="position:absolute;top:100px;left:650px"> > <input type="submit" name="submit" > value="Search"style="position:absolute;top:100px;left:800px;border: 1px > solid;boder-color:#663366"> > </form> > > -------------------------------------------- > > > --part of documentview.php-------------------------------------- > class seek{ > function file_read($pattern){//retrieve_binary > if($pattern){ > $sql_select = "SELECT * FROM view WHERE b_col = '$pattern'"; > $result = mysql_query($sql_select) or DIE ("Could not perform > SELECT in retrieve function ".mysql_errno().": > ".mysql_error()); > echo "$result"; > if($result){ > while ($temp = mysql_fetch_assoc($result)) > { > $filename = $temp['file_name']; > $fileType = $temp['file_type']; > $fileContent = $temp['b_col']; > header("Content-type: $fileType"); > header("Content-Disposition: attachment; > filename=$filename"); > header("Content-Description: PHP Generated Data"); > echo $fileContent; > } > exit; > } else { > print "There is more then one record with that name or record > does not exist!"; > } > } > }//end function file_read > }// end of class seek > if ($pattern){ > //print("$pattern <br>"); > $obj1 = new seek(); > $obj1->file_read($pattern); > exit; > } > --------------------------------------------- > > if anyone knows how to search text inside mysql database when I input > text box from web, please teach me how! > > > Regards, > Yui > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Joe Harman --------- Do not go where the path may lead, go instead where there is no path and leave a trail. - Ralph Waldo Emerson
