MySQL, PHP Job by jonheffernan

As per our discussion:

We are making a flash website for our client

we are localising for uk/fr/it/de/es/pt/dk

it has an application that sends virtual letters to santa

when a user visits the letter part of the application the website needs to contact a database to get the number of letters that have been sent. all country versions user the same database and the number sent = the total number sent.

TASK = write script for flash site to get total numbers of letter sent

When users write a letter to santa in the site they click 'send' and the flash site tells the database a letter is sent

the database must store the date/time this was sent, the country site it came from i.e. uk, the number sent (1) and the method of adding i.e. site

TASK - write script to add row in database from flash site - so site sends you just the country code and datanbase in incremented with the date/country/number (always 1 from site) and method (always 'site' from site)

Admin tool = we need an admin tool on the clients server and this will need to be made simply but securely so no danger of sql injection and config details separate from code - more details on this to come (minor stuff to drop on clients server).

So admin enters user/pass

On successful login user can

1. see total letter sent

2. see total letters sent by country

3. search total letters sent by date, as all, or specific country versions

4. Add to the number of letters sent...

The client has shops that have postboxes where kids will post real letters.

therefore the client will need to enter numbers weekly of the letters received in stores

therefore admin can add to the letters sent in which case they enter a number, select a single country OR select country 'unknown' - and they enter a number. we save this as method 'admin'.

The admin user can also see and delete all entries and filter them by 'site' and 'admin' method entries.

TASK - create admin tool

I don't think this needs to be a codeigniter project - unless you feel strongly that it does.

We are dropping this on our clients server so it will come under judgement if it is badly made or has security issues.

Skills: MySQL, PHP

See more: get more website visits, get more visits to website, dk security, task number 1 project, project de, kids store, website sql injection, admin user login codeigniter, codeigniter script, select country site, codeigniter custom config, security danger, unknown database, injection tool, website users can post real time, kids application, script website codeigniter, create user admin login codeigniter, codeigniter login search application, codeigniter admin login, sql injection tool, custom application sql, website code injection, custom case, create database letters

About the Employer:
( 25 reviews ) Brighton, United Kingdom

Project ID: #2540299

Awarded to:


Hired by the Employer

$300 USD in 5 days
(100 Reviews)