Posts Tagged “query”

SQL

MySQL Sorting Persian Data

Feb 14, 2016

Introduction: When sorting Persian data in mysql, Persian letters (گ,چ,پ,ژ) are not placed in the right order and they will appear after other letters...

Yii 2.x

Yii 2.0 rollBack()

Mar 3, 2015

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...

Yii 2.x

Yii 2.0 db createCommand()

Feb 24, 2015

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...

Yii 2.x

Yii 2.0 Using Subqueries

Feb 23, 2015

In this post I want to show you how to use subqueries in your conditions.

Yii 2.x

Model - View - Controller

Feb 22, 2015

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...

SQL

Fetching Records from Database

Feb 21, 2015

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...

Yii 2.x

Yii 2.0 find (SELECT)

Feb 20, 2015

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...

SQL

Pagination, OFFSET, LIMIT

Feb 16, 2015

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...