using php to insert xml data into database (text)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



sorry may have sent the html version last time

any ideas how to do this?
 
i can get the php to print out all the details of the
xml but not sure how to input that data into a
database. - maybe using some sort of array?
its an annoying postgresql database that i need to
insert it into but any ideas on how to insert into any
database would be helpful.
thanks  
 
 
// this function prints out a list of properties found
in the xml file
    function print_houses()
    {
        global $obj;
        echo '<table width="' . $this->TableWidth . '"
border="' . $this->TableBorder . '" cellpadding="' .
$this->TableCellpadding . '" cellspacing="' .
$this->TableCellspacing . '" class="' .
$this->TableClass . '">';
        while (list($key, $val) =
each($obj->xml->XMLDATA->PROPERTIES->PROPERTY)) {
            echo "<tr>\n";
            echo "<td class=" . $this->TableRow1Class
. ">\n";
            echo "<a href=\"./property.php?id=" .
$val->attr['PROPERTYID'] . "\" class=\"" .
$this->TableTxtProperties . "\">" . $val->SUBURB->data
. ", $" . $val->RENT->data . "</a>\n";
            echo "</td>";
            echo "</tr>\n";
        } // while
        echo '</table>';
       
reset($obj->xml->XMLDATA->PROPERTIES->PROPERTY);
    } 
    
 



		
__________________________________
Do you Yahoo!?
Y! Messenger - Communicate in real time. Download now. 
http://messenger.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux