PHP - Slightly :s Delete Row Id ????

Hi,   I wish to find out is there any possible that I can delete some data inside my php website but inside my sql database, the record will still at there?   Thank you.

I'm trying to set it so that it will delete an entire populated directory based upon a value in the database then after finishing that to go back and delete that row in the database.  my current code is

Code: [Select]
<?php $page_title = "Central Valley LLC | Photo Addition" ?>
<?php include("header.php"); ?>
<?php include("nav.html"); ?>
<div id="content">
<form action="delprod.php" method="post" enctype="multipart/form-data">
<label for="which">Choose A Product To Remove:</label>
<?php $con = mysql_connect("localhost","phoenixi_cv","centraladmin");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("phoenixi_cvproducts", $con);
$result = mysql_query("SELECT * FROM Products");
echo "<select name=\"which\">";
while($row = mysql_fetch_array($result))
   {
echo "<option ";
echo "value=\"" . $row['id'] . "\">";
echo $row['Name'] . "</option>";
}
echo "</select>";
mysql_close($con);
?>
<br />
<input type="submit" name="submit" value="Submit" />
</form>
</div><!--#content-->
<?php include("footer.html") ?>

and the delete script

Code: [Select]
<?php
$con = mysql_connect("localhost","phoenixi_cv","centraladmin");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("phoenixi_cvproducts", $con);
$result = mysql_query("SELECT id FROM Products WHERE id=$_POST['which']");
$row = mysql_fetch_array($result)


chdir('assets');
chdir('images');
$mydir = $row . '/';
$d = dir($mydir);
while($entry = $d->read())
{
if($entry!="." && $entry!="..")
{
unlink($_POST['which'] . '/' . $entry);
}
}
rmdir($mydir);
$result = mysql_query("DELETE * FROM Producs WHERE id=$_POST['which']");
?>
Thank you in advance for all your help.  any easier ways of approaching this will be welcome as well

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.

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...

I need a bit of help.  I am displaying records from a db, and want the user to be able to delete a record.  I'm almost there (I think) but it doesn't pass the variable ($hours_id) to the delete query.  Any ideas?  Should be easy...but I'm just at my end.

<?php

include '../php/config_conn.php';

$querysum = "SELECT SUM(total_time) FROM `coop_hours` where user = '".$_SESSION['user_name']."'";
$resultsum = mysql_query($querysum);
$arr = mysql_fetch_row($resultsum);
$resulthours = $arr[0];

$querytime = "SELECT * FROM `coop_hours` WHERE user = '".$_SESSION['user_name']."' ORDER BY 'date_completed'";
$result = mysql_query($querytime);

$num = mysql_num_rows($result);

mysql_close();


echo "<table width='800' cellpadding='0'><tr>
      <td><strong>Coop Job</strong></td>
      <td align=center><strong>Date Completed</strong></td>
      <td align=center><strong>Total Time</strong></td>
      <td><strong>Comments</strong></td><td>Delete Entry</td></tr>";

$i=0;
while ($i < $num) {
   
$hours_id = mysql_result($result, $i, "hours_id");
$user = mysql_result($result, $i, "user");
$coop_job = mysql_result($result, $i, "coop_job");
$date_completed = mysql_result($result, $i, "date_completed");
$start_time = mysql_result($result, $i, "start_time");
$end_time = mysql_result($result, $i, "end_time");
$total_time = mysql_result($result, $i, "total_time");
$comments = mysql_result($result, $i, "comments");


echo "<tr><td>$coop_job</td>
   <td align=center>$date_completed</td>
   <td align=center>$total_time</td>
   <td>$comments</td>
   <td align=center>
   
   <a href='php/del.php'><img src='images/del.png'></a></td>
   </tr>";

$i++;
}
echo "<tr><td colspan=5><hr></td></tr>";
echo "<tr><td></td><td align=right>Total hours:</td><td align=center>$resulthours</td><td></td></tr>";
echo "<table>";

?>

And here is del.php:

<?php

include '../../php/config_conn.php';

$del_query = ("DELETE FROM coop_hours WHERE hours_id = '".$hours_id."' LIMIT 1");
$result = mysql_query($del_query);

header("Location: http://.../myaccount-testing.php");

?>

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>

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?

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,

I need a simple command to delete all rows where userID = 2567
I had a shot but didn't work: DELETE FROM * WHERE userID='2567' || usgID='2567'

My website is spammed by this user so I want to delete all records by this userID in my database.

Hope someone can help and thanks!

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>

nevermind delete

hey i am having a problem with the delete command. i have included the code for help.

to me i don't see a problem but obviously there is.

it is not deleting the field that the form is sending.

it does complete the header fine.

some advice would be great.

Code: [Select]
<?php 


include("dbc.php");

$id = $_POST['id'];

$sql="DELETE FROM players WHERE id= '$id' ";
$result=mysql_query($sql);

header("Location: masterrosteredit.php?msg=Your player was deleted");

mysql_close();

?>

Hi guys,

I need a bit of your help. I have successfully deleted a row in a database after I have inserted the value name with a var function that match with a username in the url bar. Now I would like to delete more than one row, but I don't know how to do this?

What I am trying to achieve is to enter the url something like this:

www.mysite.com/delete.php?favorites=the value1&use=test


It will search for a value in the database and then delete it. But if I add the &favorites=the value2 or more than 2, then search for the values in each row while looking for a username before delete the rows

Here's the current code:

Code: [Select]
<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbuser');
    define('DB_PASSWORD', 'mydbpass');
    define('DB_DATABASE', 'mydbname');
       
    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
    $favorites = clean($_GET['favorites']);
    $username = clean($_GET['user']);


if($favorites == '' && $username == ''){
   // both are empty
   $errmsg_arr[] = 'Both name and email are missing. You must enter one or the other.';
   $errflag = true;
}

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
$insert = array();
if(isset($_GET['favorites'])) {
    $insert[] = 'favorites = \'' . clean($_GET['favorites']) . '\'';
}


if(($favorites) && isset($username)) {
   mysql_query("DELETE FROM favorites WHERE username='$username' AND favorites='$favorites'");
   $deleted = mysql_affected_rows();
   if($deleted > 0) 
   {
     echo "favorites rows is deleted";
   } 
   else 
   {
     echo("favorites are already deleted");
   }
 }
}
?>

Any advice would be much appreciated.

Thanks,
Mark

Hello, I have many session variables and instead of unsetting them all I want to know if there is some code to remove all current sessions apart from a couple of them.

Cheers