|
| |
|
|
All times are GMT + 7 Hours
|
|
OUTPUT DARI 2 KONDISI VALUE DROPDOWN
 |
Wed Aug 04, 2010 21:34 |
 |
 Author |
Message |
cazucknova
PHPnewbie
Joined: 29 Jul 2010
Posts: 9
|
| Post subject: OUTPUT DARI 2 KONDISI VALUE DROPDOWN |
 |
|
Salam kenal buat Mastah, mohon bantuannya, oke langsung saja..
Bagaimana menampilkan hasil/output dari 2 kondisi value dropdown A & B,
sebagai contoh simple :
A | B | C
-------------
1 > 2 = A
-------------
1 > 3 = B
-------------
2 > 1 = C
-------------
2 > 3 = D
-------------
3 > 1 = E
-------------
3 > 2 = F
-------------
Ket :
A = Dropdown 1
B = Dropdown 2
C = Hasil Output
Mohon solusinya, sebelum dan sesudahnya terima kasih...salam kenal...!! |
|
| |
|
|
|
Sat Aug 07, 2010 08:34 |
|
| Author |
Message |
desrizal
Jagoan PHP
Joined: 21 May 2009
Posts: 448
Location: Papua
|
| Post subject: |
|
|
<html>
<body>
<script>
function proses(){
var a = document.getElementById("a");
var b = document.getElementById("b");
na = a.options[a.selectedIndex].text;
nb = b.options[b.selectedIndex].text;
var h = "";
if(na=="1" && nb=="2"){
h = "A";
}else if(na=="1" && nb=="3"){
h = "B";
}else if(na=="2" && nb=="1"){
h = "C";
}else if(na=="2" && nb=="3"){
h = "D";
}else if(na=="3" && nb=="1"){
h = "E";
}else if(na=="3" && nb=="2"){
h = "F";
}
document.getElementById("hasil").value= h;
}
</script>
<select id=a onchange=proses()>
<option>A</option>
<option>1</option>
<option>2</option>
<option>3</option>
</select>
>
<select id=b onchange=proses()>
<option>B</option>
<option>1</option>
<option>2</option>
<option>3</option>
</select>
=
<input type=text id=hasil size=2>
</body>
</html>
_________________
http://blog.codingwear.com
===================
PHP Ajax jQuery Tutorial |
|
| |
|
|
|
Sun Aug 08, 2010 12:21 |
|
| Author |
Message |
cazucknova
PHPnewbie
Joined: 29 Jul 2010
Posts: 9
|
| Post subject: |
|
|
Sebelumnya makasih buat mas desrizal, sudah saya pelajari, dan saya sudah dapet logikanya, memang disitu ada dua buah dropdown, tapi aku sudah coba memindahkan logikanya ke program yg sedang aku buat dengan perbedaan 3 dropdown, dengan kondisi Dropdown A independen ( tidak terpengaruh dropdown lain ), sedangkan Dropdown B saling bergantung yg akan menghasilkan Dropdown C setelah apa yg dipilih pada Dropdown B, yang jadi pertanyaan saya :
1. Bagaimana mengambil value dari Dropdown A & Dropdown C ?
2. Dan bagaimana dengan 2 kondisi value tersebut menghasilkan output yg diinginkan ?
mohon solusinya mas, apabila ada referensi boleh dikirimkan melalui emailku langsung atau link juga saya terima dengan senang hati, buat bahan juga, sebelum dan sesudahnya makasih banyak mas, berguna sekali mas ilmunya... |
|
| |
|
|
|
Sun Aug 08, 2010 14:15 |
|
| Author |
Message |
andriant
Jagoan PHP
Joined: 31 Mar 2010
Posts: 911
Location: Jakarta
|
| Post subject: |
|
|
1.fungsi:
| Code: | <?php var a = document.getElementById("a");
var b = document.getElementById("b");
na = a.options[a.selectedIndex].text;
nb = b.options[b.selectedIndex].text; ?> |
itu buat ngambil nilai dropdown.
2.
pake if (percabangan)
| Code: | <?php var h = "";
if(na=="1" && nb=="2"){
h = "A";
}else if(na=="1" && nb=="3"){
h = "B";
}else if(na=="2" && nb=="1"){
h = "C";
}else if(na=="2" && nb=="3"){
h = "D";
}else if(na=="3" && nb=="1"){
h = "E";
}else if(na=="3" && nb=="2"){
h = "F";
}
document.getElementById("hasil").value= h; ?> |
kalo maksudnya valuenya diumpetin sesuai dropdown a.
bro desrizal, saya update dikit ya:
| Quote: |
<html>
<body>
<script>
function proses1(){
var a = document.getElementById("a");
var b = document.getElementById("b");
na = a.options[a.selectedIndex].text;
var h = "";
if(na=="1"){
b.innerHTML = "<option value=\"\"></option><option value=\"2\">2</option><option value=\"3\">3</option>";
}
else
if(na=="2"){
b.innerHTML = "<option value=\"\"></option><option value=\"1\">1</option><option value=\"3\">3</option>";
}
else
if(na=="3"){
b.innerHTML = "<option value=\"\"></option><option value=\"1\">1</option><option value=\"2\">2</option>";
}
document.getElementById("hasil").value= h;
}
function proses2(){
var a = document.getElementById("a");
var b = document.getElementById("b");
na = a.options[a.selectedIndex].text;
nb = b.options[b.selectedIndex].text;
var h = "";
if(na=="1" && nb=="2"){
h = "A";
}else if(na=="1" && nb=="3"){
h = "B";
}else if(na=="2" && nb=="1"){
h = "C";
}else if(na=="2" && nb=="3"){
h = "D";
}else if(na=="3" && nb=="1"){
h = "E";
}else if(na=="3" && nb=="2"){
h = "F";
}
document.getElementById("hasil").value= h;
}
</script>
A
<select id="a" onchange="proses1()">
<option></option>
<option value="1">1</option>
<option value="2">2</option>
<option value="2">3</option>
</select>
>B
<select id="b" onchange="proses2()">
</select>
=
<input type="text" id="hasil" size="2">
</body>
</html>
|
|
|
| |
|
|
|
Tue Aug 10, 2010 01:40 |
|
| Author |
Message |
hotaru89
PHPnewbie
Joined: 09 Aug 2010
Posts: 8
|
| Post subject: |
|
|
master php
numpang nanya nie klo nilainy comboboxny dari database ambil nilainy d masukin k textbox gmn??
mohon d bantu ya
 |
