Hello,
I 'm not sure if this is the right place to post about this, but I do like to learn from here and there, so here is my question:
I'm building my site with a server offering many capabilities among which the connection to mysql databases through its extensions which I only know how to code a little with AS 2.
I want to build a form or gueestbook that connects to one, but I can't make it insert data into it unless the INT value in the database is BIGINT if I want to have it autoincrement itself chronologically. My doubt is whether that is due to my client side in AS 2 or how I prepare the database.
In the client side, Flash I have this code to insert the values into the database:
Code:
function addRecord()
{
var req:Object = {}
if (add_name_txt.text != "")
{
req.name = add_name_txt.text
req.location = add_location_txt.text
req.email = add_email_txt.text
// Clear textfields
add_name_txt.text = add_location_txt.text = add_email_txt.text = ""
smartfox.sendXtMessage(extensionName, "addData", req, "xml")
}
}
In the extension :
Code:
else if (cmd == "addData")
{
var id = getTimer()
var sql = "INSERT INTO contacts (id, name, location, email) VALUES ("
sql += "'" + id + "', "
sql += "'" + _server.escapeQuotes(params.name) + "', "
sql += "'" + _server.escapeQuotes(params.location) + "', "
sql += "'" + _server.escapeQuotes(params.email) + "')"
var success = dbase.executeCommand(sql)
{
var response = {}
response._cmd = "addData"
response.id = id
response.name = params.name
response.location = params.location
response.email = params.email
_server.sendResponse(response, -1, null, [user])
}
}
In the database the Id row is BIGINT (20) and the rest of the fiels are varchar 255. If I try to make it INT(11) and autoincrement on, nothing is added to the database.
I still haven't tried getting rid off the getTimer variable and changing the database again, could that be it? Whenever I look into the id values are very large, like this one: 1382786279642