In Progress

PHP / CGI to Update MySQL

Hello,

We have one image directory on our Linux server that contains many .jpg and .gif images. These image files are named after an ID -- some IDs have more than one image. Here is an actual file listing of this directory:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

ID NUMBER 1 has 4 total images (1,1b,1c,1d), and ID NUMBER 2 has 2 total images (2,2b).

What we need is a PHP or CGI script to read the filenames in this directory and update our MySQL database in one single table.

The database table fields are:

ID

Filename1

Filename2

Filename3

Filename4

Filename5

Filename6

Filename7

Filename8

Filename9

Filename10

Filename11

Filename12

Filename13

Filename14

Filename15

Filename16

Filename1 through Filename16 is the name of the image files for that ID. When the script is executed, it must insert or update the table like this:

ID: 1

Filename1: [url removed, login to view]

Filename2: [url removed, login to view]

Filename3: [url removed, login to view]

Filename4: [url removed, login to view]

ID: 2

Filename1: [url removed, login to view]

Filename2: [url removed, login to view]

ID: 3

Filename1: [url removed, login to view]

ID: 4

Filename4: [url removed, login to view]

We will use FTP to upload new pictures every day to our image directory. Some pictures will be new ID numbers (these will need to be added to the database), some will be replacement images ([url removed, login to view] could become [url removed, login to view], or it could be deleted), and some images could be additional images for an existing ID (for example, [url removed, login to view] and [url removed, login to view]) and these will need to be added to the database.

After our FTP upload, we will run the script to do the database update.

Please ask any questions before bidding. Thank you for your interest.

Skills: Perl, PHP

See more: cgi update mysql, php id, mysql questions, update mysql gif, php update mysql, mysql update set cgi, update mysql perl cgi, update number mysql database, update mysql, update listing, run update, php perl, mysql, mysql 4, linux update, cgi php server, cgi images, c update, c mysql, additional php, mysql read files, script update database mysql, upload gif, table jpg, php replacement

About the Employer:
( 85 reviews ) Grandville, United States

Project ID: #55632

Awarded to:

bruzli2005

Very easy, 2 hour and done.

$30 USD in 0 days
(133 Reviews)
7.1

8 freelancers are bidding on average $71 for this job

tisindiadelhi

Can be done perfectly. Lets start:)

$100 USD in 0 days
(36 Reviews)
7.2
pinoywebdev

I understand very well what you need. Pick me for this project and I will give you the right script.

$100 USD in 5 days
(38 Reviews)
6.1
vnWebWorld

Hi, pls kindly check PMB. THanks.

$80 USD in 1 day
(13 Reviews)
5.3
Romka

Ready to fast and nice work. Please look your PMB.

$50 USD in 1 day
(5 Reviews)
4.1
yuniar

I will help you with this. Please see PM. Thanks.

$30 USD in 2 days
(7 Reviews)
3.9
kskumar31

I clearly understood what you want.Release this project to me and I will give you the best result.

$75 USD in 5 days
(0 Reviews)
0.0
genisys

Please see PM.

$100 USD in 5 days
(0 Reviews)
0.0