Member Avatar for djcritch

Hi,

Got a bit of a problem with form, i need to be able to update a number in a mysql database using an html form. so basically i need to increment or decrement a number using a text box and a submit button.

heres the code i got:

==============================================

<form name="input" method="get" action="select.php">
Add Stock : <input type="text" name="number1">
<input type="submit" value="+">
</form>
</pre>

<?php
$add = $_REQUEST;

// update table "goods" contents
$sql =
"UPDATE goods SET stock = stock + $add WHERE id = 1";
"UPDATE stock";
if(!($result = mysql_query($sql,$dblink))) {
print "Fail: query";
exit;
}

?>

===============================================

the code half works but you need to refresh the page and it not updating the database correctly.

also if i made a copy of this code to do the stubtraction it all goes a bit tits up

im guessing there must be a better way for me to do this ?

Someone please help! Merry christmas!

  • 2 Contributors
  • 3 Replies
  • 747 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by nav33n
Member Avatar for nav33n
<html> <body> <form name="form" method="post" action="test.php"> Number: <input type="text" name="number"><br /> <input type="submit" name="add" value="+"><input type="submit" name="subtract" value="-"> </form> </body> </html> <?php $conn=mysql_connect("localhost","username","password"); mysql_select_db("dbname"); if(isset($_POST['add'])){ $add=$_POST['number']; $query="update goods set stock=stock+$add where id=1"; mysql_query($query) or die("Cannot update"); } if(isset($_POST['subtract'])){ $subtract=$_POST['number']; $query="update goods set stock=stock-$subtract where id=1"; mysql_query($query) or die("Cannot subtract"); } ?>

Umm.. you forgot to put your code in [ c o d e ] [ / c o d e ] tags. Anyways, I hope this helps.

Member Avatar for djcritch

Thanks mate that sorted it for me!

Member Avatar for nav33n

:) you are welcome!

commented: Dont give up, keep the spirit of helping. Sometimes i wish if i was like you+3
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.