checked(checkbox) row or rows to be deleted when button(delete) is clicked

Hi all,
I am new to php,my question is that in this following code i am retrieving many rows from the database which is working good.i want to delete a particular row(s) which is checked(checkbox) and this should be done when the deletecontact button is clicked and also should be deleted int the database also

Somebody help me out on this code

Expand|Select|Wrap|Line Numbers

 
<html>

<head>

<script type="text/javascript">

function SetAllCheckBoxes(FormName, FieldName, CheckValue)

{

    if(!document.forms[FormName])

        return;

    var objCheckBoxes = document.forms[FormName].elements[FieldName];

    if(!objCheckBoxes)

        return;

    var countCheckBoxes = objCheckBoxes.length;

    if(!countCheckBoxes)

        objCheckBoxes.checked = CheckValue;

    else

        // set the check value for all check boxes

for(var i = 0; i < countCheckBoxes; i++)
 
            objCheckBoxes[i].checked = CheckValue;

}

</script>

</head>

<body>
 
<?php include "menu.php";?>
 
<center><b>CONTACT INFO</b></center><br>
 
  <form method="post" onSubmit="<?=$PHP_SELF?>">
 
 <table border="0" cellpadding="0" cellspacing="0">
 
  <tr>

    <td>

        <table  border="0" cellpadding="0" cellspacing="0">

            <tr>

                <td style="padding-left:20px;padding-bottom:20px;"><a href="createcontact.php" style="text-decoration:none"><input type="button" name="new" value="CREATE CONTACT"  style="width:170px;background-image:url(pink.gif)"></a></td>

                <td style="padding-left:20px;padding-bottom:20px;"><a href="createlead.php" style="text-decoration:none"><input type="button" name="new" value="CREATE LEAD"  style="width:170px;background-image:url(pink.gif)"></a></td>

            </tr>
 
            <tr>

                <td style="padding-left:20px;"><a href="createaccount.php" style="text-decoration:none"> <input type="button" name="new" value="CREATE ACCOUNT"  style="width:170px;background-image:url(pink.gif)"></a></td>

                <td style="padding-left:20px;"> <a href="createopportunity.php" style="text-decoration:none"> <input type="button" name="new" value="CREATE OPPORTUNITY"  style="width:170px;background-image:url(pink.gif)"></a></td>

            </tr>

        </table>

    </td>
 
    <td style="padding-left:120px;">

        <table  cellpadding="8" cellspacing="0" with frame="box">        

        <tr>

            <td style="padding-left:10px;padding-bottom:20px;">LAST NAME</td>

            <td style="padding-left:60px;padding-bottom:20px;"><input type="text" name="lname"></td>

        </tr>
 
        <tr>

            <td style="padding-left:10px"><input type="submit" name="search" value="SEARCH"  style="width:80px;background-image:url(pink.gif)" ></td>

            <td style="padding-left:30px"><input type="reset" name="clear" value="CLEAR"  style="width:80px;background-image:url(pink.gif)" ></td>

        </tr>

        </table>

    </td>

  </tr>

</table>

<br/><br/>
 
<b><center>CONTACT LIST </center></b>
 
<br/>
 
 <?php

     include 'connect.php';

     $a= $_POST[lname];
 
 if(!$a==NULL)

{

    $res = mysql_query("SELECT * FROM createcontact where lname LIKE '%$a%' ");

?>   
 
   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

    <input type="button"  style="width:130px;background-image:url(pink.gif)" onclick="SetAllCheckBoxes('contacts', 'myCheckbox', true);" value="SELECT ALL">
 
<input type="button" style="width:130px;background-image:url(pink.gif)"onclick="SetAllCheckBoxes('contacts', 'myCheckbox', false);" value="SELECT NONE">

  <input type="button" name="delete" value="DELETE CONTACT"  style="width:130px;background-image:url(pink.gif)">
 
   </form>

    <table border="1" align="center" cellpadding="0" cellspacing="0" width="900" style="border:1px solid #ffaacc;">        <tr>

        <td width="50" align="center"><form name="contacts" onLoad="return false;"><input type="checkbox" name="myCheckbox"></td>

        <td>NAME</td>

        <td>TITLE</td>

        <td>A/C NAME</td>

        <td>EMAIL</td>

        <td>PHONE NO</td>

        <td>TEAM</td>

        <td>USER</td>

    </tr>
 
    <?

    while($row = mysql_fetch_array($res))

   {
 
    echo '<tr>';

    echo '<td width="50" align="center"><form name="contacts" onLoad="return false;"><input type="checkbox" name="myCheckbox"></td>';

    echo '<td >'.$row['lname'].'</td>';

    echo '<td >'.$row['title'].'</td>';

    echo '<td >'.$row['acname'].'</td>';

    echo '<td >'.$row['email'].'</td>';

    echo '<td >'.$row['phone'].'</td>';

    echo '<td >'.$row['team'].'</td>';

    echo '<td >'.$row['assignedto'].'</td>';

    echo '</tr>';
 
   }
 
   echo "</table>";

}

