In this tutorial we will discuss how to retrieve data in codeigniter using ajax
We use 3 file for fetch students data.
- Crud.php Path: application\controllers\Crud.php
- Crud_model.php Path: application\models\Crud_model.php
- view.php Path: application\views\view.php
Sql Table
CREATE TABLE crud (
`id` int(11) NOT NULL,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(30) NOT NULL,
`email` varchar(30) NOT NULL,
PRIMARY KEY (id)
);
view.php(View)
<!DOCTYPE html>
<html lang="en">
<head>
<title>View Ajax</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<h2>View data</h2>
<table class="table table-bordered table-sm" >
<thead>
<tr>
<th>Sl No</th>
<th>Name</th>
<th>Email</th>
<th>Phone</th>
<th>City</th>
</tr>
</thead>
<tbody id="table">
</tbody>
</table>
</div>
<script>
$.ajax({
url: "<?php echo base_url("Crud/viewajax");?>",
type: "POST",
cache: false,
success: function(data){
//alert(data);
$('#table').html(data);
}
});
</script>
</body>
</html>
0 Comments