PHP - Delete Row From Db

I get registered spammers on my website, they seem to bypass captcha (manually spamming I believe) and we all know why IP ban is no good so I want to be able to simply delete all rows on my database where this user comes from.

Can you use one query to delete from all tables with WHERE userID= '$userID' ??

hi. just a quick question about a delete link i have on a page ive made.

basically with the code i have currently...nothing at all happens when i click delete...and i cant for the life of me see the problem.

here is the code for the page where the delete link is.

$sql=mysql_query("SELECT items.itemname, cat.catid, cat.category FROM items,cat WHERE cat.catid=items.catid");
$temp_item = "";
while($res=mysql_fetch_array($sql))
{
echo "<table cellpadding='0' cellspacing='0' width='700'><tr>";
if($res['category'] != $temp_cat )
    {
 echo "<td width='30%'>" . "<b>" . $res['category'] . "</b>" . "</td>" . "<td width='30%'><a href='delcat.php?id=$res[catid]'>Delete Category</a></td></tr>";
$temp_cat=$res['category'];
}




and here is the code for the delete page that should do the deleting.

include_once("config_class.php");

 $db = new db();         // open up the database object
 $db->connect();            // connect to the database

//getting id of the data from url
$id = $_GET['id'];

//deleting the row from table
$result=mysql_query("DELETE FROM cat WHERE listid=$id");

//redirecting to the display page (index.php in our case)
header("Location:list.php?id=$id");


as i said nothing happens...please help anybody?

nevermind delete

Hi,i know this is a duplicated thread but i have made changed to code and I have been trying to create a functionality which allows users to delete multiple entries from database, I have been working on this for a while now but cant get my head around it, can u please tell me what im doing wrong here?

thanks in advance

<?php

session_start();

include ("../global.php");
//welcome messaage
$username=$_SESSION['username'];
echo "$username";

$query=mysql_query("SELECT id FROM users WHERE username='$username'");
while($row = mysql_fetch_assoc($query))
{
$user_id = $row['id'];
echo $id;
}

$per_page=5;


$start=$_GET['start'];

$record_count =mysql_num_rows(mysql_query("SELECT * FROM rent"));
?>
<td><form name="form1" method="post" action=""> </td>
<?php
$max_page=$record_count/$per_page;

if(!$start)
$start=0;
$result= mysql_query("SELECT id, msg, title, reference FROM msg LIMIT $start, $per_page");
while($row = mysql_fetch_array($result))
{
            
$id=$row['id'];
$msg=$row['msg'];
$reference=$row['reference'];
$title=$row['title'];

?>



<table>


<tr>
    <td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
        <td><?php echo $title; ?></td>
        <td><?php echo $id; ?></td>
        <td><?php echo $reference; ?></td>
        <td><?php echo $msg; ?></td>


        </tr>
        
</table>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
        <?php
        
        //while
        }


$prev=$start - $per_page;
$next=$start + $per_page;        
        


if(!($start<=0))    
    echo    "<a href='view-data.php?start=$prev'>Previous</a>";
    
if(!($start>=$record_count-$per_page))
    echo    "<a href='view-data.php?start=$next'>Next</a>";    
if(isset($_POST['delete']))
{
    for($i = 0; $i <= count($_POST['checkbox']); $i++)
    {
        $del_id = $checkbox[$i];
        $sql = "DELETE FROM rent WHERE id='$del_id'";
        $result = mysql_query($sql);
    }
    

    if($result)
    {
        header('Location: view-data.php');
    }
}
?>

</table>
</form>

ok, so how would I insert a link to remove a photo from this code:
Code: [Select]
<?php
                  include("connect_to_mysql_1.php");

$query  = "SELECT link, id FROM products where page123=$page ORDER BY listorder ASC ";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{

$link = stripslashes($row['link']);
$id = stripslashes($row['id']);

?>
      <li id="arrayorder_<?php echo $id ?>"> <img src="<?php echo $link; ?>" width="300" height="250"/>
     
<div class="clear"></div>
      </li>
      <?php } ?>
     
    </ul>
the images are able to move around but I need to know a way to keep photos with their own delete link.  I am thinking of someway using listorder and the page123 to do it.  could anybody help.  I can't really think of a good way to describe the issue...

Hello, the user selects an id (sid) on select form then presses confirm button. Below is my delete function however I have error :

Warning: Missing argument 5 for dbstudent::delete_student(), called in C:\xampp\htdocs\cw1\delstudent.php on line 36 and defined in C:\xampp\htdocs\cw1\studentfunc.php on line 28
SQL Insertion error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(sid, name, address, postcode, photo) from student where values ('1', '', '', '' at line 1

Please advise!!

     function delete_student($sid, $name, $address, $postcode, $photo) {
        $esc_name = mysql_real_escape_string($name, $this->conn);
        $esc_address = mysql_real_escape_string($address, $this->conn);
        $esc_postcode = mysql_real_escape_string($postcode, $this->conn);
        $esc_photo = mysql_real_escape_string($photo, $this->conn);
        $sql = "delete (sid, name, address, postcode, photo) from student where
values ('{$sid}', '{$esc_name}', '{$esc_address}', '{$esc_postcode}', '{$esc_photo}')";

        $result = mysql_query($sql, $this->conn);

        if (!$result) {
            die("SQL Insertion error: " . mysql_error());
        } else {
            $numofrows = mysql_affected_rows($this->conn);
            return $numofrows;
        }
    }

I want to delete record which i clicked the delete button in the table.

I want a confirm box for delete

Help me solve..

Here is code display.php
Code: [Select]
<?php
$cn=mysql_connect("localhost","root","");

mysql_select_db("register",$cn);

$qry2=mysql_query("SELECT * FROM reg_table");
?>
<html>
<head>
<script type="text/javascript">

function show_confirm()
{
var r=confirm("Do you want to Delete?");
if (r==true) {
 
  }
else {
  alert("You pressed Cancel!");
  }
}

</script>
</head>
<body>
<form action="delete.php" method="get">

<table width="200" border="1">
  <tr>
    <th scope="col">Name</th>
    <th scope="col">Address</th>
    <th scope="col">Gender</th>
    <th scope="col">Qualify</th>
  </tr>
<?php
while($res=mysql_fetch_array($qry2))
{?>

  <tr>
    <td><?php echo $res['name']; ?></td>
    <td><?php echo $res['adrs']; ?></td>
    <td><?php echo $res['gender']; ?></td>
    <td><?php echo $res['qualify']; ?></td>
<td> <a href="edit.php?uid=<?php echo $res['id']; ?>">edit</a></td>
<!--<td>  <button type="button" onClick="return show_confirm();">Delete</button>  </td> -->
    <td> <input type="hidden" name="nid" value="<?php echo $res['id']; ?>" /> </td>
    <td> <input type="submit" value="Delete" name="del" onClick="return show_confirm();">
    </td>

  </tr>
<?php
}
?>

</table>
</form>

</body>
</html>
delete.php

Code: [Select]
<html>


<body>
<?php

$cn=mysql_connect("localhost","root","");

mysql_select_db("register",$cn);


$del_id=$_GET['nid'];
$qry=mysql_query("delete from reg_table where id='".$del_id."' ") or die(mysql_error());

if($qry) {
echo "deleted";
}
else {
echo "not deleted";
}
?>

<!--<form action="update.php" method="get">
<br />
Name:    <input name="name" type="text" maxlength="20" /><br /><br />

<input type="hidden" name="uno" value="// echo $id; ">

<input name="submit" type="submit" value="Save" />
</form>
-->
</body>
</html>

I am building a user interface to manipulate a database I have in mySQL and one of the functions is deleting records from a table I call Titles. Given my primary key is mID and a column in the table is Title, here is the code I'm working with:

$sql="delete from myDb.Titles where mID=" . $_GET['mID'];

if (mysql_query($sql))
{
    $target="delete.php?";
}

echo "Successfully deleted title: " . $_GET['Title'];

The actual delete itself is working fine and the record deletes properly. What I am trying to do is display the Title field associated with the record being deleted and it's not working. I don't know if I am misusing the GET function or not, but that's where I am. Any help would be appreciated.

This script add and delete data to the database, it add it correctly but it's not able to delete it.
I appreciate somebody more expert to me to help me.
thank you.

<?php
require 'include/db.inc.php';

$db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD) or
    die ('Unable to connect. Check your connection parameters.');
mysql_select_db(MYSQL_DB, $db) or die(mysql_error($db));

switch ($_POST['action']) {

case 'Add Character':

    // escape incoming values to protect database
    $alias = mysql_real_escape_string($_POST['alias'], $db);
    $real_name = mysql_real_escape_string($_POST['real_name'], $db);
    $address = mysql_real_escape_string($_POST['address'], $db);
    $city = mysql_real_escape_string($_POST['city'], $db);
    $state = mysql_real_escape_string($_POST['state'], $db);
    $zipcode_id = mysql_real_escape_string($_POST['zipcode_id'], $db);
    $alignment = ($_POST['alignment'] == 'good') ? 'good' : 'evil';

    // add character information into database tables
    $query = 'INSERT IGNORE INTO comic_zipcode
            (zipcode_id, city, state)
        VALUES
            ("' . $zipcode_id . '", "' . $city . '", "' . $state . '")';
    mysql_query($query, $db) or die (mysql_error($db));

    $query = 'INSERT INTO comic_lair
            (lair_id, zipcode_id, address)
        VALUES
            (NULL, "' . $zipcode_id . '", "' . $address . '")';
    mysql_query($query, $db) or die (mysql_error($db));

    // retrieve new lair_id generated by MySQL
    $lair_id = mysql_insert_id($db);
    $query = 'INSERT INTO comic_character
            (character_id, alias, real_name, lair_id, alignment)
        VALUES
            (NULL, "' . $alias . '", "' . $real_name . '", ' .
            $lair_id . ', "' . $alignment . '")';
    mysql_query($query, $db) or die (mysql_error($db));

    // retrieve new character_id generated by MySQL
    $character_id = mysql_insert_id($db);
    if (!empty($_POST['powers'])) {
        $values = array();
        foreach ($_POST['powers'] as $power_id) {
            $values[] = sprintf('(%d, %d)', $character_id, $power_id);
        }
        $query = 'INSERT IGNORE INTO comic_character_power
                (character_id, power_id)
            VALUES ' .
                implode(',', $values);
        mysql_query($query, $db) or die (mysql_error($db));
    }

    if (!empty($_POST['rivalries'])) {
        $values = array();
        foreach ($_POST['rivalries'] as $rival_id) {
            $values[] = sprintf('(%d, %d)', $character_id, $rival_id);
        }
       
        // alignment will affect column order
        $columns = ($alignment = 'good') ? '(hero_id, villain_id)' :
            '(villain_id, hero_id)';

        $query = 'INSERT IGNORE INTO comic_rivalry   
                ' . $columns . '
            VALUES
                ' . implode(',', $values);
        mysql_query($query, $db) or die (mysql_error($db));
    }

    $redirect = 'list_characters.php';
    break;

case 'Delete Character':

    // make sure character_id is a number just to be safe
    $character_id = (int)$_POST['character_id'];

    // delete character information from tables
    $query = 'DELETE FROM c, l
        USING
            comic_character c, comic_lair l
        WHERE
            c.lair_id = l.lair_id AND
            c.character_id = ' . $character_id;
    mysql_query($query, $db) or die (mysql_error($db));

    $query = 'DELETE FROM comic_character_power
        WHERE
            character_id = ' .  $character_id;
    mysql_query($query, $db) or die (mysql_error($db));

    $query = 'DELETE FROM comic_rivalry
        WHERE
            hero_id = ' . $character_id . ' OR villain_id = ' . $character_id;
    mysql_query($query, $db) or die (mysql_error($db));

    $redirect = 'list_characters.php';
    break;

case 'Edit Character':

    // escape incoming values to protect database
    $character_id = (int)$_POST['character_id'];
    $alias = mysql_real_escape_string($_POST['alias'], $db);
    $real_name = mysql_real_escape_string($_POST['real_name'], $db);
    $address = mysql_real_escape_string($_POST['address'], $db);
    $city = mysql_real_escape_string($_POST['city'], $db);
    $state = mysql_real_escape_string($_POST['state'], $db);
    $zipcode_id = mysql_real_escape_string($_POST['zipcode_id'], $db);
    $alignment = ($_POST['alignment'] == 'good') ? 'good' : 'evil';

    // update existing character information in tables
    $query = 'INSERT IGNORE INTO comic_zipcode
            (zipcode_id, city, state)
        VALUES
            ("' . $zipcode_id . '", "' . $city . '", "' . $state . '")';
    mysql_query($query, $db) or die (mysql_error($db));

    $query = 'UPDATE comic_lair l, comic_character c
            SET   
                l.zipcode_id = ' . $zipcode_id . ',
                l.address = "' . $address . '",
                c.real_name = "' . $real_name . '",
                c.alias = "' . $alias . '",
                c.alignment = "' . $alignment . '"
        WHERE
            c.character_id = ' . $character_id . ' AND
            c.lair_id = l.lair_id';
    mysql_query($query, $db) or die (mysql_error($db));

    $query = 'DELETE FROM comic_character_power
        WHERE
            character_id = ' . $character_id;
    mysql_query($query, $db) or die (mysql_error($db));

    if (!empty($_POST['powers'])) {
        $values = array();
        foreach ($_POST['powers'] as $power_id) {
            $values[] = sprintf('(%d, %d)', $character_id, $power_id);
        }
        $query = 'INSERT IGNORE INTO comic_character_power
                (character_id, power_id)
            VALUES
                ' . implode(',', $values);
        mysql_query($query, $db) or die (mysql_error($db));
    }

    $query = 'DELETE FROM comic_rivalry
        WHERE
            hero_id = ' . $character_id . ' OR villain_id = ' . $character_id;
    mysql_query($query, $db) or die (mysql_error($db));

    if (!empty($_POST['rivalries'])) {
        $values = array();
        foreach ($_POST['rivalries'] as $rival_id) {
            $values[] = sprintf('(%d, %d)', $character_id, $rival_id);
        }
       
        // alignment will affect column order
        $columns = ($alignment = 'good') ? '(hero_id, villain_id)' :
            '(villain_id, hero_id)';

        $query = 'INSERT IGNORE INTO comic_rivalry
                ' . $columns . '
            VALUES
                ' . implode(',', $values);

        mysql_query($query, $db) or die (mysql_error($db));
    }

    $redirect = 'list_characters.php';
    break;

case 'Delete Selected Powers':

    if (!empty($_POST['powers'])) {
        // escape incoming values to protect database-- they should be numeric
        // values, but just to be safe
        $powers = implode(',', $_POST['powers']);
        $powers = mysql_real_escape_string($powers, $db);

        // delete powers
        $query = 'DELETE FROM comic_power 
            WHERE 
                power_id IN ("' . $powers . '")';
        mysql_query($query, $db) or die (mysql_error($db));

        $query = 'DELETE FROM comic_character_power 
            WHERE
                power_id IN ("' . $powers . '")';
        mysql_query($query, $db) or die (mysql_error($db));
    }

    $redirect = 'edit_power.php';
    break;
   
case 'Add New Power':

    // trim and check power to prevent adding blank values
    $power = trim($_POST['new_power']);
    if ($power != '')
    {
        // escape incoming value
        $power = mysql_real_escape_string($power, $db);

        // create new power
        $query = 'INSERT IGNORE INTO comic_power
                (power_id, power)
            VALUES
                (NULL, "' . $power . '")';
        mysql_query($query, $db) or die (mysql_error($db));
    }

    $redirect = 'edit_power.php';
    break;

default:
    $redirect = 'list_characters.php';
}

header('Location: ' . $redirect);
?>

Code: [Select]
$itemlisted = $_POST['itemlisted'];

unset($_SESSION['items']['$itemlisted']);

e.g. $itemlisted = 5

so i want [5] deleted from the array.


is the above way correct?

Hello,

I am getting my drop down menu data from an array from the database. Were I am stuck is I am not sure how to link the "text" from the drop down menu into the query. When I click delete it should delete the image row from the database. Any help on how to delete the file will be very welcome.

Jess

Would I set or get? - I think set


deleteimage.php


<?php 
include('includes/session.php'); 

include('includes/header.php'); 

include('includes/class/class.form.php'); 

include('includes/class/class.image.php'); 

include('includes/class/class.imageManager.php'); 



$formImageDelete = new Form('deleteimage.php', 'Delete','return CheckDelete();', ''); 

$imImageManager = new imageManager(); 

$aImageObjects = $imImageManager->getallImages(); 



$aImageName = array(); 

for($iCount=0; $iCount<count($aImageObjects);$iCount++){ 
    $imImage = $aImageObjects[$iCount]; 
    $aImageName[] = $imImage->getImageName(); 
} 



if(isset($_POST["submit"])){ 
          
    $formImageDelete->setStickyData($_POST); 
     
     
   $formImageDelete->checkNotEmpty("DeleteImage"); 

     
     
    if($formImageDelete->getValid() == true){ 
     
    $removeImage = new Image(); 
     
    $removeImage->setImageName($_POST["DeleteImage"]); 
     
    $removeImage->removeImage(); 
     
    $Message = "Image Deleted"; 
     
    }else{ 
     
    $Message = "Error"; 
    } 
     

} 


$formImageDelete->openFieldset(); 
$formImageDelete->makeDropDownList("Delete","DeleteImage",$aImageName); 
$formImageDelete->makeSubmitButton("submit","Delete"); 
$formImageDelete->closeFieldset(); 

$newNavigation = new Navigation(); 

?> 

    <?php echo $newNavigation->mainMenu();?> 
     
     
           <h1  class="Heading">Delete Image</h1> 
     
    <?php echo $Message; ?> 
         
        <?php echo $formImageDelete->getHTML();?> 
         
     
<?php include('includes/footer.php') ?>



class.image.php


public function removeImage(){ 
     
         global $database; 
         
        $Query = "DELETE * FROM Gallery WHERE imageName =" .$aImageName; 
         
        $resResult = $database->query($Query); 
     
     
        //Fetch The Row 
         
        $aImage = $database->fetch_array($resResult); 
         
        $this->iID = $aImage["id"]; 
        $this->sImageName = $aImage["imageName"]; 
        $this->sImagePath = $aImage["imagePath"]; 
         
        $this->bExisting = true; 
     
    } 

Hi everyone,

im new to php,
iv just created a news feed where i have a limit of 10 to be echoed out. but i want the update form to delete the oldest post as it updates... how would i do this please

New to php so I'm having trouble with deleting a record from my php table.


This is my code for my page where the records are being displayed. I have a delete statement that is not working properly. Also, I was thinking maybe I need a array to delete records? Please help!





Code: [Select]
<?php
require_once('database.php');
session_start();




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


$query = "INSERT INTO grades (student_id, grade_type, grade_name, grade_points) ";
$query .= "VALUES (:student_id, :grade_type, :grade_name, :grade_points) ";

$statement = $db->prepare($query);
$statement->bindValue (':student_id', $_SESSION['student_id']);
$statement->bindValue (':grade_type', $_POST['grade_type']);
$statement->bindValue (':grade_name', $_POST['grade_name']);
$statement->bindValue (':grade_points', $_POST['grade_point']);

$statement->execute();

$statement->closeCursor();


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

foreach($_POST['delete'] as $delete_id)
{

$query = "DELETE FROM grades WHERE grade_id = $delete_id";
mysqli_query($dbc, $query) or die ('can\'t delete user'); 

}
}


}








?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>View Course Grades</title>

<link rel="stylesheet" type="text/css" href="main.css" />
</head>

<body>


   



<?php

$student_name = $_SESSION['student_name'];
$student_id = $_SESSION['student_id'];
$query = "SELECT * FROM grades WHERE student_id = :student_id ";

$statement = $db->prepare($query);
$statement->bindValue (':student_id', $student_id);
$statement->execute();
$grades = $statement->fetchAll();
$statement->closeCursor();


echo "<h1>Show Grades for $student_name </h1>";

foreach ($grades as $grade)
{

echo $grade['grade_type'] . " " . $grade['grade_name']. " " . $grade['grade_points'] . "<br />";
}

$query = "select*from se266";  
$result = mysql_query($dsn, $query);  
while($row = mysql_fetch_array($result))
{      
echo '<input type="checkbox" value="' .$row['grade_id'] . '"name="delete[]" />';
echo ' ' .$row['grade_type']; 
                                echo ' ' .$row['grade_name'];
echo '<br />';  

}


?>

<div id="content">
            <!-- display a table of products -->
           
            <table>
                <tr>
                    <th>Grade Type</th>
                    <th>Grade Name</th>
                    <th>Grade Points</th>
                    <th>Remove</th>
                </tr>
                <?php foreach ($grades as $grade) : ?>
                <tr>
                    <td><?php echo $grade['grade_type'];   ?></td>
                    <td><?php echo $grade['grade_name'];   ?></td>
                    <td><?php echo $grade['grade_points']; ?></td>
                    <td><form action="grades.php" method="post">
                       
                        <input type="submit" name="remove" value="Delete" />




                    </form></td>
                </tr>
                <?php endforeach; ?>
            </table>
           
        </div>
    </div>

    <div id="footer">
       
    </div>






