Home > CMS Tutorial > PHPCMS > How to connect to the database in phpcms

How to connect to the database in phpcms

藏色散人
Release: 2019-12-26 10:31:33
Original
2289 people have browsed it

How to connect to the database in phpcms

How does phpcms connect to the database?

PHPCMS database configuration

Database configuration file location: caches/configs/database.php

We open this configuration file and join us database configuration information. The database configuration information is a two-dimensional array structure. The default is default. Multiple database links can be configured according to the default structure (such as: extended_1)

<?php
 return array (
   &#39;default&#39; => array (
     &#39;hostname&#39; => &#39;localhost&#39;,
     &#39;database&#39; => &#39;phpcms&#39;,
     &#39;username&#39; => &#39;admin&#39;,
     &#39;password&#39; => &#39;admin&#39;,
     &#39;tablepre&#39; => &#39;v9_&#39;,
     &#39;charset&#39; => &#39;gbk&#39;,
     &#39;type&#39; => &#39;mysql&#39;,
     &#39;debug&#39; => true,
     &#39;pconnect&#39; => 0,
     &#39;autoconnect&#39; => 0
   ),
    /* 以下默认不存在 */
   &#39;extended_1&#39; => array (
     &#39;hostname&#39; => &#39;10.10.125.2&#39;,
     &#39;database&#39; => &#39;phpcms&#39;,
     &#39;username&#39; => &#39;admin&#39;,
     &#39;password&#39; => &#39;admin&#39;,
     &#39;tablepre&#39; => &#39;v9_&#39;,
     &#39;charset&#39; => &#39;gbk&#39;,
     &#39;type&#39; => &#39;mysql&#39;,
     &#39;debug&#39; => true,
     &#39;pconnect&#39; => 0,
     &#39;autoconnect&#39; => 0
   ),
 );
 ?>
Copy after login

Modify the above configuration content according to your database connection information. After the modification is completed, Save the database configuration file.

After configuring the database, you can select the database configuration file, database, etc. through the database model class below!

The database model is located in: phpcms/model/ directory

<?php
   defined(&#39;IN_PHPCMS&#39;) or exit(&#39;No permission resources.&#39;);
   pc_base::load_sys_class(&#39;model&#39;, &#39;&#39;, 0);
   class test_model extends model {
     public function __construct() {
     $this->db_config = pc_base::load_config(&#39;database&#39;);
     $this->db_setting = &#39;default&#39;;
     $this->table_name = &#39;test&#39;;
     parent::__construct();
   }
  }
Copy after login

PHP Chinese website, a large number of free PHPCMS tutorials, welcome to learn online!

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

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template