| |
Forum PHP IndonesiaDapatkan pertolongan pertama pada kebingungan PHP dan sekitarnya |
|
|
|
|
|
| |
|
|
All times are GMT + 7 Hours
|
|
menampilkan data dari database dengan ajax di textfiled
 |
Thu Jul 22, 2010 22:34 |
 |
 Author |
Message |
blueelf
Anak Baru
Joined: 21 Jun 2008
Posts: 1
|
| Post subject: menampilkan data dari database dengan ajax di textfiled |
 |
|
tolong dong master ane ada scrip kayak gini
| Code: | <?php <script type="text/javascript" src="ext-core.js"></script>
<script language="javascript">
function getNama()
{
var id = document.getElementById('no_ang').value;
Ext.Ajax.request({
url : 'getNama.php?id='+id,
method: 'GET',
success: function(response){
var s = response.responseText;
if(s!='0') document.getElementById('nama').value = s;
else alert('Kode Nasabah Tidak Ditemukan!');
}
});
}
function getAlmt()
{
var di = document.getElementById('no_ang').value;
Ext.Ajax.request({
url : 'getAlmt.php?id='+di,
method : 'GET',
success : function(response){
var r = response.responseText;
if(r!='0') document.getElementById('almt').value = r;
else alert('Alamat Tidak Ditemukan');
}
});
}
</script>
<form name="form1" method="post" action="">
<table width="299" align="center" border="1" rules="all">
<tr>
<td width="103">No Anggota</td>
<td width="8"><div align="center">:</div></td>
<td width="170"><label>
<input type="text" id="no_ang" name="no_ang" size="10" /> <input type="button" value="Cari" onclick="getAlmt()" />
</label></td>
</tr>
<tr>
<td>Diterima dari</td>
<td><div align="center">:</div></td>
<td><label>
<input type="text" name="nama" id="nama" value="getNama()" readonly="readonly">
</label></td>
</tr>
<tr>
<td>Alamat</td>
<td><div align="center">:</div></td>
<td><label>
<input type="text" name="almt" id="almt" value=>
</label></td>
</tr>
</table>
</form> ?> |
ntar tuh hasil dari klik tombol cari isi dari text diterima ama alamat langsung ke isi tapi kok yang ke isi cuman text yang alamatnya aja yah
ada saran
thx sebelumnya
masih newbie nie  [/code] |
|
| |
|
|
|
Fri Jul 23, 2010 17:10 |
|
| Author |
Message |
rooster23
PHPnewbie
Joined: 22 Jul 2010
Posts: 12
Location: Sidoarjo
|
| Post subject: |
|
|
oh,, itu eventnya yang kurang.. di bagian button:
<input type="button" value="Cari" onclick="getAlmt()" />
edit jadi gini:
<input type="button" value="Cari" onclick="getNama();getAlmt();" />
value textfield nama dikosongi aja.
_________________
Best Regards,
Peetex. |
|
| |
|
|
|
Sun Aug 22, 2010 09:34 |
|
| Author |
Message |
ndasgodhog
Anak Baru
Joined: 22 Aug 2010
Posts: 1
|
| Post subject: |
|
|
permisi...saya mempunyai permasalahan yg hampir sama...saya menginginkan hasil yang ditampilkan oleh ajax dapat tampil di textfield yg saya inginkan...
| Code: | <?php <script type="text/javascript">
function showUser(str)
{
if (str=="")
{
document.getElementById("tf_nik").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("tf_nik").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","getuser.php?q="+str,true);
xmlhttp.send();
}
</script>
</head>
<body>
<form>
<table width="506" border="0" align="center" cellpadding="1" cellspacing="1">
<tr>
<td width="122"><strong>NIK</strong></td>
<td width="377" rowspan="2"><label>
<input name="tf_nik" type="text" onchange="showUser(this.value)" size="60" />
<div id="tf_nik"><b>Person info will be listed here.</b></div>
</label></td>
</tr>
<tr>
<td><strong>Gaji Total</strong> </td>
<td><label>
<input name="tf_gatot" type="text" size="60" value= "showUser()" readonly = readonly/>
</label></td>
</tr>
<td> </td>
<td><label>
<input type="submit" name="Submit" value="Submit" />
</label></td>
</tr>
</table>
</form> ?> |
dan phpnya
| Code: | <?php <?php
$q=$_GET["q"];
$con = mysql_connect('localhost', 'root','');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("officer", $con);
$sql="select
data_pegawai.nama as nama,
data_pegawai.jabatan as jabatan,
data_pegawai.gaji as gaji,
pph.periode as periode,
pph.masa_kerja as masa_kerja,
pph.rapelan as rapelan,
pph.iuran_jht as jht_setahun,
pph.pph_total as pph
FROM data_pegawai JOIN pph ON data_pegawai.nik = pph.nik
WHERE data_pegawai.nik = '".$q."'";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$gaji = $row['gaji'] + $row['rapelan'];
echo $row['nama']." Gaji = ".$gaji;
}
mysql_close($con);
?> ?> |
Seharusnya hasil yang ditampilkan di bawah tf_nik bisa ada di dlm tf_gatot...
mohon pencerahannya....  
Last edited by ndasgodhog on Sun Aug 22, 2010 09:38; edited 1 time in total |
|
| |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
|
|
|
|
Powered by phpBB © 2001, 2002 phpBB Group
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
PHP Ajax 
