//print $cle.", ". $val;
if (substr($cle, 0, 7) == "datedel") {
$querry = "select id_empr,empr_cb,empr_nom,empr_prenom From empr where empr_date_expiration = '{$val}';";
$res = mysql_query($querry, $dbh) or die($msg["sqlselect_errdel1"] . "<br />" . $msg["sqlselect_errdel2"] . $querry);
while ($row = mysql_fetch_row($res)) {
$querry1 = "select * From pret where pret_idempr = " . $row[0] . ";";
$result3 = mysql_query($querry1, $dbh);
$row2 = mysql_fetch_row($result3);
//print $row2[0]."test";
if ($row2[0] == "") {
emprunteur::del_empr($row[0]);
} else {
$cmpt++;
//print "compteur = ".$cmpt."<br />";
if ($cmpt == 1) {
$desc_empr = desc_table($dbh, "empr");
print $val . "<br />";
print '<font color="#FF0000" face="Geneva, Arial, Helvetica, sans-serif"><strong>' . $msg["personnes_nodel"] . "<p>";
print '</strong></font>';
print "<table border='2'>";
print " <tr>";
foreach ($desc_empr as $dummykey => $empr) {
print " <td>" . $empr[0] . "</td>";
}
print " </tr>";
}
$nbr1 = mysql_num_fields($res);
print " <tr>";
for ($i = 0; $i < $nbr1; $i++) {
print " <td>{$row[$i]}</td>";
}
<?php
include "connexion.php";
//modification des donnees personnelew
if (isset($_POST)) {
include '../action_bdd/action_bdd.php';
$CheminFichier = "../export/exportDB.sql";
touch($CheminFichier);
$file = fopen($CheminFichier, "w");
// Ouverture du fichier avec le mode Ècriture
$ContenuFichier = "\n-- Dump de la base de donnees\n-- Entraide et Partage\n\n\nSET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";\nSET time_zone = \"+00:00\";\n\n";
$ContenuFichier .= "--\n-- Database: `entraide`\n--\n\n-- --------------------------------------------------------\n";
$SQL_TABLES = show_tables();
while ($table = mysql_fetch_array($SQL_TABLES, ENT_QUOTES)) {
// Description Table
$SQL_DESC = desc_table($table[0]);
$ContenuFichier .= "\n--\n-- Table structure for table `" . $table[0] . "`\n--\n\n";
$ContenuFichier .= "DROP TABLE IF EXISTS `" . $table[0] . "`;\n";
$ContenuFichier .= "CREATE TABLE `" . $table[0] . "` (\n";
$records = mysql_query('SHOW FIELDS FROM `' . $table[0] . '`');
if (mysql_num_rows($records) == 0) {
return false;
}
while ($record = mysql_fetch_assoc($records)) {
$ContenuFichier .= ' `' . $record['Field'] . '` ' . $record['Type'];
if (@strcmp($record['Null'], 'YES') != 0) {
$ContenuFichier .= ' NOT NULL';
}
if (!empty($record['Extra'])) {
$ContenuFichier .= ' ' . $record['Extra'];
} else {
