How to link to database through ThinkPHP

Make the following configuration in the configuration file to connect to the database

'配置值' 'DB_TYPE' => 'mysql', // 数据库类型 'DB_HOST' => 'localhost', // 服务器地址 'DB_NAME' => 'shop', // 数据库名 'DB_USER' => 'root', // 用户名 'DB_PWD' => '123', // 密码 'DB_PORT' => '3306', // 端口 'DB_PREFIX' => 'sw_', // 数据库表前缀 );

CreateModelModel

Cut the'Home/Model'folder to theApplicationfolder, and letHomeandAdminare used together.

My database indicates that it isgoods. First, create a model class with the same name as the database

GoodsModel.class.php# Methods for instantiating models in ##

        

         Copy after login
        
       

:

First method:

Define acontroller(GoodsController)To call thisGoodsModel class

'; var_dump($goods); } }

Second type:

UseMfunction for instantiation:

'; var_dump($goods); } }

Third type:

UseDfunction

'; var_dump($goods); } }

method is the same asDmethod

Similar tonew Model()

Similar tonew GoodsModel()

Tips: You can see the information of thegoodstable. There is no code written in the model. All business logic is implemented by theModelclass

Operations on tables

Add:M('Table name')-> ;add($date);

Delete:M('Table name')->delete($id);

Update:M('Table name')->save($date);

Query:M('Table Name')->select();

Normal query (display all products)

:

select(); $this->assign('list', $list); $this->display(); } }

Remove from the template

  {$i} {$vo.goods_name} {$vo.goods_number} {$vo.goods_price}   {$vo.goods_brand_id} {$vo.goods_create_time} 修改 删除  

How to connect multiple databases through thinkphp

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