foreach variable to update databse wordpress

Vote count:

-1

how to give a variable to update wordpress database?

if instead of a variable, i give number is ok, i think this is a mistake.

i greet :)

    global $wpdb;
    $wpdb->teams = $wpdb->prefix.'teams';
    $retrieve_data = $wpdb->get_results( "SELECT * FROM $wpdb->teams WHERE moder = 'nie'" );

    foreach ($retrieve_data as $retrieved_data){
        echo "<form method='post'><table><tr>";
        echo "<td>".$retrieved_data->id."</td>";
        echo "<td>".$retrieved_data->nazwa."<input type='hidden' name='id'>".$retrieved_data->id."</input><input type='submit' value='OK' /></td>";
        echo "</tr></table></form>";
    }

    $id = $_POST['id'];
    settype($id, 'int');
    $wpdb->update( 'teams', array( 'moder' => 'tak' ), array( 'id' => $id ));

asked 1 min ago

Sebastian Sebek

1

foreach variable to update databse wordpress