Refresh variable after update

Question

I am trying to find a way to refresh the count on a class after a successfull mysql update. At the moment I am using a class to display the information and for styling and this works well on page load. Is is possible to refresh a class after update. $ni; stores the result after mysql count.

I have attached the code I am using and would be grateful for any advice. Thanks

html

<ul>
    <li>
      <a href="/domain/admin/test.php" title="Add">New Intake <span class="notification" style="float: right;"><?php echo $ni; ?></span></a>
    </li>
</ul>

php

<?php    
  $sql = mysqli_query($conn, "SELECT count(*) as total FROM act WHERE new = '1'"); // provide db connection object as first parameter
  $rows = mysqli_fetch_assoc($sql);
  $num = $rows['total'];
  $ni = $num;

  if ($ni < 1) {
    $ni = '0';    
  }
?>

You could do this by sending a request to run the PHP via AJAX then update the DOM using the AJAX callback method — Master Yoda
– Master Yoda, Commented Feb 26, 2018 at 11:21
@MasterYoda do you have example please. Just a starter would do. Would I do this within success call? Run another ajax. Thanks — user1532468
– user1532468, Commented Feb 26, 2018 at 11:27

DobromirM · Accepted Answer · 2018-02-26 11:35:29Z

1

You need to make an AJAX call after you execute the SQL update in order to obtain the latest data and insert it in the DOM as mentioned by Master Yoda in the comments.

Example ajax code:

$.ajax({
        url: 'yourURL',
        success: function(msg){
            $(".notification").text(msg);
        },
        error: function(jqXHR, textStatus)
        {
            //Manage your error.   
        }
    });

Explanation: 'yourURL' should be replaced with a link to the php page that calculates the value and returns it. On success that value will be written in the span with class notification. Also you need to execute the ajax code every time you do an updated.

More information about AJAX

edited Feb 26, 2018 at 11:35

answered Feb 26, 2018 at 11:28

DobromirM

2,0272 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1532468 Over a year ago

Thanks very much for starter. Got it working this way:

$.get('/ldomain/admin/requests/boxes/retrieve/refreshBox.php?rtvni=' + 'New Intake', function(data) {           console.log(data);           $(".notification").text(data); });

Collectives™ on Stack Overflow

Refresh variable after update

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related