Editing data from mysql table using php

Question

I have retrieved data from my table and displayed them using the code below.

<?php require_once('../Connections/bidco.php'); ?>
<body>
<table width="671" height="43" border="1" align="center">
<table width="781" height="190" align="center">
    <tr>
      <td height="61" colspan="4"><div align="center"><strong> Inventory </strong></div></td>
    </tr>
    <tr>
      <td width="77" height="68"><strong>ID</strong></td>
      <td width="152"><strong>Item name.</strong> </td>
      <td width="253"><strong>unit price</strong> </td>

      <td width="253"><strong>Update price</strong></td>

    </tr>
<?php
$query=mysql_query("SELECT *FROM manuf ") or die (mysql_error());
while($row=mysql_fetch_array($query))
{
 $id=$row['id'];
?>
 <tr>
      <td><?php echo $row['id']; ?></td>
      <td><?php echo $row['itemname']; ?></td>
    <td><?php echo $row['unitprice']; ?></td>

      <td><a href="change.php">change</a></td>


 </tr>
 <?php

}
?>
</table>
</body>
</html>

Now this PHP code is supposed to allow me to edit individual rows that have been displayed when i click on 'change' but it it not selecting the row. Any ideas how to solve this?

<?php require_once('../Connections/bidco.php'); ?>
<?php   

        $id = isset($_GET['id']) ? $_GET['id'] : null;


        $query=mysql_query("SELECT * FROM manuf where id='$id' ")or die(mysql_error());
        $row=mysql_fetch_array($query);

        ?>

<form action="updateprice.php" method="post" enctype="multipart/form-data">
  <table align="center">
    <tr>
   <td> <label><strong>Item Name</strong></label></td>
     <td> <input type='text' name='itemname' value=" <?php echo $row['itemname']; ?>"  />
      <input type="hidden" name="id" value="<?php echo $id; ?> " /> <br /></td>
    </tr>
    <tr>

     <td><label><strong>Unit price </strong></label></td>
  <td> <input type="text" name="unitprice" value="<?php echo $row['unitprice']; ?> " /><br /></td>
  </tr>

    <tr>
  <td> 
          <input type="reset" name="Reset" value="CANCEL" />
      <br></td>


     <td> 
          <input type="submit" name="Submit2" value="Update" />      </td>
   </tr>
</table>
</form>
</body>
</html>

Thank you in advance

arif_suhail_123 · Accepted Answer · 2014-10-31 11:08:53Z

2

Your forget to add you id to your link

<td><a href="change.php?id=<?php echo $row['id']?>">change</a></td>

edited Oct 31, 2014 at 11:08

answered Oct 31, 2014 at 11:02

arif_suhail_123

2,5092 gold badges14 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

KevInSol · Accepted Answer · 2014-10-31 11:03:02Z

1

I think you need

<a href="change.php?id=$row['id']">

Edit - use Arif_suhail_123's answer - I did not notice you have PHP mixed in with HTML

answered Oct 31, 2014 at 11:03

KevInSol

2,6844 gold badges34 silver badges47 bronze badges

1 Comment

KevInSol Over a year ago

Thank you :) I would not want to claim false kudos! and also so that the OP will get the correct answer. Returned favour.

Sumit Patil · Accepted Answer · 2014-10-31 11:08:31Z

0

You need to pass rowid to href of Edit Link.

<td><a href="change.php?id=<?php echo $row['id']; ?>">change</a></td>

answered Oct 31, 2014 at 11:08

Sumit Patil

5561 gold badge5 silver badges19 bronze badges

Comments

user3736335 · Accepted Answer · 2014-10-31 11:17:05Z

0

You are looking for id in change.php, but you are not sending that in the header. You must change change with

<a href="change.php?id=<?php echo $row['id']; ?>">change</a>

Also, I suggest you STOP using mysql_* commands, since the are Depreceted, and will no longer be supported. Use mysqli_* commands instead.

edited Oct 31, 2014 at 11:17

answered Oct 31, 2014 at 11:11

user3736335

581 silver badge9 bronze badges

Collectives™ on Stack Overflow

Editing data from mysql table using php

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest