In Progress

Rapid php mysql script

I need a very fast turnaround on a simple set of functions that create responses for post statements. We have a very small database with 4 tables (User, admin, options and data). The current application is simply there to manage user log-ins and managers a user community created by? [url removed, login to view] We have extended the db by one table.

We now would like to be able to access the database via post commands that are secured by a session cookie. We expect to be able to interogate the db by sending urls (post)

We expect a range of commands to be enables including user managemnt calls such as register, confirm, change, inactivate, changepass, searchuser, listusers) but also some data exchanges with the new table (find,get,put,delete).? We reward puctuality! We will need daily communication on progress.?

## Deliverables

Clarification of the [url removed, login to view] script that will intorogate the attached mysql database:

URLS are sent to the webserver looking like this:? <[url removed, login to view]>

The php script will resolve the request and call functions withing a function script that wil generate return xml similar to the following:

<SERVER>

? <RESPONSE>

? ? ? <SID>REYyMTgzRTNGNjU1Qjc2RjkxRTAxNzJBNDc2RTdFQjR8MTkx

? ? ? </SID>

? ? </RESPONSE>

</SERVER>

The following calls must be supported on the User table:

- register (Registers a new user)- returns TRUE/FALSE

- confirm (Confirms a new registered user? - client side send) returns TRUE/FLASE

- login (creates the session id) - Returns Session ID

- logout (logs a user out) - Returns TRUE/FALSE

- change (Change any field in the user table except user or userid) - Returns? TRUE/FALSE

- deactivate (closes a user account) - Returns? TRUE/FALSE

- reactivate (reactivates a user) - Returns? TRUE/FALSE

- delete (deletes a user account) -? Returns TRUE/FALSE

- finduser (allows users to be found based on any wildcard search element within user) - Returns list of multiple records and details of each account

- finduserlight (as above, but only returns userid and username)

- userinfo (recalls 1 user records) - returns all information on one user

In regards to the data table only a few capabilities are required:

- delete line (based on name and type field)

- find record (based on wild card search in any field)

- retrieve record (based on name and type input)

- create record including long text post in foeld data!!!

- amend record including long text in field data!!!!

- addtodata (adds data at the end of the data field)

- retrievedata (simpley presents back the content of the datafield with no xml around it as a .xml (simply assume we will be storing xml documents in the data field, so we don't need more tags :)

I would expect something like this on the phpside:

// This is the vairable that sets the root path of the website

$Root_Path = "./";

$config = $Root_Path."[url removed, login to view]";

require($Root_Path."[url removed, login to view]");//<- the main script you deliver!

// Get variables

$action = $_GET['action'];

$xsid = $_GET['sid'];

$data = $_GET['data'];

$userid = $_GET['useridid'];

...

function isSessionIDValid($config, $xsid)

{...}

switch($action){

///////////////////////////////////////////////////////////////////////////////////////////

// LOGOUT

// Params: action, sid

////////////////////////////////////////////////////////////////////////////////////////////

case "logout":

? if(isSessionIDValid($config, $xsid)){

? //Instantiate the? command Class

? ? ? $ocommand = new command($config);

? ? ? $sid = $ocommand->delete_session($config, $xsid);

? ? ? unset($ocommand);

? ? ? echo "<RESPONSE>\n";

? ? ? echo "<LOGOUT>TRUE</LOGOUT>\n";

? ? ? echo "</RESPONSE>\n";

? ? }else{

? ? ? echo "<RESPONSE>\n";

? ? ? echo "<LOGOUT>FLASE</LOGOUT>\n";

? ? ? echo "</RESPONSE>\n";

}

break;

////////////////////////////////////////////////////////////////////////////////////////////

// LOGIN

// Params: action, user, pass

////////////////////////////////////////////////////////////////////////////////////////////

case "login":

....

The main delivery is the [url removed, login to view] where all the functions are housed, and the [url removed, login to view] where the get is being processed. [url removed, login to view] will be included via include(see above) in [url removed, login to view]

I hope this should be straight forward ifor a coder who has done this type of work before.

I have attached files here which is the original maaking script (as downloaded from the site) and the database dump from mysql which shows the db as well as the aditional table for the data. Please make sure that this works with the database as it is included, and not using different lables or names.

Kind regards

pgnnew

Skills: Amazon Web Services, Anything Goes, Engineering, MySQL, PHP, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: wild at work, where to find xml files, where is community set, return path, register a new name server, rapid works, rapid coder, php main functions, php find element in xml, mysql database name in include config php, find set-root, find php id of a website, fast switch, action script list, rapid it, php end script, rapid, php script create table, php command, find root, Community managers, communication engineering, php xml delete, session php login, create admin login php mysql

About the Employer:
( 59 reviews ) Weybridge, United Kingdom

Project ID: #3081598

Awarded to:

infinitydes

See private message.

$85 USD in 3 days
(6 Reviews)
3.0

11 freelancers are bidding on average $99 for this job

khalidsafwatvw

See private message.

$85 USD in 3 days
(65 Reviews)
5.5
geniussoftwvw

See private message.

$110.5 USD in 3 days
(20 Reviews)
4.8
webdevdad

See private message.

$119 USD in 3 days
(40 Reviews)
4.6
Cexpert

See private message.

$85 USD in 3 days
(14 Reviews)
4.6
saikatewu

See private message.

$80.75 USD in 3 days
(12 Reviews)
3.8
ashishsalveeug53

See private message.

$119 USD in 3 days
(15 Reviews)
3.5
khali6581

See private message.

$127.5 USD in 3 days
(8 Reviews)
3.2
blackfirelx

See private message.

$63.75 USD in 3 days
(11 Reviews)
2.1
birsansl

See private message.

$127.5 USD in 3 days
(0 Reviews)
0.0
soonsoftpvt

See private message.

$85 USD in 3 days
(0 Reviews)
0.0