Return to dbxml.php CVS log

Up to [Local Repository] / db / prgsrc

Annotation of db/prgsrc/dbxml.php, revision 1.1

1.1     ! roma7       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: ?>