Your code should look something like this:
$this->table_name="table_name";
$how_much = $this->wpdb->get_var("SELECT COUNT(*) FROM $this->table_name");
We don’t need to use the prepare method, since this is not meant for table names, more here
And also… as you what are trying to do is going not in a good direction… I don’t what to criticize you or anything… But I really suggest you to ask someone who knows better what WordPress can do, about what you need to do, and maybe he will suggest a better approach.
P.S: When you develop something, is good to enable the error/warnings/notices, and have a debugger, to know what’s going on.
Related Posts:
- correct validate and sql query
- correct sql query
- SQL query, error
- Show a different number of posts per page depending on context (e.g., homepage, search, archive)
- What are the common security flaws I need to look for? [closed]
- Making my plugin multi-site compatible
- Creating 20,000 Posts or Pages using a .csv file?
- Is their any way to Extend WPDB class and Overwrite the Default Query Function
- What’s the easiest way to duplicate an entire navigation menu?
- Using nextGen Gallery.. how can I call a list of all Gallery Names?
- Search and replace text across all posts
- Updating WooCommerce variable product stock issue
- bulk post_content update
- How can I get a list of plugins and which blogs are using them?
- What is the easiest way to implement cascading database upgrade for my plugin?
- [Plugin: Posts 2 Posts] How does it work?
- Post query – show posts from specified day and month and whole years
- Plugin Development sqlite or WordPress’ database
- Retrieving a Value from a wp-database
- Plugin echos text from shortcode function in gutenberg page editor
- Problem with creating tables for Plugin
- Prevent duplicate records in plugin table
- WordPress WPforms customization
- How do I run SQL queries on a WordPress web page? [closed]
- Migrating to WordPress Recipe Plugin and Some SQL Issues
- WP Query. Is there a maximum size?
- WordPress and a secondary database?
- plugin code is pulling information from database in one instance and not in other. What is wrong?
- WooCommerce search products between price range using WP_Query
- How to create multiple database tables on plugin activation?
- Does deleting a Plugin via the WordPress admin ‘completely’ remove the code?
- Speeding SQL queries for a large database?
- $wpdb update query in plugin only updating one column
- Create a post builder skin in a plugin
- Taxonomy Drill-Down / Plugin Help – hierarchical queries within plugin?
- How to customize a title by passing query string?
- What is the best way to cache pages on WordPress
- Always get creating a new table with foreign key
- Woocommerce Backend Search by Title and SKU
- add_query_arg not work in admin
- Deactivation Hook does not remove database
- How to return the values from a row where a value occurs for the first time among the rows available?
- How to use apply_filters?
- Using AJAX to run SQL statement and populate dropdown
- Adding CASE in WP_Query
- JOIN and SUM different statement results (Mailster Database)
- How to search post titles with whole words only, but not the exact word only?
- How to get specific column data conditionally in database in WordPress?
- Change language on website and change currency with url query
- Memcaching recurring SQL Queries
- add products to WordPress site automatically
- How to get database connection details without longing to cpanel in WordPress?
- Performing CRUD operations on front end in wordpress
- Displaying different content depending on variable
- How to create algorithm for ordering posts in WordPress?
- Display a number value from mysql query in WP
- Looping the data from WordPress database using foreach
- How To Toggle User_Meta in frontend in a form using PHP
- Get and Update Most Meta Value as an array in HTML form
- WordPress filter from custom table is not working properly
- errno: 150 “Foreign key constraint is incorrectly formed” [closed]
- Multiple Meta key in search
- Having trouble going from Jfiddle to implementing in WordPress :(
- Create Array from data in the OPTIONS table
- Proper way to trigger a MySQL query via link in a plugin
- get_var result empty for query of custom table in plugin admin
- WP-Snap too slow (caused by WP_Query?)
- why the current date do not update
- Custom Table doesn’t create on plugin activation
- Using wp config to connect to a DB from a plugin
- correct validate inputs
- Get all the related data from WordPress DB
- ‘Active lotteries’ only custom query for woocommerce lottery plugin and elementor
- How to change and edit users according to the extension in the URL
- WordPress plugin archive
- MailChimp integration that allows users to select from multiple lists [closed]
- filemtime() warning when enqueuing style within plugin
- How to add social locker on custom fields
- WordPress multi domain – redirect
- problem with sql query in wordpress plugin
- How to add an element right after the article using jQuery?
- How to reset wordpress but not plugins and settings
- How do I avoid having duplicate of plugin in trunk?
- Plugin privelages for “editors”
- Adding a jQuery modal dialog to the admin area
- WordPress Dashboard add user password not working, etc
- Timber: Theme class not fetching the right directory?
- Add external javascript to post template
- wp-admin/admin-ajax.php 400 (Bad Request) plugin
- Check if plugin is active outside of admin screen
- Accounting for search terms that may include a space, using SearchWP
- WordPress DevOps – Environments (Rancher, Kubernetes, etc…)
- Why is every single HTML tag being stripped out of liveblog entries?
- Create Database Tables on Plugin Activation hook
- Media Playlist Plugin
- Transition Post status not working
- How can I add different menus (different style menu) on each page?
- Jquery based image accordian plugin
- Can’t modify plugin function
- Check Plugins in Use by Mutli Site Network