|
|
Posted by jfizer on 10/24/07 16:51
I'm trying to print out a table of mySQL data as XML. However, the
performance I'm getting is REALY bad. Adding the header("Content-Type:
$mime;charset=$charset"); statement triples the load time of the data
for example. Can someone with more php experience then I look this
over and tell me that I'm stupid and doing it wrong?
define( "DATABASE_SERVER", "localhost" );
define( "DATABASE_USERNAME", "root" );
define( "DATABASE_PASSWORD", "" );
define( "DATABASE_NAME", "mydatabase" );
$method=$_GET['method'];
//connect to the database
$mysql = mysql_connect(DATABASE_SERVER, DATABASE_USERNAME,
DATABASE_PASSWORD);
mysql_select_db( DATABASE_NAME );
function getDataNames()
{
$Query = "SELECT * from `My Data`";
$Result = mysql_query( $Query );
//$charset = "iso-8859-1";
//$mime = "text/xml";
//header("Content-Type: $mime;charset=$charset");
print ("<response>");
while ( $DataName = mysql_fetch_object( $Result ) )
{
//$Return .= "<data><name>".$DataName->DataName."</
name><iocode>".$DataName->IOCode."</iocode><coicop>".$DataName-
>COICOP."</coicop></data>";
print ("<data>");
print ("<name>".$DataName->DataName."</name>");
print ("<code1>".$DataName->code1."</code1>");
print ("<code2>".$DataName->code2."</code2>");
print ("<code3>".$DataName->IOComName."</code3>");
print ("<code4>42</code4>");
print ("<code5>".$DataName->high_total_IOComName."</code5>");
print ("<code6>".$DataName->high_prod_IOComName."</code6>");
print ("<code7>".$DataName->high_whole_IOComName."</code7>");
print ("<code8>".$DataName->high_whole_IOComName."</code8>");
print ("<code9>".$DataName->high_whole_IOComName."</code9>");
print ("</data>");
}
print ("</response>");
mysql_free_result( $Result );
}
Navigation:
[Reply to this message]
|