جستجو در مطالب سایت با استفاده از MySQL Full-Text

SELECT title FROM post
WHERE MATCH (title)
AGAINST ('$searchword' WITH QUERY EXPANSION);

$dbresult = mysqli_query($dblink, "SELECT * FROM `karbar` ORDER BY id DESC LIMIT 10");

$sql = "SELECT * FROM `karbar` WHERE `sname` LIKE '%".$key ."%';";

حذف شد

ft_min_word_len=3

if($radio=='code_book' && $f=="" && $t=="")
$sql ="SELECT b.titlebook,b.code_book,a.* FROM amanat as a,book as b   WHERE  b.titlebook LIKE '%$search%' AND state=0 AND b.code_book=a.code_book";
if($radio=='code_cust' && $f=='' && $t=='' )
$sql = "SELECT * FROM amanat WHERE state=0 AND code_cust LIKE '$search'  ";

if (isset($_GET['btn_search'])){
			    $search=$_GET['search'];
				$radio=$_GET['radio']; 
				$f=$_GET['from'];
                 $t=$_GET['to'];

$sql ="SELECT * FROM amanat WHERE state=0 and timeset BETWEEN LIKE'$f' AND LIKE'$t'";
if($radio=='code_book' && $f=="" && $t=="")
$sql ="SELECT b.titlebook,b.code_book,a.* FROM amanat as a,book as b   WHERE  b.titlebook LIKE '%$search%' AND state=0 AND b.code_book=a.code_book";
if($radio=='code_book')
$sql ="SELECT b.titlebook,b.code_book,a.* FROM amanat as a,book as b   WHERE  b.titlebook LIKE '%$search%' AND state=0 AND b.code_book=a.code_book and timeset BETWEEN '$f' AND '$t'";
if($radio=='code_cust' && $f=='' && $t=='' )
$sql = "SELECT * FROM amanat WHERE state=0 AND code_cust LIKE '$search'  ";

if($radio=='code_cust')
$sql ="SELECT * FROM amanat WHERE  code_cust LIKE '$search' AND state=0 AND timeset BETWEEN '$f' AND '$t'";

			$res= mysql_query($sql)or die(mysql_error());
			$num_rows=mysql_num_rows($res);
				
			if($num_rows){
             while($row=mysql_fetch_array($res)){
            ?>

if (isset($_GET['btn_search'])){
			    $search=$_GET['search'];
				$radio=$_GET['radio']; 
				$f=$_GET['from'];
                 $t=$_GET['to'];
if($f=='from' && $t=='to'){
$sql = mysql_query("SELECT * FROM amanat WHERE timeget BETWEEN '$f' AND '$t' AND  state=1 ",$con);
}elseif($radio=='code_book')
$sql = mysql_query("SELECT b.titlebook,b.code_book,a.* FROM amanat as a,book as b   WHERE  b.titlebook LIKE '%$search%' AND state=1 AND b.code_book=a.code_book ",$con);
elseif($radio=='code_cust')
$sql = mysql_query("SELECT * FROM amanat WHERE  code_cust LIKE '$search' AND state=1",$con);

 <input name="search" type="text" id="input1" size="20" maxlength="255" value="<?php echo $_GET['search']; ?>" />

<br /><b>Notice</b>:  Undefined index: search in <b>C:\xampp\htdocs\proje library\backbook.php</b> on line <b>27</b><br />

    if (isset($_GET['btn_search'])){
            $search=$_GET['search'];
			$re=mysql_query("SELECT * FROM amanat WHERE code_cust LIKE '$search' and state=1")or die(mysql_error());
اینم از فرم که متدش get هستش 
 <form id="form1" name="form1" method="get" action="">