Return to dbxml.php CVS log

Up to [Local Repository] / db / prgsrc

dbxml.php added

    1: <?php
    2: $hostname   = "localhost";
    3: $database   = "chgk";
    4: $username   = "piataev";
    5: $password   = "";
    6: 
    7: $link = mysql_connect($hostname.':'.$port, $username, $password) or die("Can't connect to database");
    8: mysql_select_db($database,$link) or die ("Can't select to database");
    9: mysql_query ("SET NAMES 'utf8'");
   10: $tour = $_GET['tour'];
   11: 
   12: 
   13: if (preg_match('/\./',$tour))
   14: {
   15: 	$temp = explode('.', $tour);
   16: 	$fname=$temp[0];$n=$temp[1];
   17: 
   18: 
   19: 	$sth = mysql_query(
   20: 		$sql="SELECT t2.Id FROM Tournaments as t1, 
   21:                         Tournaments as t2 
   22: 			WHERE (t1.FileName = '$fname.txt' OR t1.FileName='$fname')
   23:                         AND t1.Id=t2.ParentId AND t2.Number=$n") or die(mysql_error().": $sql");
   24: }	
   25: else 
   26: {
   27: 	$sth=mysql_query($sql="SELECT Id FROM Tournaments WHERE FileName = '$tour.txt' OR  FileName = '$tour'") or die (mysql_error().": $sql");
   28: }
   29: 
   30: $res = mysql_fetch_row ($sth);
   31: $id=$res[0];
   32: 
   33: $sth = mysql_query("SELECT * FROM Tournaments WHERE Id=$id") or die(mysql_error());
   34: $tournament = mysql_fetch_assoc($sth);
   35: $xw = new xmlWriter();
   36: $xw->openMemory();
   37: $xw->startDocument('1.0','utf8');
   38: $xw->startElement('tournament'); 
   39: foreach ($tournament as $key => $value)
   40: {
   41: 	$xw->writeElement ($key, $value);
   42: }
   43: 
   44: $sth = mysql_query("SELECT * FROM Questions WHERE ParentId =$id");
   45: 
   46: while ($question = mysql_fetch_assoc($sth) )
   47: {
   48: 	$xw->startElement('question');
   49: 	foreach ($question as $key => $value)
   50: 	{
   51: 		$xw->writeElement($key, $value);
   52: 	}
   53: 	$xw->endElement('question');
   54: }
   55: 
   56: $xw->endElement('tournament'); 
   57: 
   58: $xmlResult = $xw->outputMemory(true);   
   59: $xmlResult = preg_replace('/\>\s*\</', ">\n<", $xmlResult);	
   60: 
   61: header("Content-Type: text/xml");
   62: 
   63: print $xmlResult;
   64: 
   65: 
   66: ?>