I am having challenges creating a database in phpmyadmin which I need to fetch information from a registration form to include picture upload, select menu and text area datas. What is the best approach to go about it.

Use a blob, medium blob or long blob. Do some research to know which suits what you are doing. But you are better of saving the images to a directory and then saving the directory path(link/url) in your database

Javanian: Use a blob, medium blob or long blob. Do some research to know which suits what you are doing. But you are better of saving the images to a directory and then saving the directory path(link/url) in your database

Exactly. That's what I did for my site in the signature...

dont store your files in the database directly.
Best practice nowadays is to store it in your directory, rename it to a meaningful name and then store that filename in your database as a varchar field.

a 100 character length varchar field should be enough if your naming rules are smart e.g userid_6letterformname_6digitdate.jpg like 00898_schreg_140313.jpg.

All the best.

Storing images directly into databases isnt a good idea.
It makes your db unecessarily too large, causes a deal of bottleneck in both READ and WRITE activities

blob will be it, but it's always a bad idea to store the actual binary data in the database.
store the reference and save the data in a folder.

Thanks everyone.