Saving Record - AJAX
It would be great if anyone show me the example for saving record to mysql database by using AJAX?
I found some articles but we hav to use one Server-side Script...
Any Idea.
[255 byte] By [Sync] at [2007-11-11 8:26:24] 
Is it possible to connect with database (eg: mysql) by using AJAX?
It would be great if anyone show me the example for saving record to mysql database by using AJAX?
I found some articles but we hav to use one Server-side Script...
Any Idea.
# 1 Re: Saving Record - AJAX
I got some coding from internet.. but conn variable is always emty("")..Do you have any idea??
My Env:
- WinXp
- VS 6.0, .NET 2003, .NET 2005 and MySQL, MSDE and FireBird.
Any Idea?? Thanks.
<SCRIPT LANGUAGE=javascript>
<!--
function ConDB()
{
var conn = new ActiveXObject("ADODB.Connection") ;
//var conn = CreateObject("ADODB.Connection");
alert(conn);
//var connectionstring="Provider=SQLOLEDB;Password=;User ID=;Initial Catalog=;Data Source=;"
//var connectionstring="Provider=SQLOLEDB;Password=;User ID=gpctadmin;Initial Catalog=;Data Source=;"
var connecitonstring = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;DATABASE=test;UID=root;PWD=testing123;" //_ & "OPTION=" & 1
alert(connecitonstring);
if(conn != ''){
conn.Open(connectionstring);
alert(conn);
}
else{
alert("d");
}
//var rs = new ActiveXObject("ADODB.Recordset");
//rs.Open("SELECT * FROM YourTablename ", conn);
//rs.MoveFirst
//while(!rs.eof)
//{
//document.write( yourtablefieldname);
//rs.movenext;
//}
//rs.close;
//conn.close;
} //-->
</SCRIPT>
<body topmargin="0" OnLoad="javascript:ConDB()">
Sync at 2007-11-11 23:42:40 >
# 2 Re: Saving Record - AJAX
I think this coding can't make connection with server... :(Sync at 2007-11-11 23:43:37 >
# 3 Re: Saving Record - AJAX
The best way to interact with a MySQL db is to write a little PHP script to except a SQL statement and return the results...Zak at 2007-11-11 23:44:35 >
