Technoknol

SubQuery in Doctrine 2.x using getDQL()

<?php $queryBuilder = $this->entityManager->createQueryBuilder(); $queryBuilder2 = $this->entityManager->createQueryBuilder(); $subQuery = $queryBuilder2->select('COUNT(fr.status)') ->from(FeedbackRequest::class, 'fr') ->where('fr.giverId = iu.userId') ->groupBy('fr.status') $Query = $queryBuilder->select('iu') ->addSelect("(".$subQuery->getDQL().") statusCount") ->from(InstitutionUser::class,…

[Fixed] Firebase not working on Safari on iOS

As Push API doesn’t support on Safari, so your FCM config will fail and will return an error or blank page especially on React.js app. To fix that we can check if notifications are supported or not and if not then we will try to fake messaging object. Check the below snippet and change your code accordingly.

Setup Websockets with Apache Reverse Proxy with SSL

I’ve scratched my head for hours and finally I was able to set it up and make it running.

So my tech stack was .NET Core app for API on docker, SignalR for socket and Apache as a reverse proxy. Everything was working without Reverse Proxy and SSL.

As soon as I’ve setup SSL and reverse proxy, websockets stopped working. So here below is a VirtualHost configuration that I’ve used to forward…

Laravel migration Error – Specified key was too long

As seen above in image, this issue you may have faced many a times. That’s why you’re on this page. This is a nasty error that says (1071 Specified key was too long) and your migration fails. You need to delete entry from migration table and also delete a table sometimes.

This is because of changes in Laravel 5.4, which uses default character set of database as utf8mb4. Which will allow to…

Laravel - Log Guzzle requests to file - Log Guzzle requests the best way using Laravel's Service Container. It's very easy method to make your code looks cleaner and it's re-usable too.

You may have faced this scenario many times, where you are calling an third party API from postman. It’s working but not working when you call it from Guzzle. And wanted to Log Guzzle requests in a file or a database.

You must be aware of what Guzzle is, if you don’t : Guzzle is a PHP HTTP client that makes it easy to send HTTP requests and trivial to integrate with web services.

Source:

Laravel – Override Eloquent Model’s default table name

For one of my client’s project I needed to use wordpress’s users table wp_users in Laravel’s User model. Because client wanted to use one database for WordPress and Laravel both. So I was forced to override eloquent model’s default table and use mine.

So suppose you have to use existing database, and you have my_citiestable. But you can’t afford to rename your table. So easiest way is…

How to set Redis Password in Windows/Ubuntu

Set password in Redis

To set a password in redis is very easy than any other database. You just need to edit one conf file or fire a command from redis-cli and you’re good to go. Follow the steps below according to your operating system.

Windows

Okay, I lied to you that there’s one file to edit. But actually in windows you may have to edit 2 files based on how are you using redis.

Usin…

Best Javascript books and resources to Learn

JI’ve been asked this question multiple times, by my juniors, colleagues and friends. So I decided to publish a list of resources that I have used and I love.  So following is a curated list of all the JavaScript books are resources that I feel will very helpful to you.

Books

JavaScript: The Good Parts  – By Douglas Crokford (Founder of JSON)

Eloquent JavaScript (FREE) – By Marijn Haverbeke…

How to Send test mail in Laravel via Terminal/Tinker

Just a small piece of code to test your mail settings and fire a test mail right from your terminal. I needed this when changing configuration in .env file to check different settings. But everytime changing setting and then running your piece of code which sends mail is kind of boring and lengthy. Instead just change config, fire a command is quick to test your settings. So I did it via Tinker…

Laravel – How to override vendor class file?

As a Laravel developer you might have faced situation where you don’t like some code in a package in vendor folder, and you wanted to change it. And you can change that directly in that file. But the issue is when you hit composer update command.

So what’s the solution?

Thanks to composer guys that it has functionality to override any/package classes. Composer uses PSR-4to load classes. So in…

[Solved] Hacker Rank – Birthday Cake Candles

Problem

Solution

Solution on Github

Is this THE END of World (Torrent)?

By reading news and comments on internet and found that many users are upset due to voluntarily or by force torrent giants are falling one by one by one, like an army.

  First kickass torrents allegedly owner was arrested on 20 July 2016 and US Department of Justice had seized the main domain (kat.cr).

Then thepiratebay had ceased it’s operation, (eventually it’s up again now).

And now the…

CodeIgniter : Dynamic Database Query Caching

Purpose: This article is intended to show you how you can disable query caching for particular methods and enable it globally for all methods.

In CodeIgniter there is default option for query caching. If you enable query caching in database.php, by passing $db['default']['cache_on'] = TRUE; It will enable query caching for all controllers.

You might be thinking that there are already defined…

Theme Options Z: My second Plugin is out !

Just another powerful Theme Options Plugin.

After months of hard work My second plugin Theme Options Z is ready for use. Let’s talk something about it.

Checkout my first plugin WP admin todo list, easily manage your tasks right from WordPress admin.

From Where I get Idea

During developing themes for clients I needed to use Options.php for custom options to allow clients to change it’s value…

Save image to Imgur from Nimbus Extension in Google Chrome

During development everytime I take a screenshot via Nimbus Extension and edit it. Then to upload images to imgur.com I have to open imgur.com in new tab then copy image and paste to it, and upload. To get rid of this lengthy process I decided to create something that will make this whole process easier and faster.

  I was thinking to develop new Google Chrome extension but due to lack of time I…

Solved:Some add-ons have been disabled -Firefox issue

After updating Firefox I saw button “some extensions could not be verified” on add-ons page with title “Some add-ons have been disabled”, and found that some of my add-ons disabled. This thing starts from Firefox version 41, If Mozilla has not signed the extension, Firefox will auto-disable it.

Introducing Extension Signing: A Safer Add-on Experience

First time they started in Firefox version 40…

Cryptowall 4.0 : Save your Ass (Prevention tips)

What this (Cryptowall 4.0) shit is ?

This is new Ransomware in family of Cryptowall. This is bullsh*t ransomware that leaves no option to move for victim.

What it does ?

It does encrypt all your files, with file names (Yeah! that’s scary). It confuses victims.

“Cryptowall 4.0 still includes advanced malware dropper mechanisms to avoid antivirus detection, but this new version possesses vastly…