Flex Remoting problem with PHP as back end
My PHP code always returns NO regardless of username and password.
Flex / MXML code:
<mx:RemoteObject id="zendAMF" destination="zend" showBusyCursor="true" source="test_class" >
<mx:method name="doLogin" result="onSayHelloResult(event)">
<mx:arguments>
<username>
{username.text}
</username>
<password>
{password.text}
</password>
</mx:arguments>
</mx:method>
</mx:RemoteObject>
ActionScript code:
private function callZend():void {
zendAMF.doLogin();
}
PHP code:
class test_class {
public function __construct() {
}
public function doLogin($username,$password) {
include("connection.php");
if (isset($_POST['username']) && isset($_POST['password']))
{
$username= $_POST['username'];
$password= $_POST['password'];
$query = "SELECT *
FROM users
WHERE username = '".mysql_escape_string($username)."'
AND password = '".mysql_escape_string($password)."'";
$result = mysql_fetch_array(mysql_query($query));
return 'yes';
}
else
{
return 'no';
}
}
}
0
a source to share
2 answers
I'm pretty sure $ username and $ password are parameters of your method, and since you are sending these two arguments via RemoteObject, you already have values for them and therefore you don't need to use $ _POST.
public function doLogin($username,$password) {
include("connection.php");
if (isset($username) && isset($password))
{
$query = "SELECT *
FROM users
WHERE username = '".mysql_escape_string($username)."'
AND password = '".mysql_escape_string($password)."'";
$result = mysql_fetch_array(mysql_query($query));
return 'yes';
}
else
{
return 'no';
}}
That should be enough.
+1
a source to share