using php to insert xml into database
| From: | mishin coleman | Date: | Fri, 29 Oct 2004 02:59:20 +0000 |
| Subject: | using php to insert xml into database | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37078@lists.php.net to get a copy of this message | ||
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 - You care about security. So do we.