1. Home
2. php - Yii 1.1 How to get raw query from queryBuilder

341 votes

1 answers

php - Yii 1.1 How to get raw query from queryBuilder

Get the solution ↓↓↓

I have YII PHP code below:

   $query = Yii::app()->db->createCommand()->select('id,email')
        ->from('users')
        ->where('id=:id', array(':id'=>2))
        ->getText();
    echo "<pre>"; print_r($query); echo "</pre>"; exit;
Copy code

Output:

SELECT `id`, `email`
FROM `users`
WHERE id=:id
Copy code

Expected Result:

SELECT `id`, `email`
FROM `users`
WHERE id=2
Copy code

Please help

Undefined asked

2021-09-9

Write your answer

---

691

votes

Answer

Solution:

I think you can try this way:

$query = Yii::app()->db->createCommand()->select('id,email')
        ->from('users')
        ->where('id=:id', array(':id'=>2))
        ->getText();
var_dump($query->params);
var_dump($query->text);
Copy code

If there are any parameters to be bound to the query, they can be retrieved via the CDbCommand::params property.

Check please the documentation

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-09-9

Link To Source
Link To Answer People are also looking for solutions of the problem: unable to determine current zabbix database version: the table "dbversion" was not found.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

70 php - In a Twig template {{0 in ['a', 'b', '99']}} returns 1. WHY?

148 Get php results with jquery ajax

390 php - Filter content from mysql db with checkboxes using jQuery?

648 How to check whether $_GET['id'] is set and it's not empty using php

12 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

52 php - How to json_decode an json array received from JavaScript?

312 linux - Safest way to write into /etc from php application?

347 PHP classes are keeping me from accessing the needed variable

669 php - How to retrieve response headers after an Ajax request with jQuery based on lastinsertid?

855 php - Save data to two different tables in CakePHP 3

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

Yii

Yii is a simple yet high performance generic component framework based framework. It is known for its high performance, but above all, it is famous for its simplicity. This framework appeared in December 2008. It allows you to use third-party code, and its Gii code generator allows you to quickly create basic structures from which you can build your own solutions.
https://www.yiiframework.com/