<?php include "connect.php"; $jsArray1 = "var idxspp = new Array();\n"; $jsArray2 = "var idxdpp = new Array();\n"; echo "<table width='60%' border='1'> <tr><td>Nama </td><td>SPP</td><td>DPP</td></tr> <tr> <td><select name='uv' id='uv' onchange='document.getElementById(\"spp\").value = idxspp[this.value]'> <option value='0'>Pilih </option>"; $tampil=mysql_query("SELECT * FROM coba ORDER BY nama"); while($r=mysql_fetch_array($tampil)){ echo "<option value=$r[id_coba]>$r[nama]</option>"; $jsArray1 .= "idxspp['" . $r[id_coba] . "'] = '" . addslashes($r['SPP']) . "' ;\n"; $jsArray2 .= "idxdpp['" . $r[id_coba] . "'] = '" . addslashes($r['DPP']) . "' ;\n"; } echo " </select> </td> <td><input type=text name='spp' id='spp'></td> <td><input type=text name='dpp' id='dpp'></td> </tr>"; echo " </table>"; ?> <script type="text/javascript"> <?php echo "$jsArray1 $jsArray2 ";?> </script>
<?php mysql_connect("localhost","root",""); mysql_select_db("dbgestun"); $result = mysql_query("select * from edc"); $jsArray = "var prdName = new Array();\n"; echo 'Kode EDC : <select name="prdId" onchange="changeValue(this.value)">'; echo '<option>--Silahkan Pilih --</option>'; while ($row = mysql_fetch_array($result)) { echo '<option value="' . $row['id_edc'] . '">' . $row['id_edc'] . '</option>'; $jsArray .= "prdName['" . $row['id_edc'] . "'] = {name:'" . addslashes($row['nama_edc']) . "',desc:'".addslashes($row['bankRT_trans'])."'};\n"; } echo '</select>'; ?> Nama EDC Machine : <input type="text" name="nama_edc" id="nama_edc"/> Bankrate : <input type="text" name="bankRT_trans" id="bankRT_trans"/> <script type="text/javascript"> <?php echo $jsArray; ?> function changeValue(id){ document.getElementById('nama_edc').value = prdName[id].name; document.getElementById('bankRT_trans').value = prdName[id].desc; }; </script>