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]
- Is it bad practice to create own table for a plugin?
- How to Add an Index to Plugin Database table
- How can I delete orphan keys in WordPress database tables?
- What are these entries in the database? Looks similar to JSON
- Creating two database tables via plugin
- How to make sense of the active_plugins option_value to enable and disable certain plugins from the database?
- Insert query inserts 2 entries, should insert 1
- Updating WordPress – the best approach (updating wp core, plugins and db)
- Custom database table for plugin not creating on activation
- Should I global $wpdb outside of any of my plugin’s functions scope?
- How to edit/delete single row items in a table on my own menu page
- greatest() function returns undefined property
- Default Plugin Settings Not Writing to Database
- Unable to create new database table upon plugin activation using dbDelta
- How to determine what is generating large amount of database queries?
- Retrieving a Value from a wp-database
- Need help restoring my WordPress blog
- WP plugins for building a database?
- Plugin Options Not Saving to Database in WP 4.5
- Doubt using $wpbd->get_col for a single column
- Access WordPress database outside of WordPress
- Is it possible to create Custom Post plug-in?
- WordPress Settings Lost After Site Migration
- Help With MySQL to WPDB Query Conversion
- Delete query not working in plugin
- How to remove traces from widget during uninstallation
- How do I network enable a plugin for a multisite install via the database?
- import posts with dutch/special letters
- How can I change the meta_key for a particular piece of information?
- Is it necessary to auto delete my WP plugin database tables when users deactivate/delete my plugin?
- Plugins in WP_Options but not Active
- How do i edit the plugin files in DataBase via phpMyAdmin?
- WordPress as a data-store?
- How to insert and call new data in wordpress website database through a plugin
- WPDB: Update table
- Issue running db create table query from static method
- Problem of encoding characters (apostrophes) in my posts publications
- Separate database for a wordpress plugin
- Is there a rule for wordpress plugins developers to not do any database changes upon update?
- How to keep variable `$post` to using in another file
- Updating options into the wp database performance
- Making my plugin create a page?
- Ajax save data to database on document ready, no data being saved
- Add some fileds to the wp_posts table
- Always get creating a new table with foreign key
- How to do database for download stats?
- What is the WordPress approach to custom data?
- How retreive saved data from gravity forms in my template?
- External wpdb connections in different plugins on single page
- Comment “like” problem – “users who like this” avatar linking to current user profile instead of “liker’s” profile
- WordPress plugin boilerplate table create
- How to relate 3 wordpress components with each other (Create database relationships)
- Creating a search form and displaying results
- How can I store data from custom fields to custom tables?
- How to access the WordPress DB from a plugin file
- Integrating Custom Database with WordPress
- How to display results from a data table with an encrypted user id?
- How to add a custom form to a plugin’s setting page
- update_option creates an option, which empties on a blog reload
- add_action for publish_post doesn’t work
- Bulk Edit Media Library alt, caption, image names
- Cant create table on plugin activation
- Optimise wordpress database using SQL after deleting registered images from Media Folder
- How to implement data residency in my WordPress site
- Moving a few select DB tables to a new WP instance
- WordPress database problem wp_posts, primary key
- How to allow URL with filename & extension in wordpress?
- How wordpress handle urls present in db for external wp-content directory
- Using Filters to modify contect – DB query results alwats appear fist
- PHP message: WordPress database error Deadlock found when trying to get lock
- Enable plugins that are “not supported”
- Many to many relationship for variable products
- Is it a good practice to use wordpress database to store pages contents which loading to page dynamically?
- using wordpress login details for other website / application / forum?
- Where do the section input fields values are stored in database
- how to create database to use it in wordpress website?
- My plugin can’t see my files
- User content database [closed]
- Show a table from data submitted by a form from a user
- How to save information related to post in database?
- RSS Feed has no Items (Possible Plugins Conflict)
- A plugin is giving me “You do not have sufficient permissions to access this page.” error
- wpdb get_var is not returning any result (verified mysql query returns only one value)
- Is there a plugin that will override the “Error establishing a database connection” message? [closed]
- Get the url of attachments from the post?
- Managing database tables in WordPress multisite
- Create New Admin Menu Section – Like how custom post type works, in a way
- Creating fields in the database
- Allow users to enter and edit data in one-to-many configuration
- Updating WordPress [closed]
- User register hook can’t access form request
- 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?
- Text Wrapping in WPDataTables
- Very slow page loads
- Form with response button after on table after submission
- Can’t save formdata in DB
- Can’t change login logo & css – older plugin data blocking?