


Example of Yii's addition, deletion, modification and query operations for adding rows
Dec 20, 2016 pm 03:10 PMThe 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:
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('ids')) { $ids=Yii::$app->request->post('ids'); $str=''; for($i=0;$i<count($ids);$i++) { if($a->createCommand()->delete('zhan',['id'=>$ids[$i]])->execute()) { $str++; } } if($str!='') { echo '<script>alert("刪除成功");location.href="index.php?r=index/index"</script>'; } } else { //判斷是否有id傳值 $cid=Yii::$app->request->post('cid'); $xu_ids=Yii::$app->request->post('xu_id'); //print_r($id);die; //添加行的數據 $names=Yii::$app->request->post('zhan_name'); $ulrs=Yii::$app->request->post('url'); //遍歷數組 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",['zhan_name'=>$name,'url'=>$url,'xu_id'=>$xu_id],"id=$c_id")->execute(); //數據可能沒被修改,只有成功一條就改變標記的值 if($res) { echo '<script>alert("修改成功");location.href="index.php?r=index/index"</script>'; } } else { $url=$ulrs[$k]; $xu_id=$xu_ids[$k]; $name=$v; $res=$a->createCommand()->insert("zhan",['xu_id'=>$xu_id,'zhan_name'=>$name,'url'=>$url])->execute(); //數據可能沒被修改,只有成功一條就改變v標記的值 if($res) { echo '<script>alert("添加成功");location.href="index.php?r=index/index"</script>'; } } } } } else { //查詢數據 $models=Zhan::find()->orderBy(['xu_id'=>'asc'])->asArray()->all(); //var_dump($models); return $this->renderPartial("show",['models'=>$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['id']; ?>" /> <td><input type="checkbox" name="ids[]" class='ids' value="<?= $v['id'] ?>"></td> <td><input type="text" name="xu_id[]" value="<?= $v['xu_id'];?>"></td> <td><input type="text" name ='zhan_name[]'value="<?= $v['zhan_name'];?>"></td> <td><input type="text" name="url[]" value="<?= $v['url'];?>"></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='<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 />'; tr.after(newtr); } //刪除當前行 function del(ts) { $(ts).parent().parent().remove(); } //刪除所有 function jian(ts) { var ids=$('.ids'); //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!

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

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

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

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 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.

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 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

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

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,

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.

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.
