How to delete emails using checkboxes

this is d code:

Expand|Select|Wrap|Line Numbers

 <html>

<body>

<?php

$dbhost='localhost';

$dbuser='root';

$dbpass='';

$db='country1';

$connection=mysql_connect($dbhost,$dbuser,$dbpass) or die("unable to connect");

mysql_select_db($db) or die("unable to select");

session_start();
 
$_SESSION['userid']=$_COOKIE['userid'];

$q=$_SESSION['userid'];

$query="select * from inbox where receiverid='$q' GROUP BY (id) DESC";

$result=mysql_query($query);

if(!isset($_POST['submit']))

{

?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

<?php

if(mysql_num_rows($result)>0)

{

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

    while($row=mysql_fetch_row($result))

    {

        echo "<tr>";

            echo "<td><input type='checkbox' name='chk1[]' value='' ></td>";

            echo "<td><a href='abc.php?id=$row[0]'>$row[1] $row[2] $row[3]</a></td>";

            echo "</tr>";
 
    }

    echo "</table>";

}

?>

<input type="button" name="submit" value="delete">

</form>

<?php

}

else

{

$dbhost='localhost';

$dbuser='root';

$dbpass='';

$db='country1';-

$connection=mysql_connect($dbhost,$dbuser,$dbpass) or die("unable to connect");

mysql_select_db($db) or die("unable to select");

$c=$_POST['id'];

if (sizeof(id)>0)

{

foreach($c as $ca)

{

    $query="select * from inbox where id='$ca'";
 
    $result=mysql_query($query);

    if(mysql_num_rows($result)>0)

    {    

        while($row=mysql_fetch_row($result))

        {

        $q="insert into trash (inboxid,senderid,receiverid,subject,message,mdate) values ('$row[0]','$row[1]','$row[2]','$row[3]','$row[4]','$row[5]')";

        }

        $q1="delete * from inbox where id='$ca'";

    } 

}

}

}

?>

</body>

</html>

nothing happens when i check d checkbox n click delete button..pls rep as soon as psble n i'l b realy thnkful..

i need to store the content in trash table b4 deleting frm inbox..bt nothig of d two z hppng..

Aug 27 '10 #1

Subscribe Post Reply

819

Similar topics

delete files using CFile ?

by: German | last post by:

Hi Team : I do no know the procedure to delete file using CFile ?? or any other way (command or procedure) to reach this action. Thanks in advanced

.NET Framework

Can anyone provide a good example of using checkboxes in a repeater

by: Mark | last post by:

I am looking for an example of using checkboxes in a repeater control where the checkbox state is persisted from page to page. Thank you, Mark

ASP.NET

Sending Emails using C#

by: A | last post by:

Hi all! I would like to ask a question on sending emails... I have a web application that requires sending emails using email templates. The templates that I've made are separate HTML files...

ASP.NET

Deleting multiple records(rows) from tables using checkboxes

by: Patrick.O.Ige | last post by:

I have a datagrid with checkboxes.. When a user clicks one check box and clicks the delete button it deletes that ROw. There another situation when a user clicks multiple rows so i had to loop...

ASP.NET

sending emails using vb with outlook

by: Nicole | last post by:

I found this code below to use to send emails using VB with Outlook. However, it gives these errors. 'Send' is ambiguous across the inherited interfaces 'Outlook._MailItem' and...

Visual Basic .NET

how do i delete rows in datagrid by using checkboxes

by: shameem | last post by:

hi 2 all, my question is how to delete the records by using checkboxes in datagrid. pls give reply to my question.

.NET Framework

Sending Emails Using a macro

by: damimkader | last post by:

Hi, I'm trying to send emails using a Macro based on an Excel Sheet and the Email Client I'm using is Lotus Notes. OS used - Windows Xp. Language - VB Below is the Code I'm using for doing...

Visual Basic 4 / 5 / 6

Help Using Checkboxes to delete MySQL Rows.

by: recordlovelife | last post by:

Hey guys, ill try to make this simple. I want to make a GUI for a client so that they can delete news entries that they have posted. I figure I can code a site that will query the table for the news...

PHP

C#: add/show delete method using date time object

by: Shani Aulakh | last post by:

Hi there, I have a FolderWatcher.cs class that will monitor a given folder and delete files older than X number of days. I have the following methods. I need to add/show delete mothod using date...

.NET Framework

I have not declare any primary key of the table and I want to delete row using gridvi

by: mdbi | last post by:

i have not declared any primary key of table and I want to delete row using gridview or formview. Is it possible?

ASP.NET

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

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

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

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

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

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