Mysql Row And File Delete
I have a database with the following colums, imageID, imageName, imageDesc, imageFile, imageHeight, imageWidth, imageThumb, imageThumbHeight, and imageThumb Width. I can easily delete a row from the mysql table, galImages, but I also want to delete two files from a directory. The file names are stored in the columns imageFile and imageThumb.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
PHP File To Delete Multiple Talbes In MySQL
i installed PHP Nuke, didnt really like it. I think its much more then what I need. Great System, just think alot of it is useless for my needs. In any case i want to delete all the tables it created in my DB. Anyone got a script I can run to delete all tables that start with.
View Replies !
Mysql Delete - $query = Mysql_query("DELETE
how would i do the following ? $query = mysql_query("DELETE notes, datestamp, abs_value, ID FROM absence_mgt WHERE datestamp='$date' AND ID='$vtc_login' ") or die(mysql_error()); im just getting "Unknown table 'notes' in MULTI DELETE" ?
View Replies !
What Is The Best Way To Delete File ...?
I have script that allows a user to upload a txt file for processing, filtering, to save bandwidth,instead of user reuploading the file everytime he/she does a new process on the same file, i save the file to the server, and process from that file. What I want to be able to do is, when the user uploads a new file, or leaves the site, this temp file is automatically deleted (saves disk space).
View Replies !
Delete File();
I was wondering if php4 has a built in function that could delete a file. In my case I need my php to delete a picture. (jpg, gif) Does php4 have the ability to delete an exsiting file? Something like this?? delete_image("../images/somePic.jpg");
View Replies !
File Delete
I need to delete a compressed backup file after it has been sucessfully uploaded to a ftp server, the upload works fine using CRON and a php page. I have tried to delete the file using: <? $oldfile = "/home/#*$!/backup-10.8.2005_07-00-01_yyy.tar.gz"; unlink($oldfile); ?> However I get a permission denied, what's wrong? Also, I don't know the exact file name, so what I really want to do is wildcard the file name like this: <? $oldfile = "/home/xxx/backup-*_yyy.tar.gz"; unlink($oldfile); ?> Is this possible?
View Replies !
Mysql DELETE
im a stuck again, could some one please tell me why this dosent work; mysql_query("DELETE FROM messages WHERE from='$fromid', sento='$myid'");
View Replies !
Delete For MySQL
I'm an experienced java/C++/SQL programmer who hasnt used PHP. I'm looking for some generic database access pages for doing dds, edits, deletes, etc., hopefully with some error handling. I'd rather start with a basic shell of code, so I don't have to reinvent the wheel, and can just change connection string, database fields, etc.
View Replies !
Using Php To Delete A File In A Directory- Help
I can use php to execute the cp command to copy an image file into a directory. Now I want to delete images in that directory if they are not named "picturelink.gif" when an entry with a corresponding id is deleted. Below is the code I am using which doesn't seem to be working when it comes to deleteing the file. The directory has the correct permissions for read/write access. $query = "DELETE FROM $userstable WHERE id ='$id' "; if($picture != "picturelink.gif") { exec("rm $picture /virtualhosts/capefearantiques.com/www/pictures/$picture"); }
View Replies !
Delete Lines From File:
How to delete $n first lines from $str if i know how much lines shuld remain in the string? $str = "aaaaaaaaa bbbbbbbb ccccccccc ddddddddd ... zzz"; Can it be done easly with preg_replace? (i.e without splitting it by '', removing elements from array and joining tham back.
View Replies !
How Do You Delete A File From A Listing Please?
I have the code: <?php if ($dir = @opendir("../project/proj_images")) { while (($file = readdir($dir)) !== false) if($file != ".." && $file != ".") echo "<tr><td align="left" class="bodyblue2">$file</td></tr>"; closedir($dir); } ?> which displays a list of files in a directory. What I want, is to be able to click on a file in the list and delete it. I know you use unlink but how do you tie it in with the above code?
View Replies !
Trying To Delete A File Using Unlink
i am trying to delete a file using the unlink function but it just is not working. i just get the Could not delete message. Is there anyway to find out exactly what is wrong? I've tried the exact path which is C:/domain/wwwroot/temp/0000000.txt but it just does not delete. Also i dont think it can be related to permissions because the 0000000.txt was created automatically by a script. The code i used is as follows: <? $delete = unlink("C:/domain/wwwroot/temp/0000000.txt"); if($delete) { echo "Succesfully Deleted"; } else { echo "Could not Delete"; } ?>
View Replies !
How To Delete Last Line Of File
I have a flat file on the server which I append to from a HTML web form. I need to delete the last line of the flat file before I append though. How do i do that? I have the following code. I'm not sure if it's correct. $pattern = "</member>"; // what I want to look for. $ora_books = preg_grep($pattern, file('/path/to/your/file.txt'));
View Replies !
How To Delete N Lines From The Top Of A File?
I'm not sure how to do this in php - need to calculate and delete an unspecified number of lines from the *top* of a file. <?php //append $visitor to the bottom of $visdata $fp = fopen($visdata,"a"); fwrite($fp, " ".$visitor;) //count the lines in $visdata $lines = count($visdata); if $lines > 10 { //delete as many lines off the top as necessary //to end up with 10 lines total in $visdata } fclose($fp); ?>
View Replies !
Delete File Contents
Can someone post some code to show me how to delete a file from a folder please? I need to delete a file first, and then upload something in it's place. Maybe a bit of code to slide in what i have already would work? Code:
View Replies !
Delete A File Within A Directory
Is there a way to delete a file within a directory using a link? I have a script that will list all the files in a directory and, in the output, I'd like to create a link next to each file that says "delete This file" and then will delete the file from the /dir filename1.jpg delete file filename2.jpg delete file filename3.jpg delete file filename4.jpg delete file I try but when I click on the delete button I delete all the files of the /dir...
View Replies !
Delete File Content, Possible ?
I would like to know if it is possible to delete the content of a file or overwrite the content of a file or even delete / overwrite a certain part of the filecontent, for example a given line-number ? I have searched php.net for a function but couldnt find anything in that direction. Did I missed something ? Or is it not possible ?
View Replies !
Delete From Db If Not In Excel File
A while back I had written a script for a client who had wanted to upload an excel file for his clients that contained their inventory information. I had it set so everytime he would upload the file it would check the information in the file against that already stored in the db. If a row in the db contained a certain field like an account number. It would make any changes that were made to that field or if none were made it would leave it be. If there were any new rows in the file it would upload those. Code:
View Replies !
Php File Delete Coding
i would to do a little advance php file delete coding that does a check if any other records are using that image file before it deletes. How would i modify it? PHP Code: $myFile = "upldimg/".$_GET['thumb_filename']; unlink($myFile);
View Replies !
File Delete / Unlink
i have made scirpt that list all the files in a dir so you can delete them but it wont delete i get the page as normal but when you select one and click delete it don't work! Code:
View Replies !
Can't Delete File From Server
I've pawed through previous posts and tried a bunch of the suggestions to delete files on my web server. I use Filezilla to UL stuff and lately the connection has broken a couple of times and I'm left with a couple of files that are named with complete jibberish. I can't chmod, rename, delete, etc. any of them. Code:
View Replies !
Flat File Delete Row
Does anyone know how to delete just a single row in a flat file database using php? The "w" function deletes the whole file. Is there a tutorial anyone knows about with examples of this?
View Replies !
Delete A File In My Web Server
I have mysql database and a web page to upload files to my webpage, I know how to delete them from the database, but didnt find the code to delete them from the web server. Please help me with this code.
View Replies !
Not Enough Permissions To Delete A File
I want to delete a file using unlink() function. I'm getting a warning that says that I have no permissions to do that. I suppose that is because the file I'm trying to delete is under the root directory path. I searched the forum about deleting files but found nothing alike my problem...
View Replies !
Delete File After Headers Sent
Is there any way how to delete a file after download headers have been sent? This code does not work for some reason. header('Content-type: application/xml'); header('Content-Transfer-Encoding: binary'); header('Content-length: '.filesize($f)); header('Content-Disposition: attachment; filename="'.basename($f).'"'); if($fp = fopen($f, "rb")) { while ($buffer = fread($fp, filesize($f))) print $buffer; fclose($fp); } unlink($f);
View Replies !
Delete MySql Row By Date
Can someone help me with the following problem: I have a table that includes a column for "last application date", let's simply call it "date". Now the problem is how to automatically delete rows where the information in the "date" column has gone old, let's say by -86400 (1 day). Example: today's date is April 11th, which means that all rows with the info April 10th in the date column would get deleted.
View Replies !
How Do You Do A CASCADE Delete In MySQL?
I'd like to delete a record and all its children records at one time. How do I do that? Can you, in one SQL statement, delete from table 1 where id = 3 delete from table 2 where id = 12 delete from table 3 where id = 12 ......
View Replies !
MySQL - Delete Across Two Tables. OT
i cant find the MySQL newsgroup, however i am hoping to pick up on some expert advice from php/mysql gurus here. I'm having some trouble performing a delete across two tables. The tables i have are: questionnaires (id, name); questionnaire_questions (questionnaires_id, id, name, qf_type) The questionnaire_questions table contains a list of questions for a specific questionnaire (indicated by the questonnaires_id). I would like to remove a questionnaire, and when doing so all corresponding questionnaire_questions who have matching id's (questionnaires.id = questionnaire_questions.questionnaires_id). I have this statement, however it only works if a questionnaire has questions... however i would like it to delete even if no questions exist for that specific questionnaire. The SQL i am using is: delete questionnaires, questionnaire_questions FROM questionnaires, questionnaire_questions WHERE questionnaires.id = questionnaire_questions.questionnaires_id AND questionnaires.id = THE_QUESTIONAIRE_TO_DELETE_ID
View Replies !
DELETE Problem With MySQL
I've been learning using PHP and MySQL from the tutorial at freewebmasterhelp.com. Everything works fine, except deleting things. The script is invoked with a URL like this: http://www.example.org/test/delete_entry.php?id=35 And here's the script: <? include("dbinfo.inc.php"); $id = $_POST['id']; mysql_connect($server, $user, $password); $query = "DELETE FROM test1 WHERE id = '$id'"; @mysql_select_db($database) or die("Unable to select database."); mysql_query($query); mysql_close(); header("Location: entries.php"); ?> The dbinfo.inc.php file defines the variables $server, $database, $user and $password. The login part works.
View Replies !
Mysql Delete From A Form
i'm trying to find out how to get this to work. You type in a name of a record in the database and it removes it. In this case it's deleting the record that when you type in the name of the server it looks for it in the column "servername". You type in the servername and it will delete the whole record. Code:
View Replies !
MySQL MultiTable Delete...
I've been able to delete rows from one table successfully but what I want to try next is giving me some problems. I have a users 'id' which is unique. Heres what I want to-do. DELETE * FROM users WHERE id = 1 DELETE * FROM messages WHERE from = 1 DELETE * FROM comments WHERE user = 1 In each table there oginizaed a little different hense the id , from & user... but thats what I want to-do, without having to-do them all sepreatly, would like it to be efficent. the users ID will be passed along as the var 'id' any thoughts? So pretty much it takes the users id number and deletes them from each table.
View Replies !
Mysql Delete Record
when I run this code below it doesn't delete the record or display any error message $id = $_GET['id']; include("../dbconnect.php"); mysql_query("DELETE FROM promotions WHERE id='$id'") or die(mysql_error()); Such a simple thing to do but I don't no why it doesn't work
View Replies !
How To Delete Only Certain Text In A Mysql Row?
I have a table setup that has a column setup as friends and users can add friends to this column no problem. What I would like to know is how to delete only certain parts of the text of the row/cell where their friends are stored. The friends text is seperated by the following : " , " That is a space on either side and comma in the middle of the space. I know how to explode the results and put into an array to display the reuslts, but is there a way to delete only one of the friends if the text is as follows. , thomas , frank , irene , I think you can get the idea. Is it possible to do this or should I just update the whole cell without the array[$i] result being the friend?
View Replies !
PHP Unlink() & Mysql Delete
Im trying to delete a file, then delete the row in my table that holds the info for this file. I tried the code below and got this error: Parse error: parse error, unexpected T_STRING in /nfs/cust/4/97/13/731794/web/Admin/backup/PXS_DeleteBackup.php on line 34 Here is my code:
View Replies !
Delete MySQL Data
I am building a lunch ordering system for a company. The employees can login, order lunch, and the administrator can see what everyone ordered for lunch in the admin panel. The problem is that when the employees enter data, it stays in the database until they update it. If an employee is sick, their lunch order from the previous day is still in the database. Is there a way to clear those values they enter at a certain time in MySQL.
View Replies !
|
TRACKER
