Is BEM applicable to MySQL?

Question

PHP

Are the fields in the table named according to the pattern table_name__cell_name__type, for example users__banned__flag, so that PDO can figure out which table the value is in when joining and how to secure the data?
Is it applied or bicycle?

Answer 1

Answer 2

ORM is used for this.

Answer 3

I can answer for PDO.
1. PDO has nothing to do with requests. PDO does not write SQL for you, nor does it make it secure. You can name the columns whatever you want, PDO is a no-brainer.
2. To secure data, you should use **prepared expressions.**