0
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $row['Inq_id']; ?>"></td>

<td colspan="5" align="left" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td></tr>


<?php
foreach( $_GET['checkbox'] as $del_id ){

     $sql = "DELETE FROM Inq_cat WHERE Inq_id='$del_id'"; 
     $result = mysql_query($sql);
	}
?>

Edited by Ezzaral: Added code tags. Please use them to format any code that you post.

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by kiran33
0

Use array in field name.
When form is submitted using foreach delete each element.

<?php
if(isset($_POST['delete']))
{
	$checkboxAll = $_POST['checkbox'];
	foreach( $checkboxAll as $key=>$del_id )
	{
		$sql = "DELETE FROM Inq_cat WHERE Inq_id='$del_id'";
		$result = mysql_query($sql);
	}
	header("location:index.php");
	exit;
}
?> 
<form name="frm" id="frm" method="post">
<input name="checkbox[]" type="checkbox" value="1" /> Cat name 1
<input name="checkbox[]" type="checkbox" value="2" /> Cat name 2
<input name="checkbox[]" type="checkbox" value="3" /> Cat name 3
<input name="delete" value="delete" type="submit" />
</form>
0
<?php 
	
include("Connectivity.php");
include("Main_Temp.php");
function main()
{	
?>
<head>
<link rel="stylesheet" href="style.css"/>
<title>View Detail</title>
<link href="css/css.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="jquery-1.2.1.pack.js"></script>
<script type="text/javascript">
	function lookup(inputString) {
		if(inputString.length == 0) {
			// Hide the suggestion box.
			$('#suggestions').hide();
		} else {
			$.post("rpc8.php", {queryString: ""+inputString+""}, function(data){
				if(data.length >0) {
					$('#suggestions').show();
					$('#autoSuggestionsList').html(data);
				}
			});
		}
	} // lookup
	
	function fill(thisValue) { 
		$('#inputString').val(thisValue).focus();;		
		setTimeout("$('#suggestions').hide();", 200);
	}
</script>

<style type="text/css">
	body {
		font-family: Helvetica;
		font-size: 2px;
		color: #000;
	}
	
	h3 {
		margin: 0px;
		padding: 0px;	
	}

	.suggestionsBox {
		position: relative;
		left: 30px;
		margin: 10px 0px 0px 0px;
		width: 200px;
		background-color: #212427;
		-moz-border-radius: 7px;
		-webkit-border-radius: 7px;
		border: 2px solid #000;	
		color: #fff;
	}
	
	.suggestionList {
		margin: 0px;
		padding: 0px;
	}
	
	.suggestionList li {
		
		margin: 0px 0px 3px 0px;
		padding: 3px;
		cursor: pointer;
	}
	
	.suggestionList li:hover {
		background-color: #659CD8;
	}
</style>
</head>

<body>
<?php
//print_r($_GET);
//foreach( $_GET['checkbox'] as $del_id ){
//
//     $sql = "DELETE FROM Inq_cat WHERE Inq_id='$del_id'"; 
//     $result = mysql_query($sql);
//	 echo $result;
//	}

	if(isset($_GET['delete']))
{
$checkboxAll = $_GET['checkbox'];
foreach( $checkboxAll as $key=>$del_id )
{
$sql = "DELETE FROM Inq_cat WHERE Inq_id='$del_id'";
$result = mysql_query($sql);
echo $result;
}
header("location:Inq_cat_view.php");
exit;
}



if($_REQUEST['All'])
{
  $result = mysql_query("SELECT * FROM Inq_cat where Dels='N' order bY Inq_nm asc");
  $count=mysql_num_rows($result); 
}


if($_REQUEST['inputString'])
{
  $veh=$_REQUEST['inputString'];
  $result = mysql_query("SELECT * FROM Inq_cat where Inq_nm like '$veh%' and Dels='N' order by Inq_nm asc");
  $count=mysql_num_rows($result); 
}
else
{   
  $result = mysql_query("SELECT * FROM Inq_cat where Dels='N'");
  $count=mysql_num_rows($result); 


if (isset($_GET['pageno']))
 {
   $pageno = $_GET['pageno'];
 }
else
 {
	$pageno = 1;
 }


  $query_data = mysql_fetch_row($result);
  $numrows=mysql_num_rows($result);
// 3. Calculate number of $lastpa

  $pno=$_GET['psize'];
  if($pno==0)
   {
     $pno=15;
   }

  $rows_per_page = $pno;

  $lastpage = ceil($numrows/$rows_per_page);

// 4. Ensure that $pageno is within range
   $pageno = (int)$pageno;
   if ($lastpage == 1)
	 {
		$pageno = 1;
	 } 
   else if ($pageno >= $lastpage)
     {
        $pageno = $lastpage;
     }
	 

$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;

$query = "SELECT * FROM Inq_cat where Dels='N' order by Inq_nm $limit";
$result = mysql_query($query);
$count=mysql_num_rows($result);
}

?>
<form method="get" action="Inq_cat_view.php" name="frmcover">

<table>
<tr>
	<td height="1px"></td>
</tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" width="95%">
	<tr height="30px" >
	 <td colspan="10">
	  <table width="100%">
		<tr>
			<td align="left"  class="txt"><font color="#AA0000">&nbsp;
				<b>Inquiry Master View</b></font>			</td>
			<td align="right">
			[<a href="Inq_cat.php" style="text-decoration:none"><font color="#AA0000" class="txt">Add</font></a>]
			[<a href="Main.php" style="text-decoration:none" ><font color="#AA0000" class="txt">Close</font></a>]
			</td>
		</tr>
		<tr>
			<td colspan="2">

		</tr>
	 </table>
    </td>
    </tr>


<tr height="3px"><td colspan="9"></td></tr>

<?php
if($count!="")
{
?>


<tr align="right"> <td colspan="10"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="4%" style="padding-left:10px;">Inquiry Type :</td>
        <td width="4%"><input type="text" id="inputString" name="inputString" onKeyUp="lookup(this.value);"  onblur="fill();">
		<div class="suggestionsBox" id="suggestions" style="display: none;">
				<img src="upArrow.png" style="position: relative; top: -12px; left: 30px;" alt="upArrow" />
				<div class="suggestionList" id="autoSuggestionsList"></td>
        <td width="4%"></td>
        <td width="10%">&nbsp;</td>
        <td width="18%" align="right">
		<?php if($_REQUEST['inputString']==""){ ?>Page Size &nbsp;&nbsp;
          <input type="text" name="psize" size="3" style="text-align:center"  maxlength="2" onKeyPress="return onlyNumbers(event)" value="<?php echo $pno;?>"/>&nbsp;&nbsp;<input type="submit" name="submit" value="Go" class="submit"/>
		 <?php }
		 else
		 {?>
		 <input type="submit" name="All" value="All" class="submit">
		 <?php }
		  ?>
		 </td>
      </tr>
      </table>
	 </td></tr>
<tr height="3px"><td colspan="9"></td></tr>
<tr>

</tr>

<tr bgcolor="#B7A97B" height="30">
<td align="center" width="4%" class="txt1">#</td>
<td align="center" width="4%" class="txt1">Serial No</td>
<td align="left" width="45%" style="padding-left:10px;" class="txt1"> Inquiry Type</td>
<td align="left" width="40%" style="padding-left:10px;" class="txt1">Remarks</td>

<td align="center" width="11%" colspan="2" class="txt1"> Action</td>

</tr>

<?php
		if($pageno==1)
		{	$sr=1; }
		else
		{
			$sr=(($pno*($pageno-1))+1);
			
		
		}
		
		function dateconvert($date,$func) 
		{
				if ($func == 1)
					{ //insert conversion
						list($day, $month, $year) = split('[/.-]', $date); 
						$date = "$year-$month-$day"; 
						return $date;
					}
					
				if ($func == 2)
				{ //output conversion
						list($year, $month, $day) = split('[-.]', $date); 
						$date = "$day-$month-$year"; 
						return $date;
				}

		} 
	
		while($row = mysql_fetch_array($result))
		{
			
							
			if(($sr%2)==0)
		  {
		  	 ?>
		  <tr onMouseOver="this.className = 'hlt';" onMouseOut="this.className = 'hlt1';" bgcolor="#EBEBEB" height="23" style="font-family:Tahoma; font-size:14px;">
		  
		<?php
		  }
		  else
		  {
		  	 ?>
		  <tr onMouseOver="this.className = 'hlt';" onMouseOut="this.className = 'hlt1';" height="25" style="font-family:Tahoma; font-size:14px;">
		  
		<?php
		  }
							
		$id=$row['Inq_id']; ?>
		
       <td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $row['Inq_id']; ?>"></td>
	<?php
		 echo "<td align=center>" . $sr. "</td>";
         echo "<td align=left style='padding-left:10px;'>" . $row['Inq_nm'] . "</td>";
		       echo "<td align=left style='padding-left:10px;'>" . $row['Inq_rem'] . "</td>";
		
		
		 echo "<td align=center width='50'> <a href=\" Inq_cat.php?action=Edit&srid=".$sr."&id=" .$id."\" class=edit>Edit</a></td>";
		 echo "<td align=center ><a href=\" Inq_cat.php?del=Delete&id=".$id. "\" class=edit>Delete</a></td>";
  

  echo "</tr>";
  $sr++;

}
?>
<tr>
<td colspan="5" align="left" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td></tr>
<?php
// 
//  // Check if delete button active, start this
// 
//  $delete = $_REQUEST['delete'];
// 
//  if( $delete != '' ){
// 
//   
// 
//   foreach( $checkbox as $del_id ){
// 
//     $sql = "DELETE FROM Inq_cat WHERE Inq_id='$del_id'";
// 
//     $result = mysql_query($sql);
//	
// 
//   
// }
//   }
// 
// ?>
 
</table>

<?php echo "<table width='50%' align='center'>";
if($_REQUEST['inputString']=="")
{
if ($pageno==1 and $lastpage==1)
	 {
		$next=$pageno+1;
		echo "<tr><td align=center> <img src=images/previous_button.PNG>   </td></td>";
		echo "<td align=center>";
		for ($i=1;$i<=$lastpage;$i++)
		{ 
		 if($i==$pageno)
		  {
			echo $i;
		  }
		  else
		   {
			echo "<a href='Inq_cat_view.php?pageno=$i&psize=$pno'  style=color:#383E47> $i</a>";
		  }
		}
		echo "</td>";
		echo "<td align=center><img src=images/next_button.PNG border=0> </a> ";
	 }
else if ($pageno <= 1)
	 {
		$next=$pageno+1;
		echo "<tr><td align=center><img src=images/previous_button.PNG border=0>  </td></td>";
		echo "<td align=center>";
		for ($i=1;$i<=$lastpage;$i++)
		{ 
		 if($i==$pageno)
		  {
			echo "<font size='+2'><a href='Inq_cat_view.php?pageno=$i&psize=$pno'  style=color:#383E47> $i</a></font>";
		  }
		  else
		   {
			echo "<a href='Inq_cat_view.php?pageno=$i&psize=$pno'  style=color:#383E47> $i</a>";
		  }
		}
		echo "</td>";
		echo "<td align=center> <a href=Inq_cat_view.php?pageno=$next&psize=$pno' style=color:#383E47><img src=images/next_button.PNG border=0> </a> ";
	 } 
else if($pageno >= $lastpage)
     {
			$prevpage = $pageno-1;
			echo "<td align=center> <a href='Inq_cat_view.php?pageno=$prevpage&psize=$pno' style=color:#383E47>   <img src=images/previous_button.PNG border=0></a></td>";
			echo "<td align=center>";
		for ($i=1;$i<=$lastpage;$i++)
		{ 
		  if($i==$pageno)
		  {
			echo "<font size='+2'><a href='Inq_cat_view.php?pageno=$i&psize=$pno'  style=color:#383E47> $i</a></font>";
		  }
		  else
		   {
			echo "<a href='Inq_cat_view.php?pageno=$i&psize=$pno' style=color:#383E47> $i</a>";
		  }
		}
		echo "</td>";	
		echo "<td align=center><img src=images/next_button.PNG border=0> </td>  ";
    } 
else 
     {  
	    $prevpage = $pageno-1;
		echo "<td align=center> <a href='Inq_cat_view.php?pageno=$prevpage&psize=$pno' style=color:#383E47> <img src=images/previous_button.PNG border=0></a></td> ";
		echo "<td align=center>";
		for ($i=1;$i<=$lastpage;$i++)
		{ 
		 if($i==$pageno)
		  {
			echo "<font size='+2'><a href='Inq_cat_view.php?pageno=$i&psize=$pno'  style=color:#383E47> $i</a></font>";
		  }
		  else
		   {
			echo "<a href='Inq_cat_view.php?pageno=$i&psize=$pno'  style=color:#383E47> $i</a>";
		  }
		}
		echo "</td>";		
 		$next=$pageno+1;
		echo "<td align=center> <a href='Inq_cat_view.php?pageno=$next&psize=$pno' style=color:#383E47><img src=images/next_button.PNG border=0>   </a> ";
		
    } 
}	
	}//end Of numcmp(Record Found)

//else record Not Found
else
{?>

<tr><td align="center"><font color="#3300CC" class="txt" size="+1" style="text-decoration:blink;">No Record Found</font></td></tr>
<?php 
}?>
<?php	
	echo "</tr></table>";
?>

</form>
</body>
<?php 
}
?>

but i using form method get not post
please suggest in our code
please implement in our code how writing code in which place.

Edited by Ezzaral: Added code tags. Please use them to format any code that you post.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.