Php yii framework web project Connection database and crud operations

The previous article introduced how to configure the yii framework. In this article, we will learn about the yii crud operation. If you do not know, you can leave a message for me.

First, find the configuration file of our wen project, which has three pages in .. \ yiiphp \ protected \ config to open its main. php

Page effects we saw at the beginning

Next, we will change the project title to "my php Project". Here, the main. php modified

Change the gray part of Row 10 to "my php Project", so that the title is successfully modified,

Next we will establish a database to connect to php. For example, I have created a mysql database named "yiitest" and a "user" table with two fields. The following code is provided:

mysql> create database yiitest;Query OK, 1 row affected (0.00 sec)mysql> use yiitest;Database changedmysql> 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 has been built. We will continue to modify the configuration file of main. php and first provide the original configuration,

Comment out rows 50 to 52, then release rows 55 to 61, and change the 56 rows of dbname = "testdrive" to dbname = 'yiitest '. There are also lines 58 to 59 that you are looking at and changing, because my database has no password, so I ignore it, and now the modified:

In this way, our database connection is complete (the effect is not visible for the moment). Then we continue to configure gii and draw a gourd based on the sample. We will provide the original configuration of main. php:

All we need to do is release 24 to 29 lines of code and change the 26 lines of "password" => 'enter Your password' to what you want, for example, 'Password' => 'Password', modified Configuration

In this way, the main. php file is basically configured. Now we can check the effect and open the browser and enter: http: // localhost/yiiphp/index. php? R = gii. log on to the password you just set. <喎?http: www.bkjia.com kf ware vc " target="_blank" class="keylink"> VcD4KPHA + pgltzybzcm9 "http://www.2cto.com/uploadfile/Collfiles/20140214/20140214084303187.jpg" alt = "\">

Click the third hyperlink-Model Generator, which means to generate the Model program. Click it and enter the user table of our database.

Click Generate to Generate the program class file. Next, click the second crud Generator hyperlink to use the generated class file named "User", click the Preview button, and then click Generate, in this way, the crud file is generated. Now let's take a look at the crud of yii. On the page, enter http: // localhost/yiiphp/index. php? R = User. You can see the effect ,:

Because no information has been added to the database, the result is not displayed. You can click "create User" on the right to add a message. You can also check whether the database has been successfully added. After adding it, I believe you all know the crud of yii and give the last one.

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