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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
| <?php
header('Content-Type: text/xml');
echo "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n";
echo "<donnees>\n";
include_once("../connexion.php");
if(isset($_POST['traitement_sess']) && isset($_POST['id_sess']) && !empty($_POST['id_sess']))
{
$id_sess=$_POST['id_sess'];
/*INFOS SESSIONS POUR IMPORT apres choix list deroulante*/
try {
// Connect and create the PDO object
$conn = new PDO("mysql:host=$hostdb; dbname=$namedb", $userdb, $passdb);
$conn->exec("SET CHARACTER SET utf8"); // Sets encoding UTF-8
// Define and prepare an INSERT statement
$sql="SELECT sess_auto_eval, sess_utilisation_langue, sess_objectif, sess_dispo FROM sess WHERE sess_id = '".$id_sess."'";
$result = $conn->query($sql);
while($row = $result->fetch(PDO::FETCH_ASSOC)) {
$auto = htmlspecialchars($row['sess_auto_eval'], ENT_QUOTES,'UTF-8');
$util = htmlspecialchars($row['sess_utilisation_langue'], ENT_QUOTES,'UTF-8');
$obj = htmlspecialchars($row['sess_objectif'], ENT_QUOTES,'UTF-8');
$dispo = htmlspecialchars($row['sess_dispo'], ENT_QUOTES,'UTF-8');
if($row['sess_auto_eval'] == ' '){
echo "<auto_eval />\n";
} else {
echo "<auto_eval>"; echo $auto; echo "</auto_eval>\n";
}
if($row['sess_utilisation_langue'] == ' '){
echo "<util_langue />\n";
} else {
echo "<util_langue>"; echo $util; echo "</util_langue>\n";
}
if($row['sess_objectif'] == ' '){
echo "<obj />\n";
} else {
echo "<obj>"; echo $obj; echo "</obj>\n";
}
if($row['sess_dispo'] == ' '){
echo "<dispo />\n";
} else {
echo "<dispo>"; echo $dispo; echo "</dispo>\n";
}
}
$conn = null; // Disconnect
} catch(PDOException $e) {
echo $e->getMessage();
}
}
echo "</donnees>\n";
?> |
Partager