Completed

Server side PHP API & client side PYTHON scripts to exchange MySQL data

REQUIREMENT: You must:

1. be able to speak English.

2. Please have a cell phone or clear Skype connection for AUDIO / voice calls so we can discuss this project initially. If you can’t accept phone call or Skype audio from me, please do not bid on this project.

3. Expert programmer in Python and PHP with MySQL database with UNIX / Linux experience

DEVELOP BOTH parts of project:

PART-1: [PHP/ MySQL] CREATE SERVER SIDE PHP API(s) with MySQL database on server side

PART-2: [Python/ MySQL] CLIENT SIDE PYTHON SCRIPT TO ALLOW DATA EXCHANGE with the API(s) from PART-1 and exchange with local MySQL database on client side.

SECURITY / PREVENTING HACKS

• API CODE MUST BE WRITTEN WITH ESCAPES, AND OTHER METHODS TO PREVENT SQL INJECTIONS, E.G. [url removed, login to view]

• [url removed, login to view]

ARCHITECTURE:

PART-1 On server side there are seven tables in the mysql database. I need you to develop PHP API code (perhaps using mysqli (not PDO)) to allow sending some data which the API inserts into some of the tables. APIs should also allow reading a data in various columns for a single row when provided with unique key for a given table. This API will run on my existing account on hostgator. You will be provided with FTP access and database username/ password. I can also provide full CPANEL access if needed.

PART-2 Client side will also contain seven tables in MySQL database. My client will run on Linux. I will provide you with SQL to create these seven tables and also create dummy test data. I think for the purpose of your development, you can develop on windows with python and MySQL. HOWEVER, my testing will be on Linux. Your code must run on my Linux client. On the client side, I need you to write a python script which will call the server to insert and update data on the server from the data which exists in the local database on the client side.

More information on tables names, sample SQLs, sample data, will be provided to you when I accept your bid; here is a summary of what I need:

• One row can be downloaded from server table using APIs, and this row’s data will be used to update the single row on the client table. In this scenario, there will always be only one row on the client table.

• When “dirty4server” column is “1” for certain rows, call API and insert them into the server table. Multiple rows can be updated from client table to server table. Some server tables will reject rows based on unique constraints in the case they were already inserted before;

• If there is a successful update of server rows then set the local “dirty4server” column to “0”.

• Call API and download any single row from server where “dirty4client” column is set to “1”. If there is a successful update on client side, set “dirty4client” column on server to “0”.

• No deletes are allowed in either direction

Skills: MySQL, PHP, Python

See more: what is test scenario, what is php used for in web development, what can you do with php and mysql, what can i do with php and mysql, web develop php, web develop on python, web development information security, test scenario wiki, testing skype connection, sql.programmer.expert, sql programmer expert, skype api for php, server side web development, server side scripts, scenario wiki, rest based api architecture, rest api architecture, python or php for web development, python exchange, programmer en php mysql

About the Employer:
( 21 reviews ) Chicago, United States

Project ID: #8155515

Awarded to:

teknogeek1

I have been programming in PHP, MySQL and Python for over 5 years and have a lot of experience doing things very similar to your project. I would love to follow up with you later and discuss.

$200 USD in 7 days
(1 Review)
3.3

11 freelancers are bidding on average $305 for this job

srinichal

I am an expert in PHP and willing to discuss further about the project specifications and details .

$261 USD in 5 days
(133 Reviews)
7.3
phpraza

php mysql expert here with 3 years of experience in web development. I have a strong expertiese in custom php development along with html/css and javascript. I have gone through the requirement and understood it. More

$200 USD in 3 days
(157 Reviews)
6.6
qlle

Hi. please contact me back. I think we can help you with this project. For the server code, I propose to go with Slim acts as routing and direct MySQLi or an ORM like Idorm/Paris. We have implemented this in the past s More

$533 USD in 14 days
(25 Reviews)
5.2
html5t

Hello ! Thanks for inviting me to the project. I would be glad to help you on the project. I will provide a secure solution with prevention to CSRF and XSS attacks. Will be great if we can discuss further on the req More

$444 USD in 10 days
(14 Reviews)
4.5
prateekchandan

Hi, I am very much suitable for this project as I have great expertise in both php and python. Also Linux is my main operating system and have worked heavily with databases. You have invited me for bid based on my p More

$180 USD in 3 days
(15 Reviews)
4.5
privatecaptain

hey thanks for inviting me to the project and i'm sure i can do this very well so looking forward to i t :)

$444 USD in 2 days
(5 Reviews)
4.3
ithuang2014

Hello. How are you? I saw your description . I understand it and can do it well. I have done several project like this. I'm an expert in Data Structures and Algorithms. And I know Java ,C/C++ ,PHP and P More

$178 USD in 3 days
(27 Reviews)
3.9
tommydevoss

A proposal has not yet been provided

$189 USD in 5 days
(13 Reviews)
3.6
futurama99

Hi, I have good experiences on both PHP API design and MySQL, even though I am knowing a little bit PYTHON but seems that's not a problem for me at this project. I think a lot programmers can do this job, I hope I c More

$120 USD in 3 days
(1 Review)
3.0
develooped

Hi there, 8yrs web developer with php/python/MySQL/SQLinjection experience here! I read the project and I'm ready to start right off the bat. I have only one question: will the script run on multiple clients More

$288 USD in 7 days
(1 Review)
2.7
chronossc

Hello, I'm Felipe. I'm a experienced full stack developer with 10+ years of experience. 7 years working with Python, Django, Flask and SQLAlchemy. Did few nice APIs over the years. I'm using linux since I'm 12, now I h More

$500 USD in 7 days
(0 Reviews)
0.0
abhisheksurana

Hello There, I've looked into your job post and understand that you are looking for an expert coder familiar with PHP API and PYTHON scripts to exchange MySQL data . I’d like to be considered for Wordpress Website pos More

$222 USD in 5 days
(0 Reviews)
0.0