How to use a SQL request with YII framework

Question

I am new with YII framework so, sorry for my beginner level.

I want to know how to insert a SQL request inside this framework ?

Like

SELECT *
FROM tab_a as a, tab_b as b
WHERE a.id=b.id

TBI · Accepted Answer · 2014-06-30 15:05:27Z

1

Try this -

$connection = Yii::app()->db;
$command = $connection->createCommand("SLECT * FROM tab_a as a, tab_b as b WHERE a.id=b.id");
$row = $command->queryRow();

answered Jun 30, 2014 at 15:05

TBI

2,8091 gold badge19 silver badges22 bronze badges

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

2 Comments

Test404 Over a year ago

Sorry I use this inside the controler code or view code ?

TBI Over a year ago

You can use inside the controller if you want to render the records otherwise use in view.

Collectives™ on Stack Overflow

How to use a SQL request with YII framework

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related