AJAX and MySQL – PHP

In this example, we are talking to the database. You don\’t need to do anything else. Just write the logic for the database in your server-side page.

In this example, the code for the server is in the index.jsp file.

Table of Contents:

AJAX Database Example

How to make an ajax example with a database using jsp

You have to do the following:

load the file called org.json.jar
make a page where people can type in any text or number
make a page on the server to handle the request
Load the file called org.json.jar.

We put the org.json.jar file in the WEB-INF/lib directory so that you can download this example.

make a page where people can type in any text or number

On this page, we\’ve made a form for the user to fill out. The ajaxForm() function is called when the user presses any key. All of the ajax code is written inside this function.

Database Example

id	FirstName	LastName	Age	Hometown
1	Shaym	Lal	41	Vrandavan
2	Krishan	Das	40	Mathura
3	Jadish	Lal	39	Ayodhya
4	Ram	Das	41	Ayodhya

When the ready state changes, we have called the getData() function. With the help of the innerHTML property, it writes the returned data into the web page on the fly.

Example.html

<html>
<head>
<script>
var request;
function ajaxForm()
{
var v=document.formid.ids.value;
var url=\”index.jsp?val=\”+v;
if(window.XMLHttpRequest){
request=new XMLHttpRequest();
}
else if(window.ActiveXObject){
request=new ActiveXObject(\”Microsoft.XMLHTTP\”);
}
try{
request.onreadystatechange=getData;
request.open(\”GET\”,url,true);
request.send();
}catch(e){alert(\”Unable to connect to server\”);}
}
function getData(){
if(request.readyState==4){
var val=request.responseText;
document.getElementById(\’ram\’).innerHTML=val;
}
}
</script>
</head>
<body>
<marquee><h1>AJAX Database Example</h1></marquee>
<form name=\”formid\”>
Enter id:<input type=\”text\” name=\”ids\” onkeyup=\”ajaxForm()\”>
</form>
<span id=\”ram\”> </span>
</body>
</html>

example index.jsp

<%@ page import=\”file.sql.*\”%>
<%
String s=request.getParameter(\”val\”);
if(s==null || s.trim().equals(\”\”)){
out.print(\”Please enter id\”);
}else{
int id=Integer.parseInt(s);
out.print(id);
try{
Class.forName(\”com.mysql.jdbc.Driver\”);
Connection con=DriverManager.getConnection(\”jdbc:mysql://localhost:3306/mdb\”,\”root\”,\”12345\”);
PreparedStatement ps=con.prepareStatement(\”select * from student where id=?\”);
ps.setInt(1,id);
ResultSet rs=ps.executeQuery();
while(rs.next()){
out.print(rs.getInt(1)+\” \”+rs.getString(2));
}
con.close();
}catch(Exception e){e.printStackTrace();}
}
%>