How to implement saas using php

Saas implementation method using PHP: 1. Create a separate backend and allocate an account; 2. Transform the database operation method of TP into a public method; 3. Use session to store "saas_id" in the backend, and Query using a fixed method; 4. Encapsulate the request method and add "saas_id" fixedly.

The operating environment of this tutorial: windows7 system, PHP8.1 version, DELL G3 computer

How to implement saas with php?

About PHP implementing saas function through sub-tables

Let me briefly talk about my understanding of saas. saas is equivalent to treating your own project as a The platform allows sub-users to use platform functions by dividing accounts.

Home page The first way I tried was to distinguish each table by adding a saas_id. Currently, the amount of data in each of my tables is about 60,000. , if 10 additional users are used, the number will be 600,000. Whether it is viewing or changing the efficiency, it will definitely not be particularly high, because after the amount of background data increases, it is also considered to divide the tables by year, so give up this method. The next thing I think about is Sub-database, because it is most appropriate to sub-database according to different sub-users in Anzhao according to the year. However, due to various reasons, this method was not used, and the sub-table was used in the end. Because the function of this project has been developed, what is needed now is probably these steps

The first step is to write a function to open an account. Here you can write a separate backend to allocate account opening, or write a Small programs such as h5 allow users to apply for it by themselves. The following is my method of dividing tables to generate a database.

$exist = Db::query('show tables like "ms_user' . $id . '"');
        if (!$exist) {
     
      方法1：      $sql = <<<sql
                            CREATE TABLE ms_user{$id} LIKE ms_user;
sql;
            Db::execute($sql);
            方法二：                $sql = <<<sql
                            CREATE TABLE ms_apply{$id} LIKE ms_apply;
sql;
            Db::execute($sql);
            $sql = <<<sql
                            INSERT ms_apply{$id} SELECT * FROM ms_apply;
sql;
            Db::execute($sql);
            die;
        }
    }

The general principle is to first check whether the saas_id has a generated data table, just in case. ! If the content does not need to be copied to a new table, just copy the table structure directly according to method 1. For example, if some public tables need to copy the public content to a new table, you need to add the data to the new package according to the second step of method 2.

The following is the table structure after splitting:

The second step is to transform the database operation method of tp into a public method to facilitate replacement. The code looks like a loser, but it actually saves a lot of effort

//db类
function dbs($table=''){
 
     $table=$table.session('user.saas_id');
    return Db::name($table);
}
function dba($table=''){
    $table=$table.input('param.saas_id');
    return Db::name($table);
}

The backend uses the session to store the saas_id query and uses a fixed method to query, and the frontend encapsulates the request method and fixes the saas_id

field request. If you want to use the model to query the database and do not use the Db class, you can contact me.

…I’ll update here first, and I’ll update later. If you don’t understand, you can message me privately!

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to implement saas using php. For more information, please follow other related articles on the PHP Chinese website!