Yii query builder

Question

How build this query with YIi query builder

SELECT First_Name,User_ID,
FROM `Users`
WHERE First_name LIKE $_GET['name']

yiiframework.com/doc/guide/1.1/en/database.query-builder

adamors
– adamors

2012-12-04 12:38:12 +00:00
Commented Dec 4, 2012 at 12:38 — adamors
– adamors, Commented Dec 4, 2012 at 12:38

darkheir · Accepted Answer · 2012-12-04 13:39:22Z

6

As Örs said everything is in the Yii Guide!

$user = Yii::app()->db->createCommand()
    ->select('First_Name, User_ID')
    ->from('Users')
    ->where('First_name like :name', array(':name'=>$_GET['name']))
    ->queryRow();

answered Dec 4, 2012 at 13:39

darkheir

8,9806 gold badges47 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tuan Vu Anh · Accepted Answer · 2015-05-09 10:52:36Z

0

$cr = new CDbCriteria();
$cr->condition = "First_name LIKE '%:name%'";
$cr->params = array(':name'=>$_GET['name']);

$users = Users::model()->findAll($cr);

Another way

answered May 9, 2015 at 10:52

Tuan Vu Anh

1

1 Comment

Our Man in Bananas Over a year ago

Welcome to StackOverflow. Please add some explanation to your code, showing what it does and how it solves the problem posed in the question. This will help others who see your answer in the future

Collectives™ on Stack Overflow

Yii query builder

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related