Thread

For You

Hot Threads

Komunitas

Semua Komunitas

Kategori

Story

News

Hobby

Games

Entertainment

Female

Tech

Automotive

Sports

Food & Travel

Pengaturan

Gambar

Lainnya

Tentang KASKUS

Pusat Bantuan

Hubungi Kami

KASKUS Plus

© 2024 KASKUS, PT Darta Media Indonesia. All rights reserved

mpuyishereAvatar border
TS
mpuyishere
[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 :


hasil di form yang lain :


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 

 }

?>


0
6.2K
4
GuestAvatar border
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
Programmer ForumKASKUS Official
20.2KThread•4.3KAnggota
Terlama
GuestAvatar border
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Ikuti KASKUS di
© 2023 KASKUS, PT Darta Media Indonesia. All rights reserved.