[PHP] Select Query with Multiple Optional Values

[ben...@gmail.com]

Trying to find best way to accomplish following scenario.  Looking to search
inventory through a POST form, have the following optional fields to search
by: Product Name, Color, Size, and Status.  Search maybe for the Product
Name and/or Color or they may search for just the Color or all 4 fields.  I
am trying to find the most efficient way to do this without having 100
different if statements.