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
|
if(isset($_POST['N'])) $N=$_POST['N'];
else $N="";
if(isset($_POST['device_id'])) $device_id=$_POST['device_id'];
else $device_id="";
if(isset($_POST['Tool_description'])) $Tool_description=$_POST['Tool_description'];
else $Tool_description="";
if(isset($_POST['Tool_Area'])) $Tool_Area=$_POST['Tool_Area'];
else $Tool_Area="";
if(isset($_POST['Tool_Location'])) $Tool_Location=$_POST['Tool_Location'];
else $Tool_Location="";
if(isset($_POST['PDF'])) $PDF=$_POST['PDF'];
else $PDF="";
$query = "SELECT device_id,Tool_description,Tool_Area,Tool_Location,PDF from assembly WHERE device_id='".$_POST["device_id"]."'";
$result = mysql_query($query) or die(mysql_error());
echo '<form method="POST" action="update.php">';
while ($row = mysql_fetch_row($result)) {
$device_id = $row[0];
$Tool_description=$row[1];
$Tool_Area=$row[2];
$Tool_Location=$row[3];
$PDF=$row[4];
echo "<br>device_id<input name='device_id' size='50' value='$device_id'></input></br>";
echo "<br>Tool_description<input name='Tool_description' size='50' value=$Tool_description> </input></br>";
echo "<br>Tool_Area<input name='Tool_Area' size='50' value='$Tool_Area'></input></br>";
echo "<br>Tool_Location<input name='Tool_Location' size='50' value=$Tool_Location> </input></br>";
echo "<br>Fiche technique<input name='PDF' size='50' value='$PDF'></input></br>";
echo'</form>';
}
mysql_close(); |
Partager