// for insert query
var insert_lv:LoadVars = new LoadVars("
http://www.getaroom.dk/Flash/action.php", this, "GET");
// get today's date
var today:Date = new Date();
var filepath:String;
// limit fields to max characters allowed by database
nameInput_re.maxChars = 50;
persInput_re.maxChars = 2;
// function to execute after insertscore.php has run
// it returns errorcode, msg (sql error), id (of most recent insert)
insert_lv.onLoad = function(ok:Boolean) {
if (ok) {
if (this.errorcode == "0") {
// update the dataProvider so datagrid updates
scoreInfo.addItem(
{record:this.id,
nickname:nickname_ti.text,
score:score_ti.text,
dateposted:date_ti.text
});
// reset fields
nickname_ti.text = '';
score_ti.text = 100;
date_ti.text = today.getFullYear() + '-' +
zerofill(today.getMonth()+1) + '-' +
zerofill(today.getDate());
msg_ta.text = "Score was added to the database";
} else {
// show kind of error
msg_ta.text = errorMsgs[Number(this.errorcode)];
// if query error, show mysql_error
if (this.errorcode == "3") msg_ta.text += ": " + this.msg;
}
} else {
// if loadvars failed (eg, if script not found)
msg_ta.text = "Flash-database insert operation failed";
}
};
function insertRecord() {
// check for no name or bad score
if (nameInput_re.text > ''
&& persInput_re.text > ''
&& dateField_re.getValue() > ''
&& mailInput_re.text > ''
&& codeInput_re.text > ''
&& chooseTable_re.getValue > ''){
insert_lv.na = nameInput_re.text;
insert_lv.pe = persInput_re.text;
insert_lv.c_ma = mailInput_re.text;
insert_lv.c_pa = codeInput_re.text;
insert_lv.r_da = dateField_re.getValue();
insert_lv.t_nr = chooseTable_re.getValue();
insert_lv.sendAndLoad(filepath + "action.php?insert=yes", insert_lv, "GET")
} else {
msg_ta.text = "Du skal udfylde alle felterne korrekt!";
}
}
add_btn.addEventListener(MouseEvent.CLICK, insertRecord);
-----------------------
Og har selvfølgelig kaldt knappen add_btn, jf. sidste linje. :)
