Käynnissä

Custom API Connect to a remote database

Currently I have a fully developed script working properly.

The script is divided into two parts, one runs on the server and the other on the client, the script found on the client calls the server to use these files and process payments.

The problem is that currently the server uses the client's database directly and with whitelist in cpanel to allow connection and it only works with 1 client.

It seeks to develop an API that connects to the remote database of clients through the web server and PHP without opening ports or allowing direct access to the DB server from external sources or using whitelist in the case of Cpanel, which allows Multiple clients connect and consume the server API.

The client needs to call the server through the custom API and send the corresponding information, to use the files found on the server and process payments

Requirements:

1. Make PHP API connecting to remote client database via web server and PHP without opening ports or allowing direct access to DB server from external sources, functions must be converted correctly and use good programming practices, The API should process the client's request and use the information from its database to generate and return the result.

2. After developing the custom API, an authentication system must be implemented:

The API must be used exclusively by authenticated clients, the authentication will be done with the domain / subdomain name and the client's license as the authentication method.

For this point, a MYSQL table is used on a server where there is a list with linked domains and licenses that is constantly updated.

3. It is very important that security measures are implemented (the information between client and server must be encrypted using OpenSSL / Public and Private Key)

4. The API carried out must generate a log of the users who use / call it with the data: Date, IP, domain / subdomain This log can be consulted in a simple page of the server that is shown as a table with the following columns: Date, IP, Domain, Action and it will automatically clean every 60 days without using CRON, you can use a timestamp and put a button to delete them manually.

5. You must make a simple page that shows a blacklist as a table in PHP on the server and that allows adding to the blacklist the domains / subdomains or IP's that cannot use the API ([login to view URL], [login to view URL] , any .[login to view URL]), the blacklist will be handled in a MYSQL table on the server indicated above, the table in the database should be called api_blacklist_service.

The selected Freelancer will only be given access to the FTP data, Database Access, the freelancer must carry out the development on the client and server delivered where they can perform the corresponding tests.

Taidot: PHP, MySQL, Tietojärjestelmäarkkitehtuuri, API, Full Stack Development

Näytä lisää: connect remote computer database, connect custom flash player video database, connect remote db2 database python, phonegap connect remote database, connect remote mysql database, phonegap connect remote database retrieve, php connect remote access database windows server, php connect remote access database windows, connect phonegap app remote database, android api remote database, connect remote database proxy, connect android app remote database, connect metatrader custom api, sql connect remote database, mysql connect to remote database command line, mysql workbench connect to remote database ssh, firebird connect to remote database

Tietoa työnantajasta:
( 5 arvostelua ) Bogotá, Colombia

Projektin tunnus: #29935037

Myönnetty käyttäjälle:

mateodev0907

I am a php and mysql expert. I read deeply into your requirements. I can satisfy your needs. May I install nigux for your requirements. I will wait for your message.

$200 USD 7 päivässä
(0 Arvostelua)
0.0

6 freelanceria on tarjonnut keskimäärin $248 tähän työhön

Lavlu

Hello Sir, Project : Custom API Connect to a remote database I understand project scope but having few questions that needs to be clear in more detail. Please let me know if we can discuss the requirement over chat o Lisää

$200 USD 5 päivässä
(42 arvostelua)
7.0
patelnirav903

Hi Greetings of the day. I would like to apply to this job. I do customized solutions for Web Technologies Like PHP I have read your description and keen to provide you all the tasks to be done. I hav Lisää

$299 USD 4 päivässä
(1 arvostelu)
1.2
skyeslar

REST API GENERATION EXPERT USING PHP Crafting Uniqueness for Digital Presence with the highest ROI Don’t let your website be just another URL on the web. I am here to convert it into a powerful marketing medium and a Lisää

$289 USD 3 päivässä
(0 arvostelua)
0.0
nanditapatel2021

Hi there, I have gone through your project requirement and I have the exact match with the skills you want for a current project. As I am expertise in WordPress, PHP, Laravel, CSS, HTML, etc. of 8+ years. Areas of ex Lisää

$200 USD 7 päivässä
(0 arvostelua)
0.0
jitunbisoy

I am a php developer having more than 6 years of working experience and more excited to work with API manufacturing. I found this project worth working for best of my knowledge and experience.

$300 USD 7 päivässä
(0 arvostelua)
0.0