BLOGS

Angular 9/8 with PHP and MySQL Database

        Angular is the most advanced and versatile frontend framework, but to build a full-blown application, you need a backend. In this Blog, you will learn to code an Angular with a PHP backend.

Install Angular

  • Installation of the latest version of node.js from https://nodejs.org/en/download/
  • Node.js comes pre-packaged with npm, the package manager, which we’ll use to install the Angular CLI.
  • The Angular CLI is the command line interface to build an Angular app with a few short commands.
    After you installed node.js, run the following command in the terminal to install the Angular CLI:
  •  With the Angular CLI installed on your computer, cd into the folder where you want to create the Angular project, and let the CLI generate the project “hello-world” by typing the command.
  • Running the command will cause the display of these questions that we need to answer in order to set the app:
  • We don’t want a stricter checking nor routing, and the stylesheet format needs to be CSS.
  • We may choose otherwise but for now all we want is to run a very simple app
Once the installation finishes, cd into the newly generated project folder:

And serve the app with the command:

The serve command launches the server and compiles the TypeScript files to JavaScript because browsers can only run JavaScript, not TypeScript.

The –open flag opens the browser in http://localhost:4200

Building a Backend with PHP and MySQL Database

PHP is a language that gives you the flexibility to connect and work with different databases while developing your webpage. There are different databases, both commercial and free to use. Amongst them, MYSQL is the most commonly used database alongside PHP.

MySQL is an open-source, free-to-use relational database management system (RDBMS). It is a fast, simple, and highly scalable program and hence can be used for small as well as huge businesses.

Prerequisites for PHP With MySQL 

This PHP with MySQL will mainly focus on linking and managing a database with your webpages.

  • Basic understanding of SQL language and RDBMS.
  • Basic knowledge of HTML, CSS and PHP.

Software Requirements

To set up the PHP development environment, you mainly need two software, a code editor and a web server package.

You will be using:

  • Visual Studio Code as the code editor.
  • And XAMPP to set up your local web server.

A database is defined as an organized collection of data that makes the data easy to access, manage and modify. Generally, databases use SQL (Structured Query Language) for data manipulation.

The Design of the MySQL Database

For the application design, It’s a simple interface for working with vehicle insurance policies. For the sake of simplicity, you are only going to add the following attributes to the policies database table:

  • number which stores to the insurance policy number,
  • amount which stores the insurance amount.

This is of course far from being a complete database design for a fully working insurance system. Because at least you need to add other tables like employees, clients, coverage, vehicles and drivers etc. And also the relationships between all these entities.

Building a Full-Stack PHP/Angular App

The MySQL database management system installed on your development machine, PHP installed on your system (both these first requirements are required by the back-end project),

Node.js 8.9+ and NPM installed in your system. This is only required by your Angular 9 project.

You also need to have a working experience with PHP and the different functions that will be used to create the SQL connection, getting the GET and POST data and returning JSON data in your code.

Angular 9/8 with PHP and MySQL Database