<a href="">对数据库的操作

Is there a way to update a database using 1 click?

i.e

echo "<a href='".$wpdb->query(" UPDATE partners SET active='no' WHERE partner_id='$active_partner->partner_id' ")."'>Disable</a>";

You need to react on a click with an ajax function.

i.e.

$('#your_button_id').bind('click', function(){
    function_with_ajax();
})

function function_with_ajax(){
    $.ajax({
        here you could call the update.php script and transmit dynamic data
    });
}