Populating a form

PHP
1

please i am developing an order form, the plan was that after each insert , another div echo’s the data from the database, but i am finding it hard to update the quantity or delete a particular entry


<?php
$submit = $_POST['Add'];

//form data
$Sname = strip_tags(htmlentities($_POST['Sname']));
$Pname = strip_tags(htmlentities($_POST['Pname']));
$Pidno = strip_tags(htmlentities($_POST['Pidno']));
$Psize = strip_tags(htmlentities($_POST['Psize']));
$Pcolour = strip_tags(htmlentities($_POST['Pcolour']));
$Pquantity = $_POST['Pquantity'];
$Weblink = strip_tags(htmlentities($_POST['Weblink']));
$Price = strip_tags(htmlentities($_POST['Price']));

//echo " ('','$Sname','$Pname','$Pidno','$Psize','$Pcolour','$Pquantity','$Weblink','$Price')";

if('POST' === $_SERVER['REQUEST_METHOD'])

{
//open database
$connect = mysql_connect('localhost','xxxxxxxxx','xxxxxxxx') or die('error connecting: ' . mysql_error());
mysql_select_db('reachea2_registeringmembers')or die('error selecting db: ' . mysql_error());//select database
//check for pplac
	//if ($Sname&&$Pname)
//{
$queryreg = mysql_query("

INSERT INTO repplac VALUES ('','$Sname','$Pname','$Pidno','$Psize','$Pcolour','$Pquantity','$Weblink','$Price')

");

//}

}
?>




</div>
<form action='youraccount.php' method='Post' class='slistbar'>
	<!--<div>
	<label for='shoppinglist' class='fixedwidth'></label>
	<textarea type='text' name='shoppinglist' id='username' cols='100' rows='15'></textarea>
	</div> -->
	
	<div>
	<label for='Sname' class='fixedwidth'>Shop name</label>
	<input type='text' name='Sname' id='Sname'/>
	</div>
	<div>
	<label for='Pname' class='fixedwidth'>Product name</label>
	<input type='text' name='Pname' id='Pname'/>
	</div>
	<div>
	<label for='Pidno' class='fixedwidth'>Product id no</label>
	<input type='text' name='Pidno' id='Pidno'/>
	</div>
	<div>
	<label for='Psize' class='fixedwidth'>Product size</label>
	<input type='text' name='Psize' id='Psize'/>
	</div>
	<div>
	<label for='Pcolour' class='fixedwidth'>Product colour</label>
	<input type='text' name='Pcolour' id='Pcolour'/>
	</div>
	<div>
	<label for='Pquantity' class='fixedwidth'>Product quantity</label>
	<select name="Pquantity" id="Pquantity">
	  <option value="1">1</option>
  	  <option value="2">2</option>
  	  <option value="3">3</option>
  	  <option value="4">4</option>
  	  <option value="5">5</option>
  	  <option value="6">6</option>
  	  <option value="7">7</option>
  	  <option value="8">8</option>
  	  <option value="9">9</option>
  	  <option value="10">10</option>
</select>
	</div>
	<div>
	<label for='Weblink' class='fixedwidth'>Web link</label>
	<input type='text' name='Weblink' id='Weblink'/>
	</div>
	<div>
	<label for='Price' class='fixedwidth'>Price GBP</label>
	<input type='text' name='Price' id='Price'/>
	</div>
	<div class='buttonarea'>
			<p>
			<input type='submit' name='submit' value='Add'>
			</p>
			</div>
			</p>
	</form>
</div>
</div>
<div class="action-box rounded">
<div class="titlebar">
<h2>bookmarks</h2>
</div>
<div class="listbar">



<?


$connect = mysql_connect('localhost','xxxxxxx','xxxxxxxxx') or die('error connecting: ' . mysql_error());
mysql_select_db('reachea2_registeringmembers')or die('error selecting db: ' . mysql_error());

$pplresult = mysql_query("SELECT * FROM repplac");
//table starting tag and header cells sitehttp://www.codingmix.com/2010/10/display-data-from-mysql-table-using-php.html
echo "<table border='1'><tr><th> SHOP NAME</th><th> PRODUCT NAME</th><th> PRODUCT SIZE</th><th> PRODUCT COLOUR</th><th> PRODUCT QUANTITY</th><th> PRICE</th><th> </th></tr>";
while($row = mysql_fetch_assoc($pplresult)){
echo "<tr><td>" .$row['Sname'] ."</td><td>" .$row['Pname'] ."</td><td>" .$row['Psize'] ."</td><td>" .$row['Pcolour'] ."</td><td>" .$row['Pquantity'] ."</td><td>" .$row['Price'] ."</td><td>" ?>
<h3><a href="deleteproduct.php">delete</a></h3></td></tr><?php }
// table closing tag
echo"</table>"
?>

so , i am thinking instead of echoing the result, i should pre populate a form, where some field will be editable like quantity update, and delete, while other fields will not be editable.please can you put me through this.thanks

2

I don’t see any logic (code) where you query the database, make sure Pquantity is not larger than the stock (current inventory), and subtract Pquantity from the stock.

3

This order form is not for the store .but is to. buy goods on customers request.so no stock