Delete button in CGrid view in Yii

Mohammed_iqbalkhan · August 24, 2015, 12:04pm

I tried to create a Delete button in CButtonColumn,The problem is when I triggered the delete,It shows me an error Your request is invalid…Can anyone tell me why this is happening…

My controller

public function actionDelete($id)

{


    &#036;this-&gt;loadModel(&#036;id)-&gt;delete();





    // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser


    if(&#33;isset(&#036;_GET['ajax']))


        &#036;this-&gt;redirect(isset(&#036;_POST['returnUrl']) ? &#036;_POST['returnUrl'] : array('admin'));


}

And my view

&lt;?php &#036;this-&gt;widget('zii.widgets.grid.CGridView', array(


'id'=&gt;'replay-comment-grid',


'dataProvider'=&gt;&#036;model-&gt;search(),


// 'filter'=&gt;&#036;model,


'columns'=&gt;array(


    //'id',


    //'comment_id',


    'admin_replay',


    array(


            'class' =&gt; 'CButtonColumn',


            'htmlOptions'=&gt;array('width'=&gt;'180px'),


            'template' =&gt; '{view}&amp;nbsp;{update}&amp;nbsp;{delete}',


            'buttons' =&gt; array(


                    'view'=&gt;array(


                        'imageUrl' =&gt;false,


                        'label' =&gt; 'View', 


                        'url'=&gt;'Yii::app()-&gt;createUrl(&quot;replayComment/view/&#036;data-&gt;id&quot;)',


                        'options' =&gt; array('title'=&gt;'view','class'=&gt;'btn btn-success btn-xs'),


                    ),


                    'update'=&gt;array(


                        'imageUrl' =&gt;false,


                        'label' =&gt; '',


                        'url'=&gt;'Yii::app()-&gt;createUrl(&quot;replayComment/update/&#036;data-&gt;id&quot;)',


                        'options' =&gt; array('title'=&gt;'update','class'=&gt;'btn btn-info btn-xs fa fa-pencil-square-o'),


                            ),    


                    'delete'=&gt;array(


                        'imageUrl' =&gt;false,


                        'label' =&gt; 'delete', 


                        'url'=&gt;'Yii::app()-&gt;createUrl(&quot;replayComment/delete/&#036;data-&gt;id&quot;)',


                        'options' =&gt; array('title'=&gt;'delete','class'=&gt;'btn btn-danger btn-xs'),


                    ),                                  


            )


        ),


),


'itemsCssClass'=&gt;'table table-striped table-bordered table-hover',


    'pagerCssClass'=&gt;'pagination', 


    'pager'=&gt;array( 'header' =&gt; '','lastPageLabel'=&gt;'&lt;span class=&quot;glyphicon glyphicon-chevron-right&quot;&gt;&lt;/span&gt;&lt;span class=&quot;glyphicon glyphicon-chevron-right&quot;&gt;&lt;/span&gt;','firstPageLabel'=&gt;'&lt;span class=&quot;glyphicon glyphicon-chevron-left&quot;&gt;&lt;/span&gt;&lt;span class=&quot;glyphicon glyphicon-chevron-left&quot;&gt;&lt;/span&gt;','prevPageLabel'=&gt;'&lt;span class=&quot;glyphicon glyphicon-chevron-left&quot;&gt;&lt;/span&gt;','nextPageLabel'=&gt;'&lt;span class=&quot;glyphicon glyphicon-chevron-right&quot;&gt;&lt;/span&gt;','header' =&gt; '','cssFile' =&gt; Yii::app()-&gt;baseUrl . '/css/pager.css','htmlOptions'=&gt;array('class'=&gt;'pagination'),'selectedPageCssClass'=&gt;'active'),

)); ?>

estebanhere30 · August 24, 2015, 2:16pm

Good morning Mohammed Iqbal Khan, you can try with exceptions in the controller en el action delete, so:




public function actionDelete($id)

	{

		try{

			$this->loadModel($id)->delete();


			// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser

			if(!isset($_GET['ajax']))

				$this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));

		} catch(CDbException $e){

	        if($e->getCode()===23000){

	            //You can have nother error handling

	            header("HTTP/1.0 400 Relation Restriction");

	            echo 'Este registro no puede ser borrado, porque está relacionado con información importante de la base de datos';

	        }else{

	            throw $e;

	        }

		}

	}

or you can quit the buttons oin the view admin, so:




	array(

			'class'=>'CButtonColumn',

			'template'=>'{update}{view}{delete}',

            'buttons'=>array(

                'update'=>array(

                        'visible'=>'false',

                ),

                'view'=>array(

                        'visible'=>'true',

                ),

                'delete'=>array(

                        'visible'=>'false',

				),

			),

		),

I hope to help you

yaasky · September 10, 2015, 9:35am

In your routes, make sure you have a rule that allows replayComment/update/$data->id point to replayComment/update/id/$data->id

ilaiyaraja · September 11, 2015, 6:51am

Check your top of the controller, By default delete action are not worked as GET Method, you can use POST method.