From the Codex, 2nd parameter for the prepare() method:
(int|string|array) The value to substitute into the placeholder. Many
values may be passed by simply passing more arguments in a
sprintf()-like fashion. Alternatively the second argument can be an
array containing the values as in PHP’s vsprintf() function. Care must
be taken not to allow direct user input to this parameter, which would
enable array manipulation of any query with multiple placeholders.
Values must not already be SQL-escaped.
So you can directly pass your input array, as long as you have same number of “%s” placeholders in your query string as the array length.
Btw in your code above the $owner_id, $address1, $address2, $city, $zip, $country variables are undefined. Did you miss extract($inputArray) ?
Related Posts:
- $wpdb->get_row() only returns a single row?
- what is the way to see the currently executing query in wordpress?
- Fetch array with $wpdb
- $wpdb->last_error doesn’t show the query on error
- Theoretical Multi-Server WordPress Setup with Shared Users
- Delete/replace img tags in post content for auto published posts [closed]
- What does wp_update_post() do that the $wpdb class does not?
- $wpdb is get_results escaped
- wpdb-> not adding prefix to custom table
- WordPress insert NOW() in TIMESTAMP column returns all zeros
- $wpdb prepare issue with mysql DATE_FORMAT
- How-To: wpdb Insert Record With Date
- How to pass NULL in where array for $wpdb->update
- Get random row from custom table
- store custom WP table names in a global variable
- wpdb prepare: passing varible number of fields as second argument
- I am not understandinhg $wpdb->prepare correctly
- How to save html and text in the database?
- XOR functionality for meta_query
- Using WPDB class
- How can I migrate mysql_fetch_array to $wbpdb?
- What is _transient_random_seed for?
- Get published posts and pages?
- wpdb get_results() and prepare when to use prepare?
- Foreach loop using $wpdb not results from rows
- Return XML of Post Metadata
- What’s the proper way to add users to my site in order to test things?
- Optimizing WordPress Queries – Removing Group By ID
- External DB Connection [closed]
- Problem in inserting row to custom database table
- sanitize_text_field and apostrophe problem
- $wpdb->prepare with ON DUPLICATE KEY UPDATE
- Code only works every other time its run
- wpdb updating record in wordpress with json adds extra array elements
- How to display a specific category using a custom Query?
- Can’t pass variable in wordpress wpdb->get_results
- AWS Bitnami WordPress – SELECT command denied to user
- WPDB Placeholders and second argument for prepared statements
- PHP Fatal Error – $wpdb a non-object?
- How do I count columns on a custom WPDB query?
- how to get db values without using an loop with wpdb->get_results()
- Custom SQL query ORDER BY term_order
- Trouble inserting string containing quotations marks with wpdb in save_post hook
- How to run wp_insert_post() & wpdb on the background?
- Trying to get variable from WP table and toggle its value
- Set MySQL variables in WPDB
- get_results query with accent
- Save data from a checkbox to a wpdb array
- How to prepare an array of values with $wpdb
- Is querying wpdb directly and skipping actions provided by WP’s core “wp_update_post” a good idea?
- WP-PostRatings: list current user’s rated posts
- $wpdb->insert() doesnt work anymore
- $wpdb query outputs php code instead of executing it
- WPDB Join with custom table
- wpdb query not working
- Where can I see MySQL hostname and port for wp-config.php
- WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
- Using “->” in a page to exceute $wpdb query gives error
- Why is this $wpdb query looping 5 times?
- wpdb query not returning results containing single quotes
- Exclude specific terms from all queries using posts_where or something similar
- $wpdb->get_results not returning an array
- query a newly created table using $wpdb
- Get all sticky posts from one user through user ID
- WPDB Query Question with Category Only
- wpdb result arrray inside an array
- $wpdb->num_rows doesn’t work
- How can I change my meta_query to SQL wpdb query?
- How capturate wpdb exceptions?
- Limit left join
- “This message was added in version X” showing a later version than current one
- Get records from Formidable Table using $wpdb->get_col
- Prepare WPDB with meta key and meta value
- How to get row value from wpdb
- I am using wpdb but it not working perfectly.but if I dont use form data its work
- wont add form details to database or send me mail
- Get last element from wpdb as a string
- Missing argument 2 for wpdb::prepare() [duplicate]
- wpdb->update update the entire table instead of one row
- WPDP related functions look to work but they don’t
- Save customizer default values to DB on theme activation
- Plugin with connection to database – Single function
- Alter the main search query to search posts by coauthor user name
- Update all fields of table with ON DUPLICATE KEY UPDATE command
- Protect custom form from SQL injection
- why nl2br() is adding an extra ?
- How to add more custom fields in user meta table simultaneously
- wpdb->update error
- get unserialized array without using get_option()
- SQL Query to select post title & post ID from a particular category
- Create Table Failed Column Date DateType
- Using $wpdb to update current post
- Checking if meta_value exists for any user
- Can you create a new wpdb that connects to an SQL (not MYSQL) database? [duplicate]
- DBDelta: “table doesn’t exist” for a table that was just created
- query using wpdb in wordpress gets me no result
- $wpdb The query does not contain the correct number of placeholders
- Get count of rows based if column exists in two different tables
- Table wont load into WPDB
- WPDB prepare – like % – placeholders?