数据库更新时刷新屏幕数据

Question

I have this table:

http://puu.sh/drvIK/62086e6be8.png

When clicking the Edit button, the user gets moved to this page:

http://puu.sh/drvML/4a2652e48d.png

When they select aanpassen (Accept in English) the database gets updated:

$sql="UPDATE IGNORE `personen` 
        SET gebruikersnaam = :gn, 
            wachtwoord = :ww, 
            voornaam = :vn, 
            tussenvoegsel = :tv, 
            achternaam = :an, 
            telnummer = :tn,
            opmerking = :op, 
            email = :email, 
            adres  = :adres, 
            foto = :foto 
       WHERE id = '".$_REQUEST['id']."' ";

When this finishes I forward the user back to the table in the first screenshot:

$this->forward('docentenOverzicht','directeur');

My problem is that this table still looks the same, the new data isn't in this table until the user refreshes his page, yet I want it to be updated as soon as they get forwarded to this page.

I'm sure it's a fairly simple fix, I just can't find anything on it.

Answer 1

You can set id for table row. ( 23 can be id of record )

<tr id='t23'><td>Name</td></tr>

And after update from database, you can refresh only table tr with ajax.

$.ajax({
        url: 'getData.php',
        method: 'GET',
        data: 'recordId=' + recordId,
        success: function(updatedData){
             $("#t23").html(updatedData);

        }
    });