The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/showthread.php 28 require_once





× This forum is read only. As of July 23, 2019, the UserSpice forums have been closed. To receive support, please join our Discord by clicking here. Thank you!

  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database update function
#1
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
  Reply
#2
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.
  Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)