topical media & game development
portal-xml-getcontent.php
<?php
header ("content-type: text/xml");
mysql_connect("tornado","mwg400","48458749") or die ("Kan niet connecten.");
now = mktime();
now);
echo "<document>
<author>S. Bankras</author>
<date>"._GET['content_id']){
_GET['content_id']);
printXMLContent(_GET['category']){
_GET['category']." = 1 ORDER BY content_id DESC";
if(sql .= " LIMIT 0,".result = mysql_query(aantal = 0;
while (result)) {
row['content_id']);
aantal."</size>\n";
foreach(content_row){
printXMLContent(content_row){
echo "<item>\n";
foreach(key => key)){
value);
echo "<".value."</".content_id){
date = date("d-m-Y, H:i:s",result = mysql_query("SELECT * FROM content WHERE content_id = ".content_row = mysql_fetch_array (categoryString = result2 = mysql_query("SELECT * FROM content_matrix WHERE content_id = ".row2 = mysql_fetch_array (row2 as value){
if(key) && (categoryArray[] = keywordString = result2 = mysql_query("SELECT keyword_id FROM content_keywords WHERE content_id = ".row2 = mysql_fetch_array (result3 = mysql_query("SELECT keyword_name FROM keywords WHERE keyword_id = ".row3 = mysql_fetch_array (keywordArray[] = content_row['content_binary'] = strip(content_row['derived_keywordstring'] = implode(", ", content_row['derived_categorystring'] = implode(", ", content_row;
}
/*
else {
Tellertje en loop om de tabellen te tonen.
echo "<fieldset><legend><b>List of all tables in the database</b></legend>";
i < mysql_num_rows(t_name[tabellen, t_name[t_name[i++;
}
echo "</fieldset>";
mysql_free_result (_GET['table']){
?>
<hr />
Created for MMC2007
<div>
<img
src="http://www.w3.org/Icons/valid-xhtml10"
alt="Valid XHTML 1.0 Transitional" height="31" width="88" /></a>
</div>
</body>
</html>
<?php
}
*/
function strip(text = str_replace("–", "-",text = str_replace("â", "NULL",text = str_replace("Â", "NULL",text;
}
?>
(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.