Split Data Into Multiple Worksheets By Rows Count excel

The following VBA code can help you split the rows into multiple worksheets by rows count, do as follows: 1. Hold down the ALT + F11 key to open the Microsoft Visual Basic for Applications window. 2. Click Insert > Module, and paste the following code in the Module Window. Split data into sheets by rows count in Excel. 3. Then press F5 key […]

Joomla: Unknown column client_id in where clause

Problem: after update from 3.6.5 to 3.7.0, the modules menu shows the following error: Unknown column ‘client_id’ in ‘where clause   The solution is to use phpMyadmin and run these queries Replace `#_` by your db prefix

Send email with PHP

Send email with PHP from html form on submit Copy & Paste this into Contact.php

Both http and https

If we want http and https at the same time, there is no problem!  We write the following in wp-config.php  

Scroll to Section

Do you want to scroll down when button is clicked? Add the following code to your javascript and call the scrollnow(); function on button click do not forget to specify where to scroll by id #scrollHere

MySQL Update Category Count

Update Category Count after database transition in WordPress via SQL query Run the following script in your WP database

JQuery Load more

Simple Load More Trick…   Add this in html: Add this in css: Add this in <script> tags:

Basic Dev Start Setup

Starting from scratch in a new Windows machine. Some of  “must have” tools. Visual Studio Code Sql Server Dev SQL Server Management Studio (SSMS) Navicat Browsers: Chrome – Firefox Chrome Plugins Postman EditThisCookie Colorzilla Filezilla Office Git Sourcetree 7zip Putty Winscp Notepad++ Fiddler X-lite Skype TeamViewer 11 VMware vSphere Client   These are some of […]