Page 1 of 1
Select In Yii
#1
Posted 06 February 2013 - 03:59 AM
hi all ,i tried to get the result from the table MAIL using the below query ,but it gets displayed as a array ,how can i get it?
$connection=Yii::app()->db;
$sql = "SELECT Receiver from mail";
$command=$connection->createCommand($sql);
print_r($command->queryRow());
$connection=Yii::app()->db;
$sql = "SELECT Receiver from mail";
$command=$connection->createCommand($sql);
print_r($command->queryRow());
#3
Posted 06 February 2013 - 04:43 AM
redguy, on 06 February 2013 - 04:17 AM, said:
use queryScalar() instead of queryRow()
Thank you

One more help,if i select * from mail what can i use instead queryScalar?
$connection=Yii::app()->db;
$sql = "SELECT * from mail";
$command=$connection->createCommand($sql);
print_r($command->queryScalar());
#5
Posted 07 February 2013 - 03:49 AM
fouss, on 06 February 2013 - 05:15 AM, said:
queryAll()
<?php
echo'Only First Row'. "</br>";
echo '-----------'. "</br>";
$connection=Yii::app()->db;
$sql = "SELECT * from mail";
$command=$connection->createCommand($sql);
print_r($command->queryAll());
echo "</br>";?>
</p>
had tried this,but gets the result as
Array ( [0] => Array ( [E_Id] => xx@gmail.com [Receiver] => david) )
i need the values alone to be displayed,can u help?

#6
Posted 07 February 2013 - 04:29 AM
Try this my fiend!
echo'Only First Row'. "</br>"; echo '-----------'. "</br>"; $connection=Yii::app()->db; $sql = "SELECT * from mail"; $command=$connection->createCommand($sql); foreach ($command->queryAll()as $value) { echo $value['E_id'].' '.$value['Receiver'].'</br>'; }

#7
Posted 07 February 2013 - 05:05 AM
fouss, on 07 February 2013 - 04:29 AM, said:
Try this my fiend!
echo'Only First Row'. "</br>"; echo '-----------'. "</br>"; $connection=Yii::app()->db; $sql = "SELECT * from mail"; $command=$connection->createCommand($sql); foreach ($command->queryAll()as $value) { echo $value['E_id'].' '.$value['Receiver'].'</br>'; }
Thanks a lot

Share this topic:
Page 1 of 1