国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

Home php教程 PHP開發(fā) Example of Yii's addition, deletion, modification and query operations for adding rows

Example of Yii's addition, deletion, modification and query operations for adding rows

Dec 20, 2016 pm 03:10 PM
yii framework

The example in this article describes Yii's addition, deletion, modification and query operations for adding rows. Share it with everyone for your reference, the details are as follows:

Rendering:

Example of Yiis addition, deletion, modification and query operations for adding rows

Controller:

<?php
namespace backend\controllers;
use Yii;
use yii\web\Controller;
use backend\models\Zhan;
class IndexController extends Controller
{
  //顯示頁面
  public function actionIndex()
  {
    $index=new Zhan();
    //接受值
     if($_POST)
     {
      $a=Yii::$app->db;
      //判斷是否有刪除ids
      if(Yii::$app->request->post(&#39;ids&#39;))
      {
        $ids=Yii::$app->request->post(&#39;ids&#39;);
        $str=&#39;&#39;;
        for($i=0;$i<count($ids);$i++)
        {
         if($a->createCommand()->delete(&#39;zhan&#39;,[&#39;id&#39;=>$ids[$i]])->execute())
         {
           $str++;
         }
        }
        if($str!=&#39;&#39;)
        {
          echo &#39;<script>alert("刪除成功");location.href="index.php?r=index/index"</script>&#39;;
        }
      }
      else
      {
         //判斷是否有id傳值
         $cid=Yii::$app->request->post(&#39;cid&#39;);
         $xu_ids=Yii::$app->request->post(&#39;xu_id&#39;);
         //print_r($id);die;
         //添加行的數據
         $names=Yii::$app->request->post(&#39;zhan_name&#39;);
         $ulrs=Yii::$app->request->post(&#39;url&#39;);
         //遍歷數組
         foreach($names as $k=>$v)
         {
           if(!empty($cid[$k]))
           {
            $c_id=$cid[$k];
            //echo $c_id;die;
            $url=$ulrs[$k];
            $xu_id=$xu_ids[$k];
            $name=$v;
            $res=$a->createCommand()->update("zhan",[&#39;zhan_name&#39;=>$name,&#39;url&#39;=>$url,&#39;xu_id&#39;=>$xu_id],"id=$c_id")->execute();
            //數據可能沒被修改,只有成功一條就改變標記的值
            if($res)
            {
             echo &#39;<script>alert("修改成功");location.href="index.php?r=index/index"</script>&#39;;
            }
           }
           else
           {
            $url=$ulrs[$k];
            $xu_id=$xu_ids[$k];
            $name=$v;
            $res=$a->createCommand()->insert("zhan",[&#39;xu_id&#39;=>$xu_id,&#39;zhan_name&#39;=>$name,&#39;url&#39;=>$url])->execute();
            //數據可能沒被修改,只有成功一條就改變v標記的值
            if($res)
            {
              echo &#39;<script>alert("添加成功");location.href="index.php?r=index/index"</script>&#39;;
            }
           }
         }
      }
     }
     else
     {
      //查詢數據
      $models=Zhan::find()->orderBy([&#39;xu_id&#39;=>&#39;asc&#39;])->asArray()->all();
      //var_dump($models);
      return $this->renderPartial("show",[&#39;models&#39;=>$models]);
     }
  }
}
?>

View layer:

<center>
<form action="index.php?r=index/index" method="post">
<input name="_csrf" type="hidden" id="_csrf" value="<?= Yii::$app->request->csrfToken ?>">
<table>
<tr>
<td>ID</td>
  <td>顯示順序</td>
  <td>站點名稱</td>
  <td>站點URL</td>
</tr>
<?php foreach ($models as $key => $v) {?>
<tr>
<input type="hidden" name="cid[]" value="<?php echo $v[&#39;id&#39;]; ?>" />
<td><input type="checkbox" name="ids[]" class=&#39;ids&#39; value="<?= $v[&#39;id&#39;] ?>"></td>
<td><input type="text" name="xu_id[]" value="<?= $v[&#39;xu_id&#39;];?>"></td>
<td><input type="text" name =&#39;zhan_name[]&#39;value="<?= $v[&#39;zhan_name&#39;];?>"></td>
<td><input type="text" name="url[]" value="<?= $v[&#39;url&#39;];?>"></td>
</tr>
<?php }?>
<tr>
 <td><a href="javascript:void(0)" onclick="add(this);">+添加友情鏈接</a></td>
 <td><input type="checkbox" onclick="jian(this);">刪除?</td>
</tr>
 <tr>
  <td><input type="submit" value="提交" ></td>
 </tr>
</table>
</form>
</center>
<script src="style/jquery.js"></script>
<script>
//添加一行
function add(ts)
{
  var tr=$(ts).parent().parent();
  var newtr=&#39;<tr><td></td><td><input type="text" name="xu_id[]"></td><td><input type="text" name="zhan_name[]"></td><td><input type="text" name="url[]"></td><td><input type="button" value="刪除該行" onclick="del(this);"></td></td></tr><br />&#39;;
  tr.after(newtr);
}
//刪除當前行
function del(ts)
{
  $(ts).parent().parent().remove();
}
//刪除所有
function jian(ts)
{
  var ids=$(&#39;.ids&#39;);
  //alert(ids.length);
  for(var i=0;i<ids.length;i++)
  {
    if(ts.checked==true)
    {
     ids[i].checked=true;
    }
    else
    {
     ids[i].checked=false;
    }
  }
}
</script>
</head>

I hope this article will be helpful to everyone’s PHP program design based on the Yii framework.

For more related articles on Yii’s addition, deletion, modification and query operation examples for adding rows, please pay attention to the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

PHP Tutorial
1502
276
Yii framework middleware: providing multiple data storage support for applications Yii framework middleware: providing multiple data storage support for applications Jul 28, 2023 pm 12:43 PM

Yii framework middleware: providing multiple data storage support for applications Introduction Middleware (middleware) is an important concept in the Yii framework, which provides multiple data storage support for applications. Middleware acts like a filter, inserting custom code between an application's requests and responses. Through middleware, we can process, verify, filter requests, and then pass the processed results to the next middleware or final handler. Middleware in the Yii framework is very easy to use

Yii Framework Middleware: Add logging and debugging capabilities to your application Yii Framework Middleware: Add logging and debugging capabilities to your application Jul 28, 2023 pm 08:49 PM

Yii framework middleware: Add logging and debugging capabilities to applications [Introduction] When developing web applications, we usually need to add some additional features to improve the performance and stability of the application. The Yii framework provides the concept of middleware that enables us to perform some additional tasks before and after the application handles the request. This article will introduce how to use the middleware function of the Yii framework to implement logging and debugging functions. [What is middleware] Middleware refers to the processing of requests and responses before and after the application processes the request.

How to use Yii framework in PHP How to use Yii framework in PHP Jun 27, 2023 pm 07:00 PM

With the rapid development of web applications, modern web development has become an important skill. Many frameworks and tools are available for developing efficient web applications, among which the Yii framework is a very popular framework. Yii is a high-performance, component-based PHP framework that uses the latest design patterns and technologies, provides powerful tools and components, and is ideal for building complex web applications. In this article, we will discuss how to use Yii framework to build web applications. Install Yii framework first,

Steps to implement web page caching and page chunking using Yii framework Steps to implement web page caching and page chunking using Yii framework Jul 30, 2023 am 09:22 AM

Steps to implement web page caching and page chunking using the Yii framework Introduction: During the web development process, in order to improve the performance and user experience of the website, it is often necessary to cache and chunk the page. The Yii framework provides powerful caching and layout functions, which can help developers quickly implement web page caching and page chunking. This article will introduce how to use the Yii framework to implement web page caching and page chunking. 1. Turn on web page caching. In the Yii framework, web page caching can be turned on through the configuration file. Open the main configuration file co

How to use controllers to handle Ajax requests in the Yii framework How to use controllers to handle Ajax requests in the Yii framework Jul 28, 2023 pm 07:37 PM

In the Yii framework, controllers play an important role in processing requests. In addition to handling regular page requests, controllers can also be used to handle Ajax requests. This article will introduce how to handle Ajax requests in the Yii framework and provide code examples. In the Yii framework, processing Ajax requests can be carried out through the following steps: The first step is to create a controller (Controller) class. You can inherit the basic controller class yiiwebCo provided by the Yii framework

Debugging Tools in the Yii Framework: Profiling and Debugging Applications Debugging Tools in the Yii Framework: Profiling and Debugging Applications Jun 21, 2023 pm 06:18 PM

In modern web application development, debugging tools are indispensable. They help developers find and solve various problems with their applications. As a popular web application framework, the Yii framework naturally provides some debugging tools. This article will focus on the debugging tools in the Yii framework and discuss how they help us analyze and debug applications. GiiGii is a code generator for the Yii framework. It can automatically generate code for Yii applications, such as models, controllers, views, etc. Using Gii,

Encrypt and decrypt sensitive data using Yii framework middleware Encrypt and decrypt sensitive data using Yii framework middleware Jul 28, 2023 pm 07:12 PM

Encrypting and decrypting sensitive data using Yii framework middleware Introduction: In modern Internet applications, privacy and data security are very important issues. To ensure that users' sensitive data is not accessible to unauthorized visitors, we need to encrypt this data. The Yii framework provides us with a simple and effective way to implement the functions of encrypting and decrypting sensitive data. In this article, we’ll cover how to achieve this using the Yii framework’s middleware. Introduction to Yii framework Yii framework is a high-performance PHP framework.

Yii Interview Questions: Ace Your PHP Framework Interview Yii Interview Questions: Ace Your PHP Framework Interview Apr 06, 2025 am 12:20 AM

When preparing for an interview with Yii framework, you need to know the following key knowledge points: 1. MVC architecture: Understand the collaborative work of models, views and controllers. 2. ActiveRecord: Master the use of ORM tools and simplify database operations. 3. Widgets and Helpers: Familiar with built-in components and helper functions, and quickly build the user interface. Mastering these core concepts and best practices will help you stand out in the interview.

See all articles