Wyciągam dane z bazy takim zapytaniem:
$sql = "SELECT id, username, password FROM users u WHERE username='marek'";
$model = self::findBySql($sql)->all();
foreach($model as $post) {
die("User = |{$post->username}|");
}
zmienna $post->username jest pusta
die(var_dump($model)) wyciąga dane w postaci jak poniżej czyli samo zapytanie zwraca dane tylko nie mogę wyciągnąć konkretnej danej
Czy ktoś ma pomysł co źle robię?
array(2) {
[0]=> object(app\models\User)#75 (13)
{ ["id"]=> NULL ["username"]=> NULL ["password"]=> NULL ["authKey"]=> NULL ["accessToken"]=> NULL ["_attributes":"yii\db\BaseActiveRecord":private]=> array(3)
{ ["id"]=> int(1) ["username"]=> string(5) "marek" ["password"]=> string(5) "marek" } ["_oldAttributes":"yii\db\BaseActiveRecord":private]=> array(3)
{ ["id"]=> int(1) ["username"]=> string(5) "marek" ["password"]=> string(5) "marek" } ["_related":"yii\db\BaseActiveRecord":private]=> array(0)
{ }
["_errors":"yii\base\Model":private]=> NULL ["_validators":"yii\base\Model":private]=> NULL
["_scenario":"yii\base\Model":private]=> string(7) "default" ["_events":"yii\base\Component":private]=> array(0)
{ } ["_behaviors":"yii\base\Component":private]=> array(0) { } }
[1]=> object(app\models\User)#90 (13)
{ ["id"]=> NULL ["username"]=> NULL ["password"]=> NULL ["authKey"]=> NULL ["accessToken"]=> NULL ["_attributes":"yii\db\BaseActiveRecord":private]=> array(3)
{ ["id"]=> int(2) ["username"]=> string(5) "marek" ["password"]=> string(5) "xxxxx" } ["_oldAttributes":"yii\db\BaseActiveRecord":private]=> array(3)
{ ["id"]=> int(2) ["username"]=> string(5) "marek" ["password"]=> string(5) "xxxxx" } ["_related":"yii\db\BaseActiveRecord":private]=> array(0)
{ }
["_errors":"yii\base\Model":private]=> NULL ["_validators":"yii\base\Model":private]=> NULL ["_scenario":"yii\base\Model":private]=> string(7) "default"
["_events":"yii\base\Component":private]=> array(0) { }
["_behaviors":"yii\base\Component":private]=> array(0) { } }
}