//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 {