<form name="grades" method="post" action="grades.php">

<p>Grade Type<SELECT NAME="grade_type">
<OPTION VALUE="Mid-Term">Mid-Term
<OPTION VALUE="Final">Final
<OPTION VALUE="Lab">Lab
</SELECT>
<br>







Grade Name:<input type="text" name="grade_name" value=""><br />
Grade Points:<input type="text" name="grade_point" value="">

<input type="submit" name="add_grade" value="Add Grade">


</form>

</table>

</body>

</html>

I am trying to make a function that is customizable to delete a query from a database.

Here's the function.
function checkHashs($hours) {
        if($getHashs = mysql_query('SELECT * FROM `hash_codes`')) {
          $dateQ = mysql_query('SELECT MAX(addedon) AS lastVoteDate FROM `hash_codes`') or die(mysql_error());
          $getDate = mysql_fetch_assoc($dateQ);
          $diffrence = time() - strtotime($getDate['lastVoteDate']);
  echo $diffrence / 60 / 60;
          if (($diffrence / 60 / 60) >= $hours) {
mysql_query('DELETE FROM `hash_codes` WHERE `addedon` = '. ($diffrence / 60 / 60) >= $hours .'') or die(mysql_error());
          }
}
}

And I am trying to call it by
checkHashs(24);

What I am trying to do is make it so when that function is ran it will delete all oh the guerys that have the `addedon` row over X hours(24 hours in this case).

Any ideas?