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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
| <?php
require_once ('MySQL.php');
require_once ('conf.php');
include('functions.php');
// On commence par récupérer les champs
//if(isset($_POST['idPatient']))
//$id=$_POST['idPatient'];
$link = mysql_connect(DB_HOST,DB_USER, DB_PWD);
mysql_select_db(DB_DATABASE, $link);
$query = "SELECT 20Customer_1012.paIndex, 20Customer_1012.paNomU, 20Customer_1012.paPrenom,20Customer_1012.paDossier1, 20Customer_1012.paDossier2, 20Customer_1012.paNaissance, 20Customer_1012.paSexe, 20Customer_1012.paT_Qualite_P, 20Customer_1012.paNomPar,20Customer_1012.paPrenomPar, 20Customer_1012.T_AdrDefaut_P, 20Customer_1012.paAdress1,20Customer_1012.paAdress2,20Customer_1012.p aCodePostal,20Customer_1012.paT_Ville_P,20Customer_1012.paPays,20Custo mer_1012.pa1T_TypeTel_P,20Customer_1012.paSMS1,20Customer_1012.paNumTe l1,20Customer_1012.paRemTel1,20Customer_1012.pa2T_TypeTel_P,20Customer _1012.paSMS2,20Customer_1012.paNumTel2,20Customer_1012.paRemTel2,20Cus tomer_1012.pa3T_TypeTel_P,20Customer_1012.paSMS3,20Customer_1012.paNum Tel3,20Customer_1012.paRemTel3,20Customer_1012.paFax,20Customer_1012.p aEMail, 20Customer_1012.paProfMere, 20Customer_1012.paProfPatient, 20Customer_1012.paProfParent, 20Customer_1012.paUserZoneA1, 20Customer_1012.paUserZoneA2, 20Customer_1012.paUserZoneA3, 20Customer_1012.paUserZoneA4, 20Customer_1012.paUserZoneA5, 20Customer_1012.paUserZoneA6, 30Traitemnt_201223.ttTStatutP, 30Traitemnt_201223.ttDateStatut, 12Praticien_02.prInitiales, 20Customer_1012.pa2T_Qualite_P
FROM 20Customer_1012
JOIN 30Traitemnt_201223 ON 20Customer_1012.paIndex = 30Traitemnt_201223.ttIndex
JOIN 12Praticien_02 ON 30Traitemnt_201223.ttPraticien = 12Praticien_02.prIndex
WHERE 20Customer_1012.paIndex='16'";
$recordset = mysql_query($query, $link);
$dom = new DOMDocument('1.0', 'UTF-8');
$rootNode= $dom->appendChild($dom->createElement('OrthoExpertDB'));
while($row_recordset = mysql_fetch_array($recordset))
{
$record = new DomElement("p", "");
$rootNode->appendChild($record);
$record->SetAttribute("id", $row_recordset[0]); //index
$record->SetAttribute("nU", $row_recordset[1]);//nom U
$record->SetAttribute("pr", $row_recordset[2]);//prenom
$record->SetAttribute("d1", $row_recordset[3]);//dossier1
$record->SetAttribute("d2", $row_recordset[4]);//dossier2
$record->SetAttribute("dn", datefr($row_recordset[5]));//naissance
$record->SetAttribute("sx", $row_recordset[6]); //sexe
$record->SetAttribute("paQ", $row_recordset[7]); //qualite patient
$record->SetAttribute("nPar", $row_recordset[8]);
$record->SetAttribute("pPar", $row_recordset[9]);
$record->SetAttribute("adD", $row_recordset[10]);
$record->SetAttribute("ad1", $row_recordset[11]);
$record->SetAttribute("ad2", $row_recordset[12]);
$record->SetAttribute("cp", $row_recordset[13]);//code postal
$record->SetAttribute("vi", $row_recordset[14]);
$record->SetAttribute("pi", $row_recordset[15]);
$record->SetAttribute("tT1", $row_recordset[16]);
$record->SetAttribute("sms1", $row_recordset[17]);
$record->SetAttribute("nT1", $row_recordset[18]);
$record->SetAttribute("rT1", $row_recordset[19]);
$record->SetAttribute("tT2", $row_recordset[20]);
$record->SetAttribute("sms2", $row_recordset[21]);
$record->SetAttribute("nT2", $row_recordset[22]);
$record->SetAttribute("rT2", $row_recordset[23]);
$record->SetAttribute("tT3", $row_recordset[24]);
$record->SetAttribute("sms3", $row_recordset[25]);
$record->SetAttribute("nT3", $row_recordset[26]);
$record->SetAttribute("rT3", $row_recordset[27]);
$record->SetAttribute("fax", $row_recordset[28]);
$record->SetAttribute("mail", $row_recordset[29]);
$record->SetAttribute("prPa", $row_recordset[30]);
$record->SetAttribute("prP", $row_recordset[31]);
$record->SetAttribute("prMe", $row_recordset[32]);
$record->SetAttribute("zA1", $row_recordset[33]);
$record->SetAttribute("zA2", $row_recordset[34]);
$record->SetAttribute("zA3", $row_recordset[35]);
$record->SetAttribute("zA4", $row_recordset[36]);
$record->SetAttribute("zA5", $row_recordset[37]);
$record->SetAttribute("zA6", $row_recordset[38]);
$record->SetAttribute("st", $row_recordset[39]);//statut
$record->SetAttribute("dst", $row_recordset[40]);//date statut
$record->SetAttribute("pr2", $row_recordset[41]);//initiale prat
$record->SetAttribute("parQ", $row_recordset[42]);//qualité parent
}
mysql_free_result($recordset);
mysql_close();
print $dom->saveXML();
//echo $xmlStr;
?> |
