Код |
<form action="" method="post"><p>Поиск по сайту: </p> <input name="query" type="text" id="entry" value=""/> <input type="image" src="../images/search.png"/> </form> <?php include_once("config.php"); if (isset($_POST['search_x'])) { $query = isset($_POST['query'])?$_POST['query']:null; $result = mysql_query("SELECT * FROM `wares` WHERE MATCH (`wares`, `description`, `article`) AGAINST '".$query."'") or die ("Ошибка запроса: " . mysql_error()); while($row = mysql_fetch_assoc($result)) { echo htmlspecialchars($row["ware"]); echo htmlspecialchars($row["description"]); } } ?> |
PHP |
$query=mysql_query("SELECT * FROM `articles` WHERE `name` like '%$search_t%';"); |
Цитата (anonymouse @ 31.03.2009 - 00:19) |
А ты попробуй воспользоваться вот этим примером ) разницы не вижу... |
Цитата |
Can't find FULLTEXT index matching the column list |
SQL |
ALTER TABLE `имя_таблицы` ADD FULLTEXT ( `имя_столбца` ) |
Код |
CREATE TABLE `wares` ( `code` int(11) NOT NULL default '0', `price` text, `description` text NOT NULL, `pr_n` text NOT NULL, `pr_c` text NOT NULL, `article` text NOT NULL, `type` text NOT NULL, `ware` text NOT NULL, PRIMARY KEY (`code`), FULLTEXT KEY `description` (`description`,`article`,`ware`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; |
Код |
<?php include_once("config.php"); if (isset($_POST['search_x'])) { $query = isset($_POST['query'])?$_POST['query']:null; $result = mysql_query("SELECT * FROM `wares` WHERE MATCH (`ware`, `description`, `article`) AGAINST ('".$query."') ") or die ("Ошибка запроса: " . mysql_error()); while($row = mysql_fetch_assoc($result)) { echo htmlspecialchars($row["ware"]); echo htmlspecialchars($row["description"]); } } ?> <form action="?" method="post"><p>Поиск по сайту: </p> <input name="query" type="text" value=""/> <input type="image" name="search" src="../images/search.png"/> </form> |