Re: FLASH, MySql and PHP as CGI Problem.....
| From: | Lowell Allen | Date: | Mon, 30 Sep 2002 12:41:09 +0000 |
| Subject: | Re: FLASH, MySql and PHP as CGI Problem..... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-118197@lists.php.net to get a copy of this message | ||
> From: "Rebekah Garner" <rebekah@powergothgirls.com>
>
[snip]
> ... My SWF won't send the content of the variable to the database. The
> script runs, but it is making an empty entry. The damned things work on any
> of the three other servers that I have tested it on, but not this.
>
[snip]
> I am including my php code for retrieving information from the database (which
> works) and my code for inserting into the database (which executes, but
> doesn't pass the varible information).
[snip]
> $posted = time();
>
> $query = "INSERT INTO tablenamedefault (newsText, posted)
> VALUES('$newsText', $posted)";
>
[snip]
> Code that contains the posting info for input:
>
>
> on (release) {
>
> _root.sendTextUpdate();
>
>
> loadVariables("http://www.url.com/updatedefaultTableName.cgi"),
> _root.newsTextHolder, "POST");
>
> }
I'm not at all familiar with getting input from Flash or with using PHP as
CGI, but in the code above it looks like you're prematurely closing the
parentheses after the URL, which would cause the remaining two parameters to
be ignored.
Another thought is that if the code *does* work on other servers as you say,
maybe the problem is a register globals issue, in which case you could try
adding this above the query definition:
$newsText = $_REQUEST['newsText'];
HTH
--
Lowell Allen