- Beranda
- Komunitas
- Tech
- Programmer Forum
Cara menampilkan data dengan AJAX


TS
eigerajahdech
Cara menampilkan data dengan AJAX
permasalahan sy begini...
Tanggal : Diinputkan secara manual.
Jml Ambil : akan tampil sendirinya, setelah pengisian tanggal dan Jml Ambil berasa dari table transaksi.
STOK\t : sama halnya dengan Jml Ambil.
Table Members :
ID | TAG |
ID-R236929693-R | Silver|
ID-R243462945-R | Gold |
ID-R267342272-R | Gold |
ID-R397443933-R | Gold |
ID-R417409972-R | Gold |
ID-R492849777-R | Gold |
ID-R513852274-R | Silver|
ID-R522445347-R | Silver|
ID-R665985398-R | Premi |
ID-R764750298-R | Premi |
ID-R841675079-R | Premi |
ID-R896378462-R | Silver|
ID-R940085625-R | Premi |
ID-R956336961-R | Silver|
ID-R155597727-R | Premi |
Table Transaksi.
TGL |ID |JML|STOK|
2012-05-29 |ID-R236929693-R |10 S E N S O R |
2012-05-29 |ID-R417409972-R |43 S E N S O R |
2012-05-29 |ID-R492849777-R S E N S O R0 S E N S O R |
2012-05-29 |ID-R522445347-R |17 S E N S O R |
2012-05-29 |ID-R665985398-R |12 S E N S O R |
2012-05-29 |ID-R764750298-R S E N S O R9 S E N S O R |
2012-05-29 |ID-R956336961-R |54 S E N S O R |
2012-05-30 |ID-R492849777-R S E N S O R S E N S O R |
2012-05-30 |ID-R417409972-R |4 S E N S O R |
2012-05-30 |ID-R236929693-R S E N S O R |1 |
2012-05-30 |ID-R522445347-R S E N S O R |1 |
2012-05-30 |ID-R665985398-R S E N S O R |1 |
2012-05-30 |ID-R956336961-R S E N S O R |1 |
2012-05-30 |ID-R764750298-R S E N S O R |1 |
2012-05-31 |ID-R236929693-R |1 S E N S O R |
2012-05-31 |ID-R417409972-R S E N S O R |1 |
2012-05-31 |ID-R492849777-R S E N S O R |1 |
2012-05-31 |ID-R522445347-R S E N S O R |1 |
2012-05-31 |ID-R665985398-R S E N S O R |1 |
2012-05-31 |ID-R764750298-R S E N S O R |1 |
2012-05-31 |ID-R956336961-R S E N S O R |1 |
2012-06-01 |ID-R665985398-R |4 S E N S O R |
2012-06-01 |ID-R492849777-R S E N S O R S E N S O R |
2012-06-01 |ID-R236929693-R S E N S O R |1 |
2012-06-01 |ID-R522445347-R S E N S O R |1 |
HTMLnya :
AJAX ... :
dan php (tampil_data.php) ...
ketika dijalankan, dan dimasukkan tanggal, yang tampil cuma Loading...nya saja, sedangkan
total jumlah dari table, berdasarkan tanggal yang diinput dan berdasarkan member TAG nya tidak tampil.
kira-kira dimana ya kesalahan sy, mohon bantuannya dari kk senior
Tanggal : Diinputkan secara manual.
Jml Ambil : akan tampil sendirinya, setelah pengisian tanggal dan Jml Ambil berasa dari table transaksi.
STOK\t : sama halnya dengan Jml Ambil.
Table Members :
ID | TAG |
ID-R236929693-R | Silver|
ID-R243462945-R | Gold |
ID-R267342272-R | Gold |
ID-R397443933-R | Gold |
ID-R417409972-R | Gold |
ID-R492849777-R | Gold |
ID-R513852274-R | Silver|
ID-R522445347-R | Silver|
ID-R665985398-R | Premi |
ID-R764750298-R | Premi |
ID-R841675079-R | Premi |
ID-R896378462-R | Silver|
ID-R940085625-R | Premi |
ID-R956336961-R | Silver|
ID-R155597727-R | Premi |
Table Transaksi.
TGL |ID |JML|STOK|
2012-05-29 |ID-R236929693-R |10 S E N S O R |
2012-05-29 |ID-R417409972-R |43 S E N S O R |
2012-05-29 |ID-R492849777-R S E N S O R0 S E N S O R |
2012-05-29 |ID-R522445347-R |17 S E N S O R |
2012-05-29 |ID-R665985398-R |12 S E N S O R |
2012-05-29 |ID-R764750298-R S E N S O R9 S E N S O R |
2012-05-29 |ID-R956336961-R |54 S E N S O R |
2012-05-30 |ID-R492849777-R S E N S O R S E N S O R |
2012-05-30 |ID-R417409972-R |4 S E N S O R |
2012-05-30 |ID-R236929693-R S E N S O R |1 |
2012-05-30 |ID-R522445347-R S E N S O R |1 |
2012-05-30 |ID-R665985398-R S E N S O R |1 |
2012-05-30 |ID-R956336961-R S E N S O R |1 |
2012-05-30 |ID-R764750298-R S E N S O R |1 |
2012-05-31 |ID-R236929693-R |1 S E N S O R |
2012-05-31 |ID-R417409972-R S E N S O R |1 |
2012-05-31 |ID-R492849777-R S E N S O R |1 |
2012-05-31 |ID-R522445347-R S E N S O R |1 |
2012-05-31 |ID-R665985398-R S E N S O R |1 |
2012-05-31 |ID-R764750298-R S E N S O R |1 |
2012-05-31 |ID-R956336961-R S E N S O R |1 |
2012-06-01 |ID-R665985398-R |4 S E N S O R |
2012-06-01 |ID-R492849777-R S E N S O R S E N S O R |
2012-06-01 |ID-R236929693-R S E N S O R |1 |
2012-06-01 |ID-R522445347-R S E N S O R |1 |
HTMLnya :
HTML Code:
<html>
<head>
<script type="text/javascript"src="./ajax.js"></script>
<title>Load Data Dengan AJAX</title>
</head>
<body>
<table cellpadding="2" cellspacing="2" width="100%" height="100%" style="border:1px solid #000;">
<form id="show_data" method="post">
\t<tr>
\t<td colspan="9" align="right">Tanggal :
\t<input type="text"
id="tgl"
name="tgl"
size="10"
value="<?=date('Y-m-d'
;?>"
onfocus="LoadData_Sil(); return false;"
onkeyup="LoadData_Sil(); return false;"
maxlength="10" />
</td>
\t</tr>
<tr>
\t<td colspan="9" align="center"><b>--- Members TAG ---</b></td>
</tr>
<tr><td colspan="6"><hr size="0.1" style="border:1px solid #eee;border-width:0px 1px 1px 1px;"></td></tr>
\t<tr>
\t<td align="center" colspan="2"><b>Silver</b></td>
<td align="center" colspan="2"><b>Gold</b></td>
<td align="center" colspan="2"><b>Premi</b></td>\t
</tr>
<tr><td colspan="6"><hr size="0.1" style="border:1px solid #eee;border-width:0px 1px 1px 1px;"></td></tr>
\t<tr>
<td>Jumlah :</td>
<td>Stock :</td>
<td>Jumlah :</td>
<td>Stock :</td>
<td>Jumlah :</td>
<td>Stock :</td>
</tr>
<tr>
\t\t<!-- Silver TAG -->
<td>
\t<input type="text"
id="jml_sil"
name="jml_sil"
value="0"
size="6"
readonly="readonly" />
\t\t</td>
<td>
\t<input type="text"
id="stock_sil"
name="stock_sil"
value="0"
size="6"
onfocus=""
onkeyup=""
readonly="readonly" />
</td>
\t\t<!-- Gold TAG -->
<td>
\t<input type="text"
id="jml_gol"
name="jml_gol"
value="0"
size="6"
onfocus=""
onkeyup=""
readonly="readonly" />
\t\t</td>
<td>
\t<input type="text"
id="stock_gol"
name="stock_gol"
value="0"
size="6"
onfocus=""
onkeyup=""
readonly="readonly" />
</td>
\t\t<!-- Premi TAG -->
<td>
\t<input type="text"
id="jml_premi"
name="jml_premi"
value="0"
size="6"
onfocus=""
onkeyup=""
readonly="readonly" />
\t\t</td>
<td>
\t<input type="text"
id="stock_premi"
name="stock_premi"
value="0"
size="6"
onfocus=""
onkeyup=""
readonly="readonly" />
</td>
</tr>
</form>
</table>
</body>
</html>
<head>
<script type="text/javascript"src="./ajax.js"></script>
<title>Load Data Dengan AJAX</title>
</head>
<body>
<table cellpadding="2" cellspacing="2" width="100%" height="100%" style="border:1px solid #000;">
<form id="show_data" method="post">
\t<tr>
\t<td colspan="9" align="right">Tanggal :
\t<input type="text"
id="tgl"
name="tgl"
size="10"
value="<?=date('Y-m-d'

