How to speed up project development?

Question

MySQL

I'm going to do a project aggregator of certain services. I used to have about 2-3 years of PHP development experience. Used CodeIgniter as a framework. The question arose of how to speed up the process from creating a prototype and project design to a working web application.
It seems to me that most of the time is spent on designing the database, are there any solutions in which I could dynamically create table fields in the database in the code and get a "wrapper" to this table in PHP. For example, a project needed to create two tables: companies and categories. How to quickly create these tables in MySQL and not go into phpMyAdmin. Or by creating a class, get a table as an output. It's hard to explain, but I'm sure those who know will understand what I'm talking about. Thank you!

Answer 1

1. Use a set of classes that allows you to quickly create admin interfaces for tables and forms based on models. Models must have a description of the fields, links, validation, you can start with this CRUD Model or, more seriously , phpactiverecord
2. You can look towards ready-made admin interfaces for CI - Bonfire
3. Create and use modules repeatedly, they are also functional blocks of the page: menu, slider , news list, product description, etc. This will speed up development in the future.

Answer 2

Use frameworks that allow you to do without direct work with the database. Rails, Django. PHP analogs: Symfony, CakePHP, but it's better to learn a normal language

Answer 3

DoctrineORM is widely used for these tasks, but we can forget about the performance of our application once and for all.

Answer 4

If you need to create a table from php, then these are migrations, yii supports them for example.
But isn't it easier to design and create a database, and then form CRUD?