save_channel.php

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

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

<?php

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

$save_result = array();

$name = str_replace("'", "\\'", $_POST['name']);
$cate = $_POST['category'];
$desc = $_POST['description'];
$tags = $_POST['tags'];
$logo = $_POST['logo'];
$logo1 = $_POST['logo1'];
$series = $_POST['series'];

if ($logo == "") $logo = "BooMeeHaa.jpg";

if (isset($_POST['id'])) {   //editing
	$sql = "update ref_channels set channel_identifier='".$name."' where chid=".$_POST['id'];
	connect();
	mysql_query($sql);
	$insert_id = $_POST['id'];
	mysql_query("delete from ref_channel_logos where chid=".$_POST['id']);
	mysql_query("delete from channels where fk_chid=".$_POST['id']);
}

else {    // adding
	$sql = "insert into ref_channels (chid, channel_identifier, fk_uid, channel_type) values(null, '$name', 29, 'PRIVATE')";
	connect();
	mysql_query($sql);
	$insert_id = mysql_insert_id();
}


$sql = "insert into ref_channel_logos (chid, path) values($insert_id, '$logo')";
mysql_query($sql);
	
$series_tok = strtok($series, ",");

while ($series_tok !== false) {
	mysql_query("insert into channels(cdid, fk_chid, fk_sid) values(null, $insert_id, $series_tok)");
	$series_tok = strtok(",");
}

close();

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