PHP - Help With Deleting Rows In Database

I really need some huge help on deleting rows with check boxes. Im completly lost on how to do this. Read some examples online and even with the code being small to do this i cant figure it out on intergrading it with the code I wrote. sorry that the code is long on this. I have decent comments though. At the very bottom i have started writing the delete code. My problem is figuring out how to make the script know what check box is checked. I have a select all check box  java script on this page too



Code: [Select]
<form name="frm1" id="frm1" action="" method="post" 
15.onsubmit="javascript:return submitIt('frm1')">
  <p>
  <center>


    <table width="60%" border="1" cellspacing="1" cellpadding="0">
      <tr align="center">
       
      </tr>
      <tr align="center">
        <td><input type="checkbox" name="checkAll" value="x" id="checkall" onclick="checkUncheckAll('association[]', this.checked)" /></td>
        <td>Recipient</td>
        <td>Subject</td>
        <td>Sent</td>
        <td>read/unread</td>
        </tr>
<?php 



// find out how many rows are in the table 
$count3 = "SELECT  COUNT(*) FROM sent WHERE id = '".($_SESSION['user_id'])."'";;
$count2 = mysql_query($count3) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($count2);

$numrows = $r[0];

// number of rows to show per page
$rowsperpage = 10;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);


// get the current page or set a default
if (isset($_GET['sent']) && is_numeric($_GET['sent'])) {   

// cast var as int   
$currentpage = (int) $_GET['sent'];
} else {   
// default page num   
$currentpage = 1;
}// end if


// if current page is greater than total pages...
if ($currentpage > $totalpages) {   
// set current page to last page   
$currentpage = $totalpages;
}// end if

// if current page is less than first page...
if ($currentpage < 1) {   
// set current page to first page   
$currentpage = 1;

} // end if

// the offset of the list, based on current page 
$offset = ($currentpage - 1) * $rowsperpage;

// get the info from the db 
$count3 = "SELECT * FROM sent WHERE id = '".($_SESSION['user_id'])."' ORDER BY time DESC LIMIT $offset, $rowsperpage ";
$count2 = mysql_query($count3) or trigger_error("SQL", E_USER_ERROR);
// while there are rows to be fetched...
while ($list = mysql_fetch_assoc($count2)) {   
// these are variables to place in the echo
$sent_id = $list['sent_id'];
$recipient = $list['sendto'];
$subject = $list['subject'];
$read = $list['read'];


// grabs the time offset
$take3 = "SELECT time_offset FROM users WHERE id='".mysql_real_escape_string($_SESSION['user_id'])."'"; 
$take2 = mysql_query($take3) or die(mysql_error());
$take1 = mysql_fetch_array($take2);

$recieved = $list['time'];
// adds the users time offset to the inputed time
$time = ($recieved + $take1['time_offset']);
// sets default time to UTC then formats the inputed time that was offset with the users offset
date_default_timezone_set('UTC');
$user_offset = date('h:i:s a  M/d', $time);  

?>



<tr>
      <td><center><input type="checkbox" name="association[]" id="<?php echo $sent_id; ?>" value="1" /></center></td>

    </label></td>
       
    <td><center><a href="search_goaulds.php?goauld=<?php echo $recipient; ?>"><?php echo $recipient ?></a></center></td> 
   
       <td><center><a href="sent_view.php?sent_id=<?php echo $sent_id; ?>"><?php echo $subject ?></a></center></td>
   
       <td><center><?php echo $read ?></center></td> 
 
       <td><center><?php echo $user_offset ?></center></td>
   
     
    </tr>
     
        <?php } // while loop 
        ?>
    </table>

  </center>



<div class="deletecontainer">
<div class="delete">
<br/>
<input type="submit" name="delete" id="delete" value="Delete"></p>
</form>
</div>
</div>
<?php


if(isset($_POST['delete'])) {

                                         // if checkbox is checked with the matching sent_id
if(isset($_POST['sent_id'])) {

                                                                                      // then delete sent_id matching the checkbox id
                       mysql_query("DELETE FROM `sent` WHERE `sent_id`= '".($_POST['sent_id'])."'");




}
}

?>

Hi guys,

I am trying out this code but it does not work, any idea what I am doing wrong?

<?php
include 'connect.php';
$tbl_name="users";

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

?>
<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">&nbsp;</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>Firstname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Location</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Website</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo $rows['userID']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['firstname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['location']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['website']; ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?

if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}


if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=showusers2.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

I want to delete rows in a table of my database using check-box.
Here are my codes below:

