Find Jobs
Hire Freelancers

279870 PHP SCRIPT / DB BULK INSERTS

N/A

Slutfört
Publicerad över 15 år sedan

N/A

Betalning vid leverans
I have bought a link dump script, but i can only add items 1 by 1, and i'm looking for someone that can make an extra script to do BULK inserts in the database by importing a .txt file Example: To add an item manually i need to insert: Title, URL, Description, Image, Category, Publish Date, Status Let's say i have an [login to view URL] file with the following lines: [login to view URL]|Gallery Picture 1 [login to view URL]|Gallery Picture 2 [login to view URL]|Gallery Picture 3 In this example the [login to view URL] only has 2 fields (URL and Title) Line by Line the script should pick and add the URL, then sould add the Title, the Description field will be empty, the Category will be picked from a dropdown box or something like that (all items from an imported .txt file will ALL be added in the category selected, so there is no need to select a category for each URL of a .txt), publish date (immediately by default) and Status should be active by default too. The worst part should be the image, i need the script to read the URL and analyze it to pick a random image from each URL and then add it to the database, the random picture picked needs to be uploaded to the server to a common thumb folder, also it needs to give a random name to the picture file picked so that there aren't issues when uploading because the folder is the same for all thumb files. All galleries have about 10 to 20 images and a few more from the layout, the script should detect the most used name in all *.jpg files: Example: The script crawls one url of the [login to view URL] file and detects the following thumbnails: [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Obviously the pictures i need are those files that start with 0000*, so the script should detect the majority of the files that start with 0000, and then do a random to select only one of those and add it to the database and copy the thumb to the common thumbs folder in my server NOTE: This isn't just for picture galleries... i need it for video galleries too. No need to integrate this script in the administration NOTE: Some files imported may contain like 1000 urls , it doesn't matter how long those urls take to be added as long as the script inserts all of them correctly. So, resuming: - Import a .txt file with URL|Title - Script reads each url and title of each line of that .txt - Inserts Url, Title, description, thumb etc in the DB - Script picks 1 random thumb from each URL and copies it do the common thumbs folder with a random name and adds it to the DB It's up to you to find out the best and easiest way to do this. I will only complete the escrow when a working demo is provided by the programmer Check out the working script at: [login to view URL] L:demo P:demo I hope i made myself clear, please send PM if you didn't understood something.
Project ID: 2026159

Om projektet

1 anbud
Distansprojekt
Senaste aktivitet tolv år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
As discussed.
$103 USD Om 5 dagar
4,9 (508 omdömen)
7,3
7,3

Om kunden

Flagga för PORTUGAL
Aveiro, Portugal
5,0
2
Medlem sedan sep. 10, 2007

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.