If you use the %s in your sprintf statement, $wpdb->insert() will automatically apply single-quotes.
You want to use %f for float, or %d for int/digit.
Related Posts:
- What is the difference between an ORM and an ODM?
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Keeping WP database synced across multiple developers using git
- Checking if Database Table exists
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- How to define composite keys with dbDelta()
- Is it possible to define two databases for one installation?
- Connect forms in WP to external database
- Hook into $wpdb
- How to get site URL if database is disconnected?
- Is it wise to delete post revisions and autosaves from database?
- Improve or optimize a very slow query
- What is the advantage of separating wp_users and wp_usermeta table?
- Multiple WP install with same users database
- “MySQL server has gone away” since update to 3.8
- Using two different DB users on one WP install
- Usage of Direct Database Call Without Caching Error
- Can I transfer a mysql database to another site?
- MySQL Syntax Error upon restoring database from backup [closed]
- Weird issue with database migration and SSL links
- Merge two databases: OLD SITE -> NEW SITE
- Backup another database with BackUpWordPress plugin [closed]
- Easiest Way to Authenticate WP Users Using an External DB?
- Use one WordPress database with multiple instances of one site
- How to use a different database to list and manage comments in the backend
- Who is responsible for data sanitization in WordPress development?
- How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
- Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
- How do I find out the full path of a page’s template?
- I need to get an array from the wordpress database
- Moving minor updates between local and live sites – just database?
- what is the best way to store user created data?
- Use mulitple usernames?
- Using GROUP CONCAT in my-sql query with wp_usermeta table
- Routine to convert custom post meta from old to new value
- “The link you followed has expired” & “Error while saving” messages when adding new post
- input data and output table [closed]
- sanitize POST arrays
- WP character encoding error after sharing post on Facebook �
- Sending data with multi step form to wp database
- Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- WordPress query is not returning proper results
- Localhost to Staging to Development Dynamic WP-CONFIG
- WordPress and user security
- How to share plugin created database tables between two WordPress sites
- Migrating from PDO using SQLite to clean new install using MySQL
- can we add extra table or column in wordpress for adding our data
- Change WordPress URL in sql file via Terminal
- $wpdb->insert Giving duplicates
- Where is phpMyAdmin inside WordPress?
- What can I do when an outside party hacks into my weblog and changes my display name?
- Changing root password in PHPMyAdmin for WordPress Database when going live
- How to properly check if a table exists in WordPress Database using Show Tables Query
- How to delete database without using any plugin?
- Insert Custom Data into wpusers
- Fill custom select field with pages/post titles
- Is my way to change WordPress server is correct?
- Recovering the table wp_usermeta from users
- WordPress database products structure
- Files on Localhost, Database on Server
- No users table in WordPress’s database
- Copying blog from root to /folder (Not moving)
- Is there any way to monitor a MySQL db and check what has changed?
- DB prefix not updating
- How to restore an option_value with serialized data from backup data
- Replacing javascript link in WordPress database without getting mysql syntax errors
- How can i restore a WordPress site with the DB and WordPress Files
- User input to database
- What structure and database storage method should I use for temporary storage that may be written concurrently?
- how to access 2nd Mysqli Database from different server for wordpress
- Error establishing a database connection – WordPress setup, everything else is working
- Restore of database doesn’t show content
- Why theme settings lost when I installed https
- Change user_nickname for author page link
- What is recommended data type and encryption type for password in a database
- Is it safe to add INDEX to a column in WordPress database?
- Restore Old Database Over Newer WP & Plugin Files
- WP website showing blank page after moving from subdomain to main domain
- create a table using user meta custom data
- wpdb query to insert images in to post/page gallery
- Creating a database in my plugin not working
- WPCLI search and replace in a particlar site dir effect another site-dir
- How do I find out from my database what version of WordPress I need?
- How to create a database table?
- get_user_meta and umeta_id
- Extracted CSV as Array for Custom Query Loop
- Hang Up Followed By Can’t select database
- Database error after importing WordPress
- One WP Database outside localhost and two connections
- Send data to database after redirect (and popping out of iframe)
- Pulling values from a sepcific row in table
- import (migration) user database to wp-users
- Create hundreds of users with just ID in phpMyAdmin
- What is best for saving lot of extra detail of user?
- Insert Extra fields added in the front end registration form to DB
- $wpdb->insert not working for last select option
- How to create a table [closed]
- Cant Connect to Database