Code: [Select]
<?php
$con = mysql_connect('localhost', 'root', '') or die ('Connection Failed');
mysql_select_db('img', $con) or die ('Connection Failed');
$display = mysql_query("SELECT * FROM photos WHERE email='$lemail'");
echo '<input type="submit" value="Delete" name="del"/>';
echo "<table>
<tr>
<th>#</th>
<th>Images</th>
<th>Image description</th>
<th>Delete</th>
</tr>";
while($row = mysql_fetch_array($display))
{
echo "<tr>";
 echo "<td>".$row['img_ID']."</td>";
  echo "<td><img src='folder/".$row['imaged']."' alt='alt text' width='100' height='100' class='thumb'/> </td>";
echo "<td>".$row['image_description']."</td>";
echo '<td><input type="checkbox" name="delete[]" value="'.$row['img_ID'].'"/></td>';
echo "</tr>";
}
echo "</table>";
echo "</form>";
if (isset($_POST['delete'])) {
$del = $row['img_ID'];
for($i=0;$i<count($_POST["delete"]);$i++)
{
if($_POST["delete"][$i] != "")
{
$str = "DELETE FROM photos WHERE img_ID='$del' ";
mysql_query($str);
echo "Record Deleted.";
}
} 
}
mysql_close($connect);
?>
Here are the problems:

1/ Not working at all, I mean no image is being deleted
2/ At then end, I display a message that the record has been deleted, but if I check multiple checkbox, it keeps writing the message "Records deleted" multiple times

My images are stored in a folder while its details in database...

Help, thank you 

Hi,
I am having difficulty deleting rows in my table using check boxes. I have all the check boxes displaying for each row and a delete button below the table. However when i click on the delete button it isnt deleting the checked rows, i have displayed the code below that i am using;

Code: [Select]
<?php 
  



$result = mysql_query("SELECT * FROM contact ORDER BY msg_id ASC");

echo "<table border='1'>
<tr>
<th>Delete</th>
<th>Message ID</th>
<th>Name</th>
<th>Email</th>
<th>Message</th>

</tr>";

