<?php
class GetPollInfo
{
var $dbhost = "127.0.0.1"; //数据库地址
var $dbname = "wnwbeauty"; //数据库名称
var $dbuser = "wnwadmin"; //数据库用户名
var $dbpass = "123456"; //数据库密码
var $conn; //数据库连
function get_data(){
$conn = @mssql_connect($this->dbhost, $this->dbuser, $this->dbpass) or die("Couldn't connect to $myserver"
$d = @mssql_select_db($this->dbname, $conn) or die("Couldn't open database $this->dbname"
$strQuery = "SELECT q.vcPollQuestion as vcPollQuestion, q.intPollQuestionId as intPollQuestionId, a.vcPollAnswer as vcPollAnswer, a.intPollAnswerId as intPollAnswerId ";
$strQuery.= "FROM tblPollQuestion q, tblPollAnswer a WHERE q.intPollQuestionActive = 1 AND q.intPollQuestionId = a.intPollQuestionId ";
$strQuery.= "ORDER BY a.intPollSortOrder";
$result = mssql_query($strQuery);
private var answer0:RadioButton;
private var answer1:RadioButton;
private var answer2:RadioButton;
private var answer3:RadioButton;
private var radioGroup:RadioButtonGroup;
private var voteButton:Button;
var gatewayUrl = "http://localhost/flashservice/gateway.php";
var componentPath = "GetPollInfo";
function onlinePollQuestion()
{
trace("onlinePollQuestion()"
}
function getQuestionData()
{
trace("getQuestionData()"
var CFCService:Service = new Service(
gatewayUrl,
null,
componentPath,
null,
null);
var pcendingCall = CFCService.get_data();
//var pcendingCall = CFCService.getPollQuestion();
pc.responder = new RelayResponder(this, "onGetOnlinePollQuestionResultData", "onGetOnlinePollQuestionResultFault" );
}
function onGetOnlinePollQuestionResultData( resultEvent:ResultEvent ):Void
{
trace("onGetOnlinePollQuestionResultData()"
trace("Result is "+ resultEvent.result);
var records = 0;
records += resultEvent.result.getNumberAvailable()
trace("records: " + records)
trace("totals: " + resultEvent.result.getLength())