PHP validate_user_id示例

示例#1

文件： usermanagement.php 项目： qiemem/GovDialogue

function get_user_col($id, $col)
{
    validate_user_id($id);
    $con = db_connect();
    $result = mysql_query("SELECT {$col} FROM users WHERE id={$id})");
    if (mysql_num_rows($result) > 0) {
        $val = mysql_result($result, 0);
        db_close($con);
        return $row[$col];
    } else {
        db_close($con);
        return null;
    }
}

示例#2

文件： postmanagement.php 项目： qiemem/GovDialogue

function get_post_id($userid, $title, $content)
{
    validate_user_id($userid);
    $content = mysql_real_escape_string($content);
    $title = mysql_real_escape_string($title);
    $con = db_connect();
    $sql = "SELECT id FROM posts WHERE user={$userid} AND content='{$content}' AND title='{$title}' ORDER BY posttime DESC";
    $result = mysql_query($sql);
    if (mysql_num_rows($result) > 0) {
        $id = mysql_result($result, 0);
    } else {
        $id = null;
    }
    db_close($con);
    return $id;
}

示例#3

文件： commentmanagement.php 项目： qiemem/GovDialogue

function get_comment_id($userid, $postid, $parentid, $content)
{
    validate_user_id($userid);
    $content = mysql_real_escape_string($content);
    $con = db_connect();
    $sql = "SELECT id FROM comments WHERE user={$userid} AND content='{$content}' AND postparent={$postid}";
    if ($parentid === null) {
        $sql = $sql . " AND parent IS NULL";
    } else {
        $sql = $sql . " AND parent={$parentid}";
    }
    $sql = $sql . " ORDER BY posttime DESC";
    $result = mysql_query($sql);
    if (mysql_num_rows($result) > 0) {
        $id = mysql_result($result, 0);
    } else {
        $id = null;
    }
    db_close($con);
    return $id;
}