while($row = mysql_fetch_array($result))
  {
  ?>
   <td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo $row['del_id']; ?>"></td>
   <?php
  echo "<td>" . $row['msg_id'] . "</td>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['email'] . "</td>";
  echo "<td>" . $row['msg'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
?>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>


<?php
// Check if delete button active, start this 
if(isset($_GET['delete'])) {

for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM contact WHERE id=".$_GET['del_id'];
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php 
if($result){

}
}
mysql_close();
?>
Please help
Thank you

Hi.

What am I doing wrong he

Code: [Select]
mysql_query("DELETE FROM availability WHERE id = '$_POST['id']'");
I am able to echo the id but I must be entering the post item incorrectly into the delete string.

Can anyone show me my mistake?

Thanks

Does anyone have a code that will automatically delete stuff out of the database after 30 days of being in there...?

i trying to delete messages out of my message database but im not sure if i'm using this code right
or there stuff missing to it :S

delete.php
<?php 
require_once('settings.php');
checkLogin('1 2');

$id=$_GET["msgs"];
mysql_query("DELETE messages FROM messages WHERE message_id='$id'");
?>

link usages to delete
<a href="delete.php?msgs=<? echo $row['message_id']  ?>">[X]</a>

I've tried reading through some of the threads but couldnt understand some of them.

I've made a newsfeed script which works how i want it to. Now i want to add the function to delete a row from the database from an "admin panel" on the website.

So far i have this:
<?php
include("includes.php");

doConnect();

$get_news = "SELECT id, title, text, DATE_FORMAT(datetime, '%e %b %Y at %T') AS datetime FROM newsfeed ORDER BY datetime DESC";

$result= mysqli_query($mysqli, $get_news)
or die(mysqli_error($mysqli));

while ($row = mysqli_fetch_array($result)) {
echo '<strong><font size="3">'. $row['title'] .' </font></strong><br/><font size="3">'. $row['text'] .'</font><br/><font size="2">'. $row['datetime'] .'</font><br/><br/><a href="delnews.php?del_id=' .$row['id']. '">
<strong>DELETE</strong></a>';}
?>
then my delnews.php is:
<?php
include("includes.php");

doConnect();

$query = "DELETE FROM newsfeed WHERE id = "$_POST['id']""; 

$result = mysql_query($query); 

echo "The data has been deleted."; 

?>
I believe the problem is $_POST['id']. i've tried different things in there but none work. It displays the echo line but doesnt actually delete anything.

I am new to php so this may be a stupid mistake, but try and play nice!

Thanks

Hi Everyone,

Im trying to add a delete button to the message inbox page of my website, where when delete is clicked, the checked messages get deleted from the database.
After a bit of research on google i have come up with the code below however i cant get it to work. I have replaced the mysql delete query with echo "checked"; just for debugging.


$query = mysql_query("SELECT * FROM users WHERE id='$id'");
$row = mysql_fetch_assoc($query);

$submit = $_POST['submit'];
$username = $row['username'];
$checked = $_POST['message'];

$messages_query = mysql_query("SELECT * FROM messages WHERE recipient='$username'");
if (mysql_num_rows($messages_query) > 0)
{
   while ($messages_row = mysql_fetch_array($messages_query))
   {

   

if ($messages_row['message_read'] == 0) { echo "<div style='background-color:#FFCCCC;'>"; }

$message_id = $messages_row['id'];
   

echo "<a href='message.php?id=$message_id'>";

echo "From: " . $messages_row['sender'];

echo "Subject: " . $messages_row['subject'] . "<br />";

echo "</a>";

echo "<form method='POST'><input type='checkbox' name='message[]' value='1' /></form>";

if ($messages_row['message_read'] == 0) { echo "</div>"; }
   }
}
else
{
   echo "No messages";
}

if ($submit)
{

if ($checked == "1")

{

echo "checked";

}
}
?>
<html>
<form method="POST">
<input type="submit" name="submit" value="Delete" />
</form>
</html>


I have also tried the following but i still cant get it to work:

if (isset($checked))

{

echo "checked";

}


Can anybody see where iv gone wrong?

Thanks

i am trying to delete files for a user, and then update the database with the new bandwhitch/free space.  here is my code:

http://pastebin.com/J2XE9Fip

i just can't figure out where i'm going wrong... 

thanks in advance

I'm creating a newsletter and the unsubscribe isn't deleting the database entry like I'm asking it to. Everything else works fine, it even successfully says the user has been removed, but it doesn't actually delete the database entry.

I've spent  two days trying to figure out why. Here's the code:

Newsletter sign up:
 

<?php
//DB Connect Info
$servername = "";
$database = "";
$username = "";
$password = "";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

/*$createTable = $conn->prepare ("CREATE TABLE IF NOT EXISTS email_user (
  id int(11) NOT NULL AUTO_INCREMENT,
  email varchar(200) NOT NULL,
  hash varchar(250) NOT NULL,
  PRIMARY KEY (id)
)");

$createTable->execute();
*/

function input_security($data)
{
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $data;
}

$email = input_security($_POST['email']);

$insertData = input_security($insertData);

if(isset($_POST['submit']))
{  
  extract($_POST);
  if($email!="") :
    $email=mysqli_real_escape_string($conn,$email);
    $emailval = '/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$/';    
    if(preg_match($emailval, $email)) :
      $db_check=$conn->query("SELECT * FROM email_user WHERE email='$email'");
      $count=mysqli_num_rows($db_check);
      if($count< 1) :         
         $hash=md5($email.time());
         $link = '/unsubscribe.php?key='.$hash;

        // Change your domain        
         $fetch=$conn->query("INSERT INTO email_user(email,hash) VALUES('$email','$hash')");
         $to="$email"; //change to ur mail address
         $strSubject="Maintenance Fee Relief, LLC | Email Subscription";
         $message = '<p>Thank you for subscribing with us.</p>' ;              
         $message .= '<p>Click here to unsubscribe your email : <a href="'.$link.'">unsubscribe</p>' ;              
         $headers = 'MIME-Version: 1.0'."\r\n";
         $headers .= 'Content-type: text/html; charset=iso-8859-1'."\r\n";
         $headers .= "From: info@";            
         $mail_sent=mail($to, $strSubject, $message, $headers);  
         $msg_sucess="Your request has been accepted!.";
      else :
        $msg="This $email email address is already subscribe with us.";
      endif;  
    else :
      $msg="Please enter your valid email id";
    endif;      
  else :
    $msg="Please fill all mandatory fields";
  endif;
}
?>

<div class="newsletter-sign-up-header-form">
<div id="logerror"><?php echo @$msg; ?><?php echo @$msg_sucess; ?></div>
<form  method="post">
<span><input type="email" name="email" placeholder="Email Address - Join Newsletter" class="newsletter-sign-up-header-email" required></span>
<span><button name="submit" value="submit" title="Submit" class="newsletter-sign-up-header-submit-button">Submit</button></span>
</form>
</div>

<?php
//DB Connect Info
$servername = "";
$database = "";
$username = "";
$password = "";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>

<?php
if(@$_GET['key']!=""):
    $hash=mysqli_real_escape_string($conn,$_GET['key']);
    $fetch=$conn->query("SELECT * FROM email_user WHERE hash = '$hash'");
    $count=mysqli_num_rows($fetch);
    if($count==1) :
      $row=mysqli_fetch_array($fetch);      
        $conn->query("DELETE email_user WHERE id='$user_id'");
        $msg="Your email id unsubscribe with us";
    else :
      $msg="Please click valid link.";
    endif;
else :
    header("Location:404.php");
endif;
?>

<!doctype html>
<html lang="en">
<head>
   <title>Unsubscribe</title>
</head>
<body>
    <div align="center">
    <h2><?php echo $msg; ?></h2>
        <a href="https://www.--.com">--.com</a>                                                
    </div>
    

 

Quote

 

 

Hello -
I'm opening my website up to visitors for free, and trying to bypass a login screen to go straight into the data content that was appearing after a user logged in.  I have an index.php file that included the following code at the beginning:

 <?php
session_start();
include("database.php");
include("login.php");
include("/vservers/skyranks/db_connect.php");
?>
<?header("Cache-control: private"); ?>
<html>


I deleted the "include("login.php"); line, and was successful at bypassing the username and login screen.  However, the page that is supposed to display the data content is incomplete.  In fact, it only displays my company's logo.

Any ideas as to why the data content is not showing up? 

Thank you for any help with this, as my php is quite novice at this point.

Regards -

Joe

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=334042.0

I have a bad way with words, so if the title doesnt make much sense nor my post, I apolagize!

But I am using a while loop and mysql_fetch_array to echo all information in a table in mysql.

With each entry, I have included a button that executes a delete query for that entry.

Code: [Select]
$delquery="DELETE FROM requests WHERE user = '".$row['user']."'";
mysql_query($delquery,$link2);
echo "<font size='19px' color='#009933'>User deleted from request database.When I click the button, the message is echod in every entry listed on the page, and nothing happens. I figured Id use delete from the username, so that way mysql will know which one to delete... but Idk when I think about it thats dumb and makes no sense. Im stuck.

This side of the application im trying to make is the admin side where I can process requests. After I process the request I delete it from the database so I know I processed it. I have no idea what query to use for this.

Anybody know how I could do this?

Thanks

<?php
require_once('upper.php');

require_once('database.php');
if(isset($_COOKIE['LoginIdCookie']))
{
echo '<h4>Welcome '.$_COOKIE['LoginIdCookie'].'</h4>';
}
else{ echo '<h4>Events</h4>';}
$result=mysqli_query($dbc,"select * from events") or die('Not Connected');
echo "<html>
<body>";
  echo "<form method='post' action='EventParticipator.php'>"; 
  echo "<u><h4>Please tick events in which you want to participate</h4></u>";
  /*echo "<table cellspacing='0' cellpadding='15'>
   <th><b>Event Title:</b></th>
   <th ><b>Event City:</b></th>
<th><b>Content:</b></th>
<th><b>Images:</b></th>
<th><b>Event Date:</b></th>";*/

//while($row=mysqli_fetch_array($result))
$row=mysqli_fetch_array($result);
for($i=0;$i<5;$i++)
{
$Title=$row['Title'];
$City=$row['City'];
$Content=$row['Content'];
//$Photo=$row['Photo'];
$Date=$row['Date'];
$EventId=$row['EventId'];
$Photo=$row['Photo'];
//echo $Photo;

echo "<tr><td><img src='$Photo' width='120' height='90'/></td><td>$City</td><td>,</td><td>$Date</td><td>:</td><td>$Title</td></tr>
<tr><td>$Content</td></tr>
<tr><td><a href='#'>Know more</a></td><td>/</td><td><a href='#'>Click here to participate</a></td></tr>"; 
}
//echo "<tr><td><input type='submit' name='submit' value='Participate'</td>";
if(isset($_COOKIE['LoginIdCookie']))
{
echo "<td><a href='log_out.php'>Log out</a></td>";
echo "<td><a href='EditActivity.php'>Edit Your Activities</a></td></tr>";
}
echo "</table></form></body></html>";
require_once('lower.php');
?>






Quote

Hi friends ..........
I write above code to display top 5 rows from the database but it not works properly. It displays first row 5 times which is undesireable.
Anyone please help?????????????????
thanks in advance..................