[RESOLVED] Updating a certain row in a table

ConfusedPerson

I'm fairly new to php and have figured most of it out. Everything works except the update feature. I'm trying to make it so the user can update the quantity in a certain row in a table and then just click the update button in the row. Any help is appreciated. This is what I have so far:

 <?php

session_start();
if(!isset($_SESSION['loggedin'])) 
{
    die("To access this page, you need to be <a href='login.php'> Logged In</a>"); 
} 
else{
      mysql_connect(localhost, "----", "----");
      @mysql_select_db(----) or die("Unable to connect to database.");
      if (isset($_GET["id"]))
      {
            $id=$_GET["id"];
            $query="select * from test where id = '$id'";
            $result=mysql_query($query);     

            exit;
      }
	if (isset($_POST['delt']))
	{
		if (isset($_POST['del']))
		{
			$dele = $_POST['del'];
			foreach ($dele as $value )
			{
				$del = "DELETE FROM test WHERE id = $value";
				$de = mysql_query($del);
			}
			echo "Entry Deleted";
		}else
		{
			echo "No data selected.";
		}
	}

if (isset($_POST['update']))
{
	$update = "update test set quantity= '$quantity' where quantity= '$quantity'";
	@mysql_query($update);
	echo "Updated";
	}
?>
<html>
<body>
		<?php			
			$tempname = $_SESSION['name'];
			$query="select * from test where uname = '$tempname'";
			$result=mysql_query($query);
			if (mysql_num_rows($result)==0)
			{
				echo "Database is Empty<br />";
			}
			else
			{
		?>
        	<form method="post">
                 <div class="size_of_table">
					<table cellpadding="10px" border="2">
					<tr>
						<th>
						Name
						</th>
						<th>
							Description
						</th>
						<th>
							Price
						</th>
						<th>
							Quantity
						</th>
						<th>
							Total
						</th>
	                    <th>
	                    	Delete
	                     </th>
						 <th>
							Update
							</th>
					</tr>
						<?php

					while (list($uname, $id, $name, $description, $price, $quantity)=mysql_fetch_array($result))
					{	
						?>
						<tr>
						<td>
								<? echo $name; ?>
							</td>
							<td>
								<? echo $description?>

							</td>
							<td>
								$<? echo $price?>
							</td>
							<td>

						<input type ="text" name="quantity" value="<? echo $quantity?>"

							</td>
							<td>
								$<? echo $total ?>

							</td>

                            <td align="center">
								<input type="checkbox" name="del[]" value="<?php echo $id ?>">
							</td>
							<td> 
								<input type ="submit" name="update" value ="Update" />
								</td>

						</tr>
					<?php
					}
					?>
                 </table>
			</div>			
             <input type="submit" value="Delete Checked" name="delt" />
			 <br/>

			<br/>
			<br/>

			</form>
            <?php
		}
?>	
	</div>
</body>
</html>
<?php
}
?>

bpat1434

Make your input for the quantity have a name like: quantity[$id], i.e.:

<input type="text" name="quatity[<?php echo $id; ?>]" value="<?php echo $quantity; ?>" />

Then in your php, just see if quantity is not empty:

if(!empty($_POST['quantity'])) {

And finally, you can just loop through them and run an update statement that only updates if the quantity is different :

if(!emtpy($_POST['quantity']))
{
    foreach($_POST['quantity'] as $id=>$qnty)
    {
        // Update all rows only when the quantity in the DB is different from the quantity submitted
        $sql = "UPDATE `table` SET `quantity` = '$qnty' WHERE `id`='$id' AND `quantity` != '$qnty'";
        // Execute the sql query....
    }
}

Hope that helps.

ConfusedPerson

It worked, Thank you for your help.

bpat1434

Don't forget to mark this thread as resolved if it is.