|
|
Hey there,
This PHP script converts a MySQL table(query) to an XML output.
I use it with Macromedia Flash MX with the XML connection.
Weeronline B.V.
Coding by Digital Human
| <?php
// Connection to MySQL
include("db_inc.php");
#------------------------Get weather by datum
function getWeatherByDate($date){
if(!empty($date)){
$result = mysql_query("SELECT
tblWeerOnline.datum,
tblSteden.Plaats,
tblWeerOnline.Tx,
tblWeerOnline.Tn,
tblWeerOnline.Zonduur,
tblWeerOnline.Pa,
FFstootm
FROM
tblWeerOnline INNER JOIN tblSteden ON tblWeerOnline.Station=tblSteden.WMO
WHERE
tblSteden.Land='NL' AND
tblWeerOnline.datum='".$date."'
ORDER BY tblSteden.Plaats");
}
$data = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>\n";
$data .= "<verwachting>";
while($record = mysql_fetch_object($result)){
$data .= "<dag>";
for ($i = 0; $i < mysql_num_fields($result); $i++) {
$veld = mysql_field_name($result, $i);
$data .= "<".$veld.">";
if(!empty($record->$veld)){
$data .= $record->$veld;
}
$data .= "</".$veld.">";
}
$data .= "</dag>";
}
$data .= "</verwachting>";
if(!headers_sent()){
header("Content-Type: application/xml");
}
echo $data;
}
?> | |
|
|
| bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.
Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | DBXML- A Class to backup databases in XML Format using web interface
Categories : PHP, PHP Classes, Databases, MySQL, XML | | | TAB_STRUCT Class: Is supporting Class for the DBXML Class
Categories : PHP, PHP Classes, MySQL, XML, Databases | | | Logs hits to any page which includes it. Automatically utilises page access information left behind by PHP/FI2.0.
Categories : Databases, PHP, mSQL, Databases | | | Record Set Paging with PHP (RSP)
Categories : PHP, MySQL, Navigation, Databases, HTML and PHP | | | Implementing a Members ONLY area
Categories : PHP, MySQL, Databases, Authentication | | | Editing the virtusertable and sendmail.cw via PHP3.0 and Mysql
Categories : MySQL, HTML and PHP, PHP, Databases | | | Function for retrieving MySQL enum values into a PHP array.
Categories : PHP, Databases, MySQL, Arrays | | | This function will populate the options in a drop down HTML select list
in a form from a database query.
Categories : MySQL, General SQL, PHP, HTML and PHP, Databases | | | A login page that require username, password and userlevel.
Categories : PHP, Security, Sessions, MySQL, Databases | | | Three ways to access data selected by a mysql query
Categories : MySQL, PHP, Databases | | | Browse a MySQL database & draw a tree view & load final items into a template page.
Categories : MySQL, Complete Programs, Algorithms, PHP, Databases | | | Linked comboboxes with php-mysql & javascript
Categories : PHP, Java Script, Databases, MySQL | | | Simple pipe delimited file export program that downloads to a local machine
Categories : PHP, Filesystem, Databases, MySQL, HTTP | |
| |
| | | | | matthew waygood wrote :1271
you cant use !empty as a value of 0 is defined as empty.
change it to:-
if(is_null($value))
{
$data.=NULL;
}
else
{
$data.=$value;
}
I cant see the example while typing this, so change it to whatever fits your code.
| |
|
|
