Two wordpress sites using diiferent themes on the same database

The solution below did the job for me,

Install 2 WordPress sites on a single database.

Create new table in your database. Call it wp_options2 and copy everything from wp_options into this new table

In second install go to wp-config.php, and before if (!defined('ABSPATH')) add define( 'M7_OPTIONS_TABLE', 'wp_options2');

In second install go to wp-includes/wp-db.php on line 1009 and add code:

if (isset( $tables['options'] ) && defined('M7_OPTIONS_TABLE')) $tables['options'] = M7_OPTIONS_TABLE;

These codes should be added in public function tables function, before if (isset( $tables['users']) && defined('CUSTOM_USER_TABLE')))

I found this solution here, https://wordpress.stackexchange.com/questions/84313/how-to-run-two-wordpress-blogs-with-different-themes-and-with-single-database-an#answer-175494

Since we use the same database, links will be same on both the sites. I had a lot of images linked and I removed them using

.single a[href$=".jpg"] {
    pointer-events: none;
    cursor: default;  
} 

You can run two sites from a single database but not from the same set of database tables as the stored data includes the site's domain name.

There are two values in the options table: siteurl and home which are used. Using the same options table won't work, even if you update options forcefully for each php run.

So you would need to use two databases.

EDIT:

My advice is to replicate base and run both sites on different databases.