Display column name

Yii 1.1 General Discussion
1

Friend,

I would like to display some of column (table field) name in view part.

Can you suggest me any idea, on it?

Thank you for your help :)

2

I dont really get what you want, but here some suggestions

to get models metadata ( info about table) you could use


$model->getMetadata();

to get info about its columns


$model->getMetaData()->columns

but I think what you are looking for is


$model->attributes

try to print_r its content and see if it is what you are looking for

3

Thank Gustavo for suggestion.

I will display what I have done in view part (index.php)




foreach(Yii::app()->db->schema->getTable('tbl_contactinfo')->columns as $key=>$val) {


 		echo $form->label($model,$key);

		echo $form->hiddenField($modelContactInfo,$key);

		echo CHtml::dropDownList('privacyStatus','', $model->getStatusOptions(),

			array(

		      	'ajax' => array(

				'type'=>'POST', //request type

				'url'=>CController::createUrl('status'), //url to call.				

			))); 

		

}

It displays all the columns of the particular table ‘say tbl_contactinfo’. But my requirement is to get just few columns instead of all.

4

which ones?

5

I didn’t get what you mean Which one?

6

What do you mean by "a few columns not all " ??

I dont actually get

7

Oh!

support the table ‘tbl_contactinfo’ has 6 fields[color=#008800][font=monospace][size=2] [/size][/font][/color]The above code will display all the columns. I just need to display only 3 columns out of 6.

8 



$columns=Yii::app()->db->schema->getTable('tbl_contactinfo')->columns;

foreach(array_slice($columns,0,3) as $columns){

 //code

}

that will solve it

or you could use a counter and break the loop, like




$counter=0;

foreach(Yii::app()->db->schema->getTable('tbl_contactinfo')->columns as $columns){

 //code

 $counter++;

if($counter===2)

   break;

}
9

But the populate of columns are in random. The column display can be : column1, column3, column5.

10

It actually is ordered exactly like the table, here I’m using Mysql

Do you want in order or which ones do you want ? 3 random or 3 first ?

if 3 random fields use




foreach(shuffle($column) as $columns){

//code

}
11

Gustavo, thank you for your support. cheers :)

12

Glad I could help

Cheers