Insert and view data without refresh using PHP, MySql and AJAX

 

 Insert and view data without refresh using PHP, MySql and AJAX

Insert and view data without refresh using PHP, MySql and AJAX

Example Link: https://drive.google.com/file/d/1d7v9sBwHIkcLw3e7l2SQEwb4H9QXu_is/view?usp=sharing

// html
<table id="data">
</table>

// script 
<script>
$(document).ready(function()
{
setInterval(function(){
    $("#data").load("Withdrawcode.php");
refresh();
}, 1000);


})
</script>

 
<tr>
          <th>Wallet</th>
          <th>Email/Number</th>
          <th>Coins</th>
          <th>Status</th>
           <th>Date</th>
           <th></th>
 </tr>

Example Code 2:

for that we need to make three file to clear explanation. let see those files.

DB.PHP
INDEX.PHP
ACTION.PHP
The above three files details below here.

DATABASE DETAILS

database name : 2my4edge
table name : comment
column names : id, msg, ip_add

DB.PHP
<?php
$conn = mysql_connect('localhost','root','') or die (mysql_error);
$db=mysql_select_db('2my4edge', $conn) or die (mysql_error);
?>

INDEX.PHP
<div class="container">
<div class="main">
<form  method="post" name="form" action="">
<textarea style="width:500px; font-size:14px; height:60px; font-weight:bold; resize:none;" name="content" id="content" ></textarea><br />
<input type="submit" value="Post" name="submit" class="submit_button"/>
</form>
</div>
<div class="space"></div>
<div id="flash"></div>
<div id="show"></div>
</div>
in the same index.php file, we have to add  the AJAX details to make operation. let see the AJAX

AJAX
<script type="text/javascript" src="jquery.min.js"></script>
<script type="text/javascript">
$(function() {
$(".submit_button").click(function() {
var textcontent = $("#content").val();
var dataString = 'content='+ textcontent;
if(textcontent=='')
{
alert("Enter some text..");
$("#content").focus();
}
else
{
$("#flash").show();
$("#flash").fadeIn(400).html('<span class="load">Loading..</span>');
$.ajax({
type: "POST",
url: "action.php",
data: dataString,
cache: true,
success: function(html){
$("#show").after(html);
document.getElementById('content').value='';
$("#flash").hide();
$("#content").focus();
}  
});
}
return false;
});
});
</script>
the above is the script for make the function without refreshing the page.

ACTION.PHP
<?php
include('db.php');
$check = mysql_query("SELECT * FROM comment order by id desc");
if(isset($_POST['content']))
{
$content=mysql_real_escape_string($_POST['content']);
$ip=mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
mysql_query("insert into comment(msg,ip_add) values ('$content','$ip')");
$fetch= mysql_query("SELECT msg,id FROM comment order by id desc");
$row=mysql_fetch_array($fetch);
}
?>

<div class="showbox"> <?php echo $row['msg']; ?> </div>
the above showbox is to show the msg, what was store in the database.

HOME