PHP Database::value Examples

Example #1

File: simple_proxy.php Project: kenyattaclark/shiftspace

// for single shifts on the proxy
$cshift;
$spaceName;
$userName;
$shifthref;
// Load each requested shift
foreach ($shift_ids as $an_id) {
    // grab the shift
    $shift = $db->row("\n      SELECT *\n      FROM shift\n      WHERE url_slug = '{$an_id}'\n    ");
    $cshift = $shift;
    $spaceName = $shift->space;
    $shifthref = $shift->href;
    $date = ucfirst(elapsed_time($shift->created));
    // grab the user name
    $user_id = $shift->user_id;
    $userName = $db->value("\n      SELECT username\n      FROM user\n      where id={$user_id}\n    ");
    $legacy = true;
    if ($spaceName == 'notes') {
        $spaceName = 'Notes';
    } else {
        if ($spaceName == 'highlight') {
            $spaceName = 'Highlights';
        } else {
            if ($spaceName == 'imageswap') {
                $spaceName = 'ImageSwap';
            } else {
                if ($spaceName == 'sourceshift') {
                    $spaceName = 'SourceShift';
                } else {
                    $legacy = false;
                }