I have created a db with
Nome produto | stock
Rato 3
My objective is to enter the number in the input that it sees if it is positive (1) or negative (-1) and then it updates the genre "stock = stock + 1, or stock = stock -1 .
How do I do this using input? ..
Come on, John! I believe that what you are looking for is very simple, I will try to be as easy as possible.
1st part (Input)
<form type="post" action="NOMEDAPAGINA.php"> //POST pega o valor e ACTION manda pra pagina do PHP
<input name="n1" type="number"> //input
</form>
Part 2 (Picking up Values)
$n1 = isset($_POST['n1'])?$_POST['n1']:0; // $n1 = SE TIVER VALOR "do input n1" PEGUE "valor input n1" SENÃO "valor vai ser 0";
$stock = mysqli_query($conexao, "SELECT nome_do_campo FROM nome_da_tabela WHERE cd_do_registro"); //Pega o valor do stock no banco de dados
$array = mysqli_fetch_assoc($stock); //joga o valor para uma variavel
3rd Party (Condition)
if ($n1 < 0){ //Se for negativo
$total = $array['stock'] - 1; //Retira -1 do stock
mysqli_query($Conexao, "UPDATE Nome_da_tabela SET Nome_do_Campo ='$total' WHERE cd_do_registro"); //Muda valor no banco
} else { //Se for positivo
$total = $array['stock'] + 1; //soma +1 do stock
mysqli_query($Conexao, "UPDATE Nome_da_tabela SET Nome_do_Campo ='$total' WHERE cd_do_registro"); //Muda valor no banco
}
I hope I have helped! Good luck.