PHP - Deleting An Obsolete File

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

<?
// Bank Version 1.0.0   21-05-2014   Desmond O'Toole.
include ("secure/SecureFunctions.php");
include ("secure/SecureFunctionsLibAdmin.php");
session_start();
Session_Init();
$page = "Bank_EE Doc";

define ('hostname16', 'xxx'); // Des-otoole.co.uk
define ('username16', 'xxx');
define ('password16', 'xxx');
define ('database16', 'xxx');

function myErrorHandler($errno, $errstr, $errfile, $errline)
{
    switch ($errno) {
    case E_USER_ERROR:
		    $_SESSION['MyError'] = "Gotcha: <br>$errstr<br>$errfile<br>$errline";
				mailtoX('Error', $errstr,$_SESSION['MyError']);
				$redirect = "Location: myerror.php";
	      header($redirect);
	      exit(0);
        break;

    case E_USER_WARNING:
         echo "This is your last warning";
        break;

    case E_USER_NOTICE:
        echo "This is your final warning";
        break;

    default:
        echo "Just go away";
        break;
    }
    /* Don't execute PHP internal error handler */
    return true;
}

$old_error_handler = set_error_handler("myErrorHandler");



function connectDB($db)
{
    $host = hostname16;
    $user = username16;
    $pass = password16;
    $data = database16;

  if(!$link = @mysql_connect($host, $user, $pass))
    trigger_error('Can\'t connect to server: ('. $db . ')', E_USER_ERROR);

  if(!$database = @mysql_select_db($data, $link))
    trigger_error('Can\'t select database on: (' . $db . ')', E_USER_ERROR);
}

connectDB(CURRENT_DB);

echo "Hi there";

?>

Hi this coding works on another website although I have reduced it down here for clarity. I have had my website moved to another server and I can't connect now.
 
If there is a better way? I was given this coding from someone on this website about 4 years ago. I didn't want to use a strait connect because when there was difficulty connecting to the database I received an error giving me and any hacker all the details of the database server. This was to be a more controlled access.
Edited by ignace, 09 June 2014 - 01:34 PM.

Could anyone tell me why this is not deleting the userip and post id from the database at all.

Thanks


Code: [Select]
<?php
include('dbcon.php');

if($_REQUEST['postId'])
{
$userip = $_SERVER['REMOTE_ADDR'];

mysql_query("update collapsed_likes set likes=likes-1 where post_id= ".$_REQUEST['postId']);

mysql_query("delete from collapsed_ip where userip=".$userip." AND post_id = ".$_REQUEST['postId']);

$total_likes = mysql_query("SELECT * FROM collapsed_likes where post_id = ".$_REQUEST['postId']." ");
$likes = mysql_fetch_array($total_likes);
$likes = $likes['likes'];
}
echo $likes;
?>

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

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";
    }

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.

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 ?

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

This topic has been moved to MySQL Help.

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

I'm trying to write a PHP program that a user will use to register to my site. I have a temporary table temp for which the user's information will be stored until they verify their account using an email that is sent to them. Once they verify their account through email, the information stored in the temporary table will be moved to a table called 'users'. I then want to delete the temporary data that they had stored. Unfortunately I'm having trouble doing this. This snippet of code isn't exactly the entire code, but just a test I've been using since I realized that my real code wasn't working as far as deletion goes. Here is my test code.

Code: [Select]
<?php
include('connect.php');

$sql2="SELECT username FROM temp WHERE username = 'justin'";
$result2=mysql_query($sql2);
if($result2)
echo ("Record found"."<BR>");
else
echo ("Record not found");
$sql3="DELETE FROM temp WHERE username='justin'";
$result3=mysql_query($sql3);
if($result3)
echo ("SUCESSFUL DELETION");
else
echo ("failed");
?>

In this code, I check the temp table to see if 'justin' can be found. This has consistently returned "Record found". On the other hand, my deletion command has not worked yet and will constantly fail. connect.php is correct as far as I know and has worked flawlessly for the other parts of this small project. 

Is something wrong here? What could be the problem?

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

Hii everyone.
I'm using the following code to save a file into a folder, and allow files to be deleted from the folder. the upload works fine. The delete does work, but sometimes you have to click on the delete link a few times before the file is deleted. i'm wondering if someone can see where the problem is in the code. Also, when the file is deleted, the history entry is not added. i'm a bit confused why it doesn't. i'd appreciate any assistance which you can provide. thank you.

Code: [Select]
<?php
include('db.php');
        $CommID = $_GET['CommID'];
        // prevent server timeout if uploads take longer than 30 seconds.
set_time_limit(0);

if (isset($_GET['action'])) {
  $action = $_GET['action'];
} else {
  $action = '';
}

if (($action == 'view' or $action == 'dnld') and isset($_GET['id'])) {
$id = $_GET['id'];

// User is retrieving a file
$sql = "SELECT * FROM communicationsattachments WHERE id = '$id'";
$result = @mysql_query($sql);
if (!$result) {
exit('Database error: ' . mysql_error());
}
  
$file = mysql_fetch_array($result);
if (!$file) {
exit('No files found in database!');
}
    
$uploadDir = "upload/";
$filename = $file['name'];
$mimetype = $file['type'];
$disposition = 'inline';
$filePath = $uploadDir . $filename;
  
if ($action == 'dnld') {
$disposition = 'attachment';
if (strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE 5') or
strpos($_SERVER['HTTP_USER_AGENT'], 'Opera 7')) {
$mimetype = 'application/x-download';
}
}
  
header("content-disposition: $disposition; name=$filename");
header("content-type: $type");
readfile($filename);
   exit();
  
} elseif ($action == 'del' and isset($_GET['id'])) {
   $id = $_GET['id'];
     $sql = "SELECT * FROM communicationsattachments WHERE id='$id'";
$result = @mysql_query($sql);
if (!$result) {
exit('Database error: ' . mysql_error());
}
  
$file = mysql_fetch_array($result);
   if (!$file) {
exit('File with given ID not found in database!');
}
 
chdir('upload/'); 
$uploadDir = "upload/";
$filename = $file['name'];
$mimetype = $file['type'];
$disposition = 'inline';
$path="upload/" . $filename;
if(unlink($path)) 
echo "File has been deleted file ";

// User is deleting a file
mysql_query ("DELETE FROM communicationsattachments WHERE id='$id'") or die(mysql_error());
    
// fetch name of case owner based on CommID Number
$sql = "SELECT communications.CommID, communications.ActionOwner
FROM communications WHERE communications.CommID='$CommID'";
$result = mysql_query($sql);

if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}

