PHP - Selecting A Row And Deleting It

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

I'm trying to delete the <identifier> node of some XML, using the following code; unsuccessfully.   Can someone help me identify where I'm going wrong? TIA

$newXML = "";
$xmlString = Fedora_API::callGetDatastreamContents($this->pid, 'MODS', true);
$doc = DOMDocument::loadXML($xmlString);
$xpath = new DOMXPath($doc);

$fieldNodeList = $xpath->query("/identifier");

foreach ($fieldNodeList as $node) {  
	$fieldNodeList->removeChild($node);
}
$newXML = $doc->SaveXML();  

I am sorry even i didn't say hello to forum but i need this snippet very urgently. i have Zero knowledge of PHP but unfortunately i need a small code as follow.

Hi, I gave the following php script:

#!/usr/bin/php -f
<?php
require_once(dirname(dirname(__FILE__))."/modules/common/common.config.inc.php");
$path = $conf["root"]."/media/images/tricouri/tmp/";
$command = "rm -Rf".$path."*";
if(exec($command))
{
    echo "Folder cleared\n";
}
else
{
    echo "Folder clear failed\n";
}
?>


I want to delete some .png files from the ./tmp folder and I receive a rm error:
Quote

rm: invalid option -- /
Try `rm --help' for more information.
Folder clear failed



The rm -rf command sintax is ok on the linux bash, but from php i receive the error.
Php safe mode is off. Can someone help, please ?

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

This topic has been moved to MySQL Help.

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

There are many ways to delete everything after a character in a string. I am looking for a simple way to delete everything after a given word.

I'm trying to delete rows in the database, based on what checkboxes are left empty by the user...

What i have is small application in which a user can add an item to the database and give it tags...

for example there is "apple" and it has the tags of "fruit, red, round"

What i want is for the user to be able to edit those tags, so the user can remove "fruit" and add "sweet" instead or just remove "fruit" all at the same time.

The code i have, somewhat works...

This code below loops through the checkboxes and should remove the items that are no longer checked, by going through the database and grabbing all the tags and them checking it against those that are still checked and remove the ones that it didn't find checked...??

However whats happening is when i unchecked say "red" it removes all the other items..so if i had "red, fruit, round' and i want to remove "red" it leaves red but removes the rest.

foreach($_POST['tag'] as $r=>$n){
$t = mysql_real_escape_string($_POST['tag'][$r]);

$get_tag2 = mysql_query("SELECT * FROM file_cats WHERE fileID='$fileID'") or die(mysql_error());
while($t2 = mysql_fetch_assoc($get_tag2)){
$tmp_tag1 = $t2['category'];

if($t==$tmp_tag1){
$remove_tag = mysql_query("DELETE FROM file_cats WHERE fileID='$fileID' AND category='$t' LIMIT 1") or die(mysql_error());
}
}
}


This following piece of code just adds a new tag...however i want it to check to see if that tags already exist in the database, if it does then don't add it just add the new ones..


foreach($_POST['tag'] as $k=>$l){
$tag = mysql_real_escape_string($_POST['tag'][$k]);

$add_tag = mysql_query("INSERT into file_cats (fileID, category) VALUES('$fileID', '$tag')") or die(mysql_error());

}


My final problem is that i can't remove items if the second snippet of code is there, i have to remove those lines of code in order to remove items, however i can add items with both loops there.

I'm basically stuck and hope that someone here can shed some light on what i'm doing wrong, because i know i'm doing something wrong i just can't find it

Anyway thank you in advanced

This topic has been moved to MySQL Help.

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

please just deleting this post I think i figured it out

Hi fellas, i am wondering if someone can point me in the right direction?

I have a simple upload script where users can upload thier profile picture, but if they want to change that picture i would like to delete the old one, to save space and time cleaning up the left overs.

So, without further ado, i gather the info from the existing database:

$existingimage = "/profileimage/". $userid2['image'];


Then further on in the script when it comes time to add or update the image i have:


if (!empty($existingimage)) {unlink($existingimage);}
$insert= ("UPDATE userdatabase SET image='$finalname' WHERE user='$userid'");
mysql_query($insert);


Only problem is, the unlink part dont work, the original image is still there!
Any clues?

How would I make a script that would delete any row in a MySQL table that was more than 7 days old?

I have a string containing long text, which contains urls in the form of example.com or www.domain.com (simple plain text, not html links). How I can delete all of them. I need a php regex to delete all terms containing ".com"
 

Hi,

i have delete link for records and it goes to other page to delete all related records in tables. is there away to get confirmation before the delete process starts?

<?Php

include('session.php');
include('dbcon.php');

	if(isset($_GET['Del']))
	{
		
		$userid = $_GET['Del'];
		
		$query = "delete from staff where OracleID='".$userid."'";
		$result = mysqli_query($con,$query);
		
		if($result)
		{
			
			echo "staff deleted";
			
		}
		
		else
		{
			
			echo 'check the errors!';
			
		}
		
		$query2 = "delete from attendance_records where OracleID='".$userid."'";
		$result2 = mysqli_query($con,$query2);
		
		if($result2)
		{
			
          	echo "records deleted";
			
		}
		
		else
		{
			
			echo 'check the errors!';
			
		}
      
      
     header("location:viewstaff.php");
		
		
	}
	else
	{
		
		header("location:viewstaff.php");
		
	}

?>

how to add confirm message with php before deletion is processed?