Đã Hủy

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

Kỹ năng: Apache, Thiết kế đồ họa, Perl, PHP, Thiết kế trang web

Xem thêm: writing numbers in words, writing numbers 1 20, writing modes, writing code for apps, who is develop php, website development in simple words, website development in perl, using numbers in writing, string match, small writing table, simple php forum code, simple binary code, simple binary, shared variable, primary data, php development forum, php checked checked, modes of writing, match string, interface security, development php tools, data key entry, data host, data entry security, data entry devices

Về Bên Thuê:
( 0 nhận xét ) Melbourne, Australia

Mã Dự Án: #1704054

15 freelancer đang chào giá trung bình $207 cho công việc này

SoftSandila

hi i can help, regards, adnan

$250 AUD trong 6 ngày
(93 Đánh Giá)
6.7
khanhhuyna

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

$350 AUD trong 7 ngày
(94 Đánh Giá)
6.6
Mindon

check the message board please,thanks.

$250 AUD trong 5 ngày
(94 Đánh Giá)
6.6
sam45

can do! all information in the PM :)

$250 AUD trong 5 ngày
(104 Đánh Giá)
6.4
mikesteve

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

$100 AUD trong 4 ngày
(68 Đánh Giá)
6.4
wildlily980

I can do this.

$250 AUD trong 4 ngày
(44 Đánh Giá)
6.3
stdhtelkom

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

$200 AUD trong 3 ngày
(25 Đánh Giá)
6.1
MAST3R

You have pm

$200 AUD trong 3 ngày
(11 Đánh Giá)
5.6
stefanache

Hello, Please consult PMB. Thanks.

$180 AUD trong 3 ngày
(15 Đánh Giá)
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 trong 3 ngày
(5 Đánh Giá)
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 trong 8 ngày
(1 Đánh Giá)
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 Thêm

$250 AUD trong 8 ngày
(0 Đánh Giá)
3.2
FWX63mtV7

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

$250 AUD trong 1 ngày
(0 Đánh Giá)
0.0
hamnakhancsit

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

$200 AUD trong 7 ngày
(0 Đánh Giá)
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 Thêm

$200 AUD trong 15 ngày
(0 Đánh Giá)
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 trong 10 ngày
(0 Đánh Giá)
0.0