flash to php to flash
ok here’s the problem im trying to get my flash mx search form to connect to my MySql database using PHP…example go to [color=#22229c]http://www.nightspotz.com[/color] and go to search link…does not do anything when the submit button is hit…does anyone have any sample .fla that has a search from flash on it will be greatly appreciated…
---------script attached to button:
on (release) {
myData = new LoadVars();
myData.venuename = venuename.text;
myData.state = state.getSelectedItem().label;
myData.city = city.getSelectedItem().label;
myData.areacode = areacode.text;
myData.venuetype = venuetype.getSelectedItem().label;
myData.agegroup = agegroup.getSelectedItem().label;
myData.musictype = musictype.getSelectedItem().label;
myData.sendAndLoad(“search.php”, myData, “POST”);
gotoAndPlay(results);
venuename = “”;
state = “”;
city = “”;
areacode = “”;
venuetype = “”;
agegroup = “”;
musictype = “”;
}
----------this is the PHP script:
<?
/* mysql connection*/
$username=“nigolmvc_nigolmv”;
$password="**********";
$database=“nigolmvc_nightspotz”;
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( “Unable to select database”);
$query=“SELECT * FROM venues WHERE venuename = ‘$venuename’ AND ‘areacode’ = ‘$areacode’
AND ‘city’ = ‘$city’ AND ‘state’ = ‘$state’ AND ‘clubtype’ = ‘$clubtype’ AND ‘musictype’ = ‘$musictype’ AND ‘agegroup’ = ‘$crowd’ ORDER BY venuename ASC”, $colname_searchRS;
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$venuename=mysql_result($result,$i,“venuename”);
$areacode=mysql_result($result,$i,“areacode”);
$phone=mysql_result($result,$i,“phone”);
$address=mysql_result($result,$i,“address”);
echo “<b>$venuename</b><br>$address<br>$city<br>$state $zipcode<br>$areacode $phonenumber<br>$email<br>$website<br><br>$comments<br><hr><br>”;
$i++;
}
-----here is the script from results .fla that should show results from PHP:
myData.load(“search.php”) //php line
myData.ref = this
//Fetch data
myData.onLoad = function(succes){
if(succes){
for(var i=0; i<this.cant; i++){
this.ref[“venuename”+i].htmlText = “<b>”+this[“venuename”+i]+"</b>"
this.ref[“address”+i].text = this[“address”+i]
this.ref[“phonenumber”+i].text = this[“phonenumber”+i]
}
} else trace(“Error loading data”)
}
stop()
