• logo
  • PHP
  • PHP OOPs
  • script
    • JavaScript
    • JQuery
    • Ajax
    • AngularJs
    • VueJs
    • NodeJs
    • ReactJs
  • wordpress
  • Codeigniter
  • Codeigniter 4
  • Laravel
  • Python
  • MySql
  • Json
  • C
  • C++
  • More ...
    • Cakephp Framework
    • MongoDb
    • MySqli PDO
    • .htaccess
    • HTML 5
    • CSS
    • SEO
    • DCA

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();
}




Itechtuto

Connect Us Socially:

Quick Links

  • itech
  • About Us
  • Feedback
  • Trademarks
  • Privacy Policy
  • Terms of Use
  • Sitemap
  • Trademarks
  • Privacy Policy
  • Terms of Use
  • Sitemap

Copyright © 2016 itechxpert (P) Ltd. All rights reserved.

Copyright © 2016 itechxpert (P) Ltd. All rights reserved.