Posts Tagged “sql”

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.

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

Yii 2.x

Yii 2.0 Pagination

Feb 15, 2015

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

Yii 2.x

Yii 2.0 hasMany

Feb 14, 2015

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