|
|
|
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;
}
?> | |
|
|
| 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 | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs.
Categories : Databases, PHP, MySQL, Complete Programs | | | phpAds, a complete banner and ad management system with detailled tracking and stats.
Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases | | | Point and Click Interface ala MS Access for creating SQL statements.
Categories : MySQL, Complete Programs, General SQL, PHP, Databases | | | Message of the Day - Random Message (Needs MySQL!)
Categories : Databases, HTML and PHP, PHP, MySQL | | | Alternating background color for HTML table rows
Categories : PHP, Databases, MySQL, HTML and PHP | | | color codes for positive and negative numbers
Categories : PHP, MySQL, Databases, HTML | | | A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL | | | Tropicalm Genetree Family (MySQL based family tree)
Categories : PHP, Interfaces, Databases, MySQL, Complete Programs | | | mysql_escape_string
Categories : PHP, MySQL, Databases, Strings | | | Automatically printing the contents of an sql table in MySQL.
Categories : MySQL, PHP, HTML and PHP, Databases | | | Email a user with out exposing email address
Categories : PHP, Databases, MySQL, Email | |
| | | | 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.
| |
|
|
|
