Tell me, please, how to make the data correctly entered, and then it repeats 5 times. It is necessary that when replenishing from a certain amount, several tanks were given as a gift, but it turns out that 5 times the amount is replenished, and instead of 1p when replenishing, 5r comes to the balance.

$serebro = intval($ins_sum <= 0.01) ? ($serebro + ($serebro * 0.30) ) : $serebro; $asdd_tree = ( $ik_payment_amount >= 99.99) ? 1 : 0; $qadd_tree = ( $ik_payment_amount >= 499.99) ? 4 : 0; $wadd_tree = ( $ik_payment_amount >= 999.99) ? 1 : 0; $ssadd_tree = ( $ik_payment_amount >= 2499.99) ? 3 : 0; $vadd_tree = ( $ik_payment_amount >= 4999.99) ? 6 : 0; $lsb = time(); $to_referer = ($serebro * 0.10); $db->Query("UPDATE db_users_b SET money_b = money_b + '$serebro', b_t = b_t + '$asdd_tree', to_referer = to_referer + '$to_referer', last_sbor = '$lsb', insert_sum = insert_sum + '$ik_payment_amount' WHERE id = '{$user_id}'"); $db->Query("UPDATE db_users_b SET money_b = money_b + '$serebro', b_t = b_t + '$qadd_tree', to_referer = to_referer + '$to_referer', last_sbor = '$lsb', insert_sum = insert_sum + '$ik_payment_amount' WHERE id = '{$user_id}'"); $db->Query("UPDATE db_users_b SET money_b = money_b + '$serebro', c_t = c_t + '$wadd_tree', to_referer = to_referer + '$to_referer', last_sbor = '$lsb', insert_sum = insert_sum + '$ik_payment_amount' WHERE id = '{$user_id}'"); $db->Query("UPDATE db_users_b SET money_b = money_b + '$serebro', c_t = c_t + '$ssadd_tree', to_referer = to_referer + '$to_referer', last_sbor = '$lsb', insert_sum = insert_sum + '$ik_payment_amount' WHERE id = '{$user_id}'"); $db->Query("UPDATE db_users_b SET money_b = money_b + '$serebro', c_t = c_t + '$vadd_tree', to_referer = to_referer + '$to_referer', last_sbor = '$lsb', insert_sum = insert_sum + '$ik_payment_amount' WHERE id = '{$user_id}'");
  • Does your $db->Query accidentally have a second parameter? - vp_arth
  • one
    so you update only once. add all the variables that should go in one column - Mike
  • These are all the variables of add_tree, replace one and make some sort of switch which, depending on the amount, will make this the only value correct - Mike
  • The bottom line is that I need to put different variables in different columns of the database under different conditions. - Roman Losev

1 answer 1

If your class supports placeholders, it will look something like this:

 // Один запрос $db->Query("UPDATE db_users_b SET money_b = money_b + :money_b, c_t = c_t + :c_t, b_t = b_t + :b_t, to_referer = to_referer + :ref, last_sbor = :lsb, insert_sum = insert_sum + :ik WHERE id = :id", [ ':money_b' => $serebro, // Сразу считаем сколько чего и куда нужно добавить ':c_t' => $wadd_tree + $ssadd_tree + $vadd_tree, ':b_t' => $asdd_tree + $qadd_tree, ':ref' => $to_referer, ':lsb' => $lsb, ':id' => $user_id ]);

If it doesn’t support, then do it like with you, only in c_t/b_t insert the ready sums.