PHP select_scalar示例

示例#1

文件： index.php 项目： kjtanaka/mtt

function do_redir($id)
{
    $query = "SELECT permalink FROM permalinks WHERE permalink_id = '{$id}'";
    $url = select_scalar($query);
    header("Location: {$url}");
    exit;
}

示例#2

文件： index.php 项目： jjhursey/mtt-modern

function sql_resolve_date($date)
{
    return select_scalar("select DATE ( {$date} )");
}

示例#3

文件： index.php 项目： kjtanaka/mtt

function get_row_count()
{
    # Compose the SQL INSERT query
    $query = "SELECT COUNT(*) FROM failure;";
    $count = select_scalar($query);
    return $count;
}

示例#4

文件： index.php 项目： jjhursey/mtt-modern

function fetch_single_nextval($seq_name)
{
    return select_scalar("SELECT nextval('{$seq_name}') LIMIT 1;");
}