Home Angular 10 Solved – Angular 11 Datatable | Dynamic Data | No Data Available in Table

Solved – Angular 11 Datatable | Dynamic Data | No Data Available in Table

by therichpost
Published: Last Updated on 17 comments
Solved - Angular 11 Datatable | Dynamic Data | No Data Available in Table

Hello friends, welcome back to my blog. Today in this blog post, I am going to show you, Solved – Angular 11 Datatable | Dynamic Data | No Data Available in Table.

Angular 11 Datatable

Guys, the main purpose of making this post that, the most of my blog and my YouTube channel viewers have issue related to Angular Datatable with Dynamic Data and issue is “No Data Available in Table” but now in this post, I am sharing the few lines of code and with that Angular Datatable dynamic data “No Data Available in Table” will be gone.


Angular 11 came and if you are new then you must check below link:

  1. Angular11 Basic Tutorials

Friends now I proceed onwards and here is the working code snippet for Solved – Angular 11 Datatable | Dynamic Data | No Data Available in Table and please use carefully this to avoid the mistakes:

1. Firstly friends we need fresh angular 11 setup and for this we need to run below commands but if you already have angular 11 setup then you can avoid below commands. Secondly we should also have latest node version installed on our system:

npm install -g @angular/cli 

ng new angulardatatable //Create new Angular Project

cd angulardatatable // Go inside the Angular Project Folder

ng serve --open // Run and Open the Angular Project

http://localhost:4200/ // Working Angular Project Url

2. Now friends, here we need to run below commands into our project terminal to install datatable modules, bootstrap(for good looks), jquery  modules into our angular application:

npm install jquery --save

npm install datatables.net --save

npm install datatables.net-dt --save

npm install angular-datatables --save

npm install @types/jquery --save-dev

npm install @types/datatables.net --save-dev

npm install bootstrap --save

3. After done with commands add below code into you angular.json file:

...
"styles": [
              ...
              "node_modules/datatables.net-dt/css/jquery.dataTables.css",
              "node_modules/bootstrap/dist/css/bootstrap.min.css",
            ],
            "scripts": [
            "node_modules/jquery/dist/jquery.js",
            "node_modules/datatables.net/js/jquery.dataTables.js",
            "node_modules/bootstrap/dist/js/bootstrap.js",
            ]
...

4. Now friends, we need to run below commands to create service file and run our angular project:

ng g service crud

ng serve --o

5. Now friends we just need to add below code into src/app/app.module.ts file:

...

import { HttpClientModule } from '@angular/common/http';
...
imports: [
...

HttpClientModule
]

6. Now friends we just need to add below code into src/app/crud.service.ts file:

import { Injectable } from '@angular/core';
import { HttpClient } from '@angular/common/http';
@Injectable({
  providedIn: 'root'
})
export class CrudService {

  constructor(private http:HttpClient) { }
  public getusers()
    {
        //API request to php file
        return this.http.get('http://localhost/users.php');
    }
}

7. Now friends we just need to add below code into src/app/app.component.ts file:

...

import { CrudService } from './crud.service'; 
declare let $: any;

export class AppComponent  {
  data = [];
  dtOptions: any = {};
  constructor(private crudservice: CrudService) {}

  ngOnInit() {
  
  
    this.crudservice.getusers().subscribe((ret: any[])=>{
        
          this.data = ret;
         
          setTimeout(()=>{                          
            $('#datatableexample').DataTable( {
              pagingType: 'full_numbers',
              pageLength: 5,
              processing: true,
              lengthMenu : [5, 10, 25],
              order:[[1,"desc"]]
          } );
          }, 1);
          
          
      });
      
    
     
      
    }
}

8. Now friends we just need to add below code into src/app/app.component.html file to see the output on browser:

<table class="table table-hover table-bordered" id="datatableexample">
    <thead>
      <tr>
        <th>ID</th>
        <th>Email</th>
        <th>Username</th>
        
      </tr>
    </thead>
    <tbody>
   
       
          <tr *ngFor="let group of data">
            <td>{{group.id}}</td>
            <td>{{group.email}}</td>
            <td>{{group.username}}</td>
   
           
          </tr>
       
     
     
      
    </tbody>
  </table>

9. Now friends here is my php code snippet to fetch data and show  into angular 11  and I added this code into my xampp/htdocs/users.php file:

