This tutorial will helps you to check live availability of username or email using Ajax in Codeigniter. Using this tutorial you can also understand how can we send a jQuery Ajax request to server living in Codeigniter.

In your "view", where you have created form include jQuery library and put the below code there.

In header section:

$(document).ready(function() {     
 /// make loader hidden in start     
 $('#Loading').hide();            
 $('#email').blur(function(){   
 var a = $("#email").val();   
 var filter = /^[a-zA-Z0-9]+[a-zA-Z0-9_.-]+[a-zA-Z0-9_-]+@[a-zA-Z0-9]+[a-zA-Z0-9.-]+[a-zA-Z0-9]+.[a-z]{2,4}$/;        
 // check if email is valid   
 if(filter.test(a)){                 
  // show loader     
  $('#Loading').show();    
  $.post("<?php echo base_url()?>controller_name/check_email_availablity", {     
  email: $('#email').val()    
 },
 function(response){                         
  //#emailInfo is a span which will show you message     
  $('#Loading').hide();     
  setTimeout("finishAjax('Loading', '"+escape(response)+"')", 400);    
 });    
 return false;   
} 
}); 
function finishAjax(id, response){   
 $('#'+id).html(unescape(response));   
 $('#'+id).fadeIn(); 
}

In body section of your form:

<div>   
 <label>E-mail</label>   
 <input id="email" name="email" type="text" value=""  />   
 <span id="Loading"><img src="loader.gif" alt="Ajax Indicator" /></span>  
</div>

In "controller" add this function:

function check_email_availablity()  {   
 $this->load->model('My_model');   
 $get_result = $this->My_model->check_email_availablity();      
 if(!$get_result )   
  echo '<span >Email already in use. </span>';   
 else   
  echo '<span >Email Available</span>'; 
}

Suppose you have a model called my_model.php and a table tbl_members or what ever you named. This table should have a field named "email" of type varchar [200].

Add this function:

function check_email_availablity()  {         
 $email = trim($this->input->post('email'));   
 $email = strtolower($email);       
 $query = $this->db->query('SELECT * FROM tbl_members where email="'.$email.'"');      
 if($query->num_rows() > 0)   
  return false;   
 else 
  return true; 
}

Thats it, this function will return a message against email field that whether it is available or not. This is not for only email, you can use it to check any field. Also this is client side check so you also need to use this model function in server side so that email can also be verified when form has been submitted with disabling javascript .

JE Effective Lead Management system is a lead Management solution for Joomla websites to manage the leads or contact us Emails. This is kind of very tiny CRM for a sales person who follows up with leads. This best fits of someone who is looking for simple and effective solutuion. If you are small company with few sales guys, this works better, Doing a complete integration of other complex softwares to handle the leasds is a overkill sometime.

Features of JE Effective Lead Management system:

1. Customizable form for submitting leads.
2. Captcha field for preventing spam.
3. Displays all custom field created by Admin.
4. Supports ajax Form validation.
5. Admin can Manage Leads(ADD/EDIT/DELETE) from the back end.
6. The leads has been assigned to the salesperson by Super Admin.
7. Those who belonged to the Manager & Administrator user group are the salesperson.
8. Sales person handle the leads that has been assigned by the Admin.
9. Admin can change the status and weightage of the lead and write remarks about every leads.
10. Salesperson can change the status and weightage of the lead and write remarks about the leads.
11. Salesperson can update their daily status and next action to be taken.
12. Colorful Dashboard with shortcuts for all controllers and list of remainders by Sales person.
13. Display leads information based on the country and date.
14. Ease to maintain documents uploaded by users.
15. Admin can generate his own customfields and set parameter for every fields via backend.
16. Customizable mail template from the backend.
17. Unlimitted number of Sales persons can be added in backend.
18. Admin can restrict the users to upload particular files(.doc, .txt, etc).
19. Statistical information will be displayed based on the country, weightage, status, date and the sales person.
20. Support languages English, Swedish, French, Spanish, Dutch, German, Arabic, Norwegian, portuguese, etc ..
21. Quick Icon in Admin section [only for Joomla 2.5]
22. Module for Listing Reminder,Latest leads,Leads Report by country in control panel(Admin section) [only for Joomla 2.5]

Admin Demo - Click Here

To download files - Click Here

Screenshot Images

In the previous post we have discussed about "Building your own theme in Wordpress". At this post, we try to show a article at front page. So, we will write simple code.

Open "index.php", enter following code:

Open your browser. Point to http://localhost/wordpress.

Now, we will try to loop and show all posts: