Php Script to import a txt file via FTP or SFTP (SSH2) or HTTP

I need a php 2 script (similar to each other)


1. reading variables from a mysql table connects according to the "pull type", either via FTP or SFTP or HTTP

Pull types are:


-SFTP with password authentication

-SFTP with key file authentication (no password)

-SFTP with key file authentication (password)


-HTTP with basic authentication

2. Copying the file contents to a tmp_files folder and then save it into a mysql (pull_data) table with LOAD DATA LOCAL INFILE, and then save into a log table the results (pull_log).


- The sftp key shall be retrieved from mysql

- Transfer shall make sure the content is only text ascii

- Files bigger than 20M shall be dropped (max size defined in config)

- Post comments in the scripts


Also, I need a another script I would call via jquery/Ajax with the same logical process (pull type) to test the connection params and say if the connection is valid. The script shall return a message (i.e. connection successful, file exists, failure message, etc.).

Please also provide a html page with with form fields and the Ajax call to test file2

Later I will provide you with a sample file to import and 3 mysql tables to be used, 1 table that stores the connection values, 1 table to save the values, 1 table with the log structure for file1.

Skills: AJAX, Javascript, MySQL, PHP, Software Architecture

See more: php ssh2_connect, php sftp download file, php sftp file transfer, php ssh2, php ssh2 disconnect, php sftp list files, php sftp with key, ssh2.sftp php, php script read folder file details, php script import file, php script import excel file, php script import txt mysql, import txt file sql server script, script import txt file database, php script import xls file, excel script import txt file, import txt file php script, import txt file sql server asp net vb script, php script convert txt pdf file, php script import xls file

About the Employer:
( 7 reviews ) CORREZZANA, Italy

Project ID: #17458812

Awarded to:


I'm interested in your project very well. I've got an experience in jobs with skills like yours. Please ping me to discuss about this project.

$155 USD in 3 days
(287 Reviews)

10 freelancers are bidding on average $188 for this job


Hi, Let me do it for you. I am an Independent Software professional haveing 12+ years of experience on web technologies and would love to work on your project. I look forward to the possibility of working toget More

$200 USD in 3 days
(127 Reviews)

Dear hiring manager, We have experienced developer on php more than 4 years and developed many sites and internal system. Hotel Management System: Admin Login: [login to view URL] Username: admin Pass More

$66 USD in 3 days
(48 Reviews)

I'm really very much interested in this interesting project. Let me know if You are interested in my profile or not.

$122 USD in 5 days
(53 Reviews)
$250 USD in 2 days
(41 Reviews)

Hi.. How are you? I saw your description carefully your project. Owing to my rich experience in php script , i can say i can do this perfectly. I have many top skills like AJAX, Javascript, MySQL, PHP, Software A More

$155 USD in 3 days
(9 Reviews)

I have seen your description carefully and have a great interest your demand. I have rich 7+ years in php development. Before I solved similar to this problem. I want to discuss more details. thanks.

$155 USD in 3 days
(5 Reviews)

Hi, I have checked the requirements. Good experience in writing custom scripts. Will do this script using PHP. Please share additional details. Regards, Mohan

$111 USD in 2 days
(46 Reviews)
$166 USD in 3 days
(0 Reviews)
$500 USD in 7 days
(33 Reviews)