MySql database with Ajax

Question

Hi can anyone tell me? How to connect MySQL database with Ajax? Thanks in Advance

Jaganathan Bantheswaran · Answer

Hi, Try like this, Client side: //Browser Support Code function ajaxFunction(){ var ajaxRequest; // The variable that makes Ajax possible! try{ // Opera 8.0+, Firefox, Safari ajaxRequest = new XMLHttpRequest(); } catch (e){ // Internet Explorer Browsers try{ ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try{ ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP"); } catch (e){ // Something went wrong alert("Your browser broke!"); return false; } } } // Create a function that will receive data sent from the server ajaxRequest.onreadystatechange = function(){ if(ajaxRequest.readyState == 4 && ajaxRequest.status==200){ document.myForm.time.value = ajaxRequest.responseText; } } var age = document.getElementById('age').value; var wpm = document.getElementById('wpm').value; var sex = document.getElementById('sex').value; var queryString = "?age=" + age + "&wpm=" + wpm + "&sex=" + sex; ajaxRequest.open("GET", "ajax-example.aspx" + queryString, true); ajaxRequest.send(null); } //--> Max Age: Max WPM: Sex: m f In Server side [C# code]: protected void Page_Load(object sender, EventArgs e) { // Here is an example of an aspx page being loaded with // a GET HTTP request. We can use the QueryString // collection on the Reqest. string wordStr = Request.QueryString["age"]; if (wordStr != null) { // The query string "age" is there. Do something with database and return the value.. return; } }

MySql database with Ajax

Answers (1)