Reload/refresh table after event - Page 2

Reload/refresh table after event

2

Answers

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    The problem with those tools is I have multiple pages involved. The home page and the datatable page. How would I provide that?

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0
    edited December 2020

    Yes there is an xhr request.

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    Again, I'd be happy with any solution that just makes that page completely reload. Is there another simpler solution?

  • kthorngrenkthorngren Posts: 21,298Questions: 26Answers: 4,944

    The ajax succeeds... the page just won't reload.

    More details are needed. I asked some questions which you didn't answer. The problem is specific to your page. Without seeing the problem it will be impossible to diagnose. At a minimum please post your relevant JS code.

    The page isn't going to reload with ajax.reload(). Only the table will reload assuming its working.

    Kevin

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    The table is working. It loads fine. The issue is getting it to reload.

    This is the js

    function rejectuser(id) {

    $.ajax
    (
    {
    type : "GET",
    url: 'reject.php',
    data: {id:id},
    async: false,
    success : function(data)
    {
    //var result = jQuery.parseJSON(data);
    //alert(data);
    },
    error: function (jqXhr, textStatus, errorMessage)
    {
    alert("error!");
    }
    }
    )

    $('#siteTable3').DataTable().ajax.reload();

    It's called by a button on the datatables page that is a bootstrap tab named #newusers.

  • colincolin Posts: 15,240Questions: 1Answers: 2,599

    As Kevin said, we'll need to see this - so for us to help you, please make a minimum test case for us to debug.

    Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

    Cheers,

    Colin

  • kthorngrenkthorngren Posts: 21,298Questions: 26Answers: 4,944

    Yes there is an xhr request.

    Just to be clear the $('#siteTable3').DataTable().ajax.reload(); sends an XHR request. Does the table contain the data that is in the response?

    Maybe you need to place the $('#siteTable3').DataTable().ajax.reload(); in the Ajax success function to reload once you update is complete?

    If you can't supply a test case then you will need to provide more details of exactly what happens.

    Kevin

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    I moved to success but no change. I'd be happy to provide the pages just not sure where or how. A test case would still include two pages so that doesn't make it any easier to supply.

  • kthorngrenkthorngren Posts: 21,298Questions: 26Answers: 4,944

    If you can't provide a test case we can look at then you will need to do some debugging. I've asked questions that you haven't answered.

    Lets start with this:

    $('#siteTable3').DataTable().ajax.reload();
    

    You said the XHR request is sent but that the table data is not updated. Does the response contain the data you expect? Is the table updated with the data in the response?

    Kevin

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    How do I test that specifically?

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    When I click on the button I get XHR finished loading: GET "http://3.129.25.141/operator/approve.php?id=136".

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    I assume that means it's running.

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0
    edited December 2020

    The home page loads the datatables page into a tab by using <?php include 'newusers.php'; ?>.

    That page sends back this "action"=>"<button id='appprove' onclick='approveuser(" . $row['id'].")'>Approve </button> &nbsp<button id='reject'
    onclick='rejectuser(" . $row['id'].")'>Reject</button>$nbsp" as the button.

    That will run this function in the home page.

    function approveuser(id) {

    $.ajax
    (
    {
    type : "GET",
    url: 'approve.php',
    data: {id:id},
    async: false,
    success : function(data)
    {
    $('#siteTable3').DataTable().ajax.reload();
    //var result = jQuery.parseJSON(data);
    //alert(data);
    },
    error: function (jqXhr, textStatus, errorMessage)
    {
    alert("error!");
    }
    }
    )

    $('#siteTable3').DataTable().ajax.reload();

    }

    in newusers.php the database is defined as

    <

    table id='sitesTable3' class='display dataTable' width="100%">.

    The page continues to show the current data after a button is selected and data is updated. The update removes that record from the listing but the listing is not updating.

    Does this help or is there more I can share somehow?

    Thanks for all your help!

  • kthorngrenkthorngren Posts: 21,298Questions: 26Answers: 4,944

    When I click on the button I get XHR finished loading: GET

    Use the browser's network inspector to see the request and response. The diagnostic steps in this technote will show how.

    At least for me the small code snippets you have provided aren't enough to fully understand what your page is doing. Maybe someone else will have a better idea.

    Kevin

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    I can provide the pages too.

    http://3.129.25.141/operator/home.php
    http://3.129.25.141/operator/newusers.php

    You'd have to login.. user = ctz08@health.ny.gov pw = bit7Wise

    This is the code for the datatables page.

    <?php
    try {

    if (!isset($_SESSION))
    {
    session_start();
    }

    include 'config.php';

    //## Read value
    $draw = $_POST['draw'];
    $row = $_POST['start'];
    $rowperpage = $_POST['length']; // Rows display per page
    $columnIndex = $_POST['order'][0]['column']; // Column index
    $columnName = $_POST['columns'][$columnIndex]['data']; // Column sitename
    $columnSortOrder = $_POST['order'][0]['dir']; // asc or desc
    $searchValue = $_POST['search']['value']; // Search value
    $searchArray = array();

    //## Search
    $searchQuery = " ";
    if($searchValue != ''){
    $searchQuery = " AND concat(firstname, ' ' , lastname) LIKE :name ";
    $searchArray = array('name'=>"%$searchValue%");
    }

    $mysql = "SELECT COUNT(*) as allcount from ( select firstname from users where operatorid = " . $_SESSION['operatorid']. " and (role is null or role = 0)) x";

    //## Total number of records without filtering
    $stmt = $conn->prepare($mysql);
    $stmt->execute();
    $records = $stmt->fetch();
    $totalRecords = $records['allcount'];

    $mysql2 = "SELECT COUNT(*) as allcount from ( select firstname from users where operatorid = " . $_SESSION['operatorid']. " and (role is null or role = 0) " . $searchQuery. ") x ";

    //## Total number of records with filtering
    $stmt = $conn->prepare($mysql2);

    $stmt->execute($searchArray);
    $records = $stmt->fetch();
    $totalRecordwithFilter = $records['allcount'];

    //$columnName = "lastName";
    //$columnSortOrder = "asc";

    //## Fetch records
    $mysql3= "select id, email, concat(firstName,' ', lastName) as name, title, phone, role from users where (role is null or role = 0) and operatorid = " .$_SESSION['operatorid'] . $searchQuery. " order$
    $stmt = $conn->prepare($mysql3);
    // Bind values
    foreach($searchArray as $key=>$search){
    $stmt->bindValue(':'.$key, $search,PDO::PARAM_STR);
    }

    $stmt->bindValue(':limit', (int)$rowperpage, PDO::PARAM_INT);
    $stmt->bindValue(':offset', (int)$row, PDO::PARAM_INT);
    $stmt->execute();
    $empRecords = $stmt->fetchAll();
    $data = array();
    $mycount = $stmt->rowCount();

    //echo "mycount ".$mycount;

    foreach($empRecords as $row){
    $data[] = array(
    "name"=> "<a href='user.php?id=" . $row['id'] . "'>" . $row['name']." </a>",
    "phone"=>$row['phone'],
    "email"=>$row['email'],
    "action"=>"<button id='appprove' onclick='approveuser(" . $row['id'].")'>Approve </button> &nbsp<button id='reject'
    onclick='rejectuser(" . $row['id'].")'>Reject</button>$nbsp",
    );
    }

    //## Response
    $response = array(
    "draw" => intval($draw),
    "iTotalRecords" => $totalRecords,
    "iTotalDisplayRecords" => $totalRecordwithFilter,
    "aaData" => $data
    );

    /*
    echo $mysql . "<br><br>";
    echo $mysql2 . "<br><br>";
    echo $mysql3 . "<br><br>";
    */

    echo json_encode($response);

    }catch(Exception $e) {
    echo 'Message: ' .$e->getMessage();
    }

  • kthorngrenkthorngren Posts: 21,298Questions: 26Answers: 4,944

    I tried logging into both links but get this error:

    Username does not exist

    Kevin

  • kthorngrenkthorngren Posts: 21,298Questions: 26Answers: 4,944

    Also please provide the steps needed to show the problem.

    Kevin

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    I'd try the login again. There was an issue which was resolved (I hope).

    Step is to click on approve or reject.

  • kthorngrenkthorngren Posts: 21,298Questions: 26Answers: 4,944

    The login still isn't working.

    Kevin

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0
    edited December 2020

    Sorry. Typo. czt08@health.ny.com

  • kthorngrenkthorngren Posts: 21,298Questions: 26Answers: 4,944

    Sorry to say that login doesn't work either.

    Kevin

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    What the... I'll take another look. Sorry.

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    Just logged in with czt08@health.ny.gov. Worked fine? If you have a problem again try christopher.thompson@health.ny.gov... same password.

  • kthorngrenkthorngren Posts: 21,298Questions: 26Answers: 4,944

    Now it says bad password.

    Kevin

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    bit7Wise!

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0

    again, sorry.

  • kthorngrenkthorngren Posts: 21,298Questions: 26Answers: 4,944

    The "DOH Dashboard" is displayed. Please provide detailed steps of what to do and what you expect to happen. not sure what to Accept or Reject.

    Kevin

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0
    edited December 2020

    Change to http://3.129.25.141/operator/home.php and click on the new users tab. You'll see records listed. Click approve. The user will be approved and if you refresh the page and go back there's no longer any records which is correct. I just want them to see that immediately so they know they've made their change.

  • cthompsoncthompson Posts: 24Questions: 0Answers: 0
    edited December 2020

    I put some bogus records in so you can try more than once.

  • kthorngrenkthorngren Posts: 21,298Questions: 26Answers: 4,944

    Your table id is sitesTable3:

    <table id='sitesTable3' class='display dataTable' width="100%">
    

    You are using the wrong selector for the ajax.reload(). You have:

    $('#siteTable3').DataTable().ajax.reload(); 
    

    It should be #sitesTable3 with an s in sites. Keep the one you have in the success function so it runs after receiving the ajax response. Remove the one at the end of the function. Also you should remove the async: false, to keep the page from locking up while the request is active.

    Kevin

Sign In or Register to comment.