Codeigniter didn’t provide an option to use subqueries with active record class. So today I would like to provide simple and possible comprehensive techniques on…
4 CommentsAuthor: Praveen Anaparthi
11+ years of IT industry experience holding a wide range of skill sets and roles with significant work on PHP, Node.js, Python, Ruby, Docker, React.js, Microsoft Azure, Azure DevOps, Windows PowerShell, Shell script, Jenkins, MongoDB, SQL, MySQL, Apache, Nginx. etc. It is my passion to learn new things and implement them as a practice. Aside from work, I like gardening and spending time with pets.
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 Comments
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 Comment
Here the simple AngularJS tutorial on creating Cascading DropDownList with Angular JS. Country: Select States: Select City: Select
9 Comments
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…
1 Comment
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…
Leave a Comment
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…
Leave a Comment
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…
Leave a Comment
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…
Leave a Comment
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…
12 Comments
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…
1 Comment
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…
1 Comment
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…
Leave a Comment
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’,…
Leave a Comment
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…
Leave a Comment