PHP - Deleting Urls From A String

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 ?

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

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();  

Hi, this is the first time I've asked for some help from a forum. I guess this code has sort of got me stumped.

So, I have a system where a user can enter a number. The number goes into a mysql database. A random number is also generated and it is added into another column.

So, I want users to be able to delete the number using the random number. I've shown it to them, and I need help working my delete script.
Code: [Select]
<?php
$con = mysql_connect("localhost","","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("a8784hos_adopts", $con);
$adopt = $_POST['adoptid'];
$uniquecode = $_POST['uniquecode'];
$result = mysql_query("SELECT uniquecode, id FROM id WHERE id='$adopt'");
mysql_fetch_array($result);
if (($adopt == $row['id']) || ($uniquecode == $row['uniquecode'])){
mysql_query("DELETE FROM id WHERE id='$adopt'");
echo 'Done! <br/><br/><a href="tester.php">Go back....</a>';
}
else {
echo 'Bad unique code. <br/><br/><a href="tester.php">Go back....</a>';
}
?>

So, the random number is uniquecode in the database, and the number is id. However, when I try this code, it always tell me I have a bad unique code. What am I doing wrong?

Thanks.

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.

I'm just trying to get suggestions on what people think would be the best way to go with this. With the bottom part of this card where it s tarts working with the foreach loop its taking what was a UL and for each of each LI's and updating a table with its new data however this way isn't going to work as this is editing a user. Because there could be 5 in the database but the new edit user has only 4 lis so I'm sure you could all see the issue here. What I'm thinking would be best is to have it DELETE the existing characterIDs that have WHERE handler_ID = $handlerID and then just do a new INSERT statement. Anyone else think this would be the best way to go about this?


Code: [Select]
if (mysqli_num_rows($Qresult) == 0) {
        $query = "UPDATE `handlers`
            SET `userName` = '".$userName."', `password`='".$password."', `firstName`='".$firstName."', `lastName`='".$lastName."', `statusID`='".$statusID."', `isAdmin`='".$admin."', `defaultCharID`='".$defaultCharID."', `email`='".$email."' WHERE `ID` = '".$handlerID."'"; 
        mysqli_query($dbc, $query);
        foreach ($characterIDs as $cID) {
               $query2 = "UPDATE `handler_characters`
               SET `handler_id` = '".$handlerID."', `characterID` = '".$cID."'";
               mysqli_query($dbc, $query2);
        }
        $result = "good";
    }

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

Hi, When i launch my code i get the following php error:
Warning: unlink(../files/"yCUuH0223e3d6d046acb58678fbb54042e0fe.pdf") [function.unlink]: Invalid argument in C:\xampp\htdocs\intra\VVS\admin\fakture-edit.php on line 74

But in the dir: C:\xampp\htdocs\intra\VVS\files\

The file exists..

here's my php code:

Code: [Select]
$id = mysql_real_escape_string($_GET['id']);
$fil = mysql_real_escape_string($_GET['fil']);


$result2 = mysql_query("SELECT * FROM fakture WHERE id=('$id')  LIMIT 1");
$row2 = mysql_fetch_array($result2);

if ($_GET["op"] == "process")
{

if (!unlink('../files/"'.$fil.'"'))

This topic has been moved to MySQL Help.

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

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

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

Ok I am trying to delete some rows from a database. I have done this before with success so I thought I could use the same method just modify it a little and it would work. Man was I wrong. Any help on this is much appreciated below is my code.

Code for the Query to get the data from the database and for displaying the results in a table:
Code: [Select]

//GET DATA
$sql = "SELECT * FROM `".$tblname."` ORDER BY $orderby $sort LIMIT $startrow,$limit";
$result = mysql_query($sql) or die(mysql_error());
$result2 = mysql_query($sql);

//START TABLE AND TABLE HEADER
echo "<form name='form1' method='post' action=''><table style='font-size:9.5px;'>\n<tr><th>Delete</th>";
$array = mysql_fetch_assoc($result);
foreach ($array as $key=>$value) {
if($config['nicefields']){
$field = str_replace("_"," ",$key);
$field = ucwords($field);
}

$field = columnSortArrows($key,$field,$orderby,$sort);
echo "<th>" . $field . "</th>\n";
}
echo "</tr>\n";

//reset result pointer
mysql_data_seek($result,0);

//start first row style
$tr_class = "class='odd'";

//LOOP TABLE ROWS
while($row = mysql_fetch_assoc($result)){


echo "<tr ".$tr_class.">\n<td><a
 href='remove_rec.php?id=". $rows['ID'] . "'><p>Delete</p></a>";
echo "</td>";
foreach ($row as $field=>$value) {
echo "<td>" . $value . "</td>\n";
}
echo "</tr>\n";
//switch row style
if($tr_class == "class='odd'"){
$tr_class = "class='even'";
}else{
$tr_class = "class='odd'";
}

}

//END TABLE
echo "</table>\n</form>";

Here is the code that should delete the row:
Code: [Select]
$tblname = 'tablename';
// get value of id that sent from address bar
$id=$_GET['ID'];

// Delete data in mysql from row that has this id
$sql="DELETE FROM $tblname WHERE ID='$id'";
$result=mysql_query($sql);

// if successfully deleted
if($result){
echo "Deleted Successfully";
echo "<BR>";
echo "<a href='leads3.php'>Back to Results</a>";
}

else {
echo "ERROR";
}

When I click on the link to delete a record it redirects me to the appropriate page with the "Deleted Successfully" message but when I go to view the results the row was not deleted. Any help on this would, again, be greatly appreciated.

I've seen two post now about not deleting within a loop and I think I may need to ask a question about this.

I have a photograph db that gives the addresses of the thumbs and photos in files for a product, it also is keyed to the products db. There can be more than one photo per product.

If someone selects yes from a radio button and clicks submit the process should delete the record of the product in the product db, delete the photos in the photo images/files(this is the loop) and then delete the product id and row in the photo db

Is this a decent way of doing this?



if ($_POST['sure'] == 'Yes') { // If Yes delete the item and its pictures in image folders

$q = "DELETE FROM product WHERE id = $item LIMIT 1"; // Delete the product record
$r = @mysqli_query ($dbc, $q);

$q = "SELECT id, thumb, photo FROM photos WHERE id = '$item'";
$r = @mysqli_query ($dbc, $q);
if ($r){
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)){
unlink('images/members/'.$row['thumb'].''); // Remove-delete photos from folders for each row in photo db
unlink('images/members/'.$row['photo'].'');
}
}

$q = "DELETE FROM photos WHERE id_prod = $item"; // Delete the photo record
$r = @mysqli_query ($dbc, $q);

// When through redirect
header("Location: $home/member/index.php?user=$mem_id");
exit();
}

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

I use this this same exact delete for users to delete their own account with no problem
for some reason this code below is deleting all my rows in each table


Code: [Select]
<?php 
if(isset($_POST['delete'])) {
                                                                      // this is a check box you need to check in order to confirm
  if(empty($_POST['confirm'])){ 
 
  echo "You need to check confirm";

}else{

mysql_query("DELETE FROM `users` WHERE `goauld`= ".(int)($_POST['delete_goauld']));
mysql_query("DELETE FROM `game` WHERE `goauld`= ".(int)($_POST['delete_goauld']));

echo "$delete_goauld was deleted<br />\n";
}
}
?>