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
|
<?php
include 'connect.php';
?>
<?php
if(isset($_POST['cat']) && isset ($_POST['type']) && isset($_POST['sn']))
{
$cat=$_POST['cat'];
$type=$_POST['type'];
$sn=$_POST['sn'];
echo $cate; /* ( designation=" ' . mysqli_real_escape_string($db,$cate) . '" ) AND (type=" ' . mysqli_real_escape_string($db,$tip) . '" ) AND*/
$select = 'SELECT partnumber,type,designation,nsn,serialnumber,position,dispo,datedemise,description FROM materiel WHERE designation=" ' . mysqli_real_escape_string($db,$cat) . '" AND type=" ' . mysqli_real_escape_string($db,$tip) . '" AND serialnumber="'.mysqli_real_escape_string($db,$sn).'" ';
$result = $db->query($select)or die ('An error has been detected ['. $db->error . ']');
$data = mysqli_fetch_assoc($result);
if($data) {
echo"<p><label >Cateégorie/Désignation:</label> ".$data['designation']." ";
echo " </p>
<br /><p>
<label >Type:</label> ".$data['type']."";
echo "</p>
<br /><p>
<label>Part Number: </label> ".$data['partnumber']."";
echo " <label ><u>NSN:</u></label>".$data['nsn']."";
echo "</p>
<br /><p>
<label >Numéro de série:</label> ".$data['serialnumber']."";
echo "</p>
<br/><p>
<label >Date de mise en service:</label> ".$data['datedemise']."";
if ($data['dispo']==0) $disp="indisponible";echo" </p>
<br/><p>
<label >Etat:</label> ".$disp." ";
echo"</tab><label >Position:</label> ".$data['position']."";
echo" </p>
<br/><p>
<label >Caractéristiques techniques:</label> ".$data['description']."";
echo"</p>";
}
else die ('There was an erreur ['. $db->error . ']');
}
else echo 'oups!!!'
?> |
Partager