yii2 单页面增删改

视图层

控制器层

<?php

namespace frontend\controllers;

use Yii;
use frontend\models\Ceshi;
use yii\db\Query;

class CeshiController extends \yii\web\Controller
{
    public function actionIndex()
    {

       //判断是否为提交表单
       if(Yii::$app->request->ispost){
           //判断是否为删除操作
           if(Yii::$app->request->post('check')){
               $check = Yii::$app->request->post('check');
               //var_dump($check);die;
               $str = '';
               for($i=0 ; $i<count($check) ; $i++){
                   $sql = "delete from ceshi where id=".$check[$i];
                   if(Yii::$app->db->createCommand($sql)->execute()){
                       $str++;
                   }
               }
               if($str!=''){
                   echo "<script>alert('删除成功'); location.href='index.php?r=ceshi/index'; </script>";
               }
           }else{
               //执行修改和添加操作
               //var_dump(Yii::$app->request->post());die;
               $cid = Yii::$app->request->post('cid');
               $orders = Yii::$app->request->post('order');
               $titles = Yii::$app->request->post('title');
               $urls = Yii::$app->request->post('url');
               $flage = '';
               foreach ($orders as $k=>$v){
                   //判断是否有ID传值
                   if(!empty($cid[$k])){

                       $order = $v;
                       $title = $titles[$k];
                       $url = $urls[$k];
                       $id = $cid[$k];
                       //echo $id;exit;
                       $res = Yii::$app->db->createCommand()->update('ceshi', [
                                           'order' => $v,
                                           'url' => $url,
                                           'title' => $title
                                       ] , "id=$id")->execute();
                       //数据可能没被修改，只有成功一条就改变标记的值
                       if($res){
                           $flage = '1';
                       }
                   }else{
                       $order = $v;
                       $title = $titles[$k];
                       $url = $urls[$k];
                       $res = Yii::$app->db->createCommand()->insert('ceshi', [
                                           'order' => $v,
                                           'url' => $url,
                                           'title' => $title
                                       ])->execute();
                       if($res){
                           $flage = '1';
                       }
                   }
               }
               //判断是否成功
               if($flage=='1'){
                   echo "<script>alert('修改/添加成功'); location.href='index.php?r=ceshi/index'; </script>";
               }else{
                   echo "<script>alert('无任何操作'); location.href='index.php?r=ceshi/index'; </script>";
               }
           }
       }
       $query = new Query();
       //查询所有数据
       $info = $query
               ->select('*')
               ->from('ceshi')
               ->orderBy(['order' => SORT_ASC])
               ->all();

        return $this->render('index' , ['info' => $info]);
    }

}

另一种表单,0-0

<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
$form = ActiveForm::begin(['method'=>'post','action' => 'index.php?r=test/index']);

?>
<style>
#tab tr td{
   height:40px;
   width:100px;
}
</style>
<table id='tab'>
<tr>
   <td><input type='checkbox' /></td>
   <td>显示顺序:</td>
   <td>站点名称:</td>
   <td>站点地址:</td>
</tr>
<?php foreach ($data as $key=> $v):?>
   <tr id='tr1'>
   <input type="hidden" name="cid[]" value="<?php echo $v['id']; ?>" />
       <td><input type='checkbox' name='check[]' class='ids' value="<?php echo $v['id']?>" /></td>
       <td><input type='text' name='t_xu[]' value="<?= $v['t_xu']?>" size="3"/></td>
       <td><input type='text' name='t_name[]' value="<?= $v['t_name']?>"size="8" /></td>
       <td class='td1'><input type='text' name='t_url[]' value="<?= $v['t_url']?>" /></td>
   </tr>
<?php endforeach; ?>
   <tr id='tr2'></tr>
</table>
<input type='button' value='+' id='btn' />添加友情链接
<p><input type='checkbox' onclick='getAll(this)' />    
删?    
<input type='submit' id='btnok' value='提交'/></p>
<?php ActiveForm::end()?>

<?php $this->beginBlock('checkAgree');?>
   $('#btn').on('click',function()
   {
       //var trhtml = "<td><input type='checkbox' name='id' /></td><td><input type='text' name='t_xu' /></td><td><input type='text' name='t_name'/></td><td><input type='text' name='t_url' /></td>";
       //alert(trhtml);
       //$('#tr2').append(trhtml);
       var tab=document.getElementById('tab');
       var n=document.getElementById('tr2').rowIndex+1;
       var tr=tab.insertRow(n);
       var td=tr.insertCell(0);
       tr.innerHTML="<td></td><td><input type='text' name='t_xu[]' size='3' /></td><td><input type='text' name='t_name[]' size='8'/></td><td><input type='text' name='t_url[]' /><td><input type='button' value='删除此行' onclick='deltr(this)' /></td>";
   });
   function deltr(ts){
       var tr = $(ts).parent().parent();
       tr.remove();
   }
   function getAll(ts)
   {
       var ids = $('.ids');
       //alert(ids.length);
       for(i=0; i<ids.length; i++)
       {
           if(ts.checked == true)
           {
               ids[i].checked = true;
           } else {
               ids[i].checked = false;
           }
       }
   }
<?php $this->endBlock(); $this->registerJs($this->blocks['checkAgree'], \yii\web\View::POS_END);?>

巴特西

yii2 单页面增删改

最新文章

热门文章