|
 |
| |
จาก PHP เพิ่มแถวอัตโนมัติ จะทำให้เลือก Product Code แล้ว Description ขึ้นตามมาข้าง ๆ ยังไงอะครับ |
| |
 |
|
|
 |
 |
|
Code (PHP)
<html>
<?php include 'header.php' ?>
<link href="css/addrowitem.css" rel="stylesheet">
<?
mysql_connect("localhost","root","");
mysql_select_db("inter");
$strSQL = "SELECT * FROM product";
$objQuery = mysql_query($strSQL);
?>
<script language="JavaScript">
function resutName(index){
document.getElementById('prodes'+index).value = document.getElementById('procode'+index).options[document.getElementById('procode'+index).selectedIndex].title;
}
</script>
<script language="javascript">
function CreateSelectOption(ele)
{
var objSelect = document.getElementById(ele);
var Item = new Option("", "");
objSelect.options[objSelect.length] = Item;
<?
while($objResult = mysql_fetch_array($objQuery))
{
?>
var Item = new Option("<?=$objResult["procode"];?>", "<?=$objResult["procode"];?>");
objSelect.options[objSelect.length] = Item;
<?
}
?>
}
function CreateNewRow()
{
var intLine = parseInt(document.frmMain.hdnMaxLine.value);
intLine++;
var theTable = document.getElementById("tbExp");
var newRow = theTable.insertRow(theTable.rows.length)
newRow.id = newRow.uniqueID
var newCell
//*** Column 1 ***//
newCell = newRow.insertCell(0);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" STYLE=\"WIDTH:50px;\" NAME=\"item_"+intLine+"\" ID=\"item_"+intLine+"\" VALUE=\"\"></center>";
//*** Column 2 ***//
newCell = newRow.insertCell(1);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><SELECT STYLE=\"WIDTH:150px;\" NAME=\"procode_"+intLine+"\" ID=\"procode_"+intLine+"\"></SELECT></center>";
//*** Create Option ***//
CreateSelectOption("procode_"+intLine)
//*** Column 3 ***//
newCell = newRow.insertCell(2);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" STYLE=\"WIDTH:500px;\" NAME=\"prodes_"+intLine+"\" ID=\"prodes_"+intLine+"\" VALUE=\prodes_+intLine+\></center>";
//*** Column 4 ***//
newCell = newRow.insertCell(3);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" STYLE=\"WIDTH:100px;\" NAME=\"qty_"+intLine+"\" ID=\"qty_"+intLine+"\" VALUE=\"\"></center>";
//*** Column 5 ***//
newCell = newRow.insertCell(4);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" STYLE=\"WIDTH:100px;\" NAME=\"uprice_"+intLine+"\" ID=\"uprice_"+intLine+"\" VALUE=\"\"></center>";
//*** Column 6 ***//
newCell = newRow.insertCell(5);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" STYLE=\"WIDTH:100px;\" NAME=\"amount_"+intLine+"\" ID=\"amount_"+intLine+"\" VALUE=\"\"></center>";
//*** Column 7 ***//
newCell = newRow.insertCell(6);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"hidden\" STYLE=\"WIDTH:100px;\" NAME=\"pono_"+intLine+"\" ID=\"pono_"+intLine+"\" VALUE=\"\"></center>";
document.frmMain.hdnMaxLine.value = intLine;
}
function RemoveRow()
{
intLine = parseInt(document.frmMain.hdnMaxLine.value);
if(parseInt(intLine) > 0)
{
theTable = document.getElementById("tbExp");
theTableBody = theTable.tBodies[0];
theTableBody.deleteRow(intLine);
intLine--;
document.frmMain.hdnMaxLine.value = intLine;
}
}
</script>
<body>
<form name="frmMain" method="post">
<input name="btnAdd" type="button" id="btnAdd" value="+" onClick="CreateNewRow();">
<input name="btnDel" type="button" id="btnDel" value="-" onClick="RemoveRow();">
<table width="100%" border="0" id="tbExp">
<tr>
<td><div align="center">Item </div></td>
<td><div align="center">Product Code </div></td>
<td><div align="center">Description </div></td>
<td><div align="center">QTY </div></td>
<td><div align="center">Unit Price </div></td>
<td><div align="center">Amount </div></td>
<td><div align="center"></div></td>
</tr>
</table>
<input type="hidden" name="hdnMaxLine" value="0">
</form>
</body>
</html>
มี
Code (JavaScript)
<script language="JavaScript">
function resutName(index){
document.getElementById('prodes'+index).value = document.getElementById('procode'+index).options[document.getElementById('procode'+index).selectedIndex].title;
}
</script>
ที่ท่านผู้ใจดีช่วยเขียนให้ แต่พอมาใช้กับการเพิ่มแถวแบบกด + แล้ว ไม่รู้จะใส่ยังไงอะครับ
รบกวนชี้แนะด้วยนะครับ ขอบคุณครับ
Tag : PHP, MySQL, HTML/CSS, JavaScript, Ajax
|
|
|
 |
 |
 |
 |
| Date :
2017-03-15 15:09:28 |
By :
pexmini |
View :
1197 |
Reply :
1 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
บทความนี้ครับ
การนำ jQuery มาทำ AutoFill ข้อมูล Textbox และการตรวจสอบข้อมูลซ้ำด้วย Ajax
|
| |
|
|
| |
| Date :
2017-03-16 10:57:38 |
By :
mr.win |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 02
|