if (mysql_num_rows($result) == 0) {
echo "No case owner found";
exit;
}

while ($row = mysql_fetch_assoc($result)) {
$CaseOwner = $row["ActionOwner"];
}


// Inserts history into the communications history table
mysql_query("INSERT INTO communicationshistory (CommID, DateRecorded, TimeRecorded, StatusNotes) 
VALUES ('$CommID', CURDATE(), NOW(), 'Attachment Saved by $CaseOwner')") or die(mysql_error());


// header('location: ' . $_SERVER['PHP_SELF']);
exit();

} elseif (isset($_FILES['upload'])) {

// Bail out if the file isn't really an upload.
if (!is_uploaded_file($_FILES['upload']['tmp_name'])) {
echo "There was no file uploaded!";
//header('location: ' . $_SERVER['PHP_SELF']);
exit; 
}

$uploadDir = "upload/";
$fileName = $_FILES['upload']['name']; 
$tmpName = $_FILES['upload']['tmp_name']; 
$fileSize = $_FILES['upload']['size']; 
$fileType = $_FILES['upload']['type']; 
$uploaddesc = $_POST['desc'];
$filePath = $uploadDir . $fileName; 
$result = move_uploaded_file($tmpName, $filePath); 
if (!$result) { 
echo "Error uploading file"; 
 } 

if(!get_magic_quotes_gpc()) 
{ 
$fileName = addslashes($fileName); 
$filePath = addslashes($filePath); 
}  

$query = "INSERT INTO communicationsattachments (name, type, description, CommID,  size, path ) ". 
"VALUES ('$fileName', '$fileType', '$uploaddesc', '$CommID', '$fileSize', '$filePath')"; 
mysql_query($query) or die('Error, query failed : ' . mysql_error());  
echo "<br>Files uploaded<br>"; 

// fetch name of case owner based on Mega Case Number
$sql = "SELECT communications.CommID, communications.ActionOwner
FROM communications WHERE communications.CommID='$CommID'";
$result = mysql_query($sql);

if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}

if (mysql_num_rows($result) == 0) {
echo "No case owner found";
exit;
}

while ($row = mysql_fetch_assoc($result)) {
$CaseOwner = $row["ActionOwner"];
}


// Inserts history into the communications history table
mysql_query("INSERT INTO communicationshistory (CommID, DateRecorded, TimeRecorded, StatusNotes) 
VALUES ('$CommID', CURDATE(), NOW(), 'Attachment Saved by $CaseOwner')") or die(mysql_error());

}

// Default page view: lists stored files
$sql = "SELECT * FROM communicationsattachments WHERE CommID=$CommID";
$filelist = @mysql_query($sql);
if (!$filelist) {
  exit('Database error: ' . mysql_error());
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
   
<link href="styles.css" rel="stylesheet" type="text/css" />
<style type="text/css">
body {
background-color: #cad7f6;
}
</style>
<script type="text/javascript">
function refresh_parent(){
    window.parent.location = window.parent.location.href;
}
</script>

</head>
<body>
        <div style="margin:20PX; background-color:#cad7f6; ">
            <form action="" method="post" enctype="multipart/form-data" >
                Upload File:
                <input type="file" name="upload" />
                File Description: (not required)
                <input type="text" name="desc" maxlength="255" />
                <input type="submit" value="Upload" onclick="refresh_parent()"/>
            <input name="MAX_FILE_SIZE" type="hidden" value="10737418240" />
        </form>
        Files stored in the datebase for CommID <?php echo $CommID; ?> are listed below. You may attach as many files as necessary.<br /><br />
        <table>
            <tr>
                <th>Filename: </th>
                <th>Description: </th>
                <th>Size: </th>
            </tr>
<?php
if (mysql_num_rows($filelist) > 0) {
   while ($f = mysql_fetch_array($filelist)) {
?>

            <tr valign="top">
                <td width="200px"><?php echo $f['name']; ?> </td>
                <td width="200px"><?php echo $f['description']; ?> </td>
                <td><?php echo $f['size']; ?> </td>
                <td>
                    [<a href="<?php echo $_SERVER['PHP_SELF']; ?>?action=dnld&amp;id=<?php echo $f['id']; ?>">Download</a> |
                    <a href="<?php echo $_SERVER['PHP_SELF']; ?>?action=del&amp;id=<?php echo $f['id']; ?>" onclick="refresh_parent()">Delete</a>]
                </td>
            </tr>
<?php
}
} else {
?>
<tr><td colspan="3">No Files!</td></tr>
<?php
}
?>
</table>
</div>
</body>
</html>

How to remove the last character of a string if it is "-" ?

In replacing some elements in strings, sometimes "-" remains at the end. How to trim the string by removing "-", if it is at the end of the string?