php search - help needed - PHPBuilder Forums

php search - help needed

drmanny

Hi,
Firstly i am not a programmer and any help is appreciated.
A friend of mine set this search for me, searching titles only in a mysql table for 2275 religious hymns ,works fine,But the problem is the titles contain these tags like this:

aa-ay anik janam bharam sarnee.
amrit banee har har tayree.

thus any one searching for word 'amrit' finds no results

Can the code below be modified to ignore the tags while doing the search, tags like . And also the code be modified to show only 25 results per page and then show link for next page

This is the CODE:
<form name="frm" action="search.php">

Search for a title </div>

</form>

</td>

</tr>

<tr>

<td>Search results for <?php echo $srchString;?>... </td>

</tr>

<?php

$srchString=$srchString;

$allrecs=array();

getResults();

//display results onm the page

displayResults();

if(!$found){

echo "<TR><TD>No results found.</TD></TR>";

}

//function to retr. results

function getResults(){

global $found;

global $allrecs;

global $srchString;

$query="SELECT * FROM english_index WHERE eng_line LIKE '%".$srchString."%'";

$result=mysql_query($query);

if($myrow=mysql_fetch_array($result)){

$found=true;//record found.

do{

$rec["eng_id"]=$myrow["eng_id"];

$rec["eng_line"]=$myrow["eng_line"];

$rec["eng_link"]=$myrow["eng_link"];

array_push($allrecs,$rec);

}while($myrow=mysql_fetch_array($result));

}//no result found...

return $found;

}

//function that displays results

function displayResults(){

global $allrecs;

global $srchString;

disp($allrecs);

}

//function to siplay the array

function disp($arr){

global $allrecs;

foreach($allrecs as $rec){

//$rec=$allrecs[$v];

echo "<tr><td bgcolor='#eeeeee'><a href='englishindex.php?file=".$rec["eng_link"]."'>",$rec["eng_line"],"</a></td></tr>";

}

Thanks a lot
regards,
Manny

drmanny

"bump" please help

zmola

aa-ay anik janam bharam sarnee.
amrit banee har har tayree.

if you want the query results to contain the tags, then perhaps the way to go with this is to add another table column, eng_line2, that contains the above without the tags. then do

$query="SELECT * FROM english_index WHERE eng_line2 LIKE '%".$srchString."%'"; // blah blah

here is toot on results per page: http://www.phpbuilder.com/columns/rod20001214.php3
and perhaps this will be helpful too:http://www.mysql.com/doc/en/SELECT.html

cahva

You probaply dont want to input those titles again so I thought to do you a favor(and I got nothing better to do 🙂 ).

First, do as zmola told you to do. Add a new column to your table called 'eng_line2'.

Next, run the below script once to copy the titles from eng_line to eng_line2 without html-tags.

$query="SELECT eng_line FROM english_index";
$result=mysql_query($query); 
while ($row=mysql_fetch_array($result))
{
$id=$row["eng_id"];
$stripped=strip_tags($row["eng_line"]);
mysql_query("UPDATE english_index SET eng_line2='$stripped' WHERE eng_id='$id'");
}