Untitled

<html> <head>
<meta http-equiv="content-type" content="text/html; charset=windows-1251">
<title> EDIT </title> </head>
<body bgcolor=#e6f2ff>
<h3>EDIT </h3>

<?php
include "config.php";
if(isset($_GET['edit']) && $_GET['edit'])
{
  $sql="SELECT * FROM User WHERE Code=" . (int)$_GET['edit'];
  $result=$conn->query($sql);
  $row=$result->fetch_assoc();
?>
<form method="post" action="edit.php">
  <table cellpadding="8">
    <tr>
      <td> Code: </td>
      <td> <input type="hidden" size="55" name="Code"
      value="<?php echo $row['Code']; ?>" /></td>
    </tr>

<tr>
  <td>Name:</td>
  <td><input type="text" size="55" name="Name"
  value="<?php echo $row['Name']; ?>" /></td>
</tr>

<tr>
  <td>Product Name</td>
  <td><input type="text" size="55" name="ProductName"
  value="<?php echo $row['ProductName']; ?>" /></td>
</tr>

<tr>
  <td>Quantity</td>
  <td><input type="text" size="55" name="Quantity"
  value="<?php echo $row['Quantity']; ?>" /></td>
</tr>

<tr>
  <td>Price</td>
  <td><input type="text" size="55" name="Price"
  value="<?php echo $row['Price']; ?>" /></td>
</tr>

<tr>
  <td>Pay</td>
  <td><input type="text" size="55" name="Pay"
  value="<?php echo $row['Pay']; ?>" /></td>
</tr>

<tr>
  <td>Sum</td>
  <td><input type="text" size="55" name="Sum"
value="<?php echo $row['Sum']; ?>" /></td>
</tr>
</table><p>
<input type="submit" name="submit" value="Promeni">
</form>
<?php
} else {
if(isset($_POST['submit']))
{
  $sql="UPDATE User SET Name=' " . $_POST['Name'] .
               " ProductName=' " . $_POST['ProductName'] .
                  " Quantity=' " . $_POST['Quantity'] .
                     " Price=' " . $_POST['Price'] .
                       " Pay=' " . $_POST['Pay'] .
  ",Sum=" .(float) $_POST['Sum'] . " WHERE Code=" . (int) $_POST['Code'];
  $result=$conn->query($sql);
}
  $result=$conn->query("SELECT * FROM User ORDER BY Name ASC");

if ($result->num_rows <= 0)
    echo "0 results";
  else
  {
    $zag=array();
  ?>
  <table border="4" bordercolor="black" cellpadding="15" cellspacing="0" bgcolor="#e6f2ffw">
  <tr>
  <?php
    foreach($zag as $v) echo "<th>" .$v. "</th>";
  ?>
  </tr>
<?php
 while($row = $result->fetch_assoc())
    {
 ?>
 <tr bgcolor=#e6f2ff>;
 <td> <?php echo $row["Code"]; ?> </td>
 <td> <?php echo $row["Name"]; ?> </td>
 <td> <?php echo $row["ProductName"]; ?> </td>
 <td> <?php echo $row["Quantity"]; ?> </td>
 <td> <?php echo $row["Price"]; ?> </td>
 <td> <?php echo $row["Pay"]; ?> </td>
 <td> <?php echo $row["Sum"]; ?> </td>
 <td align=center> <a href="edit.php?edit=<?php echo $row['Code']; ?>"> EDIT </a> </td>
 </tr>
 <?php
 }
 }
 }
?>
</table>
<?php   $conn->close();  ?>
<p> <a href="index.htm#Menu"> Menu =>> </a>
</body> </html>