|
| |
|
|
|
Thu Aug 12, 2010 03:33 |
|
| Author |
Message |
cazucknova
PHPnewbie
Joined: 29 Jul 2010
Posts: 9
|
| Post subject: |
|
|
Terima kasih mas Andriant, langsung saja deh saya kasi yg sudah saya buat, intinya saya sedang membuat informasi busway, bagaimana kita mengetahui alur busway dari halte awal sampai halte turun yg paling terdekat dari tempat tujuan yg kita pilih. Untuk penjelasan sebagai berikut:
1. HALTE AWAL => Output diambil dari value Dropdown Halte (A) yg dipilih ( contoh : Ancol )
2. HALTE TRANSIT => ( Contoh di gambar : Perkantoran => Gedung Lenmark )
Ouput diambil bukan dari value "Ancol & Gedung Lenmark".
Tetapi value pada database dengan kolom yg berbeda
* Ancol = kor_wal(koridor awal = "5"), database (busway_db > halte)
* Gedung Lenmark = kor_hir(koridor akhir = "4"), database(busway_db > subfasilitas).
Berarti berangkat dari koridor 5 berhenti di koridor 4,
Dengan 2 kondisi tersebut akan di cocok kan pada database "transit"
( kor_wal = 5 & kor_hir = 4 yg menghasilkan halte transit = "Matraman 1")
Hasil output halte transit = "Matraman 1".
3. HALTE TURUN => Output diambil dari value hal_tur Dropdown Subfasilitas (C) pada database "subfasilitas", yg menghasilkan = "Dukuh Atas II".
Hasil Output :
HALTE AWAL = Ancol
HALTE TRANSIT = MATRAMAN I
HALTE TURUN = DUKUH ATAS II
| Code: | <?php //index.php
<?php
include 'koneksi.php';
function createXmlData($data)
{
header("Content-type: text/xml");
echo "<?xml version=\"1.0\"?><response>$data</response>";
}
// handle ajax from javascript function
if ($_POST['id_fas']){
$res = mysql_query("SELECT * FROM subfasilitas WHERE id_fas = '".$_POST['id_fas']."'");
$data = "<select>";
while ($row = mysql_fetch_array($res)){
$data .="<option>".$row['nm_subfas']."</option>";
}
$data .= "</select>";
$data .= "<data><![CDATA[".$data."]]></data>";
createXmlData($data);
exit;
}
?>
<head>
<title>Menu Utama</title>
<script language="javascript" src="jquery.js" type="text/javascript"></script>
<script language="javascript" type="text/javascript">
// function get city from province id
function getSubFasilitas(id_fas)
{
$.post("index.php",{
id_fas : id_fas
}, function(xml) {
data = $("data",xml).text();
if (data){
$("#subfasilitas").html(data);
}
});
}
</script>
<head>
<title>Menu Utama</title>
</head>
<body>
<form action="" method="post" target="_self">
<table width="570" border="0">
<tr>
<td colspan="3" bgcolor="#CCCCCC"><div align="left"><strong>PILIH HALTE</strong></div></td>
</tr>
<tr>
<td width="159" bgcolor="#FFFFFF">Pilih Halte </td>
<td width="10">:</td>
<td width="387"><select name="lm_halte" onChange="getHalte(this.value)" id="lm_halte">
<option value="">Pilih Halte Keberangkatan</option>
<?php
$res = mysql_query('SELECT * FROM halte ORDER BY nm_hal ASC');
while ($row = mysql_fetch_array($res)){
?>
<option value="<?php echo $row['nm_hal']?>"><?php echo $row['nm_hal']?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">Pilih Tujuan </td>
<td>:</td>
<td><select name="lm_fasilitas" onChange="getSubFasilitas(this.value)" id="lm_fasilitas">
<option value="">Pilih Tujuan</option>
<?php
$res = mysql_query('SELECT * FROM fasilitas ORDER BY id_fas ASC');
while ($row = mysql_fetch_array($res)){
?>
<option value="<?php echo $row['id_fas']?>"><?php echo $row['nm_fas']?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFFFF"> </td>
<td><div id="subfasilitas"> </div></td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFFFF"> </td>
<td><label>
<input type="submit" name="button" id="button" value="Cari">
</label> </td>
</tr>
</table>
</form>
<table width="465" border="0">
<tr>
<td width="161">Halte Awal</td>
<td width="10">:</td>
<td width="280"><div></div></td>
</tr>
<tr>
<td>Halte Transit</td>
<td>:</td>
<td><div> </div></td>
</tr>
<tr>
<td>Halte Turun</td>
<td>:</td>
<td><div> </div></td>
</tr>
</table>
</body>
</html> ?> |
| Code: | <?php //koneksi.php
<?php
$servername='localhost';
// username and password to log onto db server
$dbusername='root';
$dbpassword='123';
// name of database
$dbname='busway_db';
////////////////////////////////////////
////// DONOT EDIT BELOW /////////
///////////////////////////////////////
connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect ("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());
}
?> ?> |
Jquery
http://www.indowebster.com/jquer.html
Database
http://www.indowebster.com/db__10.html
Mungkin simple tapi sudah aku utak atik sampai sekarang belum ada hasilnya, aku kirim juga scriptnya dan databasenya, kiranya ada yg bisa membantu persoalanku ini, sebelum dan sesudahnya terima kasih banyak... |
|
| |
|
|
|
Fri Aug 13, 2010 03:54 |
|
| Author |
Message |
andriant
Jagoan PHP
Joined: 31 Mar 2010
Posts: 911
Location: Jakarta
|
| Post subject: |
|
|
mungkin seperti ini gan:
halaman index.php nya
| Quote: |
<?php
include 'koneksi.php';
// handle ajax from javascript function
if ($_GET['a'] == 'fas'){
$res = mysql_query("SELECT * FROM subfasilitas WHERE id_fas = '".$_GET['id']."'");
$result = array();
while ($row = mysql_fetch_array($res)) {
$result[$row['nm_subfas']] = $row['id_subfas'];
}
echo json_encode($result);
die;
}
if ($_GET['a'] == 'result'){
$query = "SELECT * FROM subfasilitas INNER JOIN halte ON subfasilitas.id_subfas = '$_GET[id_subfas]' AND halte.id_hal = '$_GET[id_hal]' INNER JOIN transit ON transit.kor_wal = halte.kor_wal AND transit.kor_hir = subfasilitas.kor_hir";
$res = mysql_query($query);
$result = array();
if ($row = mysql_fetch_array($res)) {
echo json_encode($row);
}
die;
}
?>
<head>
<title>Menu Utama</title>
<script language="javascript" src="jquery.js" type="text/javascript"></script>
<script language="javascript" type="text/javascript">
function checkcomplete()
{
lm_fas = $("#lm_fasilitas").val();
lm_tuj = $('#lm_tujuan').val();
lm_hal = $('#lm_halte').val();
if ((lm_fas != '') && (lm_tuj != '') && (lm_hal != ''))
{
$.ajax({
type: 'GET',
url: 'index.php?a=result&lm_fas='+lm_fas+'&id_subfas='+lm_tuj+'&id_hal='+lm_hal,
dataType: 'json',
success: function(data) {
$("#hl_trans").html(data.nm_haltrans);
$("#hl_turun").html(data.hal_tur);
$("#hl_awal").html(data.nm_hal );
}
});
}
}
$(function() {
$("#lm_halte,#lm_tujuan").bind("change",function(){
checkcomplete();
});
$("#lm_fasilitas").bind("change",function(){
var d = $(this).val();
if (d == "")
{
$("#lm_tujuan").html('<option value=""></option>');
return false;
}
$.ajax({
type: 'GET',
url: 'index.php?a=fas&id='+d,
dataType: 'json',
success: function(data) {
$("#lm_tujuan").html('');
$("#lm_tujuan").html('<option value=""></option>');
$.each(data, function(text, val) {
$('#lm_tujuan').append(
$('<option></option>').val(val).html(text)
);
});
}
});
checkcomplete();
});
});
</script>
<head>
<title>Menu Utama</title>
</head>
<body>
<form action="" method="post" target="_self">
<table width="570" border="0">
<tr>
<td colspan="3" bgcolor="#CCCCCC"><div align="left"><strong>PILIH HALTE</strong></div></td>
</tr>
<tr>
<td width="159" bgcolor="#FFFFFF">Pilih Halte </td>
<td width="10">:</td>
<td width="387"><select name="lm_halte" id="lm_halte">
<option value="">Pilih Halte Keberangkatan</option>
<?php
$res = mysql_query('SELECT * FROM halte ORDER BY nm_hal ASC');
while ($row = mysql_fetch_array($res)){
?>
<option value="<?php echo $row['id_hal']?>"><?php echo $row['nm_hal']?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">Pilih Tujuan </td>
<td>:</td>
<td><select name="lm_fasilitas" id="lm_fasilitas">
<option value="">Pilih Tujuan</option>
<?php
$res = mysql_query('SELECT * FROM fasilitas ORDER BY id_fas ASC');
while ($row = mysql_fetch_array($res)){
?>
<option value="<?php echo $row['id_fas']?>"><?php echo $row['nm_fas']?></option>
<?php
}
?>
</select><br />
<select name="lm_tujuan" id="lm_tujuan">
<option value="">[Pilih Tujuan Terlebih Dahulu]</option>
</select>
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFFFF"> </td>
<td><div id="subfasilitas"> </div></td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFFFF"> </td>
<td><label>
<!-- <input type="submit" name="button" id="button" value="Cari"> -->
</label> </td>
</tr>
</table>
</form>
<table width="465" border="0">
<tr>
<td width="161">Halte Awal</td>
<td width="10">:</td>
<td width="280"><div id="hl_awal"></div></td>
</tr>
<tr>
<td>Halte Transit</td>
<td>:</td>
<td><div id="hl_trans"> </div></td>
</tr>
<tr>
<td>Halte Turun</td>
<td>:</td>
<td><div id="hl_turun"> </div></td>
</tr>
</table>
</body>
</html>
|
|
|
| |
|
|
|
Mon Aug 23, 2010 13:07 |
|
| Author |
Message |
cazucknova
PHPnewbie
Joined: 29 Jul 2010
Posts: 9
|
| Post subject: |
|
|
| Terima kasih banyak mas andriant, hampir seperti ini yang saya maksud, tapi apakah bisa lewat tombol submit dahulu setelah itu baru keluar outputnya? tidak secara live maksudku..sekali lagi terima kasih banyak mas Andriant, mohon bantuannya sekali lagi, forum ini sangat2 membantu saya sekali, mudah2an berguna bagi yang lain... |
|
| |
|
|
|
Tue Aug 24, 2010 01:19 |
|
| Author |
Message |
andriant
Jagoan PHP
Joined: 31 Mar 2010
Posts: 911
Location: Jakarta
|
| Post subject: |
|
|
bisa aja gan, tinggal ditambah submit dan diganti satu langkah... coba deh pelajari Jquery untuk mengetahui 1 langkah tersebut ^^
_________________
Lagi Boker, Makan, Mau Tidur, Coding jangan lupa baca:
PHP Manual -> http://php.net/download-docs.php
MySQL Manual -> http://dev.mysql.com/doc/ |
|
| |
|
|
|
Tue Aug 24, 2010 03:21 |
|
| Author |
Message |
cazucknova
PHPnewbie
Joined: 29 Jul 2010
Posts: 9
|
| Post subject: |
|
|
| siip, it's work...thank u mas.. |
|
| |
|
|
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
|
|
|
|
PHP Help 
