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 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105
|
<?php session_start();
if (!isset($_SESSION['email'])) {
header ('Location: index.php');
exit();
}
$id_tournee = $_GET['tournee'];
$base = mysql_connect ('sql.free.fr', '**********', '*********');
mysql_select_db ('*********', $base);
$sql = 'SELECT Numero, Nb_pt_liv, Pickup, Nb_km, Chauffeur, Date_liv FROM tournee_tnt WHERE ID_TNT="'.$id_tournee.'"';
$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
$data = mysql_fetch_array($req);
$numero = htmlentities($data['Numero'], ENT_QUOTES, 'UTF-8');
$nbp = htmlentities($data['Nb_pt_liv'], ENT_QUOTES, 'UTF-8');
$nbr = htmlentities($data['Pickup'], ENT_QUOTES, 'UTF-8');
$nbk = htmlentities($data['Nb_km'], ENT_QUOTES, 'UTF-8');
$chauffeur = htmlentities($data['Chauffeur'], ENT_QUOTES, 'UTF-8');
$date_liv = htmlentities($data['Date_liv'], ENT_QUOTES, 'UTF-8');
if (isset($_POST['modifier']) && $_POST['modifier'] == 'Modifier') {
$new_numero = mysql_real_escape_string($_POST['numero']);
$new_nbp = mysql_real_escape_string($_POST['nbp']);
$new_nbr = mysql_real_escape_string($_POST['nbr']);
$new_nbk = mysql_real_escape_string($_POST['nbk']);
$new_chauffeur = mysql_real_escape_string($_POST['chauffeur']);
$new_date_liv = mysql_real_escape_string($_POST['date_liv']);
if (isset($_POST['numero']) AND $_POST['numero'] !== "")
{
if (isset($_POST['nbp']) AND $_POST['nbp'] !== "")
{
if (isset($_POST['nbr']) AND $_POST['nbr'] !== "")
{
if (isset($_POST['nbk']) AND $_POST['nbk'] !== "")
{
if (isset($_POST['chauffeur']) AND $_POST['chauffeur'] !== "")
{
if (isset($_POST['date_liv']) AND $_POST['date_liv'] !== "")
{
$base = mysql_connect ('sql.free.fr', '*********', '*********');
mysql_select_db ('*********', $base);
$sql ='UPDATE tournee_tnt SET
Numero ="'.$new_numero.'",
Nb_pt_liv ="'.$new_nbp.'",
Pickup ="'.$new_nbr.'",
Nb_km ="'.$new_nbk.'",
Chauffeur ="'.$new_chauffeur.'",
Date_liv ="'.$new_date_liv.'",
WHERE ID_TNT ="'.$id_tournee.'"';
$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
}
}
}
}
}
header('Location: tnt.php');exit();
}
}
?>
<!DOCTYPE html>
<html lang="fr">
<head>
<meta charset="utf-8">
<meta http-equiv="Content-type" content="text/html;charset=UTF-8" />
<title>Gestion des feuilles de route</title>
<link rel="stylesheet" href="http://code.jquery.com/mobile/1.3.1/jquery.mobile-1.3.1.min.css" />
<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
<script src="http://code.jquery.com/mobile/1.3.1/jquery.mobile-1.3.1.min.js"></script>
</head>
<body>
<div data-role="page">
<div data-role="header">
<a href="tnt.php" data-icon="back">Retour</a>
<h1>Gestion des feuilles de route</h1>
</div><!-- /Entete de la page -->
<div data-role="content">
<form action="modifier_tnt.php" method="post" id="modif_tnt">
<ul data-role="listview">
<li data-role="list-divider">Numéro de la tournée</li>
<li><input type="text" name="numero" id="numero" value="<?php echo $numero; ?>" /></li>
<li data-role="list-divider">Nombre de points</li>
<li><input type="text" name="nbp" id="nbp" value="<?php echo $nbp; ?>" /></li>
<li data-role="list-divider">Nombre de ramasses</li>
<li><input type="text" name="nbr" id="nbr" value="<?php echo $nbr; ?>" /></li>
<li data-role="list-divider">Nombre de kilomètres</li>
<li><input type="text" name="nbk" id="nbk" value="<?php echo $nbk; ?>" /></li>
<li data-role="list-divider">Chauffeur</li>
<li><input type="text" name="chauffeur" id="chauffeur" value="<?php echo $chauffeur; ?>" /></li>
<li data-role="list-divider">Date</li>
<li><input type="text" name="date_liv" id="date_liv" value="<?php echo $date_liv; ?>" /></li>
<p><label for="modifier"></label><input type="submit" name="modifier" id="modifier" value="Modifier" data-theme="b" /></p>
</ul>
</form>
</div>
<div data-role="footer">
<h4>© Aldana - Antony 2013</h4>
</div><!-- /Pied de page -->
</div>
<?php
if (isset($erreur)) echo '<br /><br />',$erreur;
?>
</body>
</html> |
Partager