Bunun için kullanıcının girdiği verileri aşağıdaki şekilde diziye attım..Ayrıca checkbox seçili hale getirdiğinde üye numarasını aldırıyorum.Aşağıdaki şekilde diziye atıyorum.
Kod: Tümünü seç
<input name="adet[]" value="<?php echo$satir[12];?>" type="text" size="10" >
<INPUT TYPE="checkbox" NAME="uyeno[]" value="<?php echo$satir[0];?>">
Kod: Tümünü seç
$uyeno=$_POST['uyeno'];
$adetimiz=$_POST['adet'];
array_keys($adetimiz,$uyeno);
foreach($adetimiz as $uyeno =>$k )
{
if ($submit=='SEPETE AT')
{
Echo "Adet $k";
Echo "Üye Numarasi $uyeno";
$s=mysql_query("Update volvocatalog set siparis='1',username='$username',adet='$k' WHERE id='$uyeno'", $baglan) or die("Sorguda hata var");
$volvo_search=$HTTP_GET_VARS["volvo_search"];
//echo"<meta http-equiv=\"refresh\" content=\"1;URL=".$_SERVER['PHP_SELF']."\">";
}//if'in end'i Sepete ata ait
} //foreach end'i
}//post'in end'i
İç ice for each kullanmayı denedim olmadı...
Problemim kullanıcının girdiği 2 değeri diziden alıp sorguda belirtmek..
Aşağıda tüm kodları gönderdim..
Lütfen acil olarak yardım ederseniz çok memmun olurum..
Kod: Tümünü seç
<?php
ob_start("ob_gzhandler");
?>
<? $baglan = mysql_connect ("localhost", "root", "triadpass");
$sec = mysql_select_db("nas",$baglan);
if (isset($_POST['submit']))
{
$submit=$HTTP_POST_VARS["submit"];
session_start();
$username = $_SESSION['User']['UserName'];
$uyeno=$_POST['uyeno'];
$adetimiz=$_POST['adet'];
array_keys($adetimiz,$uyeno);
foreach($adetimiz as $uyeno =>$k )
{
if ($submit=='SEPETE AT')
{
Echo "Adet $k";
Echo "Üye Numarasi $uyeno";
$s=mysql_query("Update volvocatalog set siparis='1',username='$username',adet='$k' WHERE id='$uyeno'", $baglan) or die("Sorguda hata var");
$volvo_search=$HTTP_GET_VARS["volvo_search"];
//echo"<meta http-equiv=\"refresh\" content=\"1;URL=".$_SERVER['PHP_SELF']."\">";
}//if'in end'i Sepete ata ait
} //foreach end'i
}//post'in end'i
else{
$ct=$HTTP_GET_VARS[ct];
$volvo_search=$HTTP_GET_VARS[volvo_search];
session_start();
$username = $_SESSION['User']['UserName'];
//--------- SORGU ----------------------//
$sayfa = $_GET["sayfa"];
if(!$sayfa) $sayfa = 1;
$kacar=10 ;
if($ct<>"1")
{
$toplam=mysql_num_rows(mysql_query("select distinct orgno,id,ntno,description,picture,catalognotes from volvocatalog where ntno like '%$volvo_search%' or orgno like '%$volvo_search%' or description like '%$volvo_search%' order by id "));
$kacsayfa = ($toplam / $kacar)+1;
$kactan = ($sayfa-1) * $kacar;
}
if($ct==1)
{
$toplam2=mysql_num_rows(mysql_query("select distinct orgno,id,ntno,description,picture,catalognotes from volvocatalog where ntno like '%$volvo_search%' or orgno like '%$volvo_search%' or description like '%$volvo_search%' order by id "));
$kacsayfa = ($toplam2 / $kacar)+1;
$kactan = ($sayfa-1) * $kacar;
}
if($ct<>"1")
{
$sql="select * from volvocatalog where ntno like '%$volvo_search%' or orgno like '%$volvo_search%' or description like '%$volvo_search%' limit $kactan,$kacar";
$sorgu=mysql_query($sql,$baglan);
}
if($ct==1)
{
$sql="select * from volvocatalog where ntno like '%$volvo_search%' or orgno like '%$volvo_search%' or description like '%$volvo_search%' limit $kactan,$kacar";
$sorgu=mysql_query($sql,$baglan);
}
?>
<HTML xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="http://www.w3.org/TR/REC-html40">
<HEAD>
<meta http-equiv="Content-Language" content="tr">
<TITLE> </TITLE>
<style type="text/css">
<!--
.style1 {
color: #FFFFFF;
font-weight: bold;
}
.style6 {font-size: 14px; font-weight: bold; color: #FFFFFF; }
.stok_hand {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10pt; text-decoration: none; cursor: hand}
-->
</style>
</HEAD>
<link rel=stylesheet href='form/format.css'>
<body bgcolor="#FFFACD"> <center>
<form method="post" action='<?=$_SERVER['PHP_SELF']?>'> <p> </p>
<table width="783" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="783"><table width="783" height="167" border="0" align="right" bgcolor="#FF0000">
<tr bgcolor="#FFEBCD">
<td width="777" height="37" bgcolor="#003399" valign="middle">
<p align="center" class="style1">VOLVO CATALOG </td>
</tr>
<tr bgcolor="#993333">
<td width="777" height="96" align="right">
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#111111" id="AutoNumber1" style="border-collapse: collapse">
<tr bgcolor="#993333">
<td width="36%" height="37" align="center"><span class="style6">PICTURE</span></td>
<td width="9%" align="center"><span class="style6">NT. REF </span></td>
<td width="9%" align="center"><span class="style6">ORG. REF </span></td>
<td width="20%" align="center"><span class="style6">DESCRIPTION</span></td>
<td width="11%" align="center"><span class="style6">NOTES</span></td>
<td width="12%" align="center"><div align="center"><span class="style6">QUANTFY</span></div></td>
<td width="3%" align="center"> </td>
</tr>
<?php $i=0;
while($satir = mysql_fetch_array($sorgu))
{
$i++; ?>
<tr bgcolor="#efefef" >
<? $picture="$satir[9].jpg";?>
<td width="36%" height="206"> <div align="center"><font color="#CC0000" face="Arial, Helvetica, sans-serif"><img src="/html/volvo_picture/<?php echo $picture;?>" width="238" height="161" align="middle" border="0"></font></div></td>
<td width="9%"> <?php echo$satir[4];?> <div align="center"></div></td>
<td width="9%"> <?php echo$satir[5];?> <div align="center"></div></td>
<td width="20%"> <?php echo$satir[6];?>
<div align="center"></div></td>
<td><?php echo$satir[7];?>
<div align="center"></div></td>
<td><div align="center">
<input name="adet[]" value="<?php echo$satir[12];?>" type="text" size="10" >
</div></td>
<td width="3%">
<div align="center">
<INPUT TYPE="checkbox" NAME="uyeno[]" value="<?php echo$satir[0];?>">
</div></td></tr>
<? } echo$i; ?>
</table>
<table width="777" border="0" bgcolor="#FF0000" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#FF0000">
<div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif">
<?}Echo "$toplam adet müþteri";?>
</font></div></td>
</tr>
<tr>
<td bgcolor="#FF0000"><b><font face="Arial, Helvetica, sans-serif" size="2" color="#FFFFFF"> <?Echo "$sayfa".".sayfa";?> </font></b></td>
</tr>
<tr>
<td bgcolor="#FF0000"> <b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" onMouseOut="bgColor='#EFEFEF'" class="stok_hand"><?echo "<br>";
for($i=1; $i < $kacsayfa; $i++)
{
echo "<a href=volvo_finds.php?sayfa=".$i."&volvo_search=".urlencode($volvo_search).">".$i."</a>\n";
}
?> </font></b></td>
</tr>
</table></td>
<tr bgcolor="#87CEFA">
<td width="777" height="1" bgcolor="#003399"> <p align="center">
<input type="submit" name="submit" value="SEPETE AT">
</tr>
</table></td>
</tr>
</table>
</form>
</center>
</body>
</HTML>