?> - </font> </td></tr> </table><br><br> <?php } pc_html_init("gb2312", "Blog文章搜索"); ?> <br><br> <p align="center" class="f2"> Blog日志搜索 </p> <?php $userid = addslashes($_GET["userid"]); @($keyword = myAddslashes(trim($_GET["keyword"]))); @($area = addslashes($_GET["area"])); @($pno = (int) $_GET["pno"]); if ($keyword) { $link = pc_db_connect(); $query_i = "SELECT COUNT(*) FROM nodes WHERE `access` = 0 "; $query = "SELECT `nid`,`tid`,`uid`,`subject`,`body`,`created`,`htmltag` FROM nodes WHERE `access` = 0 "; if ($area != "_all") { $query0 = "SELECT `uid` FROM users WHERE `username` = '" . $area . "' LIMIT 0 , 1 ;"; $result0 = mysql_query($query0, $link); if ($rows0 = mysql_fetch_array($result0)) { $query .= " AND `uid` = '" . $rows0[uid] . "' "; $query_i .= " AND `uid` = '" . $rows0[uid] . "' "; } mysql_free_result($result0); }
$keyname = "Blog描述"; break; default: $key = "username"; $keyname = "Blog所有者"; } $query = "SELECT `uid` , `username` , `corpusname` , `description` , `theme` , `createtime`,`modifytime`,`nodescount`,`visitcount` " . " FROM users WHERE "; if ($_GET["exact"] == 0) { $keyword = explode(" ", $keyword); $query .= " `uid` = 0 "; $keyword1 = ""; for ($i = 0; $i < count($keyword); $i++) { if ($keyword[$i] == " " || $keyword[$i] == "") { continue; } else { $query .= " OR `" . $key . "` LIKE '%" . myAddslashes($keyword[$i]) . "%' "; $keyword1 .= " " . $keyword[$i]; } } } else { $query .= " `" . $key . "` = '" . addslashes($keyword) . "' "; $keyword1 = $keyword; } $query .= " ORDER BY `username`;"; $link = pc_db_connect(); $result = mysql_query($query, $link); $num_rows = mysql_num_rows($result); if ($num_rows == 0) { mysql_free_result($result); pc_db_close($link); pc_html_init("gb2312", "Blog搜索");