FusionCharts XT will load here!
Weight
";
//create file to write to
$ob_file = fopen('FusionCharts/Data2.xml','w');
//write buffer to file created above
function ob_file_callback($buffer)
{
global $ob_file;
fwrite($ob_file,$buffer);
}
// Connecting, selecting database
$link = mysqli_connect('bradmac.id.au', 'bradm946_brad', 'M1lBBcca', 'bradm946_bradmac')
or die('Could not connect: ' . mysqli_error($link));
// Selecting and performing SQL query
$result = mysqli_query($link, $query) or die('Query failed: ' . mysqli_error($link));
//everything below this function gets redirected to a file
ob_start('ob_file_callback');
// Printing results in XML
printf(" \n");
// Start the chart data
// First labels (date)
printf(" \n");
while ($line = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
printf(" \n");
//now weight
// Selecting and performing SQL query
$result = mysqli_query($link, $query) or die('Query failed: ' . mysqli_error($link));
printf(" \n");
while ($line = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
printf(" \n");
// now waist/hip ratio
// Selecting and performing SQL query
$result = mysqli_query($link, $query) or die('Query failed: ' . mysqli_error($link));
printf(" \n");
while ($line = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
printf("set value='$line[w_hips]' /> \n");
}
printf(" \n");
printf(" \n");
// Free resultset
mysqli_free_result($result);
// Closing connection
mysqli_close($link);
//writes above stuff to file
ob_end_flush();
?>