PHP yii framework web project connects to database and CRUD operation_PHP tutorial

The previous article introduced how to configure the yii framework, so in this article we will learn the crud operation of yii. Friends who don’t understand can leave me a message.

First, we find the configuration file of our wen project, ..yiiphpprotectedconfig. There are three pages in it. Open its main.php

The page we just saw looks like this:

Next we change the title of the project to "My PHP Project"; here is a screenshot of the modification of main.php

Change the gray part of the tenth line to "My PHP Project"; in this way, we have successfully modified the title, as shown in the picture:

Next we create a database connected to php. For example, I create a mysql database named "yiitest", and then there is a "user" table with two fields in the table. The code is given below:

mysql> create database yiitest;
Query OK, 1 row affected (0.00 sec)

mysql> use yiitest;
Database changed
mysql> create table user(
    -> id int primary key auto_increment,
    -> name varchar(20) not null,
    -> pwd varchar(20) not null);
Query OK, 0 rows affected (0.06 sec)

In this way, our database is built. We continue to modify the configuration file of main.php, first giving the original configuration, as shown in the figure:

We comment out lines 50 to 52, then release 55 to 61, and change the dbname="testdrive' on line 56 to dbname='yiitest'. There are also lines 58 to 59, please watch and change it. , because my database does not have a password, so I ignore it and now give the modified screenshot:

In this way, our database connection is completed (the effect cannot be seen for the time being), and then we continue to configure gii and follow the same example. We give the original configuration picture of main.php:

What we have to do is release the code from lines 24 to 29 and modify the "password'=>'Enter Your Password' on line 26 to what you want, such as 'password'=>'password', the modified configuration As shown in the picture

In this way, we have basically completed the configuration of the main.php file. Now we can see the effect, open the browser and enter: http://localhost/yiiphp/index.php?r=gii, log in with the password you just set , as shown in the figure: 喎?http://www.Bkjia.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA+PGltZyBzcmM9"http://www.2cto.com/uploadfile/Collfiles/20140214/20140214084303187.jpg" alt="">

As shown in the picture, we click on the third hyperlink---Model Generator. It means the model generation program. After clicking in, fill in the user table of our database as shown in the picture

Click Generate to directly generate the class file of the program. Next, we click on the second crud Generator hyperlink, use the class file just generated, named "User", click the Preview button, and then click the Generate button, so that our crud file is generated, now let's take a look yii crud. We enter http://localhost/yiiphp/index.php?r=User on the page. You can see the effect, as shown in the picture:

Since the database has not added information yet, it shows that no results were found. We can click create User on the right to add a piece of information. You can also check the database to see if any data has been added successfully. After adding it, I believe you all understand Yii’s crud. Here is the last screenshot

This page gives the addition, deletion, modification and query of yii, which is what we call crud.

http://www.bkjia.com/PHPjc/735887.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/735887.htmlTechArticleThe previous article introduced how to configure the yii framework, so in this article we will learn the crud operation of yii. Friends who don’t understand can leave me a message. First, we find the configuration file of our wen project...