Em Andamento

Flash, PHP and MySQL

I need some help with Flash, PHP and MySQL.

Part 1:

For activation and registration of a swf file on a MySQL database I need a working sample with PHP and Flash (if possible in AS 3) scripts.

The Flash file must have a textfield and a button. If I put a number into the field and click on the button, the PHP script must check the MySQL table if the value from the textfield is in the table or not and send the result (true or false) back to the flash file. It is true the value is to be stored in a "sharedobject".

Part 2:

I would like to prevent, that several files with the same number are active at the same time. For checking this I need another working sample.

When I open the Flash file, the AS script sends the number and a timestamp to the PHP script. The PHP must check, if the number is in the MySQL [url removed, login to view] is true, the script gives a value like "false" (because the swf is active) back to Flash.

If the number is not in the table, the PHP script must create a new record with the number, timestamp, Ip-adress and a empty status field and send a value like "true" back to flash. Now the Flash file sends every 10 minutes, starting from timestamp (with new Timer class) a value like "active" to PHP. PHP writes this value in the status field.

Another PHP script checks every 11 minutes, starting from timestamp, if the status field is "active". If not the script deletes the record.

I hope you understands my goal. The flash part is no problem, but the PHP and MySQL stuff is new for me. I know, that there are a lot of similar login scripts in the web, but I don't feel like to experiment. All code must come with documentation.

Other ideas for an easy and secure workaround are welcome.

Habilidades: Adobe Flash, PHP

Ver mais: php create table, problem part, create table php, and mysql, database scripts php mysql, timestamp, registration php, php script create table, php click, login registration, experiment, adress, php script open file, php code sample, flash php web, mysql stuff, scripts flash, check table mysql script, mysql help table, table php, mysql record, mysql check, mysql create table, code create database record, mysql script help

Acerca do Empregador:
( 5 comentários ) Hannover, Germany

ID do Projeto: #172083

Premiar a:

flash2you

Hello, please check your PM

$80 USD em 0 dias
(175 Avaliações)
7.6

5 freelancers estão ofertando em média $78 para este trabalho

lucidstudios

Please See PMB for details. Thank You.

$100 USD in 2 dias
(27 Comentários)
6.4
Hatipovic

The project can be done in AS3. Look forward to work with you!

$70 USD em 1 dia
(27 Comentários)
5.9
majormf

i can do it with flex

$40 USD in 0 dias
(46 Comentários)
5.7
speedster

Hi, kinly see PM! Thanks!

$100 USD in 3 dias
(12 Comentários)
4.0