Yii2 : Retrieve multiple result set from stored procedure

Recently got chance to work on one Yii2 project, and where I encounter the situation where need to fetched multiple result set from stored procedure. I'm not experienced in Yii framework, so it was difficult to achieve easily. I googled but didn't get any proper solutions; So after some search and R&D, I achieve this …

PHP + SFTP : How to connect SFTP Server using PHP (WAMP)? (upload or download files)

In one of my project, we came to the situation where needed to move/copy and download files to/from SFTP (SSH File Transfer Protocol or Secure File Transfer Protocol) server. That was first time when we were worked with SFTP server, So we started with google and after some trial & error we found that its simple …

PHP + SSH2 : How to enable SSH2 extension in PHP (WAMP)?

To connect SFTP (SSH File Transfer Protocol or Secure File Transfer Protocol) server from PHP (WAMP SERVER), first we have to enable SSH2 extension which is not available (by default) with WAMP server. When I start with this, I got multiple solutions from google and it takes much time to find exact workable one. So …

Asp.Net MVC : Handle Session Timeout in Ajax Request

While developing Asp.net MVC application, everyone come to the common situation where search begin for the solution and that's one is - "How to handle session timeout in Ajax request?" Authentication and Authorizations are the key points of any web applications when we are managing user and their roles. Whenever there is a user ideal …

JavaScript : Not allowed to navigate top frame to data URL (Chrome)

Last week, In one of my project, Tester report a issue for preview/download Image, PDF or Docs in chrome which was working fine previously. Basically we use base64 string URL to preview documents from long time, but suddenly the code stopped working. After check inspect elements, We found one JavaScript error which was the main …

MySQL: CONCAT, CONCAT_WS & GROUP_CONCAT functions

Concatenation is the basic operation in MySql when we are working string columns. With respect to string concatenation, MySql provides three types of functions, CONCAT, CONCAT_WS and GROUP_CONCAT. CONCAT: Just Concatenate all provided argument values. mysql>SELECT CONCAT('I', 'Am', 'Software', 'Developer'); //Result: IAmSoftwareDeveloper CONCAT_WS: Stand for Concatenate with Separator and Concatenate all arguments using provided special …

Html + JavaScript: How to create a multi-language/Localize/Internationalize website in HTML5?

Today one of the best ways to target a large audience on the website is, the website needs to be compatible with multiple languages. Many server-side development languages have a built-in mechanism like CakePHP, ASP.Net and More. But what will be the case if someone has only knowledge of HTML and want to develop a multi-language application? …

MySQL: DATE vs DATETIME vs TIMESTAMP

Many times while working with MySQL date-time column, one confusion or question come to our mind and that's,       Which data type should I use DATETIME or TIMESTAMP, as both stores the same data? First, Let's take a look over all three date-related data types available in MySQL - DATE : Value: Having …

MySQL: DateTime; How to? Questions and Answers

In day to day working, Many times I'm used to google for many MySQL date-time related functions/queries. below are some of them and many more will be added to these in future. Please comments, if anyone has a better way for any of the HOW questions? and If anyone has any additional question, ask in …

JavaScript: Automatically Logout from all Open Tabs When User Logout in One of them

In a web application, When the user opens the application in multiple tabs and then log out from one of them, Current tab refreshed and shows the Login page. But what about other open tabs? Open tabs still showing last opened page, because those tabs don't know if User session terminated or not. In this …