How to add database configuration and operate data 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 database connection parameters. .

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');

We use the M function to call the PublicModel model, thus creating a PublicModel object. 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 and inserts a record with the username tom and password 123456 to the database and return the inserted record ID number.

3. Data modification

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

The above code modifies the PublicModel model and changes the user name of the record with id 1 to tom , and return 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.

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!