Flash + PHP + mySQL

Anon

I am trying to pass array variables from
Flash to a PHP script using POST.

Then I would like to insert these vars into
a table in mySQL.

Does anyone knows what is the right way
to do it.
(I'm not a PHP master)

THKS

Anon

hi.
I have problem with php or mysql...

on mi script write

if (!($link=mysql_connect "localhost","felix","")))
{ echo "Error .";
exit();
}
if (!mysql_select_db("foro",$link))
{ echo "Error .";
exit();
}

echo "connect ok";

i run on mi terminal telnet

localhost> php script.php

output > connect ok;

but run srcipt file on browser

🙁 upss.

my page is blank.

PD> run other script of php and work very find.

Anon

your question is pretty vague. are you talking about having text fields in a flash program that the user sends to a php script when they click on some kind of submit button?

Anon

ive done this many times, if you want some flash and php files to illustrate it let me know :0)

Anon

I'd love to see some source files. There is a strong desire for more examples of this work on the web.

Anon

OK,

ive had loads of ppl email and contact me regarding this

I will get around to it, its just that im really busy at the moment, keep pestering me

and i will do it :0)

Anon

hello

Anon

OK This post has sat idle long enough...

Someone must have figured this out...

C'mon now spill the beans...

Cause what You do to the World,
You do to Yourself...

Don't throttle the way how now...

Anon

i'm still looking for this as well....

if someone wrote a book on this, i think they would make a fortune

Anon

I wondered if anyone has come across this problem,

I created a .fla that resembles an htaccess login popup, but im doing mysql based authentication. I then wrote a PHP script that does the processing.

PHP Code...

<?php

require("globals.php");

// Connect to the database
if (!($link = mysql_connect("$hostName","$userName","$password"))) {
	$errMsg = "Could not connect to $hostName";
	return $errMsg;
} 
// select the database
if (!mysql_select_db ($databaseName, $link)){
	$errMsg = "Error in selecting database, $databaseName";
	return $errMsg;
} 
// execute the statement
$statement = "SELECT * FROM server WHERE userName = \"$user\";";
$result = mysql_query($statement,$link);
if (!$result) {
	$errMsg = "Error in executing $statement";
	return $errMsg;
}
$row = mysql_fetch_array($result);
$newpassword = crypt($passwrd,zz);


if ($row[0] == $newpassword) {
	// {&} - closes the output  buffer to the flash, can't evaluate Check in Flash until its closed!
	print "&Check=accepted&";
 } else {
	print "&Check=denied&";
}

mysql_close($link);
exit();

basics of .fla

// this code is on the "OK" button.

on (release) {
Status = "Checking Login Information...";
link = loadVariablesNum ("manager_login.php?user="+userName+"&passwrd="+pass, 0, "POST");
void(link);
gotoAndPlay (2);
}

adamd1

Hokay the way you hafta do it is kind of a huge hack.

The doozie is not so much posting from Flash into php - that part is easy. Set up your variables in ActionScript, name them, format them properly, then create a button whose click action is:

onRelease=get Url('http://path.to/yourform.php','post');

Set the options in the button's actionscript area so that it is passing the variables using the "post" method. PHP receives the variables, etc. No problemo.

But if you want Flash to present you with the resulting "Thank you, your info has been posted" blurb: you are in for a bit of an expedition. There is no easy way to get php to talk to flash the same way that flash can talk to PHP. It's doable (and I've done it) but it would take pages and pages to describe here.

The hope is that FlashMX will more directly address interplay between dynamic scripts and flash files. I kinda doubt it though since Macromedia very much wants people to buy their customized (and expensive) Generator suite.

Anyway lemme know how much help that was.