Codeigniter Tutorials
- What is codeigniter?
- Application_Architecture
- MVC Architecture
- HMVC Architecture
- Codeigniter Configuration
- Remove index.php from url in codeigniter
- MVC Concept
- View
- Alternate PHP Syntax for View Files
- Routing
- Codeigniter URL
- Get Current URL
- Previous page URL get
- Seo Friendly URL
- Slug Create in codeigniter
- What is _remap() function
- Remove controller name from url in codeigniter
- Codeigniter Controller Class
- Class Constructor
- GET $ POST method in Codeigniter
- Models
- Basepath, Apppath, FCPATH
- URI Segment
- Page Redirect
- Helper class
- Custom Helper class
- Form Helper
- Common Helper Functions
- Common Function
- Array Problems
- Call controller in Helper
- Add active class to menu using Helper class
- Custom Library
- Custom Library Example
- when to use get_instance()
- Codeigniter Hook
- how to work inline css in codeigniter
- Custom 404 page
- 404 custom error page
- Create custom config file in codeigniter
- How to set and get config item value
- How to Speed Up CodeIgniter App?
- Codeigniter Functions
- Session
- cookies
- How to Set & Get Tempdata in Codeigniter
- flash messages in Codeigniter
- Flashdata
- Encryption and Decryption In CodeIgniter
- Codeigniter security
- csrf token form security
- Password Hashing
- Form Validation
- Custom Validation
- Registration Form with validation
- Server Side Form Validation
- Validate Select Option Field
- Date Format Validation
- Date Format change in codeigniter
- Date Functions
- DOB Validation
- CI CRUD
- User SignUp
- User Login
- User Logout
- Login Account
- Login form with RememberMe
- Login Form with session
- User change password
- Change Password with Callback Validation to Check Old Password
- Forgot password
- Reset password
- Insert data in database
- Fetch data from database
- Update data in database
- Delete data in database
- File Upload
- Image Upload with resize Image
- Upload Multiple file and images
- Upload Multiple images with CRUD
- File and image update
- Upload Image Using Ajax.
- Email Send
- Email Send Using Email library
- Email Send Using SMTP Gmail
- Notification send
- store data in json format in DB
- Json parse
- Fetch data Using Ajax with Json data
- How to Show data Using Ajax with Json parse
- Get JSON Data from PHP Script using jQuery Ajax
- Insert data Using Ajax
- Submit data Using Ajax with form validation
- How to show data Using Ajax in codeigniter
- Insert & Update Using Ajax
- Registration Form With Validation Using Ajax in codeigniter
- Delete data Using Ajax Confirmation
- Delete All data Using checkbox selection
- Ajax CSRF Token
- Ajax Post
- Ajax serverside form validation
- Contact form using AJAX with form validation
- DataTable Using Ajax dynamically
- DataTables pagination using AJAX with Custom filter
- DataTables AJAX Pagination with Search and Sort in codeigniter
- DataTables in Codeigniter using Ajax
- Ajax Custom Serarch
- Ajax Live Data Search using Jquery PHP MySql
- Ajax Custom Serarch and sorting in datatable
- Dynamic Search Using Ajax
- Autocomplete using jquery ajax
- Jquery Ajax Autocomplete Search using Typeahead
- Dynamic Dependent Dropdown Using Ajax
- Dynamic Dependent Dropdown list Using Ajax
- Dynamic Dependent Dropdown in codeigniter using Ajax
- ajax username/email availability check using JQuery
- Check Email Availability Using Ajax
- Data Load on mouse scroll
- Ajax CI Pagination
- Pagination in codeigniter
- Ajax Codeigniter Pagination
- email exists or not using ajax with json
- CRUD using AJAX With Modal popup in CI
- Add / Show Data on modal popup using Ajax
- Modal popup Validation using Ajax
- Data show on Modal popup Using Ajax
- Add / Remove text field dynamically using jquery ajax
- How to Add/Delete Multiple HTML Rows using JavaScript
- Delete Multiple Rows using Checkbox
- Multiple Checkbox value
- Form submit using jquery Example
- REST & SOAP API
- Multi-Language implementation in CodeIgniter
- How to pass multiple array in view
- Captcha
- create zip file and download
- PhpOffice PhpSpreadsheet Library (Export data in excel sheet)
- data export in excel sheet
- Excel File generate in Codeigniter using PHPExcel
- Dompdf library
- tcpdf library
- Html table to Excel & docs download
- CI Database Query
- Database Query
- SQL Injection Prevention
- Auth Model
- Join Mysql
- Tree View in dropdown option list
- OTP Integration in codeigniter
- curl post
- download file using curl
- Sweet Alert
- Sweet alert Delete & Success
- Log Message in Codeigniter
- Menu & Submenu show dynamically
- Set Default value in input box
- Cron Jobs
- Stored Procedure
- Display Loading Image when AJAX call is in Progress
- Send SMS
- IP Address
- Codeigniter Tutorialspoint
- Website Link
- How To Create Dynamic Xml Sitemap In Codeigniter
- Paypal Payment Integration
- Get Latitude and Longitude From Address in Codeigniter Using google map API
- How To Create Simple Bar Chart In Codeigniter Using AmCharts?
- dynamic Highcharts in Codeigniter
- Barcode in Codeigniter
- Codeigniter Interview Questions
- Project
Home » Codeigniter »
How to show data using ajax with josn parse in codeigniter?
View
File Name :
<div class="card card-success col-md-12">
<div class="card-body">
<button class="btn btn-primary" id="btn-show"> Show Users</button>
<div class="row">
<div class="card-body p-0">
<div id="show-div"> </div>
<br/>
<div id="divtable" style="display:none;">
<table class="table table-striped projects" id="usertable">
<thead>
<tr>
<th style="width: 1%">
S.No
</th>
<th style="width: 15%">
Name
</th>
<th style="width: 20%">
Email
</th>
<th>Mobile</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script>
$(document).ready(function() {
$("#btn-show").click(function(event) {
$.ajax({
method: "POST",
// type: 'get',
url:"<?php echo base_url();?>getenquiry/data_show",
beforeSend: function (f) {
$('#show-div').html('Load Table ...');
},
success: function (data) {
$('#divtable').show();
var obj = JSON.parse(data);
var len = obj.length;
for(var i=0; i<len; i++){
var id = obj[i].pki_id;
var username = obj[i].vc_name;
var email = obj[i].vc_email;
var mobile = obj[i].vc_mobile;
var tr_str = "<tr>" +
"<td align='center'>" + (i+1) + "</td>" +
"<td align='center'>" + username + "</td>" +
"<td align='center'>" + email + "</td>" +
"<td align='center'>" + mobile + "</td>" +
"</tr>";
$("#usertable tbody").append(tr_str);
}
},
error: function(){
console.log(data);
alert('Error while request..');
}
});
});
});
</script>
controller menthod
File Name : Getenquiry.php
public function data_show()
{
$data = $this->User_model->Fetchdata();
echo json_encode($data);
//echo json_encode(array("data" => $data));
exit;
}
model function
File Name :
public function Fetchdata()
{
$this->db->select('*');
$this->db->from('user_quote');
$query=$this->db->get();
return $result = $query->result();
}
Output
File Name :
Example :- How to show single row using ajax with json data?
File Name :
<div class="card card-success col-md-12">
<div class="card-body">
<button class="btn btn-primary" id="btn-show"> Show Users</button>
<div class="row">
<div class="card-body p-0">
<div id="show-div"> </div>
<br/>
<div id="divtable" style="display:none;">
<table class="table table-striped projects" id="usertable">
<thead>
<tr>
<th style="width: 1%">
S.No
</th>
<th style="width: 15%">
Name
</th>
<th style="width: 20%">
Email
</th>
<th>Mobile</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script>
$(document).ready(function() {
$("#btn-show").click(function(event) {
var id = '1';
$.ajax({
method: "POST",
// type: 'get',
url:"<?php echo base_url();?>getenquiry/data_show",
data:{id:id},
beforeSend: function (f) {
$('#show-div').html('Load Table ...');
},
success: function (data) {
$('#divtable').show();
var obj = JSON.parse(data);
var id = obj['0'].pki_id;
var username = obj['0'].vc_name;
var email = obj['0'].vc_email;
var mobile = obj['0'].vc_mobile;
var tr_str = "<tr>" +
"<td align='center'>" + (1) + "</td>" +
"<td align='center'>" + username + "</td>" +
"<td align='center'>" + email + "</td>" +
"<td align='center'>" + mobile + "</td>" +
"</tr>";
$("#usertable tbody").append(tr_str);
},
error: function(){
console.log(data);
alert('Error while request..');
}
});
});
});
</script>
File Name :
public function data_show()
{
$id = $this->input->post('id');
$data = $this->User_model->Fetchdata($id);
echo json_encode($data);
//echo json_encode(array("data" => $data));
exit;
}
model function
File Name :
public function Fetchdata($id)
{
$this->db->select('*');
$this->db->from('user_quote');
$this->db->where('pki_id', $id);
$query=$this->db->get();
return $result = $query->result();
}
Example:-
File Name :
<div class="card-body">
<button class="btn btn-primary" id="btn-show"> Show Users</button>
<div class="row">
<div class="card-body p-0">
<div id="show-div"> </div>
</div>
</div>
</div>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script>
$(document).ready(function() {
$("#btn-show").click(function(event) {
var id = '1';
$.ajax({
method: "POST",
url:"<?php echo base_url();?>getenquiry/data_show",
data:{id:id},
dataType:'json',
success: function (data) {
$('#divtable').show();
data.forEach(function(entry) {
$("#show-div").append("<table><tr><td>"+entry.vc_name+"</td><td>"+entry.vc_email+"</td> <td>"+entry.vc_mobile+"</td> </tr></table>");
// $("#show-div").append("<div>"+entry.vc_email+"</div>");
//just add everything here
});
},
error: function(){
console.log(data);
alert('Error while request..');
}
});
});
});
</script>
controller function
File Name :
public function data_show()
{
$id = $this->input->post('id');
$data = $this->User_model->Fetchdata($id);
echo json_encode($data);
//echo json_encode(array("data" => $data));
exit;
}
model function
File Name :
public function Fetchdata($id)
{
$this->db->select('*');
$this->db->from('user_quote');
$this->db->where('pki_id', $id);
$query=$this->db->get();
return $result = $query->result();
}