I do not know how to assign
im.innerHTML = "<img src=\"http://localhost/image/" + document.getElementById("productname").value + ".jpg\">" to a variable $image

As, different productname will generate differnt image path with name.

Secondly, I do not know how to insert month and year with array sql.

//php
<?php 
if (isset($_POST['submit'])) 
{ 
$month = trim($_POST['month']);
$year = trim($_POST['yr']);
    foreach ($_POST['u'] as $value) 
    { 
        extract($value); 
        $sql = "INSERT INTO productupdate SET image = '$image', productname = '$productname', quantity = '$quantity', price = '$price'"; 
        echo $sql . '<br>'; 
    } 
} 
?> 

Please choose month:
<select name="month">
<option value="01">January</option> 
<option value="02">February</option> 
</select>
Please choose year:
<select name="year">
<option value="2008">2008</option> 
<option value="2009">2009</option> 
</select>

Product Name<input type="text" id="productname" name="u[][productname]" size="20" />
QTY<input type="text" id="quantity" name="u[][quantity]" size="10" />
Price<input type="text" id="price" name="u[][price]" size="10" />
<input type="button" value="Add" name="add" onclick="return add();" />

//js
<script language="javascript">
function add(){
var table = document.getElementById("table1");
var row = table.insertRow();
var im = row.insertCell();
im.innerHTML = "<img src=\"http://localhost/image/" + document.getElementById("productname").value + ".jpg\">"
var pn = row.insertCell();
pn.innerText = document.getElementById("productname").value;
var q = row.insertCell();
q.innerText = document.getElementById("quantity").value;
var p = row.insertCell();
p.innerText = document.getElementById("price").value;
var total = row.insertCell();
total.innerText = document.getElementById("price").value * document.getElementById("quantity").value;
var r = row.insertCell();
var button = document.createElement("input");
button.type = "button";
button.value = "Remove";
button.onclick=function(){document.getElementById("table1").deleteRow(row.rowIndex)}
r.appendChild(button);
}
</script>

<table id="table1" border="1">
<tr><td>Image</td><td>ProductName</td><td>QTY</td><td>Price</td><td>Total</td><td>Function</td></tr>
</table>

<input type="button" name="submit" value="Submit" id="submit" />



    Write a Reply...