Problem in executing SQL Query

Yii 1.1 General Discussion
1

Hi,

I am trying to execute the following query.




$sum="abc123";

$results = Yii::app()->db->createCommand('SELECT nano_pass FROM nano_invite where nano_pass='.$sum)->queryScalar();

echo $results;

For this I am getting the following error

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘abc123’ in ‘where clause’

Thank you,

Taraka

2

You forgot to add quotes around string value.

3

Hi samdark,

I didn’t get your answer. Where exactly I am missing.

Could you please rewrite it for me?

Thank you very much

4

The proper safe way is:




$sum="abc123";

$command = Yii::app()->db->createCommand('SELECT nano_pass FROM nano_invite where nano_pass=:sum');

$command->bindValue(':sum', $sun);

$nanoPass = $command->queryScalar();
5

Thank you very much.

Its working fine.