Variables + ActionScript 3

[hinomotoblade]

Helooooo i need some help.. T____T

When i try to send data to PHP, its like didnt connect between flash and PHP  

Code:

<?php
$hcon = mysql_connect("localhost","root","") or die ("Gagal terkoneksi ke Database !!!");
$hdb = mysql_select_db("cobaflash",$hcon) or die ("Database tidak di temukan !!!");

$nama = $_POST["namain"];
$password = $_POST["passwdin"];
$alamat = $_POST["alamatin"];
$email = $_POST["emailin"];
$pekerjaan = $_POST["pekerjaanin"];
$jumNak = $_POST["jumNakin"];
$gender = $_POST["genderin"];
$orang = $_POST["orangin"];
$url = "INSERT INTO hinodata (nama,password,alamat,email,pekerjaan,jumanak,gender,orang) VALUES ('".$nama."','".$password."','".$alamat."','".$email."','".$pekerjaan."',".$jumNak.",'".$gender."','".$orang."')";
$hinoquery = mysql_query($url);

if ($hinoquery) {
    echo "valid=OK";
} else {
    echo "valid=FAILED";
}
?>

nah in the echo "valid=OK" and "valid="FAILED"

in the flash i have caught that with

Code:

function hinoComplete(event:Event):void {
  trace(event.target.data.valid);
  if (event.target.data.valid == "OK") {
  statusin.text = "Data Send Success !!";
  } else {
  statusin.text = "Data Send Failed !!";
  }
  }

but the trace in flash said "undefined"


Please help me.. a bit bit help thats really appreciate =)

Thank you =D

[Ronald Wernecke]

Hi and welcome to the boards.

After your request has nothing to do with the thread you posted in, I created a new one.

If you receive "undefined", this means, something in your path assignment is wrong.

The best way finding yout how the structure looks like, you are ceceiving from the server, you can use Charles debugging proxy.

It tells you what happens in the communication line.

Be aware, capital letters are recognized as different

[hinomotoblade]

wiw yes thank you very much.. 

but i have tried and tried, and there are same as the flash-db tutorial about the structure..

in the example there is

Code:

echo "writing=Ok"; //

but in my PHP file i change to

Code:

echo "valid=OK";

did that influence?.. :O

huhuhu, i just want to make communication between Flash > PHP > Mysql
until now stil not success hiks2

But thank you for your reply.. thank you thank you very much 

[Ronald Wernecke]

it very much depends on how you access this inside of your flash component.
The nameing must match 100%

[hinomotoblade]

yes i have checked that.. see :

in flash side :

Code:

var hinoVar:URLVariables = new URLVariables();
hinoVar.namain = namain.text;
hinoVar.passwdin = passwdin.text;
hinoVar.alamatin = alamatin.text;
hinoVar.emailin = emailin.text;
hinoVar.pekerjaanin = comboBox.value;
hinoVar.jumNakin = jumNakin.value;
if (genderin1.selected) {
hinoVar.genderin = genderin1.value;
       } else if (genderin2.selected) {
hinoVar.genderin = genderin2.value;   
   }
   if (orangin.selected) {
   hinoVar.orangin = "YES";
   } else {
hinoVar.orangin = "NO";   
   }

and in the PHP Side :

Code:

$nama = $_POST["namain"];
$password = $_POST["passwdin"];
$alamat = $_POST["alamatin"];
$email = $_POST["emailin"];
$pekerjaan = $_POST["pekerjaanin"];
$jumNak = $_POST["jumNakin"];
$gender = $_POST["genderin"];
$orang = $_POST["orangin"];

when i trace all of variables in flash, thats work, but when i want to get some return message thats said "undefined"..
Thanks again about your reply

[Ronald Wernecke]

if you privide the two variables in your URLVariables Object, you can receive them

Thats the trick

[hinomotoblade]

Ummm sry, what do you mean?.. :O

To connect flash and php, there are some extension / plugin/ import to do that, maybe?.. :O

Thanx

[Ronald Wernecke]

definately not.
The mimik you are using is right.

But you have to define the variable, you are expecting.

Code:

hinoVar.writing="";
hinoVar.valid="";

[hinomotoblade]

Ow thank you

wew yey i have some development, the data can send to the database, i just make the publish setting to access network..

but there is some trouble when i input the data.. see in my mysql database, whereas i just input once T.T, this picture below



see in the id thats my primary key extra auto increment, it seems overload.. huhuhuh ..

How to fix that?.. :O

Thank you

[hinomotoblade]

Wew done done.. but i have 1 problem again.. maybe this is my last problem..

When i try that in flash directly (Ctrl+Enter) that work, but when i published that, it didnt work..
I mean i open the swf file which made by default when we test movie in flash.. why?.. :O

Thank you very very much

[Ronald Wernecke]

if you start the swf, it must reside at the same host the data is comming from.
Sandbox is only extended while you are in development environment.

Just upload the swf to the server and start it from there with the browser.

[Ronald Wernecke]

if you want to check doubles in your table, you have to check the existance before you insert.
do a select with the fields first, and if it delivers a record, you deliver an error message and dont insert.

[hinomotoblade]

wiwi thank you.. um i have send a data from Flash to PHP, but can i send from PHP to flash?.. :O

For example i want to show the echo in PHP to flash TextField or whatever?.. :O

Thanks a lot

[Ronald Wernecke]

if you want to go deeper, and use a more intelligent way of communication, have a look into AMFPHP.

With the URLVariables you have to know what to expect - with AMFPHP you can transfer complete object structures.

Fore more information on how to communicate with the different methods, see our loading and saving tutorials.

[hinomotoblade]

ow yes i know amfphp, but did that can call more than 1 function?.. :O
can we put many php file in the services directory?..

because when i try to use that, in the flash side we just use 'call' method to call the amfPhp
and the connection is on the Gateway.php

nah how about we have more than 1 php files in the services folder?..
Which want the 'call' method call the php services in the services folder?..

Thanks in advance