How to get week dates from week number and year

In this tutorial I will show you how to get week dates from week number and year. We will calculate ISO week number (1-53) and represent the start of the week “Monday”. There is a setISODate() method with DateTime extension that accepts the year (4-digit year) and ISO week number. Example of get week dates from week number and year The output of above code is following:  

Copy data from one column to another column in MySQL

In this tutorial I will show you how to copy data from one column to another column in same table in MySQL. There is a simple query to update record from one to another column in MySql. Most of the time we just need to copy a particular record from one table to another but sometime we need to copy the whole column values to another column in same table. …

Continue reading

How to capture screenshot of website from URL in PHP

In this tutorial, I will show you how to capture screenshot of any website from URL in PHP. There are so many third party APIs are available to capture screenshot of the website using PHP script. In the following example, I am using Google API to capture screenshot from given url. You can easily capture the screenshot using Google APIs. There are many reason to capture screenshot of website to …

Continue reading

Main differences between InnoDB and MyISAM

Most commonly used storage engine in MySQL are MyISAM and InnoDB. The default storage engine chosen by MySQL database is MyISAM. There are some advantages and disadvantages of these storage engine according to application needs. Main differences between InnoDB and MyISAM MyISAM does not support transactions by tables while InnoDB supports. InnoDB does not support FULLTEXT index while MyISAM supports. Performance speed of MyISAM table is much higher as compared …

Continue reading

How to get the Widget ID in WordPress

If you are customizing the WordPress theme or working on your own theme, you might need a widget ID to make everything work like you want. For example, if you want to hide the widget on a specific page, you will need to provide a widget ID to make the code work. In this tutorial, we will show you how to get the widget ID in WordPress. Get the widget …

Continue reading

How to Remove Special Character from String in PHP

In this tutorial I will show you how to remove special character from string in PHP. Sometimes we need to remove all special characters by using preg_replace from input string. There are two option available to remove special character from string using php. Option 1: Using preg_replace PHP Function We can remove special character from sting using preg_replace, it’s using regular expression to special character from string. Syntax of preg_replace …

Continue reading

How to Remove Duplicates from Multidimensional Array

In this tutorial I will show you how to remove duplicates from multidimensional array in PHP. array_unique() function works on single dimensional array not on multidimensional arrays. After googling I have found a way to get unique multidimensional array using serialization of array. Serialization is used to storing or passing PHP values around without losing their type and structure. Steps to remove duplicates from multidimensional array 1. We will use …

Continue reading