Sunday, August 21, 2016

How to detect “no internet connection” in AngularJS

Today i need to show some message when internet connection lost. So I define this interceptor in httpProvider in my app.js file, so its return an error when a call does not happen successfully due to internet connection lost. This Interceptor return status= "-1" when ajax call is failed. So i set a variable online= true here and in my html i display a message if online=true. See below my html code as well

angular.module('YourAppName', []).config([
      function($q,$rootScope) {
        return {
            responseError: function(res){
                //Angular returns "success" by default, but we will call "error" if data were not obtained.
                if( == null && res.status === -1 && res.statusText === ""){
      $ = true;
                    return $q.reject(res) //callback error()
                return res //return default success()

Now i need to show some message when $ = true;
Below i check that online variable is true then show a message "Your have lost your internet connection. Check your internet connection and reload your page again." other wise not.

<!--Below message is showing when internet connection is lost. --> 
<div class="alert alert-error" ng-if="online"><i class="btn-icon-only icon-warning-sign"></i>
 Your have lost your internet connection. Check your internet connection and reload your page again.<button ng-click="reloadRoute()"><i class="icon-refresh"></i> Reload</button>

If you see my above html there i also add a reload button to reload the page to do this i create a function and i call this on click of reload button Below is my function :

// This function Is use to reload the active page.
$rootScope.reloadRoute = function() {

Now in the last step you need to hide the above message automatically when internet connection is coming again to do this i just put $ = false; when view content loaded like below :

// To set the view online message false.
$rootScope.$on('$viewContentLoaded', function() {
   $ = false;

Preview :

If you like this post or you have any problem during implementation don't to leave a comment below i will definitely reply you back as soon as possible.

Chears :)

Happy coding

Friday, June 24, 2016

How to remove html in angular js

Suppose you  have a textarea editor and you entered some text in it and making some formatting like change font or adding style etc . So now you want that when you are showing it you don't want to shown html you adding in it. See screenshot below.

Remove html in angular js

To do this below is a simple filter you can use : You just need to be add this filter in your app.js and change the "yourAppName" with your own.

yourAppName.filter('htmlToPlaintext', function() {
    return function(text) {
      return  text ? String(text).replace(/<[^>]+>/gm, '') : '';

Method of calling this filter :

<label style="color: #636363;">{{company.notes | htmlToPlaintext}}</label>

If you like this post don't forgot to leave a comment.

Happy Coding :)

Thursday, June 23, 2016

Difference between php-4 and php-5

This is a very common interview question. If you are going for the interview then you have to know the difference between these. Below is the basic difference of PHP-4 and PHP-5 -

1- PHP-4 is a procedural language where as PHP-5 is a object oriented language.

2- PHP-4 was powered by zend engine 1.0 where as PHP-5 was powered by zend engine 2.0

3- In PHP-4 everything is passed by value where as In PHP-5 all objects are passed by refference.

4- PHP-5 introduce a number of new magic function like _CALL, _GET, _SET and _TOSTRING

5- In PHP-5 it is possible you can declare a class as Abstract.

6- PHP-5 introduce a special function called _autoload.

7- PHP-5 removed register_global(), magic quotes and safe mode. 
This was due to the fact that register_global had opened security holes by allowing data injection.

8- PHP-5 introduce a new mysql extention named MYSQLI for developer in Mysql 4.1 and later version.

Happy Coding :)

What is InnoDB storage engine

The InnoDB storage engine provides secure transaction capability. A transaction is a logical groping of statements that is handled by the database server as a single unit.  Either all the statements execute successfully to completion or all modification made by the statements are discarded if an error occurs. 
Transaction system often are described as ACID complient :

ATOMIC - All the statements execute successfully or are canceled as a unit.

CONSISTENT - A database that is in a consistent state when a transaction begins is left in a consistent state by the transaction.

ISOLATED - One transaction does not affected to another transaction.

DURABLE - All the changes made by a transaction that completes successfully are stored properly in the database. Changes are not lost.

Features of InnoDB storage engine:
  1. Provides Full transaction capability with full ACID (Atomic, Consistency, Isolated, and Durabe) compliance.
  2. It has row level locking. By supporting row level locking, you can add data to an InnoDB table without the engine locking the table with each insert and this speeds up both the recovery and storage of information in the database.
  3. The key to the InnoDB system is a database, caching and indexing structure where both indexes and data are cached in memory as well as being stored on disk This enables very fast recovery, and works even on very large data sets.
  4. InnoDB supports foreign key constraints
  5. InnoDB supports automatic crash recovery.
  6. InnoDB supports table compression (read/write)
  7. InnoDB supports spatial data types (no spatial indexes)
  8. Innodb support non-locking ANALYZE TABLE and is only required when the server has been running for a long time since it dives into the index statistics and gets the index information when the table opens.
  9. Innodb does not have separate index files so they do not have to be opened.
  10. Innodb builds its indexes one row at a time in primary key order (after an ALTER), which means index trees aren't built in optimal order and are fragmented.There is currently no way to defragment InnoDB indexes, as 
  11. InnoDB can't build indexes by sorting in MySQL 5.0. Even dropping and recreating InnoDB indexes may result in fragmented indexes, depending on the data.
  12. A table can contain a maximum of 1000 columns.
  13. The InnoDB internal maximum key length is 3500 bytes, but MySQL itself restricts this to 3072 bytes. (1024 bytes for non-64-bit builds before MySQL 5.0.17, and for all builds before 5.0.15.)
  14. The default database page size in InnoDB is 16KB. By recompiling the code, you can set it to values ranging from 8KB to 64KB. You must update the values of UNIV_PAGE_SIZE and UNIV_PAGE_SIZE_SHIFT in the univ.i source file.
  15. InnoDB tables do not support FULLTEXT indexes.

If you like this don't forget to leave a comment below.

Happy Coding:)

Friday, June 17, 2016

ERROR 1267 (HY000): Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='

Today i have encountered a problem when i run a select query after joining two tables i.e "ERROR 1267 (HY000): Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='" . 
This is happen because the collection type is different of each table.

Solution :

1) - First of all check the collection type of each table by running below query :

SELECT table_schema, table_name, column_name, character_set_name, collation_name

FROM information_schema.columns

WHERE collation_name = 'latin1_general_ci'

ORDER BY table_schema, table_name,ordinal_position;

2) - Second one is update the collection type of that table those collection type is different by running below query :

ALTER TABLE tbl_name CONVERT TO CHARACTER SET latin1 COLLATE 'latin1_swedish_ci';

Don't forget to leave a comment if you like this post.

Happy Coding :)

Tuesday, June 7, 2016

How to fixed header after scroll up in angular js

Suppose you have a large number of data in your listing and when you are going to scroll up into the listing then you list heading is move up and you didn't showing it and sometime its a complicated to determine that which column data is specify which column heading. To solve this problem you can do to freeze the heading at specific point (like top of the screen) when listing scroll up. To solve this problem in angular js here is a very simple directive you can use-

Below is the directive :

.directive('fixedTableHeaders', ['$timeout', function fixedTableHeaders($timeout) {
    return {
        restrict: 'A',
        link: function(scope, element, attrs){
$timeout(function () {
}, 0);

How to use : You have to call the above directive in your main div or table like below -

This is my html code of listing :

<table ng-table="tableParams" class="table table-striped table-bordered"  data-fixed-table-headers>
<tr ng-repeat="user in $data">
<td data-title="'Name'" data-sortable="'first_name'">{{user.first_name}} {{user.last_name}}</td>
<td data-title="'Phone'" data-sortable="'private_phone'">{{user.private_phone}}</td>
<td data-title="'Email'" data-sortable="'email'">{{}}</td>
<td data-title="'Designation'" data-sortable="'designation'"><div ng-repeat="(key, value) in desig" ng-if="key==user.designation">{{value}}</div></td>
<td data-title="'Type'" data-sortable="'user_type'">{{(user.user_type ==3) ? "Employee" : (user.user_type ==2) ? "Employer" : "Lender"}}</td>
<td data-title="'Status'" data-sortable="'status'">{{(user.status ==1) ? "Active" : "Inactive"}}</td>
<td class="td-actions">
<a class="btn-small" href="/#/admin/setting/users/edituser/{{user._id}}"><img src="../../../images/editicon.png" /></a>
<a class="btn-small" ng-click="deleteUser(user._id, user.company_id,user.designation,user.user_type)"><img src="../../../images/cuticon.png" /></a>

Output : 

Fixed header after scroll up in angular js

If you having problem while using this code so please leave a comment i will defenatily reply you back.

Happy coding :)

Thursday, June 2, 2016

How to create country state dropdown in angularjs

Today i have requirement in my angular js project to list the country and there corresponding state. When user selected any country then there state should be listed in the next dropdown. I did googling alot but i did't get any proper solution of it. Then i create a directive of it. I can't list the complete country code here so i just listed the code only for two countries "Afghanistan" and "Albania" .But you can download the complete code from HERE.

Code start here :

(function() {
    "use strict";
    var app = angular.module('angularCountryState', []);

(function(window) {
    "use strict";

    var template = '<div class="control-group">';
template += '<label for="country" class="col-md-3 col-sm-3 col-xs-12 field-name text-padding">{{stateLabel}}</label>';
template += '<div class="col-md-9 col-sm-8 col-xs-12">';
    template += '<select id="county" class="span4" name="state" ng-model="ngModel.county" ng-disabled="!" class="form-control">';
    template += '<option value="">Select County</option>';
    template +='<option ng-repeat="optStates in states track by $index">{{optStates}}</option>';
    template +='</select>';
    template +='</div>';
template +='</div>';
    template += '<div class="control-group">'
    template += '<label for="country" class="col-md-3 col-sm-3 col-xs-12 field-name text-padding">{{countryLabel}}</label>';
template += '<div class="col-md-9 col-sm-8 col-xs-12" val="{{}}">';
    template += '<select class="span4" name="country" ng-change="selectCountry()" ng-model="" required  class="form-control">';
template += '<option value="">Select Country</option>';
    template +='<option ng-repeat="theCountry in countries track by $index" >{{theCountry}}</option>';
    template +='</select>';
    template +='</div>';
template +='</div>';

        .directive("countryStateSelect", [ function () {
            return {
                restrict: "E",
                template: template,
                scope: { country: "=?", countryState: "=?state", ngModel: '='},
                link: function (scope, element, attrs) {
                    scope.countryLabel = "Country";
                    scope.stateLabel = "County";
                    if(typeof attrs.countryLabel != 'undefined'){
                        scope.countryLabel = attrs.countryLabel;
                    if(typeof attrs.stateLabel != 'undefined'){
                        scope.stateLabel = attrs.stateLabel;  
                    scope.countries = new Array("Afghanistan", "Albania");

scope.state = new Array();
                    scope.state[1]="Badakhshan|Badghis|Baghlan|Balkh|Bamian|Farah|Faryab|Ghazni|Ghowr|Helmand|Herat|Jowzjan|Kabol|Kandahar|Kapisa|Konar|Kondoz|Laghman|Lowgar|Nangarhar|Nimruz|Oruzgan|Paktia|Paktika|Parvan|Samangan|Sar-e Pol|Takhar|Vardak|Zabol";
                    scope.state[2]="Berat|Bulqize|Delvine|Devoll (Bilisht)|Diber (Peshkopi)|Durres|Elbasan|Fier|Gjirokaster|Gramsh|Has (Krume)|Kavaje|Kolonje (Erseke)|Korce|Kruje|Kucove|Kukes|Kurbin|Lezhe|Librazhd|Lushnje|Malesi e Madhe (Koplik)|Mallakaster (Ballsh)|Mat (Burrel)|Mirdite (Rreshen)|Peqin|Permet|Pogradec|Puke|Sarande|Shkoder|Skrapar (Corovode)|Tepelene|Tirane (Tirana)|Tirane (Tirana)|Tropoje (Bajram Curri)|Vlore";

//This Function Is Call On Country Drop Down Change.
                    scope.selectCountry = function(){
var selectedCountry =;
                        var indexCountry = scope.countries.indexOf(selectedCountry)+1;

                        scope.states = scope.state[indexCountry].split("|");

                        scope.countryState = '';
                        if(scope.states.length == 1){
                            scope.states = new Array(selectedCountry);  
                        //indexCountry correspond to the "Select" label
                        if(indexCountry == 0){
                            scope.states = new Array("");

//This Function Is Use To Load Seleted Country State On Edit Page.
if(typeof scope.ngModel!="undefined"){
var selectedCountry =;
var indexCountry = scope.countries.indexOf(selectedCountry)+1;
if(indexCountry >0){
scope.states = scope.state[indexCountry].split("|");
if(scope.states.length == 1){
scope.states = new Array(selectedCountry);  

if(indexCountry == 0){
scope.states = new Array("");



How to use this code:

Step 1- First of all you have to download and include this js file on you index page like below
<script src="js/angular-country-state.js"></script>

Step 2- Then you have to call this directive on your html page like below
<country-state-select ng-model="company"></country-state-select>

Note : I am passing the object company in ng-model. You can pass your own object. Now when you submiting your form then you will get the selected country name in variable and your state is in company.state You can change the name of these inputs country and state from the html of code.

If you like this post or having any problem while using this code please comment below i will reply you back with the solution of your problem.

Happy Coding :)