How to show data on Mat table from PHP and mysql

1

Hello community. I am new to Angular and I want to show data on Mat table using PHP and mysql. Can anyone help me?

3

Yah sure, I am getting these errors and below is my code as well

Error:
Brother there are 5 errors on app.component.ts file

  1. Line 16, A class member cannot have the ‘const’ keyword.ts(1248)
  2. Line 21, Argument of type ‘Object’ is not assignable to parameter of type ‘Applications’.
    The ‘Object’ type is assignable to very few other types. Did you mean to use the ‘any’ type instead?
    Type ‘Object’ is missing the following properties from type ‘Applications’: id, email, username
  3. Line 22, Property ‘displayedColumns’ does not exist on type ‘AppComponent’.ts(2339)
  4. Line 23,Property ‘dataSource’ does not exist on type ‘AppComponent’.ts(2339)
  5. Line 23, Argument of type ‘Applications’ is not assignable to parameter of type ‘unknown’.
    Type ‘Applications’ is missing the following properties from type ‘unknown’: length, pop, push, concat, and 26 more
  1. import {Component, OnInit, ViewChild} from ‘@angular/core’;
  2. import {MatSort, MatTableDataSource, MatPaginator} from ‘@angular/material’;
  3. import { HttpClient } from ‘@angular/common/http’;
  4. export interface Applications {
  5. id: number;
  6. email: string;
  7. username: string;
  8. }
  9. @Component({
  10. selector: ‘app-root’,
  11. templateUrl: ‘./app.component.html’,
  12. styleUrls: [’./app.component.css’]
  13. })
  14. export class AppComponent {
  15. posts: any;
  16. public const apps: Applications = new Array();
  17. title = ‘my-angular-app’;
  • constructor(private http: HttpClient) {
  1. this.http.get(‘my localhost php file’).subscribe(data => {
  2. this.apps.push(data);
  3. this.displayedColumns = [‘id’, ‘email’, ‘username’];
  4. this.dataSource = new MatTableDataSource(this.apps[0]);
  5. }, error => console.error(error));
  6. }
  7. }