Find Jobs
Hire Freelancers

279870 PHP SCRIPT / DB BULK INSERTS

N/A

Concluído
Publicado há mais de 15 anos

N/A

Pago na entrega
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.
ID do Projeto: 2026159

Sobre o projeto

1 proposta
Projeto remoto
Ativo há 12 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
As discussed.
$103 USD em 5 dias
4,9 (508 avaliações)
7,3
7,3

Sobre o cliente

Bandeira do(a) PORTUGAL
Aveiro, Portugal
5,0
2
Membro desde set. 10, 2007

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.