How to insert data from table (html) to database (mysql)?

Question

I have a problem

I try to display the data from database in TABLE (HTML), and then the data that I have displayed must be save in another table with the same content

Display Data

    <?php
     include('ApprovalDB.php');
$result = mysql_query("SELECT pr_id, prcode, type, client, requestdate, status FROM t_purchaserequest where status = 'Approved' and type = 'Sample Only'")
or die(mysql_error());

echo "<table class = 'tbl1' cellpadding='10'>";
echo "<thead><td>PRCODE</td><td>TYPE</td> <td>CLIENT</td> <td>REQUESTED DATE</td> <td>STATUS</td><td>ACTION</td></thead>";

while($row = mysql_fetch_array( $result )) {
echo "<tr>";

echo '<td>' . $row['prcode'] . '</td>';
echo '<td>' . $row['type'] . '</td>';
echo '<td>' . $row['client'] . '</td>';
echo '<td>' . $row['requestdate'] . '</td>';
echo '<td>' . $row['status'] . '</td>';

echo '<td><a href="returnDB.php?id=' . $row['pr_id'] . '" class = "link1">Return Item</a></td>';
echo "</tr>";

}
echo "</table>";
echo "<a href =  'javascript:window.history.go(-1);' class = 'img_arrow'><img src = 'back_arrow.png'></a>";
?>

this link return item, the function must be save the item display in the table.. since I was a newbie.. I don't how I should start here...

thank you for your response to my problem

Answer 1

First of all shouldn't store the details again in HTML format because that you can create anytime.

If you want to do so you can create one variable and store the rendering HTML in that variable, you can print the same variable and keep that variable in hidden field.

Submit the form with post request because may be the hidden size of hidden field value be more.

If the size of the hidden field is more then just send primary key of the record to the server side get the detail again from the DB create the same HTML and store it back to another table.

Below is the code to store the HTML in the variable and display it. you can create form and submit the values as I mentioned above.

<?php

include('ApprovalDB.php');
$result = mysql_query("SELECT pr_id, prcode, type, client, requestdate, status FROM t_purchaserequest where status = 'Approved' and type = 'Sample Only'")
or die(mysql_error());
$str = "";
$str .= "<table class = 'tbl1' cellpadding='10'>";
$str .= "<thead><td>PRCODE</td><td>TYPE</td> <td>CLIENT</td> <td>REQUESTED DATE</td> <td>STATUS</td><td>ACTION</td></thead>";

while ($row = mysql_fetch_array($result)) {
    $str .= "<tr>";

    $str .= '<td>' . $row['prcode'] . '</td>';
    $str .= '<td>' . $row['type'] . '</td>';
    $str .= '<td>' . $row['client'] . '</td>';
    $str .= '<td>' . $row['requestdate'] . '</td>';
    $str .= '<td>' . $row['status'] . '</td>';
    $str .= "</tr>";

}
$str . "</table>";


//display the data 

echo $str;

//to save the data ideally you should not save in this format but still you want to do you can do in two way

//1. most appropriate way you can get the product details in server side, create same string like i have created above and save it to db 

//2.create hidden field and save the data with post form 
echo "<input type='hidden' name='my-data' value='".$str."' >";


echo "<a href =  'javascript:window.history.go(-1);' class = 'img_arrow'><img src = 'back_arrow.png'></a>";
?>