Convenient way to display information from MySQL?

Question

PHP

Good day to all, I'm interested in the following question: how can I easily display information from mysql to the site? echo with html code is not an option. Maybe somewhere there are articles about how to do it correctly and conveniently?
it turns out porridge from the code if using echo to display information, I need to somehow make the design as separate as possible, from the software and hardware part, there was an idea with angular, but it’s not clear how to work with bd in Angular

Answer 1

First you need to understand the basic concepts of backend and frontend.
if you have such questions, then you should either find a specialist who is familiar with this, or study the materiel of web projects in general.
angular is the frontend part of the application, i.e. about half of the project, only on the client side, is done in the browser.
I think you can use a regular framework like lumen, or laravel is better right away)) with an eye to the future

Answer 2

You can use JS templating on the client, accept AXAX - JSON and build a DOM tree based on the input. But this case is only suitable for pages that can be indexed. In all other cases - build templating on PyKhe.

Answer 3

Read what a web service is, and in particular, a REST service, or REST API. Read about how JSON can be used to exchange data between a web service (i.e. backend) and a web client (including the frontend in the browser).
It's a different dimension for you now, if you're asking that question.