PHP Scripts with MySQL Storage; backup with CroneJob

See attached document for better layout


Develop a internet service (PHP/MySQL).


Develop server side of service and provide an example of the client side.


Server: providing Name->address service

Client-data provider: -> registers local IP address with serial number at server

Client-data consumer -> Asks server for local IP address of client-data provided by sending serial number of client-data provider.


• PHP Scripts

o StoreAddress01(password, serialnumber, localIPAddress, Name, varA, VarB) => result (OK|ErrorNumber)

 Server checks password and stores serial number, localAddress, Name, VarA, VarB and the detected global IP address

o GetAddress01(password, serialNumber) => result, LocalIPAddress, Name, VarA

 Server checks password and searches in MySQL database for serialnumber and provides ResultCode, GlobalIPAddress, LocalIPAddress, Name, VarA and VarB;

o GetDevices01(password) => list of devices reported at GlobalIPAddress

 Server detects from which GlobalIPAddress the request is submitted and provides a list of devices that are available at this global IP address (Format: list of GetAddress function above)

o GetDateTime01(password) => return year, month, mday, wday, hour, min, sec

• Empty database

o And empty database that can be used with phpMyAdmin in order to setup an empty database

• CroneJob for

o Automatic periodic backup of the database including sending a zipped copy through email

o Running dashboard scripts below

• Dashboard script (results in separate database; results through php script with password)

o Store total number of clients-data providers (total number of registered serial numbers)

• Support to get stuff up and running

• Document with interface functions (PHP scripts with definition of variables and error codes)


The service is a kind of Name to IP address service. Clients register their local IP address with the clients serial number at the server. The server stores this local IP address together with the provided serial number and name, WLAN IP address and some additional variables in the database.

Clients can contact each other by requesting the server for the local IP address by passing the serial number to the server (Both clients are connected in the same local network)

There is one server (Providing this service) and two type of clients. First type of client is a system that registers it's IP address and additional information and the second type of client requests information (requests an IP address for a name)

Skills: Linux, MySQL, PHP, Web Security

See more: server side scripts, php codes list, document layout service, develop dashboard in php, copy definition, client side scripts, definition of format, database scripts with php and mysql, vara, PHP SCRIPTS, php dashboard, network sec, mysql backup, local storage, ip sec, document storage, dashboard client list, php script store email mysql, together mysql, php backup mysql, php hour min, mysql stuff, dashboard layout, order number mysql, storage functions

About the Employer:
( 7 reviews ) Aldeboarn, Netherlands

Project ID: #5331008

8 freelancers are bidding on average €271 for this job


Hi there, I have over 7 years experience working on HTML, Wordpress, Magento, Database administration, OpenCart, Website Design, Logo / Banner Design Joomla, CSS and Linux Administration. I have read the project descri More

€206 EUR in 6 days
(365 Reviews)

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wro More

€773 EUR in 4 days
(475 Reviews)

Hello Hiring manager, Greetings from Evidcomm!!! We have gone through your requirements and would be pleased to work on. We have already done this kind of work in past and surely we will get finished this project More

€201 EUR in 6 days
(31 Reviews)

Dear sir, I will complete your project within 5 days and provide ONE YEAR free bug guarantee.. I have gone through your outsourced requirement "PHP Scripts with MySQL Storage; backup with CroneJob" and have analyzed More

€301 EUR in 365 days
(65 Reviews)

Hello, It is our pleasure to bid on your project. GNA Infotech is a web design and Development Company. We will provide you high quality work which mention as per your job parameters within the timeline. We More

€257 EUR in 3 days
(15 Reviews)

I understand the requirements. I'll create this service, which will store local IP with serial no. and then you can fetch IP by serial number, and it'll have all that you are looking for. Please come on chat for furt More

€151 EUR in 3 days
(5 Reviews)

Hello Mr Wittenveen. I'm a Brazillian programmer and I'm very interested in building your service. I believe that I can provide a reliable service to you. I'll be waiting your contact. Thank You --Vinicius More

€133 EUR in 3 days
(1 Review)

Hi I Previous developed database backup script, Crone & mail kindly reply so we can discuses Hi I am Deepak & I had 5 Year experience in :- I have expertise in this Technologies & Platform :- PHP5, Codeignite More

€128 EUR in 6 days
(1 Review)

Hello Sir, Our company and team is expert in all Website Development and Designing work and we work as per the Latest technology. We are delivering excellent, affordable services in Web Design, Web Development and e-co More

€155 EUR in 3 days
(3 Reviews)

Hi There, I am senior web application developer with 6+ years experience, can do quick demo if you want to test my ability, thank you. Best Regards, Sow

€200 EUR in 7 days
(0 Reviews)

Hi, Everything seems clear from your specification. The only question I have right now is about the request and response format. It sounds like REST service (using POST/GET methods), and JSON/XML for response, right More

€250 EUR in 3 days
(0 Reviews)