I've read several topics about this and different ppl have different views on the best practice.
In terms of WP, how do I store data to DB the safest way?
This is one insert I'm using now:
$result = $wpdb->insert($table_name , array( 'arena' => $galleryData['arena'], 'year' => substr($galleryData['season'], 2), 'copyright' => $galleryData['copyright'], 'description' => $galleryData['description'], 'path' => $galleryData['path'], 'fk_brand_id' => $galleryData['brand'] ), array( '%s', '%d', '%s', '%s', '%s', '%d' ));
Reading a book, another way of inerting data is doing this:
$sanitized_sql = $wpdb->prepare(“ ’INSERT INTO my_plugin_table SET field1 = %1$d, field2 = %2$s, field3 = %3$s’, 32, ‘Aaron Brazell’, ‘Washington, D.C’); $wpdb->query( $sanitized_sql );
Do I still need to sanitize data using
I'm just confused on what method is the better for safely storing data to DB.
So should I or should I not sanitize data before input?