Jadi begini permasalahannya, ane lagi buat javascript onkeyup yang dimana. ketika diinputkan kode barang. maka, informasi lain dari kode tersebut akan muncul.
contohnya begini gan :
jadi dibagian textbox jobsheet diinputkan. maka, akan muncul data yang lain disampingnya.
ane sudah buat di localsever, itu jalan gan, tapi ketika ane jalankan di live. javascriptnya nga jalan gan.
ini bentuk databasenya :
Quote:
create table `jobsheet` (
`no_jobsheet` int ,
`model` varchar (300),
`warranty_type` varchar (9),
`tass` varchar (300),
`cust_name` varchar (600),
`keluhan` text ,
);
begini script java nya. :
Quote:
var nama = new Array(nama);
var model = new Array(model);
var keluhan = new Array(keluhan);
var garansi = new Array(garansi);
<?php
$sql = mysql_query("SELECT * FROM jobsheet WHERE status_jobsheet = 'Confirm' and status_billing = ''") or die(mysql_error());
$i = 0;
while($rowAdd = mysql_fetch_array($sql)){
$i = $i + 1;
echo "nama[".(float)$rowAdd['no_jobsheet']."] = '".str_replace("'"," ",$rowAdd['cust_name'])."';";
echo "model[".(float)$rowAdd['no_jobsheet']."] = '".str_replace("'"," ",$rowAdd['model'])."';";
echo "keluhan[".(float)$rowAdd['no_jobsheet']."] = '".str_replace("'"," ",$rowAdd['keluhan'])."';";
echo "garansi[".(float)$rowAdd['no_jobsheet']."] = '".str_replace("'"," ",$rowAdd['warranty_type'])."';";
}
?>
function selectJobsheet(){
var i = 0;
i = document.form1.nojobsheet.value;
i= i.replace(/^[\s]+/,'').replace(/[\s]+$/,'').replace(/[\s]{2,}/,' ');
document.form1.txtnama.value = nama[i];
document.form1.txtmodel.value = model[i];
document.form1.txtkeluhan.value = keluhan[i];
document.form1.txtgaransi.value = garansi[i];
}
Ini bentuk PHP nya. hanya bagian field aj ya gan :
Quote:
<td><input name="nojobsheet" type="text" id="nojobsheet"></td>
<td><input type="text" name="txtnama" id="txtnama" readonly="readonly" size="15" style="background-color:#6F6"></td>
<td><input type="text" name="txtmodel" id="txtmodel" readonly="readonly" style="background-color:#6F6"></td>
<td><textarea rows="2" name="txtkeluhan" id="txtkeluhan" eadonly="readonly" style="background-color:#6F6" cols="30"></textarea></td>
<td><input type="text" name="txtgaransi" id="txtgaransi" readonly="readonly" size="8" style="background-color:#6F6"></td>
ketika ane ngulik-ngulik. javascriptnya bisa jalan kalo dibagian merah ini ane hapus..
Quote:
var nama = new Array(nama);
var model = new Array(model);
var keluhan = new Array(keluhan);
var garansi = new Array(garansi);
<?php
$sql = mysql_query("SELECT * FROM jobsheet WHERE status_jobsheet = 'Confirm' and status_billing = ''") or die(mysql_error());
$i = 0;
while($rowAdd = mysql_fetch_array($sql)){
$i = $i + 1;
echo "nama[".(float)$rowAdd['no_jobsheet']."] = '".str_replace("'"," ",$rowAdd['cust_name'])."';";
echo "model[".(float)$rowAdd['no_jobsheet']."] = '".str_replace("'"," ",$rowAdd['model'])."';";
echo "keluhan[".(float)$rowAdd['no_jobsheet']."] = '".str_replace("'"," ",$rowAdd['keluhan'])."';";
echo "garansi[".(float)$rowAdd['no_jobsheet']."] = '".str_replace("'"," ",$rowAdd['warranty_type'])."';";
}
?>
function selectJobsheet(){
var i = 0;
i = document.form1.nojobsheet.value;
i= i.replace(/^[\s]+/,'').replace(/[\s]+$/,'').replace(/[\s]{2,}/,' ');
document.form1.txtnama.value = nama[i];
document.form1.txtmodel.value = model[i];
document.form1.txtkeluhan.value = keluhan[i];
document.form1.txtgaransi.value = garansi[i];
}
tapi ane butuh banget data bagian "keluhannya". ane binggung harus bagaimana. tolong ane dong gan