bence hazir kodla boşummaktan ziyade olayı kavramaya calissaniz daha iyi olur.
normal html sayfada checkbox lar koyup bunu php ile okuyabiliyor musunuz?
mantığını anladım veritabanı sorununu çözdüm ancak silme işlemini yapamıyorum sil diyince bişe olmuyo en son kodlar bu şekilde nerde hata var acaba..
<?php
include("ayar.php");
$sor=mysql_query("select*from test_mysql");
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">#</td>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
</tr>
<?php
while($yaz=mysql_fetch_array($sor)){
$id=$yaz['id'];
$name=$yaz['name'];
$lastname=$yaz['lastname'];
$email=$yaz['email'];
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo "$id"; ?>"></td>
<td bgcolor="#FFFFFF"><?php echo "$id"; ?></td>
<td bgcolor="#FFFFFF"><?php echo "$name"; ?></td>
<td bgcolor="#FFFFFF"><?php echo "$lastname"; ?></td>
<td bgcolor="#FFFFFF"><?php echo "$email"; ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM test_mysql WHERE id='$del_id'";
$result = mysql_query($sql);
}
// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>bu kodda bi hata varmı burda sorun veriyor da
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>