$sql_details = sql_replace($sql['member']['select_member_details'], $page);
$sgbd = sql_connect();
$res = sql_query($sql_details);
$ligne = sql_fetch_array($res);
sql_free_result($res);
$page['id'] = $ligne['member_id'];
$page['name'] = $ligne['member_lastname'];
$page['firstname'] = $ligne['member_firstname'];
$page['email'] = $ligne['member_email'];
$page['photo'] = $ligne['member_photo'];
if ($page['photo'] == NULL) {
$page['photo'] = "";
}
$page['date_birth'] = convert_date($ligne['member_date_birth'], $lang['member']['format_date_php']);
if ($page['date_birth'] != '') {
$page['age'] = calcul_age($ligne['member_date_birth']);
} else {
$page['age'] = '';
}
$page['place_birth'] = $ligne['member_place_birth'];
if ($page['place_birth'] == NULL) {
$page['place_birth'] = "";
}
$page['size'] = $ligne['member_size'];
if ($page['size'] == NULL) {
$page['size'] = "";
}
$page['weight'] = $ligne['member_weight'];
if ($page['weight'] == NULL) {
$page['weight'] = "";
}
} else {
$idp = $_SESSION["idp"];
$id_doc = $_SESSION["id_doc"];
$mdp_doc = $_SESSION["mdp_doc"];
require_once "../config.inc.php";
$infos_doc = mysql_query("select * from {$table_docteurs} where id=\"{$id_doc}\" AND mdp=\"{$mdp_doc}\" AND activation=\"Y\"");
if (mysql_num_rows($infos_doc) != 1) {
echo "<p class=\"erreur\" align=\"center\">Vos identifiants d'accès sont invalides. Veuillez réessayer.</p>";
exit;
} else {
require_once "../fonctions.inc.php";
$res_doc = mysql_fetch_array($infos_doc);
// Sélection infos patient
$select_patient = mysql_query("select nom, nom_jf, prenom, titre, date_naissance from {$table_patients} where id=\"{$idp}\"");
$res_patient = mysql_fetch_array($select_patient);
$age = calcul_age(DateFR($res_patient["date_naissance"]));
$medicaments = nl2br($res_doc["sauv_medic"]);
$medicaments_ald = nl2br($res_doc["sauv_medicald"]);
if (isset($_GET["type"])) {
$type = $_GET["type"];
} elseif (isset($_POST["type"])) {
$type = $_POST["type"];
} else {
$type = "";
}
?>
<html>
<head>
<title>Ordonnance - <?php
echo $nom_log;
?>
$res_infos = mysql_fetch_array($select_patient);
/*
// Nom jeune fille
if ($res_infos[nom_jf]) { $nom_jf=$res_infos[nom_jf]; }
else { $nom_jf="<center>X</center>"; }
*/
// Date de naissance Fr
$date_naissance = DateFR($res_infos["date_naissance"]);
// Date Création dossier FR
$creation_dossier = DateFR($res_infos["creation_dossier"]);
// Date CMU FR
$cmu = DateFR($res_infos["cmu"]);
// Date Option ref FR
$option_ref = DateFR($res_infos["option_ref"]);
// Age
$age = calcul_age($date_naissance);
$age .= " ans";
?>
<nobr><center>
<a href="modifier.php">MODIFIER</a> |
<a href="../index.php">ACCUEIL</a> |
<a href="../index.php?q=choix_patient" target=_blank>OUVRIR AUTRE DOSSIER</a></center>
<table border="0" align="center">
<tr valign="top">
<td width="500">
<table width="450" border="0" bgcolor="#CECFF2" cellspacing="0" cellpadding="1" align="center">
<tr>
<td>
<table border="0" cellspacing="0" bgcolor="#F9F9FB" width="100%" valign="top">
<tr>
<td colspan="4" bgcolor="#CECFF2"><p class="titre_tab" align="center">Données administratives</p></td>
