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 fetch data from database using jquery ajax with Json
How to check username is available or not in database using ajax with josn data.
File name : userregister.php
<html>
<head>
<script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
<script type="text/javascript">
function check_if_exists() {
var username = $("#username").val();
$.ajax(
{
type:"post",
url: "<?php echo base_url(); ?>userregister/user_available",
data:{ username:username},
dataType: 'json',
success:function(response)
{
var len = response.length;
if(len > 0)
{
//$('#msg').html('<span style="color: green;">'+msg+"</span>");
$('#msg').html('<span style="color: green;">user name all ready exist</span>');
}
else
{
$('#msg').html('<span style="color:red;">User name not exist</span>');
}
}
});
}
</script>
</head>
<body>
<!-- <div id="msg"></div> -->
<form name = "form1" id = "form1" method ="post" action="">
<?php //echo validation_errors(); ?>
<label for="username" class = "labelForm">Username:</label>
<input type="text" id="username" name="username" class="input2" onblur="check_if_exists();"><label id="msg"></label><br/>
<label for="password" class = "labelForm">Password:</label>
<input type="password" id="password" name="password" class = "input2" onblur="checkPasswords();"><br/>
<label for="passconf" class = "labelForm">Password:</label>
<input type="password" id="passconf" name="passconf" class = "input2" onblur="checkPasswords();"><br/>
<label for="email" class = "labelForm">Email:</label>
<input type="text" id="email" name="email" class = "input2"><br/><br/>
<button type="submit" id = "new_user_submit">Add New User</button>
</body>
</html>
Controller
File name : Userregister.php
<?php
defined('BASEPATH') OR exit('no direct script access allowed');
class Userregister extends CI_Controller
{
public function __construct()
{
parent::__construct();
}
public function index()
{
$this->load->view('userregister');
}
public function user_available()
{
$username = $this->input->post('username');
$data = $this->Auth_model->user_present($username);
echo json_encode($data);
exit;
}
public function create_user()
{
}
}
Model
File name : Auth_model.php
<?php
defined('BASEPATH') OR exit ('no direct script access allowed');
class Auth_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
public function user_present($username)
{
$this->db->select('name');
$this->db->from('user_info');
$this->db->where('name', $username);
$qry = $this->db->get();
return $qry->result();
}
}
Get the value from codeigniter function in input form using jquery ajax.
File name : userregister.php
<html>
<head>
<script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
<script type="text/javascript">
function check_if_exists() {
var username = $("#username").val();
$.ajax(
{
type:"post",
url: "<?php echo base_url(); ?>userregister/user_available",
data:{ username:username},
dataType: 'json',
success:function(response)
{
var len = response.length;
if(len > 0)
{
// Read values
var uname = response[0].name;
var upass = response[0].password;
var uemail = response[0].email;
alert(uname);
alert(upass);
alert(uemail);
$('#username').text(uname);
$('#userpass').text(upass);
$('#useremail').text(uemail);
$('#username').val(uname);
$('#userpass').val(upass);
$('#useremail').val(uemail);
}
else
{
$('#username').text('');
$('#userpass').text('');
$('#useremail').text('');
}
}
});
}
</script>
</head>
<body>
<!-- <div id="msg"></div> -->
<form name = "form1" id = "form1" method ="post" action="">
<?php //echo validation_errors(); ?>
<label for="username" class = "labelForm">Username:</label>
<input type="text" id="username" name="username" value="" onblur="check_if_exists();"><br/>
<label for="password" class = "labelForm">Password:</label>
<input type="password" id="userpass" name="userpass" value="" onblur="checkPasswords();"><br/>
<label for="passconf" class = "labelForm">Password:</label>
<input type="password" id="passconf" name="passconf" value="" onblur="checkPasswords();"><br/>
<label for="email" class = "labelForm">Email:</label>
<input type="text" id="useremail" name="useremail" value=""><br/><br/>
<button type="submit" id = "new_user_submit">Add New User</button>
</body>
</html>
Controller
File name : Userregister.php
<?php
defined('BASEPATH') OR exit('no direct script access allowed');
class Userregister extends CI_Controller
{
public function __construct()
{
parent::__construct();
}
public function index()
{
$this->load->view('userregister');
}
public function user_available()
{
$username = $this->input->post('username');
$data = $this->Auth_model->user_present($username);
echo json_encode($data);
exit;
}
public function create_user()
{
}
}
model
File name : Auth_model.php
<?php
defined('BASEPATH') OR exit ('no direct script access allowed');
class Auth_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
public function user_present($username)
{
$this->db->select('*');
$this->db->from('user_info');
$this->db->where('name', $username);
$qry = $this->db->get();
return $qry->result();
}
}
How to send AJAX request in CodeIgniter and get all returned data.
File name : view.php
<!doctype html>
<html>
<head>
<title>How to send AJAX request in Codeigniter</title>
</head>
<body>
Select Username : <select id='sel_user'>
<option value='yssyogesh'>yssyogesh</option>
<option value='sonarika'>sonarika</option>
<option value='vishal'>vishal</option>
<option value='sunil'>sunil</option>
</select>
<!-- User details -->
<div >
Username : <span id='suname'></span><br/>
Name : <span id='sname'></span><br/>
Email : <span id='semail'></span><br/>
</div>
<!-- Script -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script type='text/javascript'>
$(document).ready(function(){
$('#sel_user').change(function(){
var username = $(this).val();
$.ajax({
url:'<?=base_url()?>index.php/User/userDetails',
method: 'post',
data: {username: username},
dataType: 'json',
success: function(response){
var len = response.length;
if(len > 0){
// Read values
var uname = response[0].username;
var name = response[0].name;
var email = response[0].email;
$('#suname').text(uname);
$('#sname').text(name);
$('#semail').text(email);
}else{
$('#suname').text('');
$('#sname').text('');
$('#semail').text('');
}
}
});
});
});
</script>
</body>
</html>
Controller
File name : user.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class User extends CI_Controller {
public function index(){
// load base_url
$this->load->helper('url');
// load view
$this->load->view('user_view');
}
public function userDetails(){
// POST data
$postData = $this->input->post();
//load model
$this->load->model('Main_model');
// get data
$data = $this->Main_model->getUserDetails($postData);
echo json_encode($data);
}
}
model
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Main_model extends CI_Model {
function getUserDetails($postData){
$response = array();
if($postData['username'] ){
// Select record
$this->db->select('*');
$this->db->where('username', $postData['username']);
$q = $this->db->get('users');
$response = $q->result_array();
}
return $response;
}
}
Table
File name : table.php
CREATE TABLE `users` (
`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
`username` varchar(80) NOT NULL,
`name` varchar(80) NOT NULL,
`email` varchar(80) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
File Name :
Example : How to show All Data using Ajax in codeigniter?
File Name : view
<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) {
$.ajax({
method: "POST",
url:"<?php echo base_url();?>getenquiry/data_show",
beforeSend: function (f) {
$('#show-div').html('Load Table ...');
},
success: function (data) {
//console.log(data);
//alert(data);
$('#show-div').html(data);
},
error: function(){
alert('Error while request..');
}
});
});
});
</script>
Controller Method
File Name :
public function data_show()
{
$data['quotedata'] = $this->User_model->Fetchdata();
$result = $this->load->view('doc-list',$data,true);
echo $result;
exit;
}
Model
File Name :
public function Fetchdata()
{
$this->db->select('*');
$this->db->from('user_quote');
$query=$this->db->get();
return $result = $query->result();
}
view
File Name : doc-list.php
<table class="table table-striped projects">
<thead>
<tr>
<th style="width: 1%">
S.No
</th>
<th style="width: 15%">
Name
</th>
<th style="width: 20%">
Email
</th>
<th>
Contact
</th>
<th> Activity </th>
<th> Message </th>
<th> Status </th>
<th style="width: 9%"> Action</th>
</tr>
</thead>
<tbody>
<?php
if(!empty($quotedata)){
$count = 1;
foreach($quotedata as $row){
?>
<tr>
<td>
<?php echo $count;?>
</td>
<td> <a href="<?php base_url() ?>enquiry_details/<?php echo base64_encode($row->pki_id);?>"><?php echo $row->vc_name; ?></a> </td>
<td> <?php echo $row->vc_email; ?> </td>
<td> <?php echo $row->vc_mobile; ?> </td>
<td> <?php echo $row->vc_activity; ?></td>
<td> <?php echo $row->vc_message; ?></td>
<td> <?php if($row->reply_status == 1)
{
?>
<span class="badge badge-success">Replyed</span>
<?php } else {?>
<span class="badge badge-warning">Pending</span>
<?php } ?>
</td>
<td class="project-actions text-right">
<!-- <a class="btn btn-info btn-sm reply_view" href="javascript:void();" id="<?php echo $row->pki_id?>">
<i class="fa fa-reply" aria-hidden="true"></i>
</a> -->
<a class="btn btn-info btn-sm" href="<?php echo base_url()?>getenquiry/reply_message/<?php echo base64_encode($row->pki_id); ?>">
<i class="fa fa-reply" aria-hidden="true"></i>
</a>
</td>
</tr>
<?php $count++; } } else { ?>
<tr>
<td colspan="10"> <center>Records Not Found. </center> </td>
</tr>
<?php } ?>
</tbody>
</table>
Example : How to show single record using Ajax in codeigniter?
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>
</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},
//cache: false,
//dataType:'json',
beforeSend: function (f) {
$('#show-div').html('Load Table ...');
},
success: function (data) {
//console.log(data);
//alert(data);
$('#show-div').html(data);
},
error: function(){
alert('Error while request..');
}
});
});
});
</script>
controller method
File Name :
public function data_show()
{
$id = $this->input->post('id');
$data['quotedata'] = $this->User_model->Fetchdata($id);
$result = $this->load->view('doc-list',$data,true);
echo $result;
exit;
}
model
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();
}
view
File Name :
<table class="table table-striped projects">
<thead>
<tr>
<th style="width: 1%">
S.No
</th>
<th style="width: 15%">
Name
</th>
<th style="width: 20%">
Email
</th>
<th>
Contact
</th>
<th> Activity </th>
<th> Message </th>
<th> Status </th>
<th style="width: 9%"> Action</th>
</tr>
</thead>
<tbody>
<?php
if(!empty($quotedata)){
$count = 1;
foreach($quotedata as $row){
?>
<tr>
<td>
<?php echo $count;?>
</td>
<td> <a href="<?php base_url() ?>enquiry_details/<?php echo base64_encode($row->pki_id);?>"><?php echo $row->vc_name; ?></a> </td>
<td> <?php echo $row->vc_email; ?> </td>
<td> <?php echo $row->vc_mobile; ?> </td>
<td> <?php echo $row->vc_activity; ?></td>
<td> <?php echo $row->vc_message; ?></td>
<td> <?php if($row->reply_status == 1)
{
?>
<span class="badge badge-success">Replyed</span>
<?php } else {?>
<span class="badge badge-warning">Pending</span>
<?php } ?>
</td>
<td class="project-actions text-right">
<!-- <a class="btn btn-info btn-sm reply_view" href="javascript:void();" id="<?php echo $row->pki_id?>">
<i class="fa fa-reply" aria-hidden="true"></i>
</a> -->
<a class="btn btn-info btn-sm" href="<?php echo base_url()?>getenquiry/reply_message/<?php echo base64_encode($row->pki_id); ?>">
<i class="fa fa-reply" aria-hidden="true"></i>
</a>
</td>
</tr>
<?php $count++; } } else { ?>
<tr>
<td colspan="10"> <center>Records Not Found. </center> </td>
</tr>
<?php } ?>
</tbody>
</table>
How to show data using json with ajax?
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},
cache: false,
dataType:'json',
beforeSend: function (f) {
$('#show-div').html('Load Table ...');
},
success: function (data) {
//console.log(data);
//alert(data);
$('#show-div').html(data);
//var obj = JSON.parse(data);
//alert(obj);
/*
data.forEach(function(entry) {
$("#show-div").append("<table><tr><td>"+entry.vc_name+"<td><td>"+entry.vc_email+"<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>
contrelloer method:-
File Name :
public function data_show()
{
$id = $this->input->post('id');
$data = $this->User_model->Fetchdata($id);
echo json_encode($data);
exit;
model
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();
}
File Name :
File Name :
File Name :
File Name :
File Name :