[ASK - Need Help] Ambil / get data dari option select di php ke form berikutnya

Beranda
Komunitas
Tech
Programmer Forum
[ASK - Need Help] Ambil / get data dari option select di php ke form berikutnya

mpuyishere

17-09-2015 16:33

[ASK - Need Help] Ambil / get data dari option select di php ke form berikutnya

Permisi gan, ane mau minta tolong nih.
ane mau ngambil munculin data dari menu select ke form lain tapi datanya tidak muncul (gak ke GET)

menu data yang mau ane ambil nilainya :
[ASK - Need Help] Ambil / get data dari option select di php ke form berikutnya

hasil di form yang lain :
[ASK - Need Help] Ambil / get data dari option select di php ke form berikutnya

scriptnya sebagai berikut :
script form 1 (lap_pkm)

Code:



<?php

require_once("include/class.php");

$dboci = new dboci();



require_once("include/Oracle_LOV.php");

$ora_lov=new OracleLov();



$date = date('d-M-y');



@session_start();



$user = $_SESSION['nik_portal'];

$nama_user = $_SESSION['nama_portal'] ;

$kbranch = $_SESSION['store'];



//$sql = "SELECT KD_PAGE, HAK , KD_BRANCH FROM MS_USERNAS_PAGE WHERE ABSEN = '$user' and KD_PAGE = '1' AND KD_BRANCH = '$kbranch'";



$sql = "SELECT kd_store,nama_store FROM amu_stores_t WHERE org_area_coordinator_nik = '".$_SESSION['nik_portal']."' AND tgl_tutup IS NULL";

$stmt = $dboci->Query($sql);

$toko = ocifetchstatement($stmt,$rowtoko);

ocifreestatement($stmt);

?>



