DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
≡ Show site navigation

Please help me. The total number of records and the number of pages are not displayed correctly

Please help me. The total number of records and the number of pages are not displayed correctly

mdanekmdanek Posts: 6Questions: 1Answers: 0
in Free community support

Answers

  • kthorngrenkthorngren Posts: 21,343Questions: 26Answers: 4,954
    edited September 2022

    You have the page length set to 10 with 5 rows showing. Based on this information the info in the screenshot is correct.

    The best thing to do is to provide a link to your page or a test case showing the issue so we can help debug. If you can't link to a test case then provide more details so we understand your environment. Start with the following:

    I set the number of entries per page to 5

    Where/how did you set this?

    Is your table DOM sourced or are you using Ajax?

    Are you using server side processing?

    Any other details you think might help us understand the problem.

    Kevin

  • mdanekmdanek Posts: 6Questions: 1Answers: 0

    Hello, thank you for your reply.
    I am a beginner. I will try to answer your questions. Although I don't know if I fully understood them.
    I have created the database on my computer in phpMyAdmin. I have WampServer installed.
    I have my project in Laravel 9. I view my project on localhost. At this early stage of my learning, I tried to create screens for simple CRUD operations. I managed to do that. Adding records to the database works fine for me. Paging worked fine. For this I used a simple table without displaying information in the bottom left of the table (showing... entries). I hadn't used Datatable back then!
    Only then did I discover Datatable. I wanted to implement Datatable (Bootstrap 5 version) in my project. Well, then you already know my problem.
    I am also sending you my view (index.blade.php) in the attachment.
    Although I probably didn't answer all of your questions, did it at least help you understand my problem a little more? I will also send you more information when you write me what kind. I would also send you the whole project, I have no problem with that, I just don't know how to do it. That's why I'm sending only 1 index.blade.php file so far.

    Thank you for your time and willingness to answer me. Miro

  • kthorngrenkthorngren Posts: 21,343Questions: 26Answers: 4,954

    The index.blade.php isn't attached. You can copy/paste it into the thread or provide a link to the code, like github or whatever you use.

    If you implemented paging originally before Datatables I suspect that is still implemented. Likely you will want to remove the paging and return all the DB data and let Datatables perform the paging in the client.

    Kevin

  • mdanekmdanek Posts: 6Questions: 1Answers: 0

    yes, I implemented Paginator (Bootstrap) before I started using Datatable. But even if I comment out these 2 lines, it still doesn't work. Posted index.blade.php in the following comment to the thread.

  • mdanekmdanek Posts: 6Questions: 1Answers: 0

    I send index.blade.php:
    <!DOCTYPE html>
    <html lang="en">
    <head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Dátový inventár MF SR</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.2.0/css/bootstrap.min.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/1.12.1/css/dataTables.bootstrap5.min.css">

    </head>
    <body>
    {{-- @extends('layouts.app')
    @section('content') --}}

    ČÍSELNÍK ZDROJOV:
    @if(count($data) > 0) @foreach($data as $row) @endforeach@else@endif
    # Zdroj - názov Zdroj - skratka MetaIS - kód Akcia
    {{ $loop->iteration }} {{ $row->zdroj_nazov }} {{ $row->zdroj_skratka }} {{ $row->metais_kod }} id) }}"> @csrf @method('DELETE') id) }}" class="btn btn-primary btn-sm">Detail id) }}" class="btn btn-warning btn-sm">Aktualizovať Odstrániť
    No Data Found
    $(document).ready(function () { $('#example').DataTable(); });

    </body>
    {{-- @endsection --}}
    </html>

  • mdanekmdanek Posts: 6Questions: 1Answers: 0

    and I also send the ZdrojController file (as I mentioned before, I use Laravel 9), where I have used the Bootstrap Paginator (I implemented it before using Datatable):

    <?php

    namespace App\Http\Controllers;

    use App\Models\Zdroj;
    use Illuminate\Http\Request;

    class ZdrojController extends Controller
    {
    /**
    * Display a listing of the resource.
    *
    * @return \Illuminate\Http\Response
    */
    public function index()
    {

        $data = Zdroj::latest()->paginate(5);
    return view('zdroje.index', compact('data'))->with('i', (request()->input('page', 1) - 1) * 1);
}

/**
 * Show the form for creating a new resource.
 *
 * @return \Illuminate\Http\Response
 */
public function create()
{
    return view('zdroje.create');
}

/**
 * Store a newly created resource in storage.
 *
 * @param  \Illuminate\Http\Request  $request
 * @return \Illuminate\Http\Response
 */
public function store(Request $request)
{
    $request->validate([
        'zdroj_nazov'   =>  'required',
        'zdroj_skratka' =>  'required',
        'metais_kod'    =>  'required',
    ]);

    $zdroj = new Zdroj;

    $zdroj->zdroj_nazov = $request->zdroj_nazov;
    $zdroj->zdroj_skratka = $request->zdroj_skratka;
    $zdroj->metais_kod = $request->metais_kod;

    $zdroj->save();

    return redirect()->route('zdroje.index')->with('success', 'Zdroj bol úspešne pridaný do databázy.');
}

/**
 * Display the specified resource.
 *
 * @param  \App\Models\Zdroj  $zdroj
 * @return \Illuminate\Http\Response
 */
public function show($id)
{
    return view('zdroje.show', ['zdroj' => Zdroj::findOrFail($id)]);
}

/**
 * Show the form for editing the specified resource.
 *
 * @param  \App\Models\Zdroj  $zdroj
 * @return \Illuminate\Http\Response
 */
public function edit(Zdroj $zdroj)
{
    //
}

/**
 * Update the specified resource in storage.
 *
 * @param  \Illuminate\Http\Request  $request
 * @param  \App\Models\Zdroj  $zdroj
 * @return \Illuminate\Http\Response
 */
public function update(Request $request, Zdroj $zdroj)
{
    //
}

/**
 * Remove the specified resource from storage.
 *
 * @param  \App\Models\Zdroj  $zdroj
 * @return \Illuminate\Http\Response
 */
public function destroy(Zdroj $zdroj)
{
    //
}

    }

  • mdanekmdanek Posts: 6Questions: 1Answers: 0

    I want to tell you that I managed to solve the problem. I started a brand new project and it's already working for me. The problem was probably that in the project where it didn't work for me, I had different settings imported according to different YouTube tutorials and those were causing the problem. I couldn't identify what exactly was causing the problem, but that would probably be more complicated to find out exactly the cause. In any case, I want to thank you for your answers and your time. Miro

Sign In or Register to comment.

DataTables

DataTables designed and created by SpryMedia Ltd.
© 2007-2023 MIT licensed. Privacy policy. Supporters.
SpryMedia Ltd is registered in Scotland, company no. SC456502.