PHPCG analyzes your database intelligently.
To obtain the best results, it is recommended to follow some good practices.
INSERTstatements and throw an error if the insert failed.
products.categories_id = categories.idwill allow you to:
* Absolutely required
** Highly desirable
There are many applications, free or paid, to build your database and manage the types of fields, constraints and relationships between tables, the most common being phpmyadmin, directly accessible on PHP servers.
You can of course use the application/software of your choice according to your own preferences.
However, we recommend the excellent MySQL Workbench (the official software released by MySQL team), available free of charge here: https://www.mysql.com/products/workbench/
MySQL Workbench allows you to build your databases simply, and synchronize them with your server
Once installed and connected with your server, you will benefit from a reliable and efficient tool.