I am writing a Flash app that needs to sent some data to a database and also retrieve this data. This project is for writing the PHP scripts and setting up the DB. It's a very basic setup.
PHP and mySQL
The Database will have around 125 countries (will supply these in an Excel doc. Each country will have:
· country name,
· a country code
· statP (number)
· statN (number)
The Flash app will both read the data in and be able to send updates
My Flash file will make this call to read all the data: [url removed, login to view] country=ALL
Return: stats=UK,26,500,USA,30,700,IT,29,50,GR,80,900,IN,20,600 etc (this is Country Code, StatP, StatN)
To read one country’s data my Flash file will call: [url removed, login to view]
To update values in the database my Flash file will call and sent:
[url removed, login to view] country=IN&statN=1
(note that a country can update either statP or statN and there can be any number of countries to update but for now it will be limited to five)
statP or statN are always incremented by 1 regardless of the number value sent through (if you want the string in a different format let me know)
I will give access to a server where the DB needs to be set up and scripts installed.
The project will be deemed complete once I've tested the the scripts work with my Flash calls.
Completion deadline 4th May