Untitled

<?php
error_reporting(0);
require_once 'conn_local.php';

$id = $_GET['id'];

$select = "SELECT * FROM list WHERE id='$id'";

$result_select = $conn->query($select);
if(!$result_select){
    die('Błąd');
}
?>

<link rel="stylesheet" type="text/css" href="css/table.css">
<script type="text/javascript" src="jquery/jquery-1.10.2.min.js"></script>
  <script type="text/javascript" src="jquery/jquery.tablesorter.min.js"></script>
  <script type="text/javascript" src="js/table.js"></script>
<body>
 <div id="wrapper">
  <h1>LISTA URZĄDZEŃ</h1>

  <table id="keywords" cellspacing="0" cellpadding="0">
    <thead>
      <tr>
        <th><span>Rodzaj</span></th>
        <th><span>Model</span></th>
        <th><span>Procesor</span></th>
        <th><span>Dysk twardy</span></th>
        <th><span>RAM</span></th>
        <th><span>IP</span></th>
        <th><span>Klucz Windows</span></th>
        <th><span>Użytkownik</span></th>
        <th><span>Sprzedawca</span></th>
        <th><span>Nr faktury</span></th>
        <th><span>Data zakupu</span></th>
        <th><span>Cena netto</span></th>
        <th><span>Data modyfikacji</span></th>

      </tr>
    </thead>
    <tbody>

<?php
 if($result_select->num_rows>0){
    while($row = $result_select->fetch_assoc()){

        $hardware_type = $row['hardware_type'];
        $model = $row['model'];
        $processor = $row['processor'];
        $hard_drive = $row['hard_drive'];
        $ram = $row['ram'];
        $ip = $row['ip'];
        $win_key = $row['win_key'];
        $user = $row['user'];
        $seller = $row['seller'];
        $invoice_no = $row['invoice_no'];
        $order_date = $row['order_date'];
        $net_price = $row['net_price'];
        $date_modified = $row['date_modified'];
?>
    <form action="<?php echo 'test.php' ?>" method="post">
          <tr><td><input name="hardware_type" required size="10" value="<?php echo $hardware_type ?>"</td>
              <td><input name="model" required size="10" value="<?php echo $model ?>"></td>
              <td><input name="processor" required size="10"value="<?php echo $processor ?>"</td>
              <td><input name="hard_drive" required size="10" value="<?php echo $hard_drive ?>"</td>
              <td><input name="ram" required size="10" value="<?php echo $ram ?>"</td>
              <td><input name="ip" required size="10" value="<?php echo $ip ?>"</td>
              <td><input name="win_key" required size="10" value="<?php echo $win_key ?>"</td>
              <td><input name="user" required size="10" value="<?php echo $user ?>"</td>
              <td><input name="seller" required size="10" value="<?php echo $seller ?>"</td>
              <td><input name="invoice_no" required size="10" value="<?php echo $invoice_no ?>"</td>
              <td><input name="order_date" required size="10" value="<?php echo $order_date ?>"</td>
              <td><input name="net_price" required size="10" value="<?php echo $net_price ?>"</td>
              <td><input name="date_modified" required size="10" value="<?php echo $date_modified ?>"</td>
              <td><input name="submit" type="submit"</td>
    </form>


    <?php }
}

        $hardware_type = $_POST['hardware_type'];
        $model = $_POST['model'];
        $processor = $_POST['processor'];
        $hard_drive = $_POST['hard_drive'];
        $ram = $_POST['ram'];
        $ip = IP.$_POST['ip'];
        $win_key = $_POST['win_key'];
        $user = $_POST['user'];
        $seller = $_POST['seller'];
        $invoice_no = $_POST['invoice_no'];
        $order_date = $_POST['order_date'];
        $net_price = $_POST['net_price'];
        $date_modified = $_POST['date_modified'];

$update = "UPDATE list
          SET   hardware_type = '$hardware_type',
                model = '$model',
                processor = '$processor',
                hard_drive = '$hard_drive',
                ram = '$ram',
                ip ='$ip',
                win_key = '$win_key',
                user = '$user',
                seller = '$seller',
                invoice_no = '$invoice_no',
                order_date = '$order_date',
                net_price = '$net_price',
                date_modified = '$date_modified'
          WHERE id = '$id'";

$result_update = $conn->query($update);
if(!$result_insert){
    die($conn->error);
}else{
    echo  "<p class='info'>Zaktualizowano rekord</p>";
}
?>

    </tbody>
  </table>
 </div>
</body>