topical media & game development
portal-cms-edit_video_web.php
<?php
if (isset(contentid = title = addslashes(contentdate = addslashes(sourcename = addslashes(sourceurl = addslashes(binary = addslashes(state = addslashes(description = addslashes(videoformat = addslashes(videoresolution = addslashes(videocode = addslashes(videolength = addslashes(videosize = addslashes(update = health = politics = wildlife = energy = business = climate = pollution = technology = lifestyle = environment = region = keywords = update){
echo "ID IS: query = "UPDATE content, content_type_video set content.content_title = 'contentdate', content.content_binary = 'sourcename', content.content_sourceurl = 'state', content.content_description = 'videoformat',
content_type_video.video_resolution = 'videolength',
content_type_video.video_size='contentid AND content_type_video.content_id=query2= "UPDATE content_matrix set content_matrix.health='politics', content_matrix.wildlife='energy', content_matrix.business='climate', content_matrix.pollution='technology',
content_matrix.lifestyle='environment',
content_matrix.region='contentid'";
keywords));
contentid'";
query3);
if(!keywords as word = trim(query3 = "INSERT ignore into keywords (keyword_id, keyword_name) values ('', 'result3 = mysql_query(result) {
die('Invalid query: ' . mysql_error());
}
word'";
query3);
if(!row = mysql_fetch_array(keywordid = query3 = "INSERT into content_keywords (content_keyword_id, content_id, keyword_id) values ('', 'keywordid')";
query3);
if(!result = mysql_query(result2 = mysql_query(result) {
die('Invalid query: ' . mysql_error());
}
}
contentid'
AND content_type_video.content_id ='result = mysql_query(result) {
die('1: Invalid query: ' . mysql_error());
}
contentid'";
query2);
if(!query3 = "SELECT * FROM `keywords`, `content_keywords` where content_keywords.content_id='result3 = mysql_query(result3) {
die('3: Invalid query: ' . mysql_error());
}
result);
result2);
row['content_binary'];
?>
<form method="post" enctype="multipart/form-data" action="">
<table>
<tr>
<td width="150">
Title:
</td>
<td>
<input type="text" name="title" size="30" value="<?php echo row['content_date']; ?>"/>
</td>
</tr>
<tr>
<td width="150">
Video Code:
</td>
<td>
<textarea rows="10" cols="20" name="videocode"><?php echo row['content_source_name']; ?>"/>
</td>
</tr>
<tr>
<td>
Source url:
</td>
<td>
<input type="text" name="sourceurl" size="30" value="<?php echo row['content_state']; ?>"/>
<tr>
<td width="150">
Content Description:
</td>
<td>
<input type="text" name="contentdescription" size="30" value="<?php echo health=health == "1"){echo " CHECKED";}?>>
<br />
Politics:
<input type="checkbox" name="politics" value="1" <?php row2['politics']; if(wildlife=wildlife == "1"){echo " CHECKED";}?>>
<br/>
Energy
<input type="checkbox" name="energy" value="1" <?php row2['energy']; if(business=business == "1"){echo " CHECKED";}?>>
<br />
Climate
<input type="checkbox" name="climate" value="1" <?php row2['climate']; if(pollution=pollution == "1"){echo " CHECKED";}?>>
<br />
Technology
<input type="checkbox" name="technology" value="1" <?php row2['technology']; if(lifestyle=lifestyle == "1"){echo " CHECKED";}?>>
<br />
Environment
<input type="checkbox" name="environment" value="1" <?php row2['environment']; if(row['video_format']; ?>"/>
</td>
</tr>
<tr>
<td width="150">
Region:
</td>
<td>
<input type="text" name="region" size="30" value="<?php echo row3 = mysql_fetch_array(row3['keyword_name']; echo " "; } ?> "/>
</td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Update" name="update" />
</td>
</tr>
</table>
<input type="hidden" name="contenttype" value="3">
<input type="hidden" name="contentid" value="<?php echo
(C) A. Eliëns
2/9/2007
You may not copy or print any of this material without explicit permission of the author or the publisher.
In case of other copyright issues, contact the author.