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
- 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?
- Is there a plugin that will override the “Error establishing a database connection” message? [closed]
- How to delete all records from or empty a custom database table?
- What are these entries in the database? Looks similar to JSON
- WordPress sharding: which multi-DB plugin to use?
- Creating two database tables via plugin
- How to properly insert data into custom table via plugin
- How does WordPress handle MySQL row lock errors?
- How to make sense of the active_plugins option_value to enable and disable certain plugins from the database?
- How to empty wordpress custom post Database table
- insert data in database table from plugin with WP3.1
- Simple form that saves to database
- How to run Two WordPress blogs with different themes and with single database and same content
- $wpdb->get_results leaking memory
- Plugins or Tutorials for displaying data from SQL-db on WP-page? [closed]
- Insert query inserts 2 entries, should insert 1
- Using Vagrant for customizable WordPress Multi-sites [closed]
- Is it a bad practice to go directly to the mysql database while developing a plugin?
- Updating WordPress – the best approach (updating wp core, plugins and db)
- How to store ACF custom fields data in a custom table
- Can I explicitly specify ENGINE=InnoDB in WordPress?
- 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
- Create custom column in post table in wordpress
- Custom database or Custom Post Types?
- Custom database table for plugin not creating on activation
- WordPress plugin DB upgrade
- How to update widget_text in the wp_options table
- Get the last post ID
- Add agenda items and notifications
- How to count number of records found in a database table?
- Should I global $wpdb outside of any of my plugin’s functions scope?
- prefix table and plugins
- Taking WordPress table prefixes into account
- Changing BIGINT to INT
- WordPress register_activation_hook table creation not working
- How to add Edit | Delete button on rows?
- The plugin generated x characters of unexpected output, $wpdb not defined
- how to show database content in wordpress post
- What is the easiest way to implement cascading database upgrade for my plugin?
- clean wp_options table unused rows
- Ajax with jQuery UI dialog not working
- How to edit/delete single row items in a table on my own menu page
- Storing Email Account Passwords for SMTP Mailing for a WordPress Plugin
- Remove obsolete plugins artifacts from database tables
- If I delete plugins via FTP are settings kept in DB?
- greatest() function returns undefined property
- Get total number of comment of the posts written by an author
- How to write one comment and publish on every post using database or plugin?
- Is the wordpress user-model changed in wpmu?
- Include plugin form in the home page
- Write mysql credentials in plugin
- How to save information related to post in database?
- Create user assessment and use results in sql query
- Is saving multiple options or saving multiple items in one option better?
- WordPress custom posttype meta values doesnot save
- RSS Feed has no Items (Possible Plugins Conflict)
- A plugin is giving me “You do not have sufficient permissions to access this page.” error
- 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?
- wpdb get_var is not returning any result (verified mysql query returns only one value)
- Insert data in custom table during new post creation
- 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
- How to submit the custom form data in database in WordPress without plugin?
- Updating WordPress [closed]
- Is it safe to increase/alter the size of the wp_post.guid column from VARCHAR(255) to VARCHAR(2048)?
- Duplicator live to wamp https to http
- Website keeps going down, is it a plugin, database, memory problem, or something else?
- Is it possible to recover Deleted users?
- 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?
- register_activation_hook not working
- On the same site, how do I send data from a plugin file to a theme file?
- Text Wrapping in WPDataTables
- Fragmented Static Conversion of WordPress Pages
- Very slow page loads
- Form with response button after on table after submission
- Does anyone recognize these table names?
- Edit a page/post DB data?
- plugin doesn’t retrieve data from database
- Can’t save formdata in DB
- Can’t change login logo & css – older plugin data blocking?
- How do I set WordPress to send 2 different emails based on criteria in the database when someone submits a form?
- can not serialize and insert data from custom form
- How can you call to data in google sheet based on ID number?