1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| <?php require_once('../../Connections/ConnexionDB.php');
mysql_select_db($database_ConnexionDB, $ConnexionDB);
$query_RECUPSCHEDULE = "SELECT AFL07SCHEDULE.ID, AFL07SCHEDULE.PSEUDO, AFL07SCHEDULE.SCHWEEK1 FROM AFL07SCHEDULE";
$RECUPSCHEDULE = mysql_query($query_RECUPSCHEDULE, $ConnexionDB) or die(mysql_error());
$row_RECUPSCHEDULE = mysql_fetch_assoc($RECUPSCHEDULE);
$totalRows_RECUPSCHEDULE = mysql_num_rows($RECUPSCHEDULE);
$xml = '<?xml version="1.0" encoding="ISO-8859-1"?>'.'<SCHEDULE>';
while ($row = mysql_fetch_array($RECUPSCHEDULE))
{
$xml .= '<RECUPSCHEDULE>'
$xml .= '<ID>'.$row['ID'].'</ID>';
$xml .= '<PSEUDO>'.$row['PSEUDO'].'</PSEUDO>';
$xml .= '<SCHWEEK1>'.$row['SCHWEEK1'].'</SCHWEEK1>';
$xml .= '</RECUPSCHEDULE>';
}
$xml .= '</SCHEDULE>';
$fp = fopen("SCHEDULEw1.xml", 'w+');
fputs($fp, $xml);
fclose($fp);
mysql_free_result($RECUPSCHEDULE);
?> |
Partager