php keywords select

標籤：else   form   演講   mon   btn   ima   empty   while   row   

視圖：

<form action="select_like.php" method="post">
<table class="search-tab">
<tr>
<th width="120">選擇分類:</th>
<td>
<select name="search-sort" id="">
<option value="">全部</option>
<option value="19">運動健身</option>
<option value="20">旅遊</option>
<option value="21">文學藝術</option>
<option value="22">演講</option>
<option value="23">經濟</option>
<option value="24">電影</option>
<option value="25">科技</option>
<option value="26">美食</option>
</select>
</td>
<th width="70">關鍵字:</th>
<td><input class="common-text" placeholder="關鍵字" name="keywords" value="" id="" type="text"></td>
<td><input class="btn btn-primary btn2" name="sub" value="查詢" type="submit"></td>
</tr>
</table>
</form>

控制器：

<?php
// var_dump($_POST);
$con = mysql_connect("localhost",‘root‘,‘12‘);
mysql_select_db(‘news‘,$con);
mysql_query(‘set names utf8‘);
$arrAll = array();
if (!empty($_POST[‘keywords‘])) {
$keywords = $_POST[‘keywords‘];
// echo "select * from newsup where `title` like ‘%{$keywords}%‘";
$result = mysql_query("select * from newsup where `title` like ‘%{$keywords}%‘") or die(‘select fail‘);
while ($row = mysql_fetch_assoc($result)) {
$arrAll[] = $row;
}
}else{

$result = mysql_query("select * from newsup") or die(‘select fail‘);
while ($row = mysql_fetch_assoc($result)) {
$arrAll[] = $row;
}
}
?>

php keywords select