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 the Application folder, and let Home and Admin are used together.

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

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

controller
: 
First method: 
Define a  controller(GoodsController)To call thisGoodsModel class
';
        var_dump($goods);
    }
}

Second type:
Use M function for instantiation: 
';
        var_dump($goods);
    }
}

Third type: 
Use  Dfunction
';
        var_dump($goods);
    }
}
M
method is the same as Dmethod
M()
Similar to new Model()
D()
Similar tonew GoodsModel()
 Tips: You can see the information of the goods table. There is no code written in the model. All business logic is implemented by the Model class 
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)
Code in GoodsController
: 
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}
    修改
    删除

This article explains how to connect to the database through ThinkPHP. For more related content, please pay attention to the php Chinese website. 
Related recommendations: 

How to connect multiple databases through thinkphp
##About ThinkPHP 5. Some basic operations of the database

Thinkphp5 rules for adding different data
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!