onfocus="LoadData_Sil(); return false;"
onkeyup="LoadData_Sil(); return false;"
maxlength="10" />
</td>
\t</tr>
<tr>
\t<td colspan="9" align="center"><b>--- Members TAG ---</b></td>
</tr>
<tr><td colspan="6"><hr size="0.1" style="border:1px solid #eee;border-width:0px 1px 1px 1px;"></td></tr>
\t<tr>
\t<td align="center" colspan="2"><b>Silver</b></td>
<td align="center" colspan="2"><b>Gold</b></td>
<td align="center" colspan="2"><b>Premi</b></td>\t
</tr>
<tr><td colspan="6"><hr size="0.1" style="border:1px solid #eee;border-width:0px 1px 1px 1px;"></td></tr>
\t<tr>
<td>Jumlah :</td>
<td>Stock :</td>
<td>Jumlah :</td>
<td>Stock :</td>
<td>Jumlah :</td>
<td>Stock :</td>
</tr>
<tr>
\t\t<!-- Silver TAG -->
<td>
\t<input type="text"
id="jml_sil"
name="jml_sil"
value="0"
size="6"
readonly="readonly" />
\t\t</td>
<td>
\t<input type="text"
id="stock_sil"
name="stock_sil"
value="0"
size="6"
onfocus=""
onkeyup=""
readonly="readonly" />
</td>
\t\t<!-- Gold TAG -->
<td>
\t<input type="text"
id="jml_gol"
name="jml_gol"
value="0"
size="6"
onfocus=""
onkeyup=""
readonly="readonly" />
\t\t</td>
<td>
\t<input type="text"
id="stock_gol"
name="stock_gol"
value="0"
size="6"
onfocus=""
onkeyup=""
readonly="readonly" />
</td>
\t\t<!-- Premi TAG -->
<td>
\t<input type="text"
id="jml_premi"
name="jml_premi"
value="0"
size="6"
onfocus=""
onkeyup=""
readonly="readonly" />
\t\t</td>
<td>
\t<input type="text"
id="stock_premi"
name="stock_premi"
value="0"
size="6"
onfocus=""
onkeyup=""
readonly="readonly" />
</td>
</tr>
</form>
</table>
</body>
</html>
AJAX ... :
Code:
var recReq = getXmlHttpRequestObject();
var _documentid='jml_sil';
function getXmlHttpRequestObject() {
if (window.XMLHttpRequest) {
return new XMLHttpRequest();
} else if(window.ActiveXObject) {
return new ActiveXObject("Microsoft.XMLHTTP");
} else {
alert('Status: Cound not create XmlHttpRequest Object. Consider upgrading your browser.';
}
}
function LoadData_Sil() {
document.getElementById(_documentid).innerHTML = ' Loading ...';
if (recReq.readyState == 4 || recReq.readyState == 0) {
recReq.open("GET", 'tampil_data.php', true);
recReq.onreadystatechange = function() {
if (recReq.readyState == 4 && recReq.status == 200) {
document.getElementById(_documentid).innerHTML = recReq.responseText;
}
}
recReq.send(null);
}
}
dan php (tampil_data.php) ...
PHP Code:
<?php
require_once( '../opendb.php' );
$tgl = $_POST['tgl'];
$sil = 'Silver';
$gol = 'Gold';
$premi = 'Premi';
$sil_data = "select tb_trs.tgl as tgl,
sum(tb_trs.jml) as jml,
sum(tb_trs.stock) as stock,
tb_mem.tag as tag
from tb_trs
left join tb_mem
on tb_trs.id=tb_mem.id
where tb_trs.tgl='$tgl'
and tb_mem.tag='$sil'
group by tb_trs.tgl";
$loop = mysql_query( $sil_data);
while( $data = mysql_fetch_array( $loop ) ) {
echo $data['jml'];
echo $data['stock'];
}
?>
ketika dijalankan, dan dimasukkan tanggal, yang tampil cuma Loading...nya saja, sedangkan
total jumlah dari table, berdasarkan tanggal yang diinput dan berdasarkan member TAG nya tidak tampil.
kira-kira dimana ya kesalahan sy, mohon bantuannya dari kk senior

0
3.7K
7


Komentar yang asik ya
Urutan
Terbaru
Terlama


Komentar yang asik ya
Komunitas Pilihan