Rename files with data from database

I have a mysql database with a user table in this table you have a field: avatar with for example this data: [login to view URL]

I need a php or sh script that does the following:

- Connect to database get user_id and avatar data

- get the user_id from the field: id

- get the avatar data from field: avatar

- Check if file is in directory: memberpictures/avatar if so

- Copy file to directory/avatar/new/

- rename file to: avatar_big_[user_id]_[originalfilename] for example: [login to view URL]

- Check if file is in directory: memberpictures/avatar/thumbs/ if so

- Copy file to directory/avatar/new/

- rename file to: avatar_[user_id]_[originalfilename] for example: [login to view URL]

And that for all 1000 records in the database.

Taidot: MySQL, PHP, Ohjelmointi, Shell Script

Näytä lisää: export data database excel aspnet, prosject 2007 data database, external files convert database, localdb rename database, sql server rename physical database files, mssql rename database with files, rename a database and its mdf and ldf files in sql server, rename physical file name sql server, how to rename mdf and ldf files in sql server 2014, how to rename mdf and ldf files in sql server 2012, sql server rename database file, create email form puts data database, google maps loading data database, need 1000 mail day mail, visual basic adding data database, data database, interface rfid data database, reorganize data database php, add data database php form, excel macro enter data database

Tietoa työnantajasta:
( 78 arvostelua ) Lelystad, Netherlands

Projektin tunnus: #17726308

Myönnetty käyttäjälle:


Hi I can do this for you with a sh script! I put as deadline two days but I think that only one must be enough! Message me if you are interested! Thanks!

$15 USD 2 päivässä
(0 Arvostelua)

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Sir, I have gone through your project description and am looking to provide my service for database work. For more than 7 years I’ve worked in this field. web projects [login to view URL] [login to view URL] Lisää

$50 USD 2 päivässä
(132 arvostelua)

Hello I want to do it for you. Thanks

$25 USD 1 päivässä
(107 arvostelua)

Hi, I read carefully your project, and I wanna do it for you. If you wanna work together, send me a message to discuss details. I am an experienced Web Developer

$20 USD 1 päivässä
(47 arvostelua)

Hello. I have good skills in MySQL, PHP, Programming, Shell Script. I can do your project perfectly. Contact me please. Thanks.

$50 USD 1 päivässä
(23 arvostelua)

hi sir i can do it i am very good in php and mysql just if you want please chat with me thanks ^-^ -

$30 USD 1 päivässä
(2 arvostelua)

Hi, I have 7 years of experience with PHP and MySQL. I have developed many websites using them. Please check my portfolios. This task is a piece of cake for me. I can do it in a few hours. Regards

$15 USD 1 päivässä
(1 arvostelu)

Dear sir. I read your job description and I am clear now. I can make the script with my PHP script. I am an expert who has good skills and rich experience. If you hire me, I can complete your job for a few hours. Lisää

$25 USD 0 päivässä
(0 arvostelua)