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.

Compétences : AJAX, Javascript, MySQL, PHP, Architecture Logicielle

en voir plus : 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

Concernant l'employeur :
( 7 commentaires ) CORREZZANA, Italy

Nº du projet : #17458812

Décerné à:


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.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(287 Commentaires)

10 freelance font une offre moyenne de $188 pour ce travail


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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(127 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(48 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(53 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(41 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(9 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(46 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(33 Commentaires)