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 ;
}
?>
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 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 How to thread a list of messages in database
and show it in a treelike structure Categories : PHP , MySQL , Databases Simple function to return the number of days in a time span between 2 given dates. Categories : PHP , Date Time , MySQL , Databases Checks Date-Input from HTML-Forms and converts to YYYY-MM-DD Format for MySQL Date-Fields Categories : MySQL , Date Time , PHP , Databases XML element extraction using MySQL 5 Categories : Databases , MySQL , Stored Procedures , XML [PHP5] aDB PDO LIKE Database Abstraction. Switch easily from one db server to another, strong errors management, manage transactions, queries preparation and more. Categories : PHP , PHP Classes , Databases , MS SQL Server , MySQL Paginator - a class that can help you to split MySQL database query result sets to pages. Categories : MySQL , Databases , HTML , PHP php-gtk mysql querying tool Categories : PHP-GTK , MySQL , PHP , Databases Password reminder Categories : PHP , PHP Classes , Databases , MySQL , Mail mediaCat-GTK v2.0.0 - an mp3/cd/dvd cataloging utility written in php-gtk which interfaces with mysql and ms access (or db supported by PHP's Unified ODBC Functions) Categories : PHP , MySQL , MS Access , Utilities , Databases Online Automatic Class Generator for MySQL Tables Categories : PHP , PHP Classes , Classes and Objects , Databases , MySQL Phorum, MySQL, Language, UK date format, MySQL UK Date format Categories : PHP , Date Time , Strings , MySQL , Databases
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.