Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14
  1. #11
    Join Date
    Mar 2006
    Posts
    477
    Plugin Contributions
    0

    Default Re: how to delete photos with SQL query?

    Well i created the file with that code in it and put it in my admin.

    When i change the admin index.php over to the file name i created basically nothing happens
    We sell ATV, Dirtbike, Streetbike, Snowmobile, Watercraft & Custom stickers & Banners. Check us out www.AD-DiscountPerformance.com

  2. #12
    Join Date
    Jul 2012
    Posts
    16,743
    Plugin Contributions
    17

    Default Re: how to delete photos with SQL query?

    Quote Originally Posted by Dashizna View Post
    Well i created the file with that code in it and put it in my admin.

    When i change the admin index.php over to the file name i created basically nothing happens
    Can you be more specific about the content of the file? I provided some alternative coding depending on the information available.

    As far as not seeing anything, there was no code to cause a display of anything. I could have added some verification content to display what was done, but didn't. The other part of this is if there was a mydebug log generated when attempting to execute the file? That should be located in the logs directory if it was created.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  3. #13
    Join Date
    Mar 2006
    Posts
    477
    Plugin Contributions
    0

    Default Re: how to delete photos with SQL query?

    Quote Originally Posted by mc12345678 View Post
    Can you be more specific about the content of the file? I provided some alternative coding depending on the information available.

    As far as not seeing anything, there was no code to cause a display of anything. I could have added some verification content to display what was done, but didn't. The other part of this is if there was a mydebug log generated when attempting to execute the file? That should be located in the logs directory if it was created.
    i'm confused. so this isn't going to make a page we can just paste the photo file path into and delete the photos right from the admin area?
    We sell ATV, Dirtbike, Streetbike, Snowmobile, Watercraft & Custom stickers & Banners. Check us out www.AD-DiscountPerformance.com

  4. #14
    Join Date
    Jul 2012
    Posts
    16,743
    Plugin Contributions
    17

    Default Re: how to delete photos with SQL query?

    No, the code provided does not create an interactional page, it simply executes the deletion of the files populated in the array.

    Creating a secure method of deleting user entered information takes a little more to do and involves incorporating user feedback on the operation.

    From the security standpoint, if the proper analysis of the user entered information was not considered, then entering the path ../index.php could delete the site's main file controlling operation.

    Instead, what was provided was a file that when path/file1 was replaced with the sub-directory in which the image was located (if any) and the image name that the specific file would be deleted. A quick and dirty program to accomplish a task having a known list of images to be removed.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Replies: 9
    Last Post: 12 Jul 2023, 12:26 AM
  2. v154 Help with a SQL Query for Query Builder
    By lindasdd in forum Managing Customers and Orders
    Replies: 2
    Last Post: 24 Mar 2016, 01:18 PM
  3. Delete Old Order IDs 1 to 3369 Using SQL Query
    By limelites in forum General Questions
    Replies: 1
    Last Post: 12 Apr 2013, 02:29 PM
  4. SQL Query to Delete All Products Only
    By toussi in forum General Questions
    Replies: 0
    Last Post: 26 Nov 2008, 06:57 PM
  5. How would I do this with an sql query?
    By member in forum General Questions
    Replies: 2
    Last Post: 22 Mar 2008, 05:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR