Modify an automatically generated product list using php while() html from mysql

[smaboud]

hi

 

i have generated a product list from a mysql table called product_list, once i enter a new product in to the table the product will be shown in the generated list and the list will grow and the table grows.  and i want to allow user the edit/delete/save the products from the generated table, i have no idea how to do it and what is the algorithmic idea to do it so. here is the php and the html code.

 

<!--Body container  for creating a new product in to the list-->

<div class="body_orderviewform">

  <form name="form1" method="post" action="upload_file.php" enctype="multipart/form-data">

    <p>

      <label for="user_id">User ID:</label>

      <input type="text" name="user_id" id="user_id">

      <label for="customer_name">Customer Name:</label>

      <input type="text" name="customer_name" id="customer_name">

      <label for="customer_family">Customer_family</label>

      <input type="text" name="customer_family" id="customer_family">

      <label for="freelancer_name">Purchaser:</label>

      <input name="freelancer_name" type="text" id="freelancer_name">

     

      <? if (isset($_COOKIE['picAdd'])) echo $_COOKIE['picAdd'];?>

     

    </p>

<!------------------------------------------------------------------------------------------------------- for generating the list -->

   

<div  class="div.neworder_list" >   

 

  <div  class="div.neworder_listheader" align="center">

 

    <table width="637" border="1" >

      <tr>

        <td width="193"><label for="link">link:</label>

          <label for="link_new"></label>

          <input type="text" name="link_new" id="link_new"></td>

        <td width="202"><label for="unitprice">Unit Price:</label>

          <label for="Unit_price_new"></label>

          <input type="text" name="Unit_price_new" id="Unit_price_new"></td>

        <td width="220"><label for="qty">Quantity:</label>

          <label for="quantity_new"></label>

          <input type="text" name="quantity_new" id="quantity_new"></td>

      </tr>

      <tr>

        <td><label for="express">Express Fee:</label>

          <label for="express_new"></label>

          <input type="text" name="express_new" id="express_new"></td>

        <td><label for="commission_new">Commission:</label>

          <input type="text" name="commission_new" id="commission_new"></td>

        <td><label for="customer_description">Description</label>

          <label for="description_new"></label>

          <textarea name="description_new" id="description_new" cols="45" rows="5"></textarea></td>

      </tr>

      <tr>

        <td> </td>

        <td colspan="2">Picture Upload:

              <input type="hidden" name="<?php echo ini_get("session.upload_progress.name");?>" value="123" />

              <input name="file" type="file" autofocus="autofocus"/>

              <br />

 

 

      </tr>

      <tr>

        <td colspan="3"><input type="reset" name="reset" id="reset" value="Reset">

        <input type="submit" name="submit" id="submit" value="Submit The Product"></td>

      </tr>

    </table>

 

 

</form>   

</div>

   

<div class="neworder_listview">

  <p>

  <form action="" method="post" name="list">

    <input type="submit" name="del" id="del" value="Save">

    <input type="submit" name="save" id="save" value="Del">

  </p>

  <table width="1022" border="1" align="center">

    <tr>

      <th width="24" scope="col"> </th>

    <th width="24" scope="col">Row#</th>

    <th width="137" scope="col">Manager</th>

    <th width="137" scope="col">Purchaser Desc</th>

    <th width="40" scope="col"><p>Link</p>

      <p>/Ссылки</p></th>

    <th width="53" scope="col">ФОТО</th>

    <th width="50" scope="col">Unit Price/Цена за еденицу товара</th>

    <th width="46" scope="col">Quantity/ Кол-во</th>

    <th width="138" scope="col">Total Unit Price/ Общая цена</th>

    <th width="89" scope="col">Express/Доставка по Китаю</th>

    <th width="119" scope="col">Description/Описание</th>

    <th width="89" scope="col">ADDITIONAL LINKS/ЗAMЕНЫ</th>

    </tr>

 

 

 

<?php

 

  $username = "my username";

  $password = "my pass";

  $database = "userinfo";

  $link = mysql_connect("localhost", "$username", "$password");

 

  if(!$link) {echo("Failed to establish connection to mysql server");

              exit();}

 

  $status = mysql_select_db($database);

  $query = "SELECT * FROM order_list";

  $result = mysql_query($query);

  $num = mysql_num_rows($result);

  $i=0;

 

 

 

  while ($i < $num) {

$field1_name=mysql_result($result,$i,"admin_st");

$field2_name=mysql_result($result,$i,"freelancer_st");

$field3_name=mysql_result($result,$i,"link");

$field4_name=mysql_result($result,$i,"picture");

$field5_name=mysql_result($result,$i,"unitprice");

$field6_name=mysql_result($result,$i,"qty");

$field7_name=mysql_result($result,$i,"express");

$field8_name=mysql_result($result,$i,"customer_st");

$i++;

    }

 

?>

 

 

 

 

 

 

 

<?php

$i=0;

$row=1;

while ($i < $num) {

 

$f1=mysql_result($result,$i,"admin_st");

$f2=mysql_result($result,$i,"freelancer_st");

$f3=mysql_result($result,$i,"link");

$f4=mysql_result($result,$i,"pic_address");

$f5=mysql_result($result,$i,"unitprice");

$f6=mysql_result($result,$i,"qty");

$f7=mysql_result($result,$i,"express");

$f8=mysql_result($result,$i,"customer_st");

$totao_unit_price = $f5*$f6;

?>

  <tr>

    <td><input type="checkbox" name="del_chbox" id="del_chbox">

<td><p><font face="Arial"><input name="row_txtbox" type="text" id="row_txtbox" size="2" value="<?php echo $row; ?>"></font></td>

<td><p><font face="Arial"> <textarea name="manager_txtbox" cols="10" id="manager_txtbox"><?php echo $f1; ?></textarea></font></td>

<td><p><font face="Arial">        <textarea name="purchase_txtbox" cols="10" id="purchase_txtbox"><?php echo $f2; ?></textarea>

</font></td>

 

 

<td><font face="Arial"><a href="<?php $f3 ?>" target="_blank"><?php echo $f3; ?></a></font></td>

<td><font face="Arial"><img src="<?php echo $f4;?>" width="100" align="middle"100></font></td>

<td><font face="Arial"><input name="unitprice_txtbox" type="text" id="unitprice_txtbox" size="2" value="<?php echo $f5; ?>"></font></td>

<td><font face="Arial"> <input name="qty_txtbox" type="text" id="qty_txtbox" size="2" value="<?php echo $f6; ?>"></font></td>

<td><p><font face="Arial"><?php echo $totao_unit_price; ?></font></td>

<td><p><font face="Arial"><input name="express2" type="text" id="express3" size="2" value="<?php echo $f7; ?>"></font></td>

<td><p><font face="Arial"> <textarea name="custdesc_txtbox" cols="20" id="custdesc_txtbox"><?php echo $f8; ?></textarea></font></td>

    <td><input name="express2" type="text" id="express3" size="2" value="<?php echo "new link" ?>"></td>

  </tr>

 

  <p>

    <?php

$i++;

$row++;

}

?>

</table>

   

  </p>

  <p> </p>

  </form>