bonjour tout le monde!!!
Je tiens jsute a vous rappeler que je suis débutant (pas trop avec dream, mais bcq en code pur!!!) donc je ne comprend que 2 mot sur trois
pour te répondre sadeq; voici mon code :
<?php require_once('../../Connections/ateliermeca.php'); ?>
<?php
mysql_select_db($database_ateliermeca, $ateliermeca);
$query_registreurgence = "SELECT * FROM urgences ORDER BY Niveau ASC";
$registreurgence = mysql_query($query_registreurgence, $ateliermeca) or die(mysql_error());
$row_registreurgence = mysql_fetch_assoc($registreurgence);
$totalRows_registreurgence = mysql_num_rows($registreurgence);
mysql_select_db($database_ateliermeca, $ateliermeca);
$query_registresecteur = "SELECT * FROM secteurs ORDER BY Secteurs ASC";
$registresecteur = mysql_query($query_registresecteur, $ateliermeca) or die(mysql_error());
$row_registresecteur = mysql_fetch_assoc($registresecteur);
$totalRows_registresecteur = mysql_num_rows($registresecteur);
mysql_select_db($database_ateliermeca, $ateliermeca);
$query_regsitremarques = "SELECT ID, Marques FROM marques ORDER BY Marques ASC";
$regsitremarques = mysql_query($query_regsitremarques, $ateliermeca) or die(mysql_error());
$row_regsitremarques = mysql_fetch_assoc($regsitremarques);
$totalRows_regsitremarques = mysql_num_rows($regsitremarques);
mysql_select_db($database_ateliermeca, $ateliermeca);
$query_registremodel = "SELECT ID, Models FROM models ORDER BY Models ASC";
$registremodel = mysql_query($query_registremodel, $ateliermeca) or die(mysql_error());
$row_registremodel = mysql_fetch_assoc($registremodel);
$totalRows_registremodel = mysql_num_rows($registremodel);
mysql_select_db($database_ateliermeca, $ateliermeca);
$query_registreavisot = "SELECT ID, Commentaire FROM avisot ORDER BY ID ASC";
$registreavisot = mysql_query($query_registreavisot, $ateliermeca) or die(mysql_error());
$row_registreavisot = mysql_fetch_assoc($registreavisot);
$totalRows_registreavisot = mysql_num_rows($registreavisot);
mysql_select_db($database_ateliermeca, $ateliermeca);
$query_registrefactur = "SELECT * FROM facturation";
$registrefactur = mysql_query($query_registrefactur, $ateliermeca) or die(mysql_error());
$row_registrefactur = mysql_fetch_assoc($registrefactur);
$totalRows_registrefactur = mysql_num_rows($registrefactur);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><!-- InstanceBegin template="../../Templates/registre.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Registre: AJOUT</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="head" -->
<link href="../../Templates/titre_zone.css" rel="stylesheet" type="text/css">
<!-- InstanceEndEditable -->
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
<link href="style_entete.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
background-image: url(../../Model/bg_grad.jpg);
}
-->
</style>
<link href="menu_gauche.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.Style1 {font-size: 24px}
.texte {
font-family: Arial, Helvetica, sans-serif;
color: #FF0000;
}
.Style2 {
font-size: 14px;
font-weight: bold;
}
.Style9 {color: #F2F2F2}
-->
</style>
</head>
<body>
<div id="Layer3" style="position:absolute; left:14px; top:10px; width:170px; height:23px; z-index:2; visibility: visible; font-style: italic; color: #FF0000; font-weight: bold;">
<div align="center" class="Style1"><a href="../sommaire.php">PONTICELLI</a></div>
</div>
<div id="Navhaut" style="position:absolute; left:11px; top:46px; width:1023px; height:15px; visibility: visible; z-index: 2;"><img src="../../Model/gblnav_left.gif" width="5" height="32"><a href="registregeneral.php"><img src="../../Model/glbnav_background.gif" width="165" height="32" border="0"></a><img src="../../Model/glbnav_background2.gif" width="4" height="32"><a href="../Expertise/expertisegeneral.php"><img src="../../Model/glbnav_background.gif" width="165" height="32" border="0"></a><img src="../../Model/glbnav_background2.gif" width="4" height="32"><a href="../Actions/actionsgeneral.php"><img src="../../Model/glbnav_background.gif" width="165" height="32" border="0"></a><img src="../../Model/glbnav_background2.gif" width="4" height="32"><a href="../FDT/fdtgeneral.php"><img src="../../Model/glbnav_background.gif" width="165" height="32" border="0"></a><img src="../../Model/glbnav_background2.gif" width="4" height="32"><a href="../Modifbasesannexes/mbageneral.php"><img src="../../Model/glbnav_background.gif" width="165" height="32" border="0"></a><img src="../../Model/glbnav_background2.gif" width="4" height="32"><a href="../Statistiques/statistiquegeneral.php"><img src="../../Model/glbnav_background.gif" width="165" height="32" border="0"></a><img src="../../Model/glbnav_right.gif" width="5" height="32"></div>
<div id="GestOT" style="position:absolute; left:21px; top:53px; width:159px; height:21px; z-index:3; visibility: visible;" class="entete">
<div align="center" class="entete">REGISTRE</div>
</div>
<div id="Layer1" style="position:absolute; left:187px; top:95px; width:841px; height:510px; z-index:4"><!-- InstanceBeginEditable name="zone" -->
<p><span class="titrezone">Enregistrement d'un nouveau dossier: </span><br>
<?
//*********************************************
if(isset($_POST['numdossier'])){
$action = $_POST['action'];
$numdossier=$_POST['numdossier'];
$numot=$_POST['numot'];
$numpompe=$_POST['numpompe'];
$urgence=$_POST['urgence'];
$secteurs=$_POST['secteurs'];
}
else{
$action = "";
}
switch($action){
case "inserer": //INSERTION DANS LA BASE
/* déclaration de quelques variables */
$host = "localhost";
$user = "root";
$pass = "xxxxxx";
$bdd = "ateliermeca";
$table = "registre";
/* connection avec MySQL */
@mysql_connect($host,$user,$pass) or die("Impossible de se connecter à la base de données"); // Le @ ordonne a php de ne pas afficher de message d'erreur
@mysql_select_db("$bdd") or die("Impossible de se connecter à la base de données");
/* affichage sélection */
echo "Bonjour, vous venez d'enregistrer avec succes les données concernant le dossier $numdossier provenant de l'OT n°$numot et portant sur la pompe n°$numpompe. Ce travail, d'urgence $urgence, est à réaliser pour le secteur $secteurs";
/* stockage dans la bdd */
$query = "INSERT INTO $table (NumDossier,NumOT,NumPompe,Marques,Models,Secteur,Urgence,Datedebut,Heure,Avisot,Typefacture) VALUES ('" . $_POST['numdossier'] . "','" . $_POST['numot'] . "','" . $_POST['numpompe'] . "','" . $_POST['marque'] . "','" . $_POST['model'] . "','" . $_POST['secteurs'] . "','" . $_POST['urgence'] . "',NOW(), NOW(),'" . $_POST['comm'] . "','" . $_POST['ID'] . "')";
$result = mysql_query($query);
/* déconnection avec MySQL */
mysql_close();
break;
default: // FORMULAIRE HTML
?>
</p>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<table width="773" border="0">
<tr>
<th width="279" scope="col"><div align="right">Votre numéro de dossier :</div></th>
<th width="484" scope="col"><div align="left"><strong>
<input type="text" name="numdossier">
</strong></div></th>
</tr>
<tr>
<td><div align="right">Numéro d'OT correspondant:</div></td>
<td><div align="left">
<input name="numot" type="text" id="numot2">
</div></td>
</tr>
<tr>
<td><div align="right">Numéro de la pompe concernée:</div></td>
<td><div align="left">
<input name="numpompe" type="text" id="numpompe2">
</div></td>
</tr>
<tr>
<td><div align="right">Marque de la pompe: </div></td>
<td><select name="marque" id="marque">
<?php
do {
?>
<option value="<?php echo $row_regsitremarques['ID']?>"><?php echo $row_regsitremarques['Marques']?></option>
<?php
} while ($row_regsitremarques = mysql_fetch_assoc($regsitremarques));
$rows = mysql_num_rows($regsitremarques);
if($rows > 0) {
mysql_data_seek($regsitremarques, 0);
$row_regsitremarques = mysql_fetch_assoc($regsitremarques);
}
?>
</select></td>
</tr>
<tr>
<td><div align="right">Model de la pompe: </div></td>
<td><select name="model" id="model">
<?php
do {
?>
<option value="<?php echo $row_registremodel['ID']?>"><?php echo $row_registremodel['Models']?></option>
<?php
} while ($row_registremodel = mysql_fetch_assoc($registremodel));
$rows = mysql_num_rows($registremodel);
if($rows > 0) {
mysql_data_seek($registremodel, 0);
$row_registremodel = mysql_fetch_assoc($registremodel);
}
?>
</select></td>
</tr>
<tr>
<td><div align="right">Secteur de provenance: </div></td>
<td><div align="left">
<select name="secteurs" id="select">
<?php
do {
?>
<option value="<?php echo $row_registresecteur['ID']?>"><?php echo $row_registresecteur['Secteurs']?></option>
<?php
} while ($row_registresecteur = mysql_fetch_assoc($registresecteur));
$rows = mysql_num_rows($registresecteur);
if($rows > 0) {
mysql_data_seek($registresecteur, 0);
$row_registresecteur = mysql_fetch_assoc($registresecteur);
}
?>
</select>
</div></td>
</tr>
<tr>
<td><div align="right">Niveau de l'urgence:</div></td>
<td><select name="urgence" id="select2">
<?php
do {
?>
<option value="<?php echo $row_registreurgence['ID']?>"><?php echo $row_registreurgence['Niveau']?></option>
<?php
} while ($row_registreurgence = mysql_fetch_assoc($registreurgence));
$rows = mysql_num_rows($registreurgence);
if($rows > 0) {
mysql_data_seek($registreurgence, 0);
$row_registreurgence = mysql_fetch_assoc($registreurgence);
}
?>
</select></td>
</tr>
<tr>
<td><div align="right">Avis OT:</div></td>
<td><select name="comm" id="select3">
<?php
do {
?>
<option value="<?php echo $row_registreavisot['ID']?>"><?php echo $row_registreavisot['Commentaire']?></option>
<?php
} while ($row_registreavisot = mysql_fetch_assoc($registreavisot));
$rows = mysql_num_rows($registreavisot);
if($rows > 0) {
mysql_data_seek($registreavisot, 0);
$row_registreavisot = mysql_fetch_assoc($registreavisot);
}
?>
</select></td>
</tr>
<tr>
<td><div align="right">Type de facturation : </div></td>
<td><div align="left">
<input name="ID" type="radio" value="1" checked <?php if (!(strcmp($row_registrefactur['ID'],"1"))) {echo "CHECKED";} ?>>
Bordereau
<br>
<input <?php if (!(strcmp($row_registrefactur['ID'],"radiobutton"))) {echo "CHECKED";} ?> type="radio" name="ID" value="2">
Temps passé</div></td>
</tr>
</table>
<p align="center"> <input type="submit" name="Submit" value="VALIDER">
<input type="hidden" name="action" value="inserer">
</p>
</form>
<?
break;
}
?></p>
<!-- InstanceEndEditable --></div>
<div id="fondblanc" style="position:absolute; left:12px; top:88px; width:1021px; height:521px; z-index:2; background-color: #F2F2F2; layer-background-color: #F2F2F2; border: 1px none #000000;"></div>
<div id="hautgauche" style="position:absolute; left:12px; top:88px; width:169px; height:11px; z-index:3"><img src="../../Model/tl_curve_white.gif" width="6" height="6"></div>
<div id="Layer4" style="position:absolute; left:941px; top:88px; width:92px; height:13px; z-index:5">
<div align="right"><img src="../../Model/tr_curve_white.gif" width="6" height="6"></div>
</div>
<div id="Layer5" style="position:absolute; left:184px; top:95px; width:3px; height:511px; z-index:6; background-color: #CCCCCC; layer-background-color: #CCCCCC; border: 1px none #000000;"></div>
<div id="Layer10" style="position:absolute; left:681px; top:19px; width:352px; height:18px; z-index:11; font-size: 10px; color: #FFFFFF;">
<p align="right" class="Style2">I <a href="../Recherche/recherchegeneral.php">RECHERCHE </a>I <a href="../Amelioration/ameliogeneral.php">AMELIORATIONS</a> I <a href="mailto:[email protected]">CONTACTS</a> I</p>
</div>
<div id="Layer11" style="position:absolute; left:186px; top:53px; width:164px; height:21px; z-index:12" class="entete">EXPERTISE</div>
<div id="Layer12" style="position:absolute; left:354px; top:53px; width:165px; height:21px; z-index:13" class="entete">ACTIONS</div>
<div id="Layer13" style="position:absolute; left:522px; top:53px; width:166px; height:21px; z-index:14" class="entete">FDT</div>
<div id="Layer14" style="position:absolute; left:692px; top:53px; width:164px; height:21px; z-index:15" class="entete">Modif bases annexes</div>
<div id="Layer15" style="position:absolute; left:860px; top:53px; width:163px; height:21px; z-index:16" class="entete">STATISTIQUES</div>
<div id="gauche" style="position:absolute; left:16px; top:93px; width:167px; height:190px; z-index:20"><!-- InstanceBeginEditable name="gauche" -->
<div id="Layer16" style="position:absolute; left:1px; top:17px; width:163px; height:25px; z-index:2"><img src="../../Model/gblnav_leftbleu.jpg" width="5" height="25"><a href="registregeneral.php"><img src="../../Model/glbnav_backgroundbleu.jpg" width="153" height="25" border="0"></a><img src="../../Model/glbnav_rightbleu.jpg" width="5" height="25"></div>
<p> </p>
<div id="Layer16" style="position:absolute; left:1px; top:46px; width:163px; height:25px; z-index:2"><img src="../../Model/gblnav_leftbleu.jpg" width="5" height="25"><a href="registreconsult.php"><img src="../../Model/glbnav_backgroundbleu.jpg" width="153" height="25" border="0"></a><img src="../../Model/glbnav_rightbleu.jpg" width="5" height="25"></div>
<div id="Layer6" style="position:absolute; left:9px; top:51px; width:145px; height:18px; z-index:3" class="menu_gauche">
<p>Consultation</p>
</div>
<p> </p>
<div id="Layer16" style="position:absolute; left:1px; top:76px; width:163px; height:25px; z-index:2">
<h2><img src="../../Model/gblnav_leftbleu.jpg" width="5" height="25"><a href="registreajout.php"><img src="../../Model/glbnav_backgroundbleu.jpg" width="153" height="25" border="0"></a><img src="../../Model/glbnav_rightbleu.jpg" width="5" height="25"></h2>
</div>
<div id="Layer6" style="position:absolute; left:8px; top:111px; width:145px; height:18px; z-index:3" class="menu_gauche">
<p>Suppression</p>
</div>
<p> </p>
<div id="Layer16" style="position:absolute; left:1px; top:106px; width:163px; height:25px; z-index:2"><img src="../../Model/gblnav_leftbleu.jpg" width="5" height="25"><a href="registresupp.php"><img src="../../Model/glbnav_backgroundbleu.jpg" width="153" height="25" border="0"></a><img src="../../Model/glbnav_rightbleu.jpg" width="5" height="25"></div>
<div id="Layer6" style="position:absolute; left:9px; top:81px; width:145px; height:18px; z-index:3" class="menu_gauche">
<p>Nouveau dossier </p>
</div>
<p> </p>
<div id="Layer6" style="position:absolute; left:9px; top:21px; width:145px; height:18px; z-index:3" class="menu_gauche">
<p>Sommaire</p>
</div>
<div id="Layer16" style="position:absolute; left:1px; top:136px; width:163px; height:25px; z-index:2"><img src="../../Model/gblnav_leftbleu.jpg" width="5" height="25"><a href="registrefdt.php"><img src="../../Model/glbnav_backgroundbleu.jpg" width="153" height="25" border="0"></a><img src="../../Model/glbnav_rightbleu.jpg" width="5" height="25"></div>
<div id="Layer6" style="position:absolute; left:8px; top:140px; width:145px; height:18px; z-index:3" class="menu_gauche">
<p>FDT</p>
</div>
<div id="Layer16" style="position:absolute; left:1px; top:166px; width:163px; height:25px; z-index:2"><img src="../../Model/gblnav_leftbleu.jpg" width="5" height="25"><a href="registrearchives.php"><img src="../../Model/glbnav_backgroundbleu.jpg" width="153" height="25" border="0"></a><img src="../../Model/glbnav_rightbleu.jpg" width="5" height="25"></div>
<div id="Layer6" style="position:absolute; left:9px; top:172px; width:145px; height:18px; z-index:3" class="menu_gauche">
<p>Archives</p>
</div>
<p> </p>
<!-- InstanceEndEditable --></div>
<div id="Layer2" style="position:absolute; left:12px; top:603px; width:28px; height:6px; z-index:21"><img src="../../Model/ll_curve_white.gif" width="6" height="6"></div>
<div id="Layer7" style="position:absolute; left:1027px; top:603px; width:11px; height:9px; z-index:22"><img src="../../Model/lr_curve_white.gif" width="6" height="6"></div>
<div id="Layer8" style="position:absolute; left:46px; top:562px; width:130px; height:42px; z-index:23">
<p align="center"><span class="Style9">Réalisation:<br>
Fabrice M-B
</span><br>
</p>
</div>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($registreurgence);
mysql_free_result($registresecteur);
mysql_free_result($regsitremarques);
mysql_free_result($registremodel);
mysql_free_result($registreavisot);
mysql_free_result($registrefactur);
?>
voila le probleme est maintenant complet!
FAb