Remove all array elements except what I want?

Question

I have controller that takes post parameters from HTML form, it will then send them to model that will insert the array into Cassandra database.

It is SQLInjection proof, because it's NoSQL, however what I'm afraid is that user can just simulate 100k post parameters or just add some that I don't need and it will be inserted into database. How can I make sure that only the values I need will stay in my array.

Example:

$post = ['parent_id', 'type', 'title', 'body', 'tags']; // Good $post = ['parent_id', 'type', 'title', 'body', 'tags', 'one', 'two', 'three'] // Bad 

How do I make sure that my array will unset all the elements that are not in good example?

Answer 1

By whitelisting the entries you do expect.

<?php $post = array(      'parent_id' => 1,     'type' => 'foo',      'title' => 'bar',      'body' => 'foo bar',      'tags' => 'foo, bar',      'one' => 'foo',     'two' => 'bar',     'three' => 'qux' );  $whitelist = array(     'parent_id',     'type',     'title',     'body',     'tags' );  $filtered = array_intersect_key( $post, array_flip( $whitelist ) );  var_dump( $filtered ); 

Anyway, using Cassandra as a data-store is of course not a reason not to do validation on the data you're receiving.