how to entry multi record to database ?

Discussion in 'PHP' started by VeRSioN, Jan 20, 2008.

  1. #1
    hi, i have a complicated problem..

    when i printed result to screen it is showing like this

    Name1 < input >
    Name2 < input >
    Name3 < input >

    and then i am putting some values into each row

    Name1 50
    Name2 80
    Name3 45

    when i submited this form values are updating, but each row value is equal last row's value. so ;

    Name1 45
    Name2 45
    Name3 45..

    if i try puting any value in first or second input then it isn't updating. i can put only last row input..

    my code is like that:

    
    <div id="veriler" align="left">
    <?php 
    if(isset($_POST['submit']))
    {
    	include "../db.con.php";
    	
    	$total = $_POST['total'];
    
    	$i = 0;
    	
    	$vize = $_POST['vize'];
    	$final = $_POST['final'];
    	$but = $_POST['but'];
    	$devamsizlik = $_POST['devamsizlik'];
    	
    	for($i = 1; $i <= $total; $i++)
    	{
    		if(isset($_POST["d$i"]))
    		{
    			
    			$idgoster = $_POST["d$i"];
    			
    			echo $idgoster;
    			
    			mysql_query("UPDATE `database` SET vize = '$vize' , final = '$final' , but = '$but' , devamsizlik = '$devamsizlik' WHERE id= '$idgoster' ") or die ( mysql_error());
    			
    			$td++;
    		}
    	}
    
    	
    	
    	mysql_close($con);
    	
    }
    ?>
    <form method="POST" action="">
    	
    <?php
    
    
    
    include "../db.con.php";
    
    $derskodu = $_GET['derskodu'];
    
    $query  = "SELECT id,derskodu,ogrencino,adsoyad,vize,final,but,durum,devamsizlik FROM `database` where derskodu='$derskodu'";
     
    $result = mysql_query($query) or die ( mysql_error());
    
    
    $renkchange=0;
    
    $n=0;
    
    $i=0;
    
    echo '<table border=0 width="800" cellpadding="0" bordercolor="#C0C0C0" cellspacing="0">';
    
    while(list($id, $derskodu, $ogrencino, $adsoyad, $vize, $final, $but, $durum, $devamsizlik) = mysql_fetch_array($result))
    
    {
    $n++;
    $i++;
    $renkchange++;	
    
    
     if (($renkchange % 2)== "0"){ $renk="#f5f5f5";} else { $renk="#e5e5e5";}
    
    ?>
    
    		<tr bgcolor="<?php echo $renk;?>">
    			<input type="hidden" name="<?php echo 'd'.$n;?>" value="<?php echo $id;?>">
    			<td width="150" class="no"><?php echo $ogrencino; ?></td>
    			<td width="240" class="adsoyad"><?php echo $adsoyad; ?></td>
    			<td width="60" class="vize"><input class="inputx" type="text" value="<?php echo $vize;?>" name="vize" size="3" maxlength="3"></td>
    			<td width="60" class="final"><input class="inputx" type="text" value="<?php echo $final;?>" name="final" size="3" maxlength="3"></td>
    			<td width="60" class="but"><input class="inputx" type="text" value="<?php echo $but;?>" name="but" size="3" maxlength="3"></td>
    			<td width="130" class="devam">
    			<input type="radio" class="check" value="0" name="<?php echo $ogrencino; ?>" checked> Geçti <input type="radio" class="check" value="1" name="<?php echo $ogrencino; ?>"> Kaldı</td>
    			<td width="100" class="durum"><?php if($durum == "0"){echo "ALIYOR";} elseif ($durum == "1") {echo "GEÇTİ";} else {echo "KALDI";} ?></td>
    		</tr>
    
    	<?php }
    
    	echo '</table>';
    	
    	mysql_close($con); ?>
    	
    	<input name="total" type="hidden" id="total" value="<?php echo $n;?>">
    	<br><br><input class="buton" type="submit" value="Kaydet" name="submit">
    </form>	
    	</div>
    
    PHP:
     
    VeRSioN, Jan 20, 2008 IP
  2. VeRSioN

    VeRSioN Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    i found solution.. =)



    
    <div id="veriler" align="left">
    <?php 
    if(isset($_POST['submit']))
    {
    	include "../db.con.php";
    	
    	$total = $_POST['total'];
    
    	$i = 0;
    	
    	
    	$devamsizlik = $_POST['devamsizlik'];
    	
    	/* for($i = 1; $i <= $total; $i++)
    	{
    		if(isset($_POST["d$i"]))
    		{
    			
    			$idgoster = $_POST["d$i"];
    			
    			echo $idgoster;
    			
    			mysql_query("UPDATE `database` SET vize = '$vize' , final = '$final' , but = '$but' , devamsizlik = '$devamsizlik' WHERE id= '$idgoster' ") or die ( mysql_error());
    			
    		}
    	}
    	*/
    	
    	while ($i <= $total)
    	{
    		
    	$i++;
    		
    	$vize = $_POST[vize.$i];
    	$final = $_POST[finalz.$i];
    	$but = $_POST[but.$i];
    		
    		if(isset($_POST["d$i"]))
    		{
    			
    			$idgoster = $_POST["d$i"];
    					
    			mysql_query("UPDATE `database` SET vize = '$vize' , final = '$final' , but = '$but' , devamsizlik = '$devamsizlik' WHERE id= '$idgoster' ") or die ( mysql_error());
    			
    			$td++;
    		}
    		
    		
    	}
    
    	
    	
    	mysql_close($con);
    	
    }
    ?>
    <form method="POST" action="">
    	
    <?php
    
    
    
    include "../db.con.php";
    
    $derskodu = $_GET['derskodu'];
    
    $query  = "SELECT id,derskodu,ogrencino,adsoyad,vize,final,but,durum,devamsizlik FROM `database` where derskodu='$derskodu' ORDER BY `database`.`ogrencino` ASC";
     
    $result = mysql_query($query) or die ( mysql_error());
    
    
    $renkchange=0;
    
    $n=0;
    
    $i=0;
    
    echo '<table border=0 width="800" cellpadding="0" bordercolor="#C0C0C0" cellspacing="0">';
    
    while(list($id, $derskodu, $ogrencino, $adsoyad, $vize, $final, $but, $durum, $devamsizlik) = mysql_fetch_array($result))
    
    {
    $n++;
    $i++;
    $renkchange++;	
    
    
     if (($renkchange % 2)== "0"){ $renk="#f5f5f5";} else { $renk="#e5e5e5";}
    
    ?>
    
    		<tr bgcolor="<?php echo $renk;?>">
    			<input type="hidden" name="<?php echo 'd'.$n;?>" value="<?php echo $id;?>">
    			<td width="150" class="no"><?php echo $ogrencino; ?></td>
    			<td width="240" class="adsoyad"><?php echo $adsoyad; ?></td>
    			<td width="60" class="vize"><input class="inputx" type="text" value="<?php echo $vize;?>" name="vize<?php echo $n;?>" size="3" maxlength="3"></td>
    			<td width="60" class="final"><input class="inputx" type="text" value="<?php echo $final;?>" name="finalz<?php echo $n;?>" size="3" maxlength="3"></td>
    			<td width="60" class="but"><input class="inputx" type="text" value="<?php echo $but;?>" name="but<?php echo $n;?>" size="3" maxlength="3"></td>
    			<td width="130" class="devam">
    			<input type="radio" class="check" value="0" name="<?php echo $ogrencino; ?>" checked> Geçti <input type="radio" class="check" value="1" name="<?php echo $ogrencino; ?>"> Kaldı</td>
    			<td width="100" class="durum"><?php if($durum == "0"){echo "ALIYOR";} elseif ($durum == "1") {echo "GEÇTİ";} else {echo "KALDI";} ?></td>
    		</tr>
    
    	<?php }
    
    	echo '</table>';
    	
    	mysql_close($con); ?>
    	
    	<input name="total" type="hidden" id="total" value="<?php echo $n;?>">
    	<br><br><input class="buton" type="submit" value="Kaydet" name="submit">
    </form>	
    	</div>
    
    PHP:
     
    VeRSioN, Jan 20, 2008 IP