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

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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

(file1)

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

Pull types are:

-FTP

-SFTP with password authentication

-SFTP with key file authentication (no password)

-SFTP with key file authentication (password)

-HTTP

-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).

Requirements:

- 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

(file2)

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.

AJAX JavaScript MySQL PHP Software Architecture

Project ID: #17458812

About the project

10 proposals Remote project Active 5 years ago

Awarded to:

liangjongai

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)
7.5

10 freelancers are bidding on average $188 for this job

CodingExpertz

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)
6.6
ripasahasl

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)
5.1
crocodile305

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)
4.8
bingdev

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)
3.9
MohanKumar28

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)
3.3