Find Jobs
Hire Freelancers

279870 PHP SCRIPT / DB BULK INSERTS

N/A

Tamamlandı
İlan edilme: 15 yıldan fazla önce

N/A

Teslimde ödenir
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.
Proje No: 2026159

Proje hakkında

1 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 12 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
As discussed.
$103 USD 5 gün içinde
4,9 (508 değerlendirme)
7,3
7,3

Müşteri hakkında

   PORTUGAL bayrağı
Aveiro, Portugal
5,0
2
Eyl 10, 2007 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.