Database Fetch data ajax


#1

I want fetch data from database in same page data fetching .but i want without refresh if any new entry in database inst.php


	
<table  class="table table-striped table-dark table-dark">

     <thead class="thead-dark">
      <tbody id="auto">
    <tr>
     
      <th>ID</th>
      <th scope="col">Namesss</th>
      <th scope="col">Email</th>
      <th scope="col">Image</th>
      <th scope="col">Update</th>
      <th scope="col">Delete</th>
    </tr>
  </thead>
  

		
		<?php
include "db.php";


$q="select * from users";
$ok=mysqli_query($con,$q);

while($raq=mysqli_fetch_array($ok)){






?>







<!DOCTYPE html>
<html lang="en">
<head>
  <title>Bootstrap Example</title>
  <meta charset="utf-8">
  <style type="text/css" media="screen">
  .link {
  color: white;
  font-size: 20px;
}

/* visited link */
a:visited {
  color: cyan;
}

/* mouse over link */
a:hover {
  background-color: red;
 
 
}

/* selected link */
a:active {
  color: yellow;
}
}
  	
  </style>
  <meta name="viewport" content="width=device-width, initial-scale=1">

  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">

  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script>
 
</head>
<body>



	<tr>
    <td ><?php echo  $raq[1];?></td>
		<input   type=hidden name="id" value="<?php echo $raq[1]?>">
		<form  class="form-group" action="" method="post" accept-charset="utf-8" enctype="multipart/form-data" >
      
		<td><?php echo  $raq[0];?></td>
		<td><?php echo  $raq[2];?></td>
		<td><img   src="<?php echo "image/$raq[3]";?>"  height='50 width='50'></td>
		<?php echo "<td><button class='btn btn-primary''text-white'><a  class='link' href=hk.php?id=$raq[1]>Modify</a></td>"?></button>
		<?php echo "<td><button class='btn btn-danger''text-white'><a  class='link' href=del.php?id=$raq[1]>Delete</a></td>"?></button>
	</tr>

</tbody>
		</div>
<?php }?>
	</table>

</div>
</div>

</div>


	</body>

#2

I use this code but page stucks. i want like bootbotsrap badge top of the table
above one div #1

[code]
$(document).ready( function(){
$(’#1’).load(‘inst.php’);
refresh();
});

function refresh()
{
setTimeout( function() {

refresh();

}, 3000);
}


#3

I wouldn’t load the entire page, just the data.

Why are you loading the entire users table? What are you actually trying to monitor?


#4

i just want if any body register page auto refresh .i want if some one registered auto refresh page
.i dont want this.1st pic i put id. code works but table shows like this after auto refresh structure change.this is with code.if some user register id goes to 10 auto.
dd1
my actual table is this.
d21


#5

<script>
setTimeout(function(){
   .load('inst.php');
}, 5000);
</script>

this code runs fine .but i want in ajax whole page auto refresh


#6

You are doing a while loop that breaks the html. You can’t have a new html document for each person.


#7

so how can i implement
help me with right code


#8

I’m not going to just write your code for you, this isn’t a code writing service that waits for someone to come along.

Take what I said and fix that first.


#9

its easy bro just rewrite whole div using ajax set all table using ajax instead of refresh page.