to display all records using jquery ajax

Hawlapoda · Apr 9, 2013

I have written code for displaying records on that same page but its not working.Actually I want in page which I insert that same page should show all records in table format and also show recently added record without refreshing page.ajaxinsert.php\[code\]<script type="text/javascript" src="http://stackoverflow.com/questions/jquery.js"></script><script type="text/javascript" >$(document).ready(function() { $("#insert").click(function() { var name = $("#name").val(); var rno = $("#rno").val(); var address = $("#address").val(); //var dataString = "&name="+name"+&address="+address; $.ajax({ type:'POST', data:{name: name, rno:rno, address:address}, url:'demo_insert.php', success:function(data){ if(data="http://stackoverflow.com/questions/15891920/inserted") { alert("Insertion Success"); } else { alert("Not Inserted"); } } }); });});</script></head><body><form id="myform" action="demo_insert.php"> <label>Name: </label> <input id="name" type="text" /><label>Rno: </label> <input id="rno" type="text" /><label>Address: </label> <input id="address" type="text" /><input name="Submit" type="button" id="insert" value="http://stackoverflow.com/questions/15891920/Submit"/> <div id="message"></div></form></body>\[/code\]demo_insert.php\[code\]<? include('connection.php'); //Pull data from home.php front-end page $name=mysql_escape_string($_POST['name']); $rno=mysql_escape_string($_POST['rno']); $address=mysql_escape_string($_POST['address']); //Insert Data into mysql$query=mysql_query("INSERT INTO school(name,rno,address) VALUES('$name','$rno','$address')");$dispquery=mysql_query("select * from school"); echo "<table border=1>"; echo "<tr>"; echo"<td>Srno</td>"; echo "<td>Name</td>"; echo"<td>Rno</td>"; echo "<td>Address</td>"; echo"</tr>";$i=1;while($result=mysql_fetch_array($dispquery)){ echo "<tr>"; echo "<td>" .$i."</td>"; echo "<td>" .$result['name'] ."</td>"; echo "<td>" .$result['rno'] ."</td>"; echo "<td>" .$result['address'] ."</td>"; echo "</tr>"; $i++;} echo"</table>";?>\[/code\]

to display all records using jquery ajax

Hawlapoda

New Member