//Please create users database inside phpmysql admin and create userdetails tabel and create id, email and username fields

<?php
//Please create users database inside phpmysql admin and create userdetails tabel and create id, email and username fields

$servername = "localhost";
$username   = "root";
$password   = "";
$dbname     = "users";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
    //get all users details
    $trp = mysqli_query($conn, "SELECT * from userdetails");
    $rows = array();
    while($r = mysqli_fetch_assoc($trp)) {
        $rows[] = $r;
    }
    print json_encode($rows);

?>

Now we are done friends. If you have any kind of query or suggestion or any requirement then feel free to comment below.

Note: Friends, I just tell the basic setup and things, you can change the code according to your requirements. For better understanding must watch video above.

I will appreciate that if you will tell your views for this post. Nothing matters if your views will be good or bad.

Jassa

Thanks

You may also like

17 comments

Akshay Bhaskare February 5, 2021 - 10:06 am

problem is still “no data available in table”

import { Component,OnInit } from ‘@angular/core’;
import { Router } from “@angular/router”;
import { AuthService } from ‘../../../services/auth.service’;

@Component({
selector: ‘app-totaljoining’,
templateUrl: ‘./totaljoining.component.html’,
styleUrls: [‘./totaljoining.component.css’]
})
export class TotaljoiningComponent implements OnInit {
data: [];
res: [];
dtOptions: DataTables.Settings = {};

constructor( public router: Router , private authService : AuthService) { }

ngOnInit(): void {
this.authService.getverifiedusers().subscribe(
res => {
this.data = res[‘data’];
});

this.dtOptions = {
pagingType: ‘full_numbers’,
pageLength: 10,
lengthMenu : [5, 10, 25],
processing: true,
};
}

}

above is my .ts code

and here is my html code

Combined All Table

Name
Email-ID
Verified
Sponsor ID
Contact No
View

{{ data.users_name }}
{{ data.users_email }}
{{ data.users_verification }}
{{ data.users_APID }}
{{ data.users_contact_number }}

View

Name
Email-ID
Status
Sponsor ID
Contact No
View

Reply
kalidass March 4, 2021 - 7:34 am

Did you used ngFor on table? in your html code file?

Reply
Etienne BELEMGNEGRE March 20, 2021 - 11:56 am

thanks, that’s work for me

Reply
Ajay Malhotra March 20, 2021 - 4:32 pm

Great 🙂

Reply
Ajay April 8, 2021 - 9:45 pm

responsive not working.. can you please share an example of responsive

Reply
Ajay Malhotra April 9, 2021 - 4:09 am

you just need to add bootstrap class table-responsive.

Reply
algassby April 27, 2021 - 12:52 pm

Hello everyone,
i have No data available in table
and i change my code like that and i always have the same error
setTimeout(()=>{
$(‘#user-table’).DataTable( {
retrieve: true,

pagingType: ‘full_numbers’,
processing: true,
pageLength: 10,
lengthMenu : [5, 10, 25,50,75,100],
order:[[1,”desc”]]
} );
}, 3000);
thanks for help.

Reply
Ajay Malhotra April 27, 2021 - 3:30 pm

Great and thanks.

Reply
Pankaj Sunal May 20, 2021 - 5:15 pm

Hi ! Below alert is coming in the browser while loading datatable

DataTables warning: table id=datatableexample – Cannot reinitialise DataTable. For more information about this error, please see http://datatables.net/tn/3

Reply
Pankaj Sunal May 20, 2021 - 5:29 pm

Thanks !! Actually i was initializing datatables twice. Once in component and other is in HTML.
Removed from HTML and it is resolved.
*
*

Reply
Ajay Malhotra May 20, 2021 - 5:34 pm

Great.

Reply
JPablo October 1, 2021 - 10:23 pm

After one week trying all tutos that I found finally this works for me!! thak you so much!! you’re the best, please don’t stop of made tutos like this!

Greetings from Mexico

Reply
Ajay Malhotra October 2, 2021 - 4:00 am

Great and welcome.

Reply
vivek December 16, 2021 - 11:46 am

thank you so much bro its working now

Reply
Ajay Malhotra December 16, 2021 - 5:09 pm

You are welcome 🙂

Reply
jagadish February 3, 2022 - 6:14 pm

its working but not exactly why because i do edit it will fecth all the data from DB>

Reply
Anil July 19, 2022 - 4:41 am

Great Thanks

Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.