PHP lease_for_video Examples

Example #1

File: functions.php Project: JikkuJose/drop

function video($id, $get_related_videos = false)
{
    global $db;
    $query = "SELECT * FROM videos WHERE id = {$id}";
    if ($result = $db->query($query)) {
        while ($row = $result->fetch_assoc()) {
            $video = array('id' => $row['id'], 'title' => $row['title'], 'video' => $row['video'], 'start' => $row['start'], 'description' => $row['description'], 'thumbnail' => $row['thumbnail'], 'premium' => $row['premium']);
        }
        $result->free();
    }
    if (!isset($video)) {
        return false;
    }
    if ($get_related_videos) {
        $video['relatedVideos'] = array();
        $query = "SELECT V2.*\n                  FROM videos V1, related_videos, videos V2\n                  WHERE V1.id = related_videos.video\n                  AND V2.id = related_videos.related_video\n                  AND V1.id = {$id}";
        if ($result = $db->query($query)) {
            while ($row = $result->fetch_assoc()) {
                $related_video = array('id' => $row['id'], 'title' => $row['title'], 'description' => $row['description'], 'thumbnail' => $row['thumbnail'], 'premium' => $row['premium']);
                $video['relatedVideos'][] = $related_video;
            }
            $result->free();
        }
    }
    if ($video['premium'] == 1) {
        unset($video['video']);
        if (($lease = lease_for_video($video['id'])) !== false) {
            $video['video'] = $lease;
        }
    }
    return $video;
    return false;
}

Example #2

File: test.php Project: JikkuJose/drop

<pre>
<?php 
require_once 'functions.php';
new_lease_for_video(2);
print_r(lease_for_video(2));