episode_list.php

一个基于PHP网页的Flash播放器

<?php
// requirements
require('assoc_to_xml.php');
require('mysql_conn.php');
?>

<?php
// file_put_contents('el_post_debug.txt', var_export($_POST, true));

$episode_list = array();

// When the user ask to list episodes by series,
// flash will send 'series_id' through POST

if(isset($_POST['series_id']))
{

	$sql = "select series_content.wid,
			series_content.fk_sid,
			series_content.title,
			series_content.duration,
			series_content.description,
			series_content.tags,
			series_content.episode_number,
			ref_series_rating.rating,
			ref_series_rating.description as rating_desc,
			ref_series_rating.image_url as rating_img
			from series_content, ref_series_rating
				where series_content.fk_rid=ref_series_rating.rid and fk_ctid=1 and fk_sid=".$_POST['series_id'].
					" order by episode_number";

	connect();
	
		$result = mysql_query($sql);
		if ($result) {
			while ($row = mysql_fetch_array($result)) {
				$episode = array('wid'=>$row['wid'], 'video_id'=>$row['wid'], 'teaser_id'=>'', 'name'=>$row['title'], 'playing_time'=>formatSeconds($row['duration']), 'description'=>$row['description'], 'tags'=>$row['tags'], 'rating'=>$row['rating'], 'rating_desc'=>$row['rating_desc'], 'rating_img'=>$row['rating_img'], 'thumb'=>'', 'watched'=>0);
				
				// get thumb
				
				$result_thumb = mysql_query("select screenshot_image from content_crop where fk_wid=".$row["wid"]);
				if ($result_thumb) {
					if ($thumb = mysql_fetch_array($result_thumb))
						$episode['thumb'] = "thumbnails/".$thumb["screenshot_image"];
				}
				
				// get teaser
				
				$sql1 = "select wid from series_content where fk_ctid=2 and sk_wid=".$row['wid'];
				$result_teaser = mysql_query($sql1);
				if ($result_teaser) {
					if ($teaser = mysql_fetch_array($result_teaser))
						$episode['teaser_id'] = $teaser["wid"];
				}
				
				// get watched
				
				$sql1 = "select count(channels_viewed_content.cvcid) as watched
							from channels_viewed_content, series_content
								where channels_viewed_content.fk_wid = ".$row['wid']." and channels_viewed_content.views>0";
				$result_watched = mysql_query($sql1);
				if ($result_watched) {
					if ($watched_row = mysql_fetch_array($result_watched))
						$watched = $watched_row['watched'];
					else
						$watched = 0;
				}
				else $watched = 0;
				
				$episode['watched'] = $watched;
				
				$episode_list[] = $episode;
			}
		}
	
	close();
}
	
// output
$xml = assocToXML($episode_list);
// file_put_contents('el_res_debug.txt', $xml);
echo $xml;

function formatSeconds($seconds) {
	$minutes = floor($seconds/60);
	$seconds = $seconds%60;
	$result = ($minutes<10?'0':'').$minutes.":".($seconds<10?'0':'').$seconds;
	return $result;
}
?>