Find Jobs
Hire Freelancers

Need Develop Custom API Connect to remote DataBase

$100-300 USD

Geschlossen
Veröffentlicht vor etwa 3 Jahren

$100-300 USD

Bezahlt bei Lieferung
I currently have a fully developed script that works properly. The script is divided into two parts, one runs on the server and the other on the client, the script on the client calls the server to use these files and process payments. The problem is that currently the server uses the client database directly and whitelisted 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 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 that are on the server and process the payments. IMPORTANT: The script will be delivered encrypted so the freelancer must carry out the development of the project between the two points that are available without encryption (Server -> [login to view URL] / [login to view URL] // Client -> [login to view URL] / Client UI calls [login to view URL]) Requirements: 1. Make PHP API connect to remote client database through web server and PHP without opening ports or without allowing direct access to database server from external sources, API must allow to connect to several clients to the server automatically, the APi must obtain the information from the client's database to generate and return the result. (Sebe must implement something like a MYSQLTUNNEL to connect client and server or an API with SOAP between client and server) 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 some option such as JWT, OpenSSL, AES) 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 be cleaned automatically 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 (, , any .), the blacklist will be handled in a MYSQL table on the server indicated above, the table in the database must be called api_blacklist_service. The selected Freelancer will only have access to the FTP, Database Access data, the freelancer must carry out the development on the client and server delivered where they can perform the corresponding tests and development.
Projekt-ID: 30067482

Über das Projekt

9 Vorschläge
Remote Projekt
Aktiv vor 3 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
9 Freelancer bieten im Durchschnitt $307 USD für diesen Auftrag
Avatar des Nutzers
Hello Thanks very much for the detailed information, this helped to understand the complete scenario place the correct estimate. I could not understand one point though, how is the database on the client is update? is the client having a static ip? can you please also explain the setup of the client, what is the exact infrastructure. Please open communication for descussion. Regards Farhan
$400 USD in 15 Tagen
5,0 (2 Bewertungen)
1,3
1,3
Avatar des Nutzers
Hi, I have experience of dealing with many types of API and I can make your API working fairly well. I am especially good at APIs for Payment Gateway Integration. Your API tool will be built under great professional skills. I can share my github API dev history and it might be a great help to you. Let's discuss about this.
$200 USD in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
-previous experience in such topics; -eager to discuss a lot in this chat stream; -degree stats/maths;
$300 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von COLOMBIA
Bogotá, Colombia
5,0
5
Zahlungsmethode verifiziert
Mitglied seit März 4, 2014

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.