We can achieve this in several way , but i would like to share this below approach because it is very simple,easy and more readable.…
1 CommentCategory: PHP / MySQL
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 Comments
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
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
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
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…
1 Comment
We generally use in_array function to check if an element is in array or not , but this function does not allow as to check…
3 Comments
In this Codeigniter tutorial, I will show you how to use Uplodify(HTML5 or Flash Multiple File Upload jQuery Plugin Script) in your CodeIgniter application. If…
22 Comments
In this CodeIgniter tutorial, I will show you how to fetch data from database using model, view, controller approach. As usual, we need need to…
45 Comments
In this post i will show you, how to find the location based on the ip of the client. We gonna use geoPlugin’s geolocation web…
Leave a Comment
In the beginning of career i used to write regular expression or long lines of code for validating and sanitizing the user submitted data(Ex:come from…
Leave a Comment