![\"\"](\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2019\/10\/scr_saas_database_list.png\")
<\/a>\n<\/p>\n
There are multiple ways to design and implement this kind of application in PHPRunner or ASPRunner.NET. You can get away using a single data to host all customers’ data but using a dedicated database for each customer is easier and more reliable. In this article, we’ll show the easiest way to build such an app.<\/p>\n
You can see that we have a common saasdb<\/strong> database here and multiple identical client databases. We only need to add to the project one of those client databases, database1 one in our example. <\/p>\n Common saasdb<\/strong> database only contains a single table named users<\/strong>. <\/p>\n We will select this table as a login table on the Security screen. Based on the username we redirect users to their database. We would only need to add two lines of code to make this happen. Things will be slightly different in PHPRunner and ASPRunner.NET.<\/p>\n 1. AfterSuccessfulLogin event<\/strong><\/p>\n Based on who is logged in we save database name in the session variable. <\/p>\n 2. Server Database Connection<\/strong><\/p>\n Proceed to the Output Directory screen, add a new Server Database Connection for the second database connection (database1) and modify the line where we specify the database name. This example is for MySQL. The point is to use $_SESSION[“dbname”] instead of the hardcoded database name. <\/p>\n 1. AfterSuccessfulLogin event<\/strong><\/p>\n 2. BeforeConnect event<\/strong><\/p>\n .NET applications are compiled before they can be deployed meaning that we cannot use any code in a new Server Database Connection. For this specific reason, we have added BeforeConnect event in ASPRunner.NET v10.3. <\/p>\n This is how default connection string looks (as shown in the event Description):<\/p>\n This is how we need to change it to grab database name from the session variable:<\/p>\n This is it. If you logon as user1 now you will see two records in the Customers table.<\/p>\n<\/a><\/p>\n<\/a><\/p>\nPHPRunner<\/h3>\n
$_SESSION[\"dbname\"] = $data[\"database\"];<\/pre>\n
$host=\"localhost\";\r\n$user=\"root\";\r\n$pwd=\"\";\r\n$port=\"\";\r\n$sys_dbname=$_SESSION[\"dbname\"];<\/pre>\n
ASPRunner.NET<\/h3>\n
XSession.Session[\"database\"]=data[\"database\"];<\/pre>\n
\r\nGlobalVars.ConnectionStrings[\"database1_at_localhost\"] = \"Server=localhost;Database=database1;User Id=root;Password=\";<\/pre>\n
\r\nGlobalVars.ConnectionStrings[\"database1_at_localhost\"] = \r\nString.Format(\"Server=localhost;Database={0};User Id=root;Password=\", XSession.Session[\"database\"]);\r\n<\/pre>\n