PHP Scripts with MySQL Storage; backup with CroneJob - repost

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:
( 0 reviews ) Hyderabad, India

Project ID: #5331091

3 freelancers are bidding on average $151 for this job


Hello my name is Matt Andrews, I am a Senior Systems admin I believe I can complete your project. Please consider my bid and check out my resume and reviews. [url removed, login to view]

$200 USD in 5 days
(11 Reviews)

hello sir i can provide you the requirements you want in the mean time and i can work with you in the future too..i have good xperience and i am excellent in php and mysql u can depend on please co More

$166 USD in 3 days
(2 Reviews)

Hello, I have strong knowledge developing database applications with php and mysql. I have completes several projects with php, mysql and hrml can css fornicated. I have also a strong knowledge on javascript program More

$88 USD in 5 days
(1 Review)