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
samdark
(Alexander Makarov)
2
You forgot to add quotes around string value.
Hi samdark,
I didn’t get your answer. Where exactly I am missing.
Could you please rewrite it for me?
Thank you very much
samdark
(Alexander Makarov)
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();