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" />