prepare accepts three placeholder arguments— ” %s (string), %d (integer) and %f (float)”. You have used %i. That isn’t going to get through the sanitization process. That is why you are getting 0. You need %d instead.
Related Posts:
- Getting wrong relationship value in $args in wp_Query?
- Retrieving custom fields with $wpdb->get_results
- Display only certain posts based on visitor’s country?
- Really simple query giving error in SQL syntax
- How to add SQL file with PHP to WordPress database [closed]
- SQL query for custom taxonomy slugs
- How to optimize multiple insert into wordpress database
- Using AND and bracket grouping in SQL not working
- How to store sensitive user data (passwords)
- Organising and completing posts (mark as read and hide)
- I can’t write in my DB using $wpdb->insert
- How to add chunk of php, html, and sql code to variable an append to $content
- select rows based on exact time (hours, minutes and seconds)
- Is get_option function cached?
- How to include jQuery and JavaScript files correctly?
- $_POST form request with admin-post
- How can I configure Docker for developing and deploying a custom theme?
- How do I log plugin (cron) actions?
- How can I run AJAX on a button click event?
- What is the difference between using global $current_screen and get_current_screen()?
- Adding pre-publish checks with Gutenberg
- Error getting correct blog_id on MU from functions.php
- How Do I Make WordPress Run an Event Every Day?
- How can I change the frequency of a scheduled event?
- How to filter $post->post_content prior to save
- How to get data from WordPress $wpdb into React Gutenberg Blocks Frontend?
- How to check if certain plugin exists and in expected version
- Error : “Updating failed: The response is not a valid JSON response” with custom shortcode
- array_map() for sanitizing $_POST
- Is there a faster way than wp_insert_post to add content to a blog
- How to include external library in wordpress plugin
- Delete a specific item menu when I deactivate my plugin
- Ajax in WordPress – path issue
- Platform/Website that Supports Crowd-Funded WordPress Projects? [closed]
- Get user id for delete and update selected user
- How can I call template partials inside my custom plugin
- Decrease RSS cache time in plugin?
- Add version query tag to all images
- Creating table with plugin is not working
- How to store a medium amount of options?
- How to delete an user including data from custom database tables
- Add custom element ID depending where the widget place is, sidebar or footer
- My plugin class doesn’t work! [closed]
- Beginner advice
- Call PHP file within a plugin to activate function
- add_action not calling back to function
- Example Dashboard Widget, Cancel not working
- Woocommerce checkout update totals with datepicker
- Multiple options pages validation for a plugin
- How to get plugin activate URL to use URL vars?
- rewrite URL based on selected taxonomy for post page
- Woocommerce – Convert Delivery method into a custom field
- Prefixing plugin hooks (actions/filters) with a wrapper class or functions
- get_option() not returning expected value from plugin
- Woocommerce Composite Products – Add a composite product to cart programmatically via ajax [closed]
- Testing Rewrite Rules with PHPUnit
- Add a page in admin without adding menu item
- Including third party libraries in plugin [closed]
- Possible to get all posts with my shortcode?
- Avoid updating post when sending POST or GET request to post.php
- should i be checking for jquery before enqueing it in a plugin
- WordPress Specified file failed upload test
- WordPress theme options Menu
- Add information to HTTP Header in WordPress Plugin
- Catching Gutenberg sidebar switch event
- Can’t retrieve body params from PUT endpoint using formdata
- Redirect in WordPress plugin
- Converting data-name editor plugin to Gutenberg plugin
- Workflow for new importer plugin – your advices?
- Use options to control jQuery plugin
- Including template in shortcodes
- How to exclude categories from get_categories() select list inside a widget admin panel
- How to automatically activate a plugin on install
- disable defaault wordpress comments from a plugin
- WordPress plugin development theme issue
- add_editor_style to the blog editor view (Gutenberg?)
- Trying to run a Ajax request from a checkout form in woocommerce via a custom plugin
- Securing custom rest API endpoints with public access from PWA
- By adding “?login – failed” code unable to access my dashboard
- jQueryUI draggable doesn’t work in WordPress plugin
- call funcution when clicking submit
- Creating a return url for getting data from external api
- How to prevent users from deleting their accounts?
- How do I get a reference to the HTML memory buffer while the page is being constructed?
- Is it possible to restore an expired transient?
- How to Maintain url on form submit
- Experts opinions needed: How (in)secure is this approach?
- Plugin Modification Change Functionality For Logged User Only
- add_option_{$option} action hook not being called
- Remove all capabilities in separate method fails versus included in method
- Hook for plugin to show content for certain urls
- action callback, for action dispatched as reported by hook sniffer, not called
- variable created in page.php is null inside of header.php
- Access WordPress Tag Function From Modal
- add short code not working
- how can I insert a link on login page
- Shortcode attribute “title” doesn’t appear in $atts array
- Allow HTML in product attributes and variation for WooCommerce
- How do I modify the error code array used by “shake_error_codes” filter?
- How do I add multiple custom menu Woo-commerce my account page?