使用单选按钮过滤搜索PHP PHP SQL

只需将单选按钮添加到窗体。

<form name="form1"  dir="rtl" method="post" action="searchresults.php"><label for="search"> search </label><input name="search" type="text" size="40" maxlength="50" placeholder="you can search"><input type="radio" name="search_type" value="job_name" checked="checked">Job<br><input type="radio" name="search_type" value="family">Family<br><input type="radio" name="search_type" value="name">Name<input type="submit" name="submit" value="search"/> <br/></form>

并在您的sql查询中使用post字段和值。mysql已贬值，因此您应该使用mysqli，并且必须对输入进行转义以防止注入攻击。

$field = mysql_real_escape_string($_POST['search_type']);$value = mysql_real_escape_string($_POST['search']);$sql = "SELECt tablesite.name,          tablesite.family,          job_list.job_name,   FROM  $db_table   INNER JOIN relation   on tablesite.id_user=relation.user_id   INNER JOIN job_list   on relation.job_id=job_list.job_id    WHERe    $field LIKE '%".$value."%'"; $dbresult=mysql_query($sql,$con);

您可能还想在运行查询之前验证搜索值，并在遍历每一行之前检查结果。