insert xml data into database

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

 



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!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail 

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux