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

How to connect phpcms to database

尚
Original
2020-01-14 09:11:572416browse

How to connect phpcms to database

phpcms method to connect to the database:

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
   ),
 );
 ?>

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();
   }
  }
?>

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

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

Statement:
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