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…
4 CommentsYear: 2014
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…
Leave a CommentHere the simple AngularJS tutorial on creating Cascading DropDownList with Angular JS. Country: Select States: Select City: Select
9 CommentsIn this post i would like to write about Angular JS ngClassOdd,ngClassEven directives , by using this directories we can take effect only on odd…
1 CommentBy default Xampp server is run on 80 port, if you want to change this port to something, just follow the below steps it is…
Leave a CommentWhile moving databases from development to production and vice versa it is sometimes necessary to export individual tables so that they can be imported into…
Leave a CommentSyntax 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…
Leave a CommentIndexes 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…
Leave a CommentThe 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…
12 CommentsRecently I tried to install YII2 but I got “The mcrypt PHP extension is not installed.” error. In this post, I will show you how…
1 CommentIn this post, I just want to show you how to return the response in JSON format in the correct way in ZF2. Returning JSON…
1 CommentHere 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…
Leave a CommentHere 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’,…
Leave a CommentGenerating 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…
1 Comment