用PHP构建搜索脚本

Question

I'm trying to build a search script in PHP-SQL something like Facebook or Stackoverflow uses. For example, the user may put in multiple entries; separated by a semi-colon and with Autocomplete on each term. Also: the values are to be stored in SQL; so what type of data should I use or how I should insert those terms in SQL table??

<script type="text/javascript">
 $().ready(function() {
 $("#job_type").autocomplete("get_job_list.php",
 { width: 224, matchContains: true, selectFirst: false }); });
 </script>

PHP code::

<?php 
require_once "connection.php";
$q = strtolower($_GET["q"]);
if (!$q) return;
$sql = "select DISTINCT itemid as itemid from eportal where itemid LIKE '%$q%'";
$rsd = mysql_query($sql);
while($rs = mysql_fetch_array($rsd)) {
    $cname = $rs['itemid']; echo "$cname
"; 
} 
?>

Answer 1

Add chosen tags separated into a table with structure query_id tag_id (you will also need a table tags with a structure tag_id tag_name. This way your query will be way easier and faster. Moreover, you will be able to get something like most popular tags easily. SQL is meant for storing data like that. Putting comma separated values is against the basics of SQL.