Buat agan agan Ane mau tanya dong.. ane lagi ada kendala nieh.
ane lagi buat web gitu.
Setelah Login.. di web tersebut.
entar terdapat 2 form. Pilih Tahun dan angkatan.
setalah di pilih entar muncul nama nama sesuai tahun dan angkatan yang sebut saja user.php dan di ujung kolom ada kotak input/update nilai.
nah yang jadi kendala itu setelah input/update nilai.kan ane direct ke halaman user.php lagi.
tapi malah muncul semua isi table dari semua angkatan dan dari semua tahun
ane sih punya perasaan kalah ada salah di do updatenya.ane masih belum paham
mohon bantuannya dan pencerahan secerah cerahnya
ini Kodingan doupdatenya.
Quote:
<?php
include "Connect.php";
session_start();
$id=$_REQUEST['id'];
$qty=$_REQUEST['qty'];
mysql_query("update msNama set Nilai_ICT='".$qty."' where ID_nama='$id' ");
header("location:user.php?succ=2");
?>
update: Ane gambarin semua biar greget
ini gan scriptnya...
Spoiler for cari :
<html>
<head>
<title> Halaman Pencarian </title>
</head>
<body>
<form name="formcari" method="post" action="home4.php">
<table width="330" border="0" align="center" cellpadding="0">
<tr bgcolor="orange">
<td height="25" colspan="3">
<strong> Student Searching ! </strong>
</td>
</tr>
<tr>
<td>Tahun</td>
<td><select name="thn">
<option>2012</option>
<option>2013</option>
<option>2014</option>
<option>2015</option>
<option>2016</option>
<option>2017</option>
<option>2018</option>
<option>2019</option>
<option>2020</option>
<option>2021</option>
<option>2022</option>
<option>2023</option>
</select></td>
</tr>
<tr> <td> Angkatan </td>
<td> <input type="text" name="name"> </td>
</tr>
<td></td>
<td> <input type="SUBMIT" name="SUBMIT" id="SUBMIT" value="search" > </td>
</table>
</form>
</body>
</html>
SS nya ini
Spoiler for ss :
Habis itu ini gan Home.php.
Spoiler for home :
Quote:
<?php
session_start();
include("connect.php");
if($_SESSION['user']=="")
{
header("location:index.php?err=must login first");
}
?>
<style type="text/css">
.c
{
font:"Arial Black", Gadget, sans-serif ;
color:#000;
#pattern-style-a
{
font-family: "Lucida Sans Unicode", "Lucida Grande", Sans-Serif;
font-size: 12px;
margin: 45px;
width: 480px;
text-align: left;
border-collapse: collapse;
background: url('table-images/pattern.png');
}
#pattern-style-a thead tr
{
background: url('table-images/pattern-head.png');
}
#pattern-style-a th
{
font-size: 13px;
font-weight: normal;
padding: 8px;
border-bottom: 1px solid #fff;
color: #039;
}
#pattern-style-a td
{
padding: 8px;
border-bottom: 1px solid #fff;
color: #669;
border-top: 1px solid transparent;
}
#pattern-style-a tbody tr:hover td
{
color: #339;
background: #fff;
}
}
</style>
<html>
<head></head>
<body>
<table width="100%" border="0">
<tr>
<td height="58"><h1> welcome USER</h1></td>
</tr>
<tr>
<td align="right">
<?php $uu=$_SESSION['user'];
$b=time();
print date("D, d F Y",$b);
echo ("| Welcome $uu |")?> <a href="logout.php">Logout </a></td>
</tr>
<tr>
<td align="center"></td>
</tr>
<tr>
<td><span class="c"><strong>Nilai Corporate Exposure ICT </strong></span>
</td>
</tr>
<tr>
<td>
<table width="100%" border="1" cellpadding="0" cellspacing="0" id="pattern-style-a">
<thead>
<tr>
<th rowspan="2" scope="col">No</th>
<th rowspan="2" scope="col">NIP</th>
<th width="17%" rowspan="2" scope="col">Nama</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
<th scope="col">�</th>
</tr>
<tr>
<th scope="col">Nilai A</th>
<th scope="col">Input Nilai A</th>
<th scope="col"> Nilai B</th>
<th scope="col">Input Nilai B</th>
<th scope="col">Nilai C</th>
<th scope="col">Input Nilai C</th>
<th scope="col">Nilai D</th>
<th scope="col">Input Nilai D</th>
<th scope="col">Nilai E</th>
<th scope="col">Input Nilai E</th>
<th scope="col">Nilai F</th>
<th scope="col">Input Nilai F</th>
<th scope="col"> Nilai G</th>
<th scope="col">Input Nilai G</th>
</tr>
</thead>
<tr>
<?php
$name= $_POST['name'];
$thn= $_POST['thn'];
$query="SELECT * from msnama where angkatan like '%$name%' and tahun like '%$thn%' ";
$rs=mysql_query($query);
$_SESSION['angkatan']=$name;
$_SESSION['admin_access'] = $thn;
while($row=mysql_fetch_array($rs))
{
?>
<td align="center"><?php echo $row[0]; ?></td>
<td align="center"><?php echo $row[2]; ?></td>
<td align="center"><?php echo $row[3]; ?></td>
<td align="center"><?php echo $row[11]; ?></td>
<td align="center"><form name="form1" method="post" action="doupdateICT1.php?id=<?php echo $row[0];?>">
<label for="textfield"></label>
<input type="text" name="qty" id="textfield" size="4" >
<input type="submit" name="button" id="button" value="Submit">
</form></td>
<td align="center"><?php echo $row[10]; ?></td>
<td align="center"><form name="form1" method="post" action="doupdateICT2.php?id=<?php echo $row[0];?>">
<label for="textfield"></label>
<input type="text" name="qty" id="textfield" size="4" min="0" max="100" >
<input type="submit" name="button" id="button" value="Submit">
</form></td>
<td align="center"><?php echo $row[11]; ?></td>
<td align="center"><form name="form1" method="post" action="doupdateICT3.php?id=<?php echo $row[0];?>">
<label for="textfield"></label>
<input type="text" name="qty" id="textfield" size="4" min="0" max="100" >
<input type="submit" name="button" id="button" value="Submit">
</form></td>
<td align="center"><?php echo $row[12]; ?></td>
<td align="center"><form name="form1" method="post" action="doupdateICT4.php?id=<?php echo $row[0];?>">
<label for="textfield"></label>
<input type="text" name="qty" id="textfield" size="4" min="0" max="100" >
<input type="submit" name="button" id="button" value="Submit">
</form></td>
<td align="center"><?php echo $row[13]; ?></td>
<td align="center"><form name="form1" method="post" action="doupdateICT5.php?id=<?php echo $row[0];?>">
<label for="textfield"></label>
<input type="text" name="qty" id="textfield" size="4" min="0" max="100" >
<input type="submit" name="button" id="button" value="Submit">
</form></td>
<td align="center"><?php echo $row[14]; ?></td>
<td align="center"><form name="form1" method="post" action="doupdateICT6.php?id=<?php echo $row[0];?>">
<label for="textfield"></label>
<input type="text" name="qty" id="textfield" size="4" min="0" max="100" >
<input type="submit" name="button" id="button" value="Submit">
</form></td>
<td align="center"><?php echo $row[15]; ?></td>
<td align="center"><form name="form1" method="post" action="doupdateICT7.php?id=<?php echo $row[0];?>">
<label for="textfield"></label>
<input type="text" name="qty" id="textfield" size="4" min="0" max="100" >
<input type="submit" name="button" id="button" value="Submit">
</form></td>
</tr>
<?php
}
?>
</table>
</td>
</tr>
<tr>
<td><?php if (!empty($_GET['error'])) {
if ($_GET['error'] == 2) {
echo '<h3>Berhasil Input</h3>';}
}
?></td>
</tr>
<tr>
<td>�</td>
</tr>
<tr class="c">
<td class="c">�</td>
</tr>
<tr>
<td></td>
</tr>
</table>
<p>�</p>
<p>�</p>
</body>
</html>
ini Gambarnya karena ane pilih angkatan 1 jadi munculnya cuma nilai angkatan 1
Spoiler for ss :
terus ane input 100 buat..alfa..
kodingan nya itu doupdateICT1.php
Spoiler for update :
<?php
include "Connect.php";
session_start();
$id=$_REQUEST['id'];
$qty=$_REQUEST['qty'];
mysql_query("update msNama set Nilai_ICT='".$qty."' where ID_nama='$id' ");
header("location:home4.php?error==2&id;=$id&qty;=$qty");
?>
Nilai 100 nya itu berhasil ke input dan dia balik ke halaman home4.
yang jadi masalahnya kok malah semua angkatan yang muncul..
bukan angkatan 1 seperti yng awal ane pilih.
jadinya gini
Spoiler for ss :