How to import and export mysql database using Command Prompt?

                                  If you have a large database and you want to export which is not exported by phpmyadmin default export option. because it shows some maximum limit or time expired. For that you can try importing and exporting any size database of phpmyadmin using Command prompt.

So command for importing and exporting is below : 

       1. open cmd

       2. set mysql path in cmd

            set path=c:\wamp\bin\mysql\mysql5.6.17\bin

       3. For database export (Backup)

           

           mysqldump -u YourUser -p YourDatabaseName > filename.sql

       4. For database import (Restore): 

            mysql -u YourUser -p YourDatabaseName < filename.sql



you can change your set path command as per your xampp,wampp etc.

Checking format of Email address in excel

Checking email addresses in bulk if the format is correct or not

So in your excel sheet if emails are in A column, go in the B column or other and as per column name put alphabet and row number like B1 cell and copy paste this code: 

=AND(NOT(ISERROR(FIND("@",A1))),NOT(ISERROR(FIND(".",A1))),ISERROR(FIND(" ",A1)))

In formula you can see A2 because A1 is occupied with head column of excel data, After that drag mouse down from B2 it will automatically change the cell row number in formulas or you can copy and paste the code to the other cells. But with respective rownumbers change i.e.

=AND(NOT(ISERROR(FIND("@",A1))),NOT(ISERROR(FIND(".",A1))),ISERROR(FIND(" ",A1)))

 For all the valid e-mails, it will give you ‘TRUE’ and for the invalid ‘FALSE’.

Loading gif image for freeze page to process ajax request in jquery

The method is use to show some animated image at time of processing the ajax request with gif image. where we have to use beforeSend object in ajax call for loading gif at time of request processing.

Your ajax function looks like 

$.ajax({
    url: uri,
    cache: false,
    beforeSend: function(){
        // show gif image when request sent
    },
    complete: function(){
        // hide gif image when response receives
    },
    success: function(html){
       // final output hadleling
    }
});

Html Code:

<div class="loading">
  <img src="//image path" class="img-responsive" />
</div> 

Styling CSS Code:

.loading {
  visibility: hidden;
  background-color: rgba(255,255,255,0.7);
  position: absolute;
  z-index: +100 !important;
  width: 100%;
  height:100%;
}

.loading img {
  position: relative;
  top:50%;
  left:50%;
}

Jquery Code: 

$.ajax({
  type:'POST',
  beforeSend: function(){
    $('.loading').css("visibility", "visible");
  },
  url:'/quantityPlus',
  data: {
   'data1':p1,
   'data2':p2,
   'data3':p3},
   success:function(data){
     // data fetch and show on html page
  },
  complete: function(){
    $('.loading').css("visibility", "hidden");
  }
});

}

Check current date falls between two dates function in jquery

         The function is to check date comes between start and end date which should be in "dd/mm/yyyy" format.

function dateCheck(dateFrom,dateTo,dateCheck) {

 var d1 = dateFrom.split("/");
 var d2 = dateTo.split("/");
 var c = dateCheck.split("/");

 var from = new Date(d1[2], parseInt(d1[1])-1, d1[0]);  // -1 because months are from 0 to 11
 var to   = new Date(d2[2], parseInt(d2[1])-1, d2[0]);
 var check = new Date(c[2], parseInt(c[1])-1, c[0]);

    if(check > from && check < to) {
        return true;
    }
    return false;
}

Calling method

var availability = dateCheck(startTheoryDate,endTheoryDate,currentDate);

And finally it returns boolean value weather it is true or false. 

Programming Related Solutions

Hello, friends if you have any programming languages topic related doubt you ask in the comment box and also you can comment on our youtube channel videos.

And Subscribe our youtube channel Programming Quest

Hit more like, share and subscribe on our channel programming quest