<!--?php if ($rowsuser['HAK'][0]=='1'){

 $log_user = $dboci->log_menu($user,$web_acces);

 ?-->

<!--link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">

[removed][removed]

[removed][removed]



<html>

<body>

<center>

<h2>Rekap PKM</h2>

<br>

 <?php 

 $sql="select distinct tag1_prod from amu_master_head_tab where tag1_prod is not null 

 and tag1_prod <> '-' order by tag1_prod asc";

 $stmt=$dboci->Query($sql);

 $jbarisdep = ocifetchstatement($stmt, $rowdep);

 ocifreestatement($stmt);

 ?>

 <!--select type="text" id="tag_select" name="tag_select">

 <option>--Pilih TAG--</option>

 <?php for($j=0;$j<$jbarisdep;$j++){ ?>

 <option value="<?=$rowdep['TAG1_PROD'][$j]; ?>"><?echo $rowdep['TAG1_PROD'][$j];?></option>

 <?php } ?>

 </select-->

 <table border="1" style="width:50%">

 <!--form class="form-horizontal " action="index.php?m=page&p=pkm.form2&s=<?php echo $rowtoko['KD_STORE'][$i]?>" method="POST"-->

 <thead>

 <tr>

 <th rowspan="2">KODE TOKO</th>

 <th rowspan="2">NAMA TOKO</th>

 <th colspan="2" >PKM</th>

 <th rowspan="2">KKP</th>

 </tr>

 <tr>

 <th> TAG</th>

 <th> DETAIL</th>

 </tr>

 </thead>



 <tbody>

 <?php for ($i=0;$i<$toko;$i++) {?>

 <tr>

 <td><center><input class="form-control" size="5" type="text" name="kd_store" id="kd_store" value="<?php echo $rowtoko['KD_STORE'][$i] ?>"/></center></td>

 <td><?php echo $rowtoko['NAMA_STORE'][$i];?></td>

 <?php 

 $sql="select distinct tag1_prod from amu_master_head_tab where tag1_prod is not null 

 and tag1_prod <> '-' order by tag1_prod asc";

 $stmt=$dboci->Query($sql);

 $jbarisdep = ocifetchstatement($stmt, $rowdep);

 ocifreestatement($stmt);

 ?>

 <td><center>

 <!--select type="text" id="tag_select" name="tag_select">

 <option>--Pilih TAG--</option>

 <?php for($j=0;$j<$jbarisdep;$j++){ ?>

 <option value="<?=$rowdep['TAG1_PROD'][$j]; ?>"><?echo $rowdep['TAG1_PROD'][$j];?></option>

 <?php } ?>

 </select-->



 <select type="text" id="tag_select" name="tag_select">

 <option>--Pilih TAG--</option>

 <option>A</option>

 <option>B</option>

 <option>C</option>

 <option>D</option>

 <option>E</option>

 <option>F</option>

 <option>G</option>

 <option>H</option>

 <option>I</option>

 <option>J</option>

 <option>K</option>

 <option>L</option>

 <option>M</option>

 <option>N</option>

 <option>O</option>

 <option>P</option>

 <option>Q</option>

 <option>R</option>

 <option>S</option>

 <option>T</option>

 <option>U</option>

 <option>V</option>

 <option>W</option>

 <option>X</option>

 <option>Y</option>

 <option>Z</option>

 </select> 

 </center>

 </td>

 <!--td><center> <button id="submit" class="btn btn-primary btn-sm">V</button></center></td-->

 <td><center><a href="index.php?m=page&p=pkm.form2&s=<?php echo $rowtoko['KD_STORE'][$i]?>"><button>V</button></a></center></td>

 <?php //}?>

 <td><center>Cetak</center></td>

 </tr>

 <?php }?>

 </tbody>

 <!--/form-->

 </table>

</center>

<br><br><br><br>

script form 2 (pkm.form2) :

Code:



<?php 

include_once ('include/koneksi1.php');

require_once ("include/class.php");



$dboci = new dboci();



$kd_store = $_GET['s'];

//$kd_store = $_POST['kd_store'];

//echo "manggil kd_store = ".$kd_store; 

$tag = $_POST['tag_select'];

$s = $_GET['s'];

//echo "muncul nilai s = ".$s;



//echo "manggil tag = ".$tag;

//$kd_store = BA46;

//$tag = F;



{

?>

<!doctype html>

<html>

 <head>

 <title>Form PKM</title>

 <link rel="stylesheet" href="css/pkm/bootstrap.min.css"/>

 <link rel="stylesheet" href="css/pkm/dataTables.bootstrap.css"/>

 </head>

 <body>

 <center><h3><strong>EDIT PKM</strong></h3></center>

 <a href="index.php?m=page&p=lap_pkm2"><-- Kembali ke menu sebelumnya</a>

 <br><br>

 <p><strong>Kode Toko : </strong><?php echo $kd_store ?><br/>

 <strong>Pilihan Tag : </strong><?php echo $tag ?></p>



 <div class="popup-container">

 <table id="provinsi" class="table table-bordered table-striped table-condensed">

 <form class="form-horizontal " action="edit_pkm.php" method="POST">

 <thead>

 <tr>

 <th><center>SUBDEPT</center></th>

 <th><center>PLU</center></th>

 <th><center>DESCP</center></th>

 <th><center>TAG PROD</center></th>

 <th><center>MPKM</center></th>

 <th><center>PKM</center></th>

 <th><center>NEW PKM</center></th>

 <th><center>AVG SALES</center></th>

 </tr>

 </thead>

 <tbody>

 <?php

 $sql="SELECT subdept,

 plu,

 rp_umum.get_descp(plu) descp,

 tag_prod,

 minim_Stok mpkm,

 maks_stok pkm,

 '0' new_pkm,

 avg_sls

 FROM OIS.amu_back_mas_t a,

 (SELECT hp_plu,

 TRUNC(SUM(hp_sales_qty)/COUNT(DISTINCT hp_date),2) avg_sls

 FROM OIS.rpt_harian_plu

 WHERE hp_Date BETWEEN TRUNC(TO_DATE(sysdate),'MM') AND TRUNC(SYSDATE)-1

 AND hp_kd_store ='".$kd_store."'

 AND hp_net_value<>0

 GROUP BY hp_plu

 ) b

 WHERE kd_Store ='".$kd_store."'

 AND plu =hp_plu(+)

 AND date_create=TRUNC(sysdate)

 AND tag_prod ='A'";

 $a2 =oci_parse($conn,$sql);

 oci_execute($a2); 

 while ($row=oci_fetch_array($a2)){

 $c1=$row['SUBDEPT'];

 $c2=$row['PLU'];

 $c3=$row['DESCP'];

 $c4=$row['TAG_PROD'];

 $c5=$row['MPKM'];

 $c6=$row['PKM'];

 $c7=$row['NEW_PKM'];

 $c8=$row['AVG_SLS'];

 ?>

 <tr>

 <td><center><?php echo $c1;?></center></td>

 <td><?php echo $c2;?></td>

 <td><?php echo $c3;?></td>

 <td><center><?php echo $c4;?></center></td>

 <td><center><?php echo $c5;?></center></td>

 <td><center><?php echo $c6;?></center></td>

 <td><center><input class="form-control center" size="5" type="text" required="require" name="new_pkm" id="new_pkm" value="<?php echo $c7 ?>"/></center></td>

 <td><center><?php echo $c8;?></center></td>

 </tr>

 <?php } ?>

 </tbody>

 </form>

 </table> 

 </div>

 

 [removed][removed]

 [removed][removed]

 [removed][removed]

 [removed][removed]

 [removed]

 $(function() {

 $("#provinsi").dataTable();

 });

 [removed]

 </body>

</html>



<?php 

 }

?>

6.2K

Kutip

Balasan

Komentar yang asik ya

Urutan

Terbaru

Terlama

Komentar yang asik ya

Komunitas Pilihan