Full-text search

[zed420]

Hi All

I wonder if you could help me I'm trying to write a programm for Full-text search but I can not seem to get the query right. error says it can not connect to databse.  Here is my code

<?php
  include("DB.php");
   // If the form has been submitted with supplied keywords
   if (isset($_POST['keywords'])) {
      // Connect to server and select database

      $keywords = $_POST['keywords'];

      // Create the query
$query= "SELECT ItemName FROM itemtb WHERE MATCH(ItemName) against(`$keywords`)";
$result = mysql_query($query)
       or die ("Couldn't execute query for collecting your data.");

?>
<TABLE BORDER=0 WIDTH=90% CELLSPACING=3 CELLPADDING=3 ALIGN=CENTER bgcolor="#99CC99">
<TR ALIGN=CENTER bgcolor="#CCFF66">
<td><font color=red><b>Item name</font></TD>
</tr>
<?
	while ($row = mysql_fetch_array($result))  {
    extract($row);
	echo "<tr align=center>
	<td>" . $row['ItemName'] . "</td>
	</tr>";
 }
?></table><?
   }
?>
<p>
<form name="action" id="action" method="post" action="<?=$_SERVER['PHP_SELF']?>">
      Keywords:<br />
      <input type="text" name="keywords" size="20" maxlength="40" value="" /><br />
      <input type="submit" value="Search!">
   </form>
</p>

 

If I leave the last two bits off (MATCH() AGAINST()) it connect to databse. Any suggestions

 

Zed

[DyslexicDog]

The problem is most likely in your DB.php file please put that code up too.

[DarkWater]

Okay, two things. 

1) Show us DB.php.

2) Why do you have "box" characters in that script?  Which editor are you using?

[zed420]

here is the DB code

<?php
	$database = "sampledb";
	$user = "xxxxxxxx";
	$pass = "xxxxxx";
	$hostname = "localhost";
	$table = "itemtb";

$db = mysql_connect("$hostname", "$user","$pass");
mysql_select_db("$database");
?>

 

On same script if I use different query it works fine for example if I take off MATCH and AGAINST and just leave it to show all ItemName it works.

I'm using Dreamweaver.  thanks for looking at my post

Zed

[DyslexicDog]

Try this, please report errors.

 

<?php
  include("DB.php");
   // If the form has been submitted with supplied keywords
   if (isset($_POST['keywords'])) {
      // Connect to server and select database

      $keywords = $_POST['keywords'];
$keywords = mysql_real_escape_string($keywords);
      // Create the query
$query= "SELECT ItemName FROM itemtb WHERE MATCH(ItemName) against(`$keywords`)";
$result = mysql_query($query) or die (mysql_errno() .":". mysql_error());

?>
<TABLE BORDER=0 WIDTH=90% CELLSPACING=3 CELLPADDING=3 ALIGN=CENTER bgcolor="#99CC99">
<TR ALIGN=CENTER bgcolor="#CCFF66">
<td><font color=red><b>Item name</font></TD>
</tr>
<?
	while ($row = mysql_fetch_array($result))  {
    extract($row);
	echo "<tr align=center>
	<td>" . $row['ItemName'] . "</td>
	</tr>";
 }
?></table><?
   }
?>
<p>
<form name="action" id="action" method="post" action="<?=$_SERVER['PHP_SELF']?>">
      Keywords:<br />
      <input type="text" name="keywords" size="20" maxlength="40" value="" /><br />
      <input type="submit" value="Search!">
   </form>
</p>

[hitman6003]

Are you using a MyISAM table with a fulltext index on the column(s) you are trying to query against?

[zed420]

Thanks for replying hitman yes I'm using fulltext index on ItmName.

 

DyslexicDog I've tried your query it brought me this Error;

1054:Unknown column 'm' in 'where clause'

'm' is the word I put in for search. thanks

[conker87]

Use apostrophes not back quotes for strings.

 

$query= "SELECT ItemName FROM itemtb WHERE MATCH(ItemName) against('$keywords')";

 

Also, for the love of God, use full tags

<?php ?>

not

<? ?>

[zed420]

Thanks conker you got me very close I'm not getting any result as yet but there are NO errors any more. I think I'm getting closer...

[conker87]

There doesn't seem to be anything wrong with your code, I'm dumbfounded.

[zed420]

Thanks blue much appreciated.

 

Zed