else

{
 
    $res = mysql_query("SELECT * FROM createcontact ");

?>

 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

    <input type="button"  style="width:130px;background-image:url(pink.gif)" onclick="SetAllCheckBoxes('contacts', 'myCheckbox', true);" value="SELECT ALL">
 
<input type="button" style="width:130px;background-image:url(pink.gif)"onclick="SetAllCheckBoxes('contacts', 'myCheckbox', false);" value="SELECT NONE">

  <input type="button" name="delete" value="DELETE CONTACT"  style="width:130px;background-image:url(pink.gif)">

</form>
 
 <table border="1" align="center" cellpadding="0" cellspacing="0" width="900" style="border:1px solid #ffaacc;">        <tr>
 
 <td width="50" align="center"><form name="contacts" onLoad="return false;"><input type="checkbox"  name="myCheckbox"></td>
 
        <td>NAME</td>

        <td>TITLE</td>

        <td>A/C NAME</td>

        <td>EMAIL</td>

        <td>PHONE NO</td>

        <td>TEAM</td>

        <td>USER</td>

    </tr>
 
</body> 

    <?

    while($row = mysql_fetch_array($res))

   {
 
    echo "<tr>";

    echo '<td width="50" align="center"><form name="contacts" onLoad="return false;"><input type="checkbox" name="myCheckbox"></td>';

    echo "<td>".$row['lname']."</td>";

    echo "<td>".$row['title']."</td>";

    echo "<td>".$row['acname']."</td>";

    echo "<td>".$row['email']."</td>";

    echo "<td>".$row['phone']."</td>";

    echo "<td>".$row['team']."</td>";

    echo "<td>".$row['assignedto']."</td>";

    echo "</tr>";
 
   }
 
    echo"</table>";?>
 
<?

    }    

?>
 
</form>

</body>

</html>

Mar 26 '09 #1

Subscribe Post Reply

4092

Markus

6,050

Expert 4TB

If you have multiple checkboxes on the same subject, you need to pass them as an array. You do this by appending brackets to the end of all the checkboxes name's. <input type="checkbox" name="delete_items[]" value="1" />

-- Assumes you're using POST --

Then, in PHP, you can traverse the array of selected checkboxes (if it exists) and perform actions on them accordingly.

Expand|Select|Wrap|Line Numbers

  
if ( count ( $_POST['delete_items'] ) > 0 )

{

    foreach ( $_POST['delete_items'] as $key => $val )

    {

        echo "{$key} -> {$val}<br />";

    }

}

else

{

    echo "No checkboxes passed.";

}

Mar 26 '09 #2

Similar topics

Textbox when radio button clicked

by: Bart Verbeke | last post by:

Hi, I have a form with 2 radio buttons (ACCEPT/REJECT). When the page is initially loaded, no textbox should be visible. When a user clicks the REJECT radio button, a textbox should...

Javascript

id of checked checkbox

by: Piotr | last post by:

how can I read (in alert for example) array index number of checked checkbox? I have: <input type="checkbox" id="id_number" name="check" value="1" onclick="show()"/> <input type="checkbox"...

Javascript

Breakpoint on a button Click does not 'break' when button clicked

by: L Mehl | last post by:

Hello -- My form's cmdCancel button requires 3 clicks before the code in Cancel_Click fires. Each click prior to that success moves the highlight to the next field in the Tab order . I...

Microsoft Access / VBA

Looping through repeater only finds first checked checkbox, not the rest

by: Alan Silver | last post by:

Hello, I have a repeater with a list of products in it. Each item in the repeater has a checkbox, allowing the product to be selected. When a link button is clicked, I want to loop through the...

ASP.NET

Have on option group but need one of the option buttons when clicked to allow editing to a certain field

by: tsnyder | last post by:

I need to have an option button that allows editing to a field only when it is checked.

Microsoft Access / VBA

Delete Rows From DataGrid

by: rn5a | last post by:

All the rows in a DataGrid are accompanied by a CheckBox. When a user checks the rows & clicks a Button, the checked rows get deleted. For e.g. assume that the DataGrid displays 10 rows. A user...

ASP.NET

Only allow one checked checkbox in a collection

by: Bishman | last post by:

Hi, I need to programmatically allow or disallow the selection of multiple checkboxes on a form . At certain times I only want to allow a single selection, at other times I may wish to allow...

C# / C Sharp

Delete With CheckBox POST

by: arizal | last post by:

Hi, I am having some problem trying to think how to write a code for deleting the entry which is loaded from the database. I have a while loop which pulls the userID, name etc from the database and...

PHP

Returning checked checkbox values

by: cyberdawg999 | last post by:

Greetings all in ASP land I have overcome one obstacle that took me 2 weeks to overcome and I did it!!!!! I am so elated!! thank you to all who invested their time and energy towards helping me...

ASP / Active Server Pages

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General