CI4: stored procedures/functions for Select / Drop down list

want recommendation for Select List ( some says Dropdown List, Select List, List of  Values, Combo box etc. ) that which is in best practices... calling stored procedures/functions from db or write a function in .php file? please guide, which is the better way to write code once (reusable code) and call it from anywhere within app. or any misconception here as of my lack of knowledge?
regards

@Ahmed Haroon,

They both work (don't forget about database views either). Pick one and go with it. I personally prefer either straight query calls or database view calls. I don't think there is a best practice as much as a preference of how you wish to obtain the data.

@Ahmed Haroon,

They both work (don't forget about database views either). Pick one and go with it.  I personally prefer either straight query calls or database view calls.  I don't think there is a best practice as much as a preference of how you wish to obtain the data.

thanks @php_rocs for your input and sharing your experience. 
regards