Show Record

Yii 1.1 General Discussion
1

Hi

This is my sample code

<?php echo $form->textField($model,‘LastName’);?>

How Show records getting from Db and show on Text filed

2

In your controller,


$model = YourClass::model()-> find();

Modify that with your requirements.

Now, in view, your code should show the value of Lastname.

3

thanks for your reply…Don’t mistake me i can’t get idea

View page

<?php

$form=$this->beginWidget(‘CActiveForm’,array(

					 'id'=&gt;'student-form',


					 'enableClientValidation'=&gt;true,


					 'clientOptions'=&gt;array(


					 'validateOnSubmit'=&gt;true),


					 ) );

?>

&lt;table width=&quot;100&quot; border=&quot;1&quot;&gt;


&lt;tr&gt;


&lt;td&gt;&lt;?=&#036;form-&gt;labelEx(&#036;model,'UID');?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;form-&gt;textField(&#036;model,'UID');?&gt;&lt;/td&gt;    


&lt;td&gt;&lt;?php echo &#036;form-&gt;labelEx(&#036;model,'UserName');?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;form-&gt;textField(&#036;model,'UserName');?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;form-&gt;labelEx(&#036;model,'type');?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;form-&gt;dropDownList(&#036;model,'type',array('2'=&gt;'AND','1'=&gt;'OR'));?&gt;&lt;/td&gt;


&lt;/tr&gt;


&lt;tr&gt;


&lt;td&gt;&lt;?php echo &#036;form-&gt;labelEx(&#036;model,'Name');?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;form-&gt;textField(&#036;model,'Name');?&gt;&lt;/td&gt;    


&lt;td&gt;&lt;?php echo &#036;form-&gt;labelEx(&#036;model,'Mobile');?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;form-&gt;textField(&#036;model,'Mobile');?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;form-&gt;labelEx(&#036;model,'Email');?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;form-&gt;textField(&#036;model,'Email');?&gt;&lt;/td&gt;


&lt;/tr&gt;


&lt;tr&gt;


&lt;td&gt;&lt;/td&gt;


 &lt;td&gt;&lt;/td&gt;


  &lt;td&gt;&lt;/td&gt;


   &lt;td&gt;&lt;/td&gt;


    &lt;td&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo CHtml::submitButton('Search');?&gt;&lt;/td&gt;





&lt;/tr&gt;


&lt;/table&gt;

<table width="100%" border="0" cellspacing="1" cellpadding="0" id="example">

&lt;thead&gt;&lt;tr&gt;


    &lt;th&gt;Edit&lt;/th&gt;


    &lt;th&gt;UID&lt;/th&gt;


    &lt;th&gt;Name&lt;/th&gt;


    &lt;th&gt;Gender&lt;/th&gt;


    &lt;th&gt;Contact&lt;/th&gt;


    &lt;th&gt;Email Id&lt;/th&gt;


    &lt;th&gt;Ishanga&lt;/th&gt;


    &lt;th&gt;Verify&lt;/th&gt;





&lt;/tr&gt;


&lt;/thead&gt;


&lt;tbody&gt;


&lt;?php 


if(&#33;empty(&#036;rows))


foreach(&#036;rows as &#036;row){ ?&gt;


&lt;tr&gt;


&lt;td&gt;


&lt;?php //echo &#036;form-&gt;hiddenField(&#036;model,'HeaderCode');





	//echo CHtml::submitButton('Edit',array('title'=&gt;&quot;View&quot;,'onclick'=&gt;'js:editTest();'));


 &#036;id = &#036;row['Header_Code']; ?&gt;





&lt;?php echo CHtml::button('Edit', array('name'=&gt;'demandeVersement','onclick'=&gt;&quot;js:editTest(&#036;id);&quot;)


);?&gt;








&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;row['IVC_Code'];?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;row['Name'];?&gt;&lt;/td&gt;	


&lt;td&gt;&lt;?php if(&#036;row['Gender'] == 0)echo 'Female'; elseif(&#036;row['Gender'] == 1) echo 'Male';?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;row['Contact1'];?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;row['Emailid'];?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;row['Category'];?&gt;&lt;/td&gt;


&lt;td&gt;&lt;?php echo &#036;row['verify'];?&gt;&lt;/td&gt;


	


	&lt;/tr&gt;


    &lt;?php }?&gt;


&lt;/tbody&gt;

</table>

Model Page

public function Singleview($head)

 {





  &#036;connection = Yii::app()-&gt;db;


    &#036;sql = &quot;[sp_IvcView] :Header_Code&quot;;


    &#036;command = &#036;connection-&gt;createCommand(&#036;sql);


	&#036;command-&gt;bindParam(&quot;:Header_Code&quot;, 	 &#036;head,       PDO::PARAM_INT);


	&#036;rows = &#036;command-&gt;queryAll();	


	return &#036;rows;


 }

Controller page

public function actionIvcview()


{





	&#036;view = new Searchishanga();


	&#036;model = new ViewTest();


		


	&#036;head = &#036;_GET['headerCode'];		


	//&#036;rows = &#036;views-&gt;Singleview(&#036;head);		


		&#036;rows = &#036;view-&gt;Singleview(&#036;head);			


	


	&#036;this-&gt;render('Singleview',array('model'=&gt; &#036;model,'rows'=&gt; &#036;rows));


}

Not working properly

help once