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
  • 737 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.