Peruttu

PHP Mysql data Interface

This is to develop an https based api, rather than a "website" in the conventional sense.

In other words, whilst the development and testing phase can be done using a browser, it is intended that the api be interacted with by apps running on smart phones.

the basic concept is a simple mechanism for an app to store and share small pieces of information on an ad hoc basis.

the data will be stored in mysql tables, and the server code will be in either php or perl (your choice)

please do not bid unless you can provide hosting during the development and testing phase (beyond this I will maintain code myself and host myself)

please include all versions numbers of php mysql and any other tools you will use in your bid

a basic specification follows - some security measures will be added later not to be discussed on this forum.

tables

table:storage

storageId - large integer - primary key

deviceId - string - up to 64 chars

privacyMode - Integer - see below

appId - Integer

appDataId - largeInteger

data - binary variable length (1 byte to 1 mb)

table:permissions

storageId - large integer - primary key

deviceId - string - up to 64 chars - primary key

storageId in storage table has 1 to many relationship with permissions table

privacy modes (for privacyMode in storage table)

0 private read write (records with this can only be read/written by device that created the record)

1 shared read only (records with this can be read by devices with an entry in the permissions table)

2 shared read write (records with this can be read or altered by devices with an entry in the permissions table)

3 public read only (records with this can be read by any device)

4 public read write (records with this can be read or written by any device)

http requests/responses

/createData - creates a record and returns it's storageId

fields:

deviceId - string - up to 64 chars

privacyMode - Integer - see below

appId - Integer

appDataId - largeInteger

data - binary variable length (1 byte to 1 mb)

returns:storageId for new record

/addPermission - creates an entry in the permissions table, if it does not already exist.

fields:

storageId

deviceId

returns:0 or 1, (1 means already existed)

/removePermission - removes a permission entry

storageId

deviceId - if null, remove all permissions for storageId

/retrieveData - retrieves data from storage table

fields:

readingDeviceId - who is asking for data

storageId

note: unless readingDeviceId = deviceId in storage table, privacy mode must be checked.

returns:

storageId

deviceId

appId

appDataId

data

/retrieveAppData - retrieves data from storage table

readingDeviceId - who is asking for data

appId

appDataId

note: unless readingDeviceId = deviceId in storage table, privacy mode must be checked.

returns:

storageId

deviceId

appId

appDataId

data

/updateData - replaces data for a record

writingDeviceId - who is writing the data

storageId

data

note: unless readingDeviceId = deviceId in storage table, privacy mode must be checked.

/updateAppData - replaces data in storage table, app specific

writingDeviceId - who is writing the data

appId

appDataId

data

/removeData - removes a record from storage table, and corresponding permissions table

deviceId - who is deleting the record (must match storage table)

storageId - record to delete

/removeAppData - app data version of /removeData (looks up app & appDataId)

deviceId - who is deleting the record (must match storage table)

appId

appDataId

Taidot: Apache, graafinen suunnittelu, Perl, PHP, verkkosivujen suunnittelu

Näytä lisää: writing numbers words, writing modes, writing code apps, website development simple words, website development perl, using numbers writing, string match, small writing table, simple php forum code, simple binary code, simple binary, shared variable, primary data, php development forum, modes writing, match string, interface security, development php tools, data key entry, data host, data entry security, data entry devices, data entry device, ad choice, data entry apps

About the Employer:
( 0 reviews ) Melbourne, Australia

Projektin tunnus: #1704054

15 freelanceria on tarjonnut keskimäärin 207 $ tähän työhön

SoftSandila

hi i can help, regards, adnan

250 $ AUD 6 päivässä
(93 arvostelua)
6.7
khanhhuyna

I'm very good with php/mysql and very happy work this for you. Thanks.

350 $ AUD 7 päivässä
(94 arvostelua)
6.6
Mindon

check the message board please,thanks.

250 $ AUD 5 päivässä
(94 arvostelua)
6.6
sam45

can do! all information in the PM :)

250 $ AUD 5 päivässä
(104 arvostelua)
6.4
mikesteve

Hi Expert in PHP/Mysql..Can do this task..check details in PM..

100 $ AUD 4 päivässä
(68 arvostelua)
6.4
wildlily980

I can do this.

250 $ AUD 4 päivässä
(44 arvostelua)
6.3
stdhtelkom

Hi, I am interested and ready to help you. Thanks, Steve

200 $ AUD 3 päivässä
(25 arvostelua)
6.1
MAST3R

You have pm

200 $ AUD 3 päivässä
(11 arvostelua)
5.6
stefanache

Hello, Please consult PMB. Thanks.

180 $ AUD 3 päivässä
(15 arvostelua)
5.0
kazey

Hi, I am using PHP 5.3.8 and MYSQL 5.5.15. I would like to do this, Details of this bid is in private.

200 $ AUD 3 päivässä
(5 arvostelua)
4.4
JimMackin

Hi, I'm a skilled PHP and MySQL programmer who uses PHP daily in my day job. Thanks for your consideration, Jim

175 $ AUD 8 päivässä
(1 arvostelu)
1.8
amritarawat3

Hi, We have send you the price for 6 days and 2 days is for testing and bug fixing. And if you want the exact price then we can let you know the price after the detail discussion. I want to introd Lisää

250 $ AUD 8 päivässä
(0 arvostelua)
3.2
FWX63mtV7

Custom Software Development - <b><i>Removed by Admin</i></b>

250 $ AUD 1 päivässä
(0 arvostelua)
0.0
hamnakhancsit

hi,if you give me an oppurtunity you will like my work..thanx

200 $ AUD 7 päivässä
(0 arvostelua)
0.0
dhanraj82

Hello sir I have 5 years exp in web development area. I had developed several sites in this period. I have use my sql ajax jquery json php for those project. I will defiantly complete ur task. Just send me your de Lisää

200 $ AUD 15 päivässä
(0 arvostelua)
0.0
flotwig

I have experience with PHP, MySQL, APIs of all kinds and heavy experience with APIs which utilize JSON. I am running PHP 5.3.13 and MySQL 5.5.25 on Debian 6 with the latest nginx install.

50 $ AUD 10 päivässä
(0 arvostelua)
0.0