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

完了済み 投稿 5年前 着払い
完了済み 着払い

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 ソフトウェアアーキテクチャ

プロジェクトID: #17458812

プロジェクトについて

10個の提案 リモートプロジェクト アクティブ 5年前

アワード:

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 3日以内
(287レビュー)
7.5

10人のフリーランサーが、平均$188 で、この仕事に入札しています。

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 もっと

$200 USD 3日以内
(127件のレビュー)
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 5日以内
(53件のレビュー)
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 もっと

$155 USD 3日以内
(9件のレビュー)
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 3日以内
(5件のレビュー)
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 2日以内
(46件のレビュー)
3.3