You can do it like this:
SQL
SELECT * FROM wp_options WHERE option_name="active_plugins";
But for better approach will be the WordPress way:
WordPress
if ( ! function_exists( 'get_plugins' ) ) {
require_once ABSPATH . 'wp-admin/includes/plugin.php';
}
$active_plugins = get_option('active_plugins');
$all_plugins = get_plugins();
$activated_plugins = array();
foreach ($active_plugins as $plugin){
if(isset($all_plugins[$plugin])){
array_push($activated_plugins, $all_plugins[$plugin]);
}
}
Related Posts:
- How do I show data from gravity forms in my template? [closed]
- Delete tables from database when deleting plugin
- How to delete all records from or empty a custom database table?
- WordPress sharding: which multi-DB plugin to use?
- How to make sense of the active_plugins option_value to enable and disable certain plugins from the database?
- Simple form that saves to database
- Using Vagrant for customizable WordPress Multi-sites [closed]
- Updating WordPress – the best approach (updating wp core, plugins and db)
- How to store ACF custom fields data in a custom table
- How can a Firebase user registration and login be integrated into a WordPress site?
- Bad Request (Invalid Hostname) on working server, database problem
- Plugin Not Working, But Only On GoDaddy Hosted site
- WordPress plugin DB upgrade
- how to show database content in wordpress post
- What is the easiest way to implement cascading database upgrade for my plugin?
- Ajax with jQuery UI dialog not working
- Remove obsolete plugins artifacts from database tables
- Is the wordpress user-model changed in wpmu?
- Default Plugin Settings Not Writing to Database
- Creating Tables on Network Activation
- What kind of data is that?
- Cannot login to ADMIN even after changing password in phpmyadmin
- Where to hook my plugin’s action
- Embed a Google Sheet as you view it in a separate tab?
- How to determine what is generating large amount of database queries?
- Building an email signup form. Where should the information be saved in the DB?
- Retrieving a Value from a wp-database
- Need help restoring my WordPress blog
- WP plugins for building a database?
- Is it possible to create Custom Post plug-in?
- Prevent duplicate records in plugin table
- Delete query not working in plugin
- How do I network enable a plugin for a multisite install via the database?
- Automatic switch to backup database on fail
- How can I change the meta_key for a particular piece of information?
- Create a table with wordpress plugin boilerplate
- WordPress and a secondary database?
- Why this function not working for install database on plugin activation
- plugin code is pulling information from database in one instance and not in other. What is wrong?
- Can I create a table on my DB without creating a plugin?
- WordPress : Explain Plugins & Theme string value in database
- Creating a CSV with PHP inside the plugin directory
- Plugins in WP_Options but not Active
- Gathering and logging data from a plugin: how to do it without race conditions?
- How to pass the API key to the client from the database? [closed]
- dbDelta not adding additional columns in plugin database update
- Updating options into the wp database performance
- Ajax save data to database on document ready, no data being saved
- How to edit a published post?
- Plugin has added weird data in wp_options, set to autoload
- How to create plugin/ page that reads from database
- Assign all Post in Wp to a specific Category
- External wpdb connections in different plugins on single page
- Storing The Data Collected by Ninja Forms into Another (custom) Database [closed]
- WordPress plugin: efficient way to store large data
- WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
- Is this plugin safe to run?
- Integrating Custom Database with WordPress
- Getting URL GET parameter with Code snippets and storing it in database?
- How to make a Product page without ordering and database
- Same Plugin tables between wordpress installations
- How can I display selected content from a seperate database in an Activity style widget?
- create pages automatically and dynamically in wordPress
- $wpdb->delete not working for me
- Performing CRUD operations on front end in wordpress
- How to add specific script to WordPress webpage that will working with user input and databases
- How to use WordPress header function and footer function and not load word press database
- add_action(‘the_content’, ‘my_plugin_content’) is null
- WordPress database problem wp_posts, primary key
- How to allow URL with filename & extension in wordpress?
- Programmatically generate new pages for a site based on page template and content elements accessed via DB
- Remove special characters from filenames
- PHP message: WordPress database error Deadlock found when trying to get lock
- errno: 150 “Foreign key constraint is incorrectly formed” [closed]
- using wordpress login details for other website / application / forum?
- database – multiple wordpress installations using same database – can they share plugin settings?
- how to create database to use it in wordpress website?
- HyperDB failover Delay
- how can i get records from wp_postmeta table using particular meta_key in database?
- How to create a custom page for unrelated database?
- User content database [closed]
- Include plugin form in the home page
- Write mysql credentials in plugin
- Is saving multiple options or saving multiple items in one option better?
- Collaborate on wordpress local website, share files via dropbox?
- Pull Data from DB for Admin Page Display as Relates to Admin Page Class by BA Internet
- Posts are deleted everyday at night
- Display Plugin information on specific url
- How to find an option in the database?
- Is there a plugin that will override the “Error establishing a database connection” message? [closed]
- Get the url of attachments from the post?
- Create New Admin Menu Section – Like how custom post type works, in a way
- Shortcode returning specific content of a post
- get_option returning a different value from what’s saved
- How can I delete the options from DB when the plugin is deleted?
- register_activation_hook not working
- Fragmented Static Conversion of WordPress Pages
- Form with response button after on table after submission
- plugin doesn’t retrieve data from database
- Can’t save formdata in DB