How to get database information in thinkphp-ThinkPHP-php.cn

How to get database information in thinkphp

尚

Release： 2019-11-01 18:13:48

Original

4158 people have browsed it

How to get database information in thinkphp

thinkphp obtains database information

How to get database information in thinkphp

Add database connection information to the project configuration file Conf/config.php:

// 添加数据库配置信息
&#39;DB_TYPE&#39;   => &#39;mysql&#39;, // 数据库类型
&#39;DB_HOST&#39;   => &#39;localhost&#39;, // 服务器地址
&#39;DB_NAME&#39;   => &#39;thinkphp&#39;, // 数据库名
&#39;DB_USER&#39;   => &#39;root&#39;, // 用户名
&#39;DB_PWD&#39;    => &#39;&#39;, // 密码
&#39;DB_PORT&#39;   => 3306, // 端口
&#39;DB_PREFIX&#39; => &#39;think_&#39;, // 数据库表前缀

Copy after login

The main configuration items are the database server address hostname, database name database, database username username, database password password, and a table prefix prefix. After configuration, you can use tp5 query statements to query the database.

Or:

&#39;DB_DSN&#39; => &#39;mysql://root:密码@localhost:3306/thinkphp&#39;

Copy after login

Modify the controller

Lib/Action/IndexAction.class.php

class IndexAction extends Action {
    public function index(){
        $Data = M(&#39;tinyphp&#39;); // 实例化Data数据模型,这行的tinyphp为数据表后缀名称
        $this->data = $Data->select();
        $this->display();
    }
}

Copy after login

Modify the template to allow data output

Tpl/Index/index.html

<html>
 <head>
   <title>Select Data</title>
 </head>
 <body>
    <volist name="data" id="vo">
    {$vo.id}--{$vo.data}<br/>
    </volist>
 </body>
</html>

Copy after login

The volist tag is the tag used by the built-in template engine to output the data set.

{$vo.id} and {$vo.data} are used similarly to Smarty. They are fields used to output data. Here, it means outputting the values of the id and data fields of the think_data table.

Recommended: php5 download

The above is the detailed content of How to get database information in thinkphp. For more information, please follow other related articles on the PHP Chinese website!