All Posts
Python Virtual Environment
In this post I want to talk about virtual environments in Python and why we need them. This is especially important if you are using Python to impleme...
Continue reading
MongoDB Indexes - Part 2
This is part two of a two-part series on MongoDB indexes. In my previous post, I talked about what indexes are, how they can help us, and some types o...
Continue readingMongoDB Indexes - Part 1
In this post, I will try to explain what indexes in MongoDB are and how they help you improve the performance of your application. We will be talking ...
Continue readingMongoDB One-to-Many and Many-to-Many (Basics)
In my previous post I talked about sub-documents. If you are here, this means you have a compelling reason not to use sub-documents (probably reasons ...
Continue readingMongoDB sub-documents (Basics)
As we all know, MongoDB is a document-oriented database which is a NoSQL database. One of the great features of MongoDB is supporting sub-documents. I...
Continue reading
MySQL Sorting Persian Data
Introduction: When sorting Persian data in mysql, Persian letters (گ,چ,پ,ژ) are not placed in the right order and they will appear after other letters...
Continue reading
Yii 2.0 Cron Job
In this post I want to teach you how to add a cron job to your Yii 2.0 project. What is a Cron Job? Cron Jobs are scheduled jobs.
Continue readingYii 2.0 Ajax
In this post I want to talk about using ajax in Yii 2.0. I assume you all know what ajax is and how to use an ajax request.
Continue readingYii 2.0 rollBack()
In this post I want to talk about rollBack() and how to use this function. What is rollBack()? Imagine you have a table called 'Product' and a table c...
Continue readingYii 2.0 XSS filtering
In this article I want to talk about XSS filtering in Yii 2.0. What is XSS? XSS or cross-site scripting happens whenoutput isn't escaped properly when...
Continue readingYii 2.0 Writing Widgets
In this post I want to teach you how to write a widget in Yii 2.0. Why do we need to add widgets to our projects? Well, sometime you want to have a sp...
Continue readingYii 2.0 Writing Components
In this post I want to teach you how to write components in Yii 2.0 Why do we need to write components? As an example, I can say, imagine you want to ...
Continue readingYii 2.0 db createCommand()
In this post I want to talk about db createCommand() and using it to fetch records instead of find(). So far you have learnt how to use find() and usi...
Continue readingYii 2.0 Using Subqueries
In this post I want to show you how to use subqueries in your conditions.
Continue reading
Model - View - Controller
In this post I want to talk about MVC architecture. When working with frameworks you can see that there are lots of frameworks which are using this pa...
Continue reading
Fetching Records from Database
In this post I want to talk about fetching records from your database using SQL Syntax. As always, let's start with an example. Imagine we have one ta...
Continue readingYii 2.0 find (SELECT)
In this post I want to talk about selecting (fetching) records from database. NOTE: When you want to download Yii 2.0, you can see that Yii 2.0 is not...
Continue readingYii 2.0 urlManager
In this post I want to talk about urlManager in Yii 2.0 and how to create cleaner, and friendlier urls. For those of you who have worked with Yii 1.x,...
Continue reading
Pagination, OFFSET, LIMIT
In this post I want to talk about LIMIT and OFFSET and how to use them, to paginate your results when you are developing a website. Let's start with a...
Continue readingYii 2.0 Pagination
In this post I want to show you how to use pagination when your are fetching a large amount of data from your database. We all know that showing our u...
Continue readingYii 2.0 hasMany
In our last post, you learned how to join two tables using joinWith() and using hasOne when declaring your relation. In this post I want to tell you t...
Continue reading