Answers

• rf1234 Posts: 2,991Questions: 87Answers: 421

  January 2023 edited January 2023

  But how can I check this in client side before datables tries to render the table?

  You could make a synchronous ajax call to check - or a promise.

  I found this in my code somewhere ...

  $.ajax({
      type: "POST",
      url: 'actions.php?action=checkValidLogin',
      async: false,
      data: {
             ....
      },
      dataType: "json",
      success: function(data) {
          if (data.validLogin) {
              loginSettings(data);
          } else {
              notLoggedInSettings();
          }
      }
  });
  
• Tronik Posts: 122Questions: 28Answers: 1

  January 2023

  I could do that, but then I need to execute that with every search/edit?
  Just seems a bit unnecessary instead of checking valid sessions server side which is done anyway, and send back a false response
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  January 2023

  Have the server return valid JSON such as:

  {
    "data" : [],
    "sessionExpired": true
  }
  

  And listen for xhr which will check for the sessionExpired and perform whatever action you need (reload to a login page for example).

  Allan
• Tronik Posts: 122Questions: 28Answers: 1

  January 2023

  Yes, I found another thread dealing with the same issue which was solved with xhr event.

  This is my solution

  in PHP

  session_start();
  
  if (!isset($_SESSION['user']))
  {
      $data['code'] = 401;
      $data['data'] = [];
      $data['message'] = 'Session expired';
      echo json_encode($data);
      die();
  }
  

  And on client

  $("#table").on('xhr.dt', function ( e, settings, json, xhr ) {
      if (json.code === 401) 
      {           
          location.href = '../login/'
      }
      else
          console.log('valid session')        
      });