CMS Database

In CMS Full Form, the CMS database is where all the data for your website is stored, including languages, posttype, terms, users, settings, and other options. CMS Full Form typically uses MySQL or MariaDB as its database management system.

---

Default tables

The structure of the CMS Full Form database includes several important tables. Some of the key tables in the CMS database include:

fast_comments

This table stores all the comments made by users on posts or pages. It typically contains fields like the comment content, the user who made the comment, the post/page it is associated with, and timestamps.

fast_files

This table is used for storing information about uploaded files on your site. It may store data such as the file name, file type, size, file path, and the user who uploaded it.

fast_languages

This table holds language settings for your site. It allows you to manage and store multiple languages, enabling multilingual support for your site.

fast_options

This table stores site-wide settings and configuration options. It may include general settings such as site name, logo, default language, SEO settings, and other custom configuration options.

fast_posttype

This table is used to define custom post types for the CMS. It allows you to create custom content types beyond the default posts and pages (e.g., products, events, etc.), providing more flexibility for content management.

fast_terms

The fast_terms table stores terms used for categorization, like tags and categories. These terms are used for categorizing and organizing posts or other content types.

fast_users

This table stores information about the users of the website. It contains data like usernames, passwords (hashed), roles (e.g., admin, editor, user), and other user-related details.

Configuring the Database

To configure the database in CMS Full Form, you'll need to set up the database connection in the Config.php file, which is located in the application/Config/ folder. Below is an example of how to configure the database settings:

<?php
'db' => [
    'db_host'     => 'localhost',                // The database host, typically 'localhost'
    'db_username' => 'your_database_user',       // Your database username
    'db_password' => 'your_database_password',   // Your database password
    'db_database' => 'your_database_name',       // Your database name
    'db_driver'   => 'mysqli',                   // The database driver, typically 'mysqli' for MySQL
    'db_port'     => 3306,                       // The port number for the MySQL connection, default is 3306
    'db_charset'  => 'utf8mb4',                  // The character set for the connection, utf8mb4 is recommended
    'db_collate'  => 'utf8mb4_unicode_ci',       // The collation for the connection
],

Configuration Parameters:

• db_host: The host where the database server is located. Typically, it is localhost, but if you're using a remote server, you will need to specify the host address.

• db_username: The username for connecting to the database.

• db_password: The password for the database user.

• db_database: The name of the database you are using for your PHPFast CMS.

• db_driver: This specifies the database driver. For MySQL databases, you will typically use mysql or mongodb as the driver. (Or you can see Database to details)

• db_port: The port number used for the database connection. The default MySQL port is 3306.

• db_charset: The character set for the database connection. It is recommended to use utf8mb4 to ensure proper support for all characters, including emojis.

• db_collate: The collation for the database connection. utf8mb4_unicode_ci is commonly used as it supports a wide range of characters and sorts them correctly.

After configuring the database settings in Config.php, PHPFast should be able to connect to the database and use the default tables (e.g., fast_comments, fast_users, etc.) for storing and retrieving data.