Home » Archive by category "Technical Questions & Answers"

How to search a column name within all tables of a database

Search a column name within all tables of a database For example, You have a database named project and you have more than one table where project_id column is present, then you can find similar column name with all tables using following SQL query. select table_name,column_name from information_schema.columns where...
Continue reading »

How to Remove Duplicates in Excel

How to Remove Duplicate values in Excel Following method you can remove duplicate values in excel 1) Click on the Data set menu on Excel Sheet 2) On the Data tab, click Remove Duplicates   The below dialog box appears. 3. Leave all check boxes checked and click OK....
Continue reading »

How to restart PHP FPM?

How to restart PHP FPM? How to start or reload php fpm for nginx?   Stop PHP FPM command: service php-fpm stop Start PHP FPM command: service nginx start Restart PHP FPM command: service php-fpm restart Reload PHP FPM command: service php-fpm reload PHP-FPM command line Usage: /etc/init.d/php-fpm {start|stop|status|restart|reload|force-reload|condrestart|try-restart}
Continue reading »

What is Use of jQuery scrollTop() function ?

What is Use of  jQuery scrollTop() function ? The scrollTop() method sets or returns the vertical scrollbar position for the selected elements.When the scrollbar is on the top, the position is 0. jQuery function scrollTop() gives the distance between the top of the object and the topmost portion...
Continue reading »

How to Enable MySQL Remote Access on Ubuntu Server

Enable MySQL Remote Access on Ubuntu Server By default, MySQL only allows connections from the same machine (i.e. only from localhost). So if you only plan to access MySQL from an application that runs on the same machine, you are already good to go. However, I find it...
Continue reading »

How to set up wildcard Apache virtual host and a wildcard DNS

How to set up wildcard Apache virtual host and a wildcard DNS 1. Set up catchall vhost Enable Apache’s vhost_alias module: sudo a2enmod vhost_alias Create /etc/apache2/sites-available/catchall <VirtualHost *:80> ServerAlias localhost *.dev #wildcard catch all VirtualDocumentRoot /path/to/your/workspace/%1/public UseCanonicalName Off <Directory "path/to/your/workspace"> Options FollowSymLinks AllowOverride All Order allow,deny Allow from...
Continue reading »