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