channel_list.php

来自「一个基于PHP网页的Flash播放器」· PHP 代码 · 共 35 行

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

<?php

// file_put_contents('cl_post_debug.txt', var_export($_POST, true));

$channel_list = array();

$sql = "select ref_channels.chid, ref_channels.channel_identifier, ref_channel_logos.path, ref_channels.channel_type
			from ref_channels, ref_channel_logos
				where ref_channels.chid=ref_channel_logos.chid
					order by ref_channels.channel_type desc, ref_channels.chid";

connect();

	$result = mysql_query($sql);
	if ($result) {
		while ($row = mysql_fetch_array($result)) {
			$channel = array('channel_id'=>$row['chid'], 'name'=>$row['channel_identifier'], 'thumb'=>$row['path'], 'access'=>$row['channel_type']);
			$channel_list[] = $channel;
		}
	}

close();

// output
$xml = assocToXML($channel_list);
// file_put_contents('cl_res_debug.txt', $xml);
echo $xml;
?>