How to add database configuration and operate data in thinkphp3.2

In the process of developing web applications, database connections and operations are essential. When developing using the thinkphp3.2 framework, you need to configure and connect to the database. This article will introduce how to add database configuration, connection and data operations in thinkphp3.2.

1. Database configuration

1. Create a new database.php file in the config folder and add the following configuration:

return array(
    'DB_TYPE'               =>  'mysql',    // 数据库类型
    'DB_HOST'               =>  'localhost', // 服务器地址
    'DB_NAME'               =>  'dbname',   // 数据库名
    'DB_USER'               =>  'username',   // 用户名
    'DB_PWD'                =>  'password',   // 密码
    'DB_PORT'               =>  '3306',   // 端口
    'DB_PREFIX'             =>  '',    // 数据库表前缀
);

2. Modify the database configuration . Add the following code to the configuration file config.php:

// 数据库配置信息
'DB_CONFIG1' => include 'database.php',

Through the above configuration, we added the database configuration file database.php to config.php and set the connection parameters of the database.

2. Database connection

1. Create a new PublicModel.class.php file in the model folder and add the following code:

<?php namespace Model;
use Think\Model;
class PublicModel extends Model {
    protected $db_config    =   &#39;DB_CONFIG1&#39;;
}

Through the above code, We created a PublicModel class that inherits from the Model class provided by ThinkPHP, and the $db_config variable specifies the connection configuration.

2. Database connection usage. The PublicModel class can be used directly in the controller. The usage method is as follows:

$PublicModel = M('Public');

Through the above code, we create a PublicModel object and call the PublicModel model through the M function. This way we establish a connection to the database.

3. Data operations

After connecting to the database, we also need to perform data operations, including adding, modifying, and deleting operations. These operations are introduced below.

1. Data query

$PublicModel = M('Public');
$list = $PublicModel->where('id=1')->find();

The above code performs a query on the PublicModel model and returns the record with id 1.

2. Data insertion

$PublicModel = M('Public');
$data['username'] = 'tom';
$data['password'] = '123456';
$id = $PublicModel->add($data);

The above code performs an insertion operation on the PublicModel model, inserts the record with user name tom and password 123456 into the database, and returns the insertion The record ID number.

3. Data modification

$PublicModel = M('Public');
$data['username'] = 'tom';
$map['id'] = 1;
$result = $PublicModel->where($map)->save($data);

The above code performs a modification operation on the PublicModel model, changes the user name of the record with id 1 to tom, and returns the operation result.

4. Data deletion

$PublicModel = M('Public');
$map['id'] = 1;
$result = $PublicModel->where($map)->delete();

The above code performs a deletion operation on the PublicModel model, deletes the record with id 1, and returns the operation result.

In this article, we introduce how to add database configuration and connection as well as data operations in the thinkphp3.2 framework. By mastering the above methods, you will be able to perform web development work more quickly.

The above is the detailed content of How to add database configuration and operate data in thinkphp3.2. For more information, please follow other related articles on the PHP Chinese website!