Kaskus

Tech

eigerajahdechAvatar border
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 :

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'emoticon-Wink;?>"
            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.'emoticon-Wink;
}
}

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( &#039;../opendb.php' );
$tgl $_POST[&#039;tgl'];
$sil = &#039;Silver';
$gol = &#039;Gold';
$premi = &#039;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[&#039;jml'];
echo $data[&#039;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 emoticon-Berduka (S)
0
3.7K
7
GuestAvatar border
Komentar yang asik ya
Urutan
Terbaru
Terlama
GuestAvatar border
Komentar yang asik ya
Komunitas Pilihan