get data from date between like condition

Question

Hi i am a beginner of the php. trying to do some search function in my project. the admin want to search based on the customer id,phone number, from date and to date. The admin want to search the data individually and also the combination of the search inputs. i want to know the following things.

1. How to fetch the data using multiple AND OR conditions.
2. My date fields are having the date and time combination i have to search the date only.

Please help me to know how to do this. Thank you..