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

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

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 Arquitectura de software

Nº del proyecto: #17458812

Sobre el proyecto

10 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

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 en 3 días
(287 comentarios)
7.5

10 freelancers están ofertando un promedio de $188 por este trabajo

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 Más

$200 USD en 3 días
(127 comentarios)
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 en 5 días
(53 comentarios)
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 Más

$155 USD en 3 días
(9 comentarios)
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 en 3 días
(5 comentarios)
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 en 2 días
(46 comentarios)
3.3