PHP Custom Script - Check for Extra and Missing Files

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

We need a php script/page that can run on a windows server (IIS not apache) and do the following:

Input for:

1. Microsoft SQL Server host/ip

2. SQL username

3. SQL password

4. SQL query to return filenames. Assume the query will always have only 1 field returned called "filename".

5. Source Path

6. Move Path

The script will read in all filenames in the source path directory. It will then compare each file in the path with the "filename" column as specified in the SQL query input by the user (1/2/3/4) and insure that the file exists in the dataset. If it does not exist, the file is moved to the move path (7). Finally, the table is re-read to check for the existence of each file in the source path. If the file exists in the query but not in the file system, write out to the screen the value from the column.

The solution must be provided as source code that is not obfuscated. It can be 1 or more PHP files. If you require specific libraries other than standard PHP libraries, please advise of this in your proposal.

IIS Microsoft SQL Server PHP Windows Server

Project ID: #12509114

About the project

10 proposals Remote project Active 7 years ago

Awarded to:

amclint

This sounds pretty straightforward and I can help you with this project, I'm US based if you want to discuss more on the phone. I have done filesystem looping with PHP before and the query against the database should b More

$150 USD in 1 day
(11 Reviews)
4.2

10 freelancers are bidding on average $140 for this job

shijudasan

hihi I am a php full stack developer with vast experience(over 5 years) in many cms and php frameworks, I am also a plugin developer for wordpress and an extension developer for joomla, plugin developer for roundcube More

$222 USD in 2 days
(34 Reviews)
6.1
rlo56467a9097547

Hi, how are you If you are interested I can help with this project and I can do it right now If you agree send me a message Thanks for your time

$155 USD in 0 days
(62 Reviews)
5.3
mervf

I have read over your project description and I'm interested in completing your task. If you check my site or portfolio you will see that I am of a higher quality than most freelancers on here. I get it done quickly, e More

$173 USD in 3 days
(18 Reviews)
3.7