Zend Framework 2 Advanced database operations ?
In this post, I would like to list basic to advanced database queries using ZF2. I am gonna use TableGateway methods here. Simple Select Query
Increase MySQL Connections Limit
Recently i got “too many connections” errors in MySQL, after quick research i found a solution to fix this issue.This issue due to connection limit
Dependent Dropdown List with AngularJS
Here the simple AngularJS tutorial on creating Cascading DropDownList with Angular JS. Country: Select States: Select City: Select I hope you like this Post, Please
How to assign alternate class to rows in Angular JS?
In this post i would like to write about Angular JS ngClassOdd,ngClassEven directives , by using this directories we can take effect only on odd
How to Change port in XAMPP
By default Xampp server is run on 80 port, if you want to change this port to something, just follow the below steps it is
Export and Import an Individual MySQL Table from command line
While moving databases from development to production and vice versa it is sometimes necessary to export individual tables so that they can be imported into
MySQL copy table to another database
Syntax to copy one existent MySQL table from one database to another database: CREATE TABLE `new_database`.`table` SELECT * FROM `old_database`.`table`; Syntax to copy one existent
Create Index in the MySQL Table
Indexes allow the database application to find data fast, without reading the whole table.The CREATE INDEX statement is used to create indexes in tables. CREATE
How to install Intl extension in Xampp ?
The PHP Internationalization extension is used in almost all modern frameworks. The extension is useful for formatting currency, number, and date/time as well as UCA-conformant
YII – The mcrypt PHP extension is not installed.
Recently I tried to install YII2 but I got “The mcrypt PHP extension is not installed.” error. In this post, I will show you how
How to return JSON response in Zend framework 2
In this post, I just want to show you how to return the response in JSON format in the correct way in ZF2. Returning JSON
Detect Current Mouse Coordinates using JQuery
Here is the simple JQuery script snippet for detecting current mouse coordinates using JQuery function. $(document).mousemove(function(e){ console.log("X = " + e.pageX + " and Y
How to detect robots and spiders with PHP?
Here is the simple function for detecting spiders and robots. It will return true or false. function is_bot(){ $bots = array( 'Googlebot', 'Baiduspider', 'ia_archiver', 'R6_FeedFetcher',
Embed YouTube video in Powerpoint
Generally, you can easily embed a youtube video into your powerpoint presentation but unfortunately, iframe style embed is not working correctly, so if you want
How to generate random string PHP
Generating random strings can be very useful in lot of cases.It might be for a verification code or a password etc. Below is the simple