+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: Database update function (/showthread.php?tid=328)
Database update function - kampfaffe - 10-28-2016
Hello,
last time I have got here quite big help. I hope now you can also help me. I do not know a lot in this area. My "users" table looks currently like this:
http://prnt.sc/d03usi
Here you can see that there is a new column called "bewerbung". The normal value is 0. Now I wanted to make it so, if someone sends a form, this value is changed to 1.
I have understood that I need as the first following:
$db = DB::getInstance();
And then: $db->update();
I would want that the abovementioned value of the user is changed who is logged in currently. The name of the database is "sanilogin"
I hope for help.
Best regards,
kampfaffe
Database update function - mudmin - 10-28-2016
I think this is what you're looking for
if(!empty($_POST)){
//do all your form updating here
$fields = array(
'bewerbung' => 1,
);
//The update method needs to know the table, the id it is supposed to update, and what field(s) to update
$db->update('users',$user->data()->id,$fields);
}
That should do it.