Code: Select all
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="tblDetail">
<tbody>
<tr>
<td class="header" width="25">No.</td>
<td class="header" width="167">Part Number</td>
<td class="header" width="41">Qty</td>
<td class="header" width="101">Harga Offer</td>
<td class="header" width="*">Description</td>
<td class="header" width="40">Stok</td>
<td class="header" width="100">Harga (Rp)</td>
<td class="header" width="100">Harga (US$)</td>
</tr>
<tr>
<script language="JavaScript">
function queryPartNumber(){
var partNo = partNumber.value;
<?php
if (isset($partNumber) && !empty($partNumber)){
echo $partNumber;
$id = $partNumber;
$query = "SELECT KD_PRO,NM_PRO,STOK_AKHIR,HRG_JUAL_RP,UT_UPUS
FROM IM_PRODUCT WHERE FORMULA_ID = '$id'";
$result = mssql_query($query) or die('Invalid Part Number');
$row = mssql_fetch_array($result);
mssql_free_result($result);
}
?>
document.getElementById('partName').innerHTML = '<font color="#BB8B00"><? echo "$row[1]"; ?></font>';
}
</script>
<td class="content" align="center">1</td>
<td class="content" align="center"><input type="text" class="detail" name="partNumber" id="txtRow1" size="24" onChange="queryPartNumber();"></td>
<td class="content" align="center"><input type="text" class="detail" name="quantity" id="txtRow1" size="3"></td>
<td class="content" align="center"><input type="text" class="detail" name="harga" id="txtRow1" size="13"></td>
<td class="content" id="partName"></td>
<td class="integer" id="qty" align="center"><font color="#BB8B00">12</font></td>
<td class="integer" id="priceRP" align="right"><font color="#BB8B00">1,000,000.00</font></td>
<td class="integer" id="priceUS" align="right"><font color="#BB8B00">$ 1,000.00</font></td>
</tr>
</tbody>
</table>Question are:
1. Can i pass JS value to PHP value??? like in the code var partNo = partNumber.value; to $id = $partNo; because i want to do a query where the WHERE condition is that value i get from JS
2. Is it matter if i put the PHP code rather inside or outside <script language="Javascript>???
3. Does anyone have a beeter idea how to make that query run???