PHP myAddslashes Examples

Example #1

File: pcnsearch.php Project: bianle/www2

    ?>
-
</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);
    }

Example #2

File: pcsearch.php Project: bianle/www2

        $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搜索");