bindParam() problem

Yii 1.1 General Discussion
1 



$tableTest = 'stock';

$sql       = 'SELECT * 

              FROM :tableName';

$command = Yii::app()->db->createCommand($sql);

$command->bindParam( ":tableName", $tableTest, PDO::PARAM_STR );

$model = $command->query();

I try to break down this error. I tried permutation with bindValue(). I also tried giving it to query() in parameter:




$command->query( array(":tableName"=>$tableTest) ); //still gives me the same error :/

config/main.php




'components'=>array( 

                'db'=>array(

			...

                        'emulatePrepare' => true,

		),

I would love someone’s insight :lol:

Thank you for your time.

2

i`m not sure but replace @tablename instead of :tablename

3

Turns out bindParam() surround the token with quotes like:


SELECT * FROM 'tableName'

which is not valid.

4

Aren’t you using this wrong? Isn’t that supposed to be used for binding values?

5

Yes he is using it wrong. See: http://php.net/manual/en/pdostatement.bindparam.php