DaniWeb Forum Index > Web Development > PHP

extracting table field to html form then inserting values back in database

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Dec 2008

Posts: 57

Reputation: khr2003 is an unknown quantity at this point

Solved Threads: 0

khr2003

Offline

Junior Poster in Training

extracting table field to html form then inserting values back in database

Mar 3rd, 2009

hi
I have a table in my database that look like this:
id - name - orderno

the table has data in the fields of id and name but orderno is empty.
I made a html form based on the data of this field, in front of each name field there is an text input field. when the user submits the data I want every value in the text input field to be inserted in the orderno of the relevant id.

is this possible?

•

Join Date: Nov 2007

Posts: 3,746

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: extracting table field to html form then inserting values back in database

Mar 3rd, 2009

Yeah, possible. Have a hidden field in the form to store the id. When the user clicks submit, update the table

 Help with Code Tags 
 mysql Syntax (Toggle Plain Text) 
UPDATE table SET orderno='".$_POST['orderno']."' WHERE id='".$_POST['id']."'";
 
update table set orderno='".$_POST['orderno']."' where id='".$_POST['id']."'";

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Dec 2008

Posts: 57

Reputation: khr2003 is an unknown quantity at this point

Solved Threads: 0

khr2003

Offline

Junior Poster in Training

Re: extracting table field to html form then inserting values back in database

Mar 3rd, 2009

thanks for the reply, that is what I did.
However, I was wondering how would I do it for more than one field. I tired to name the text input "orderno[]" and then use foreach loop to extract the values, but I could not assign each of the values to its related id.

•

Join Date: Nov 2007

Posts: 3,746

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: extracting table field to html form then inserting values back in database

Mar 4th, 2009

Okay.. This is a sloppy example, just to give you an idea.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
if(isset($_POST['submit'])) {
	print "<pre>";
	print "Id array => <br />";
	print_r($_POST['id']);
	print "Order no array => <br />";
	print_r($_POST['orderno']);
	print "</pre>";
       for($i=0;$i< count($_POST['orderno']); $i++) { //there will be equal number of elements in both id array and orderno array. 
		echo $_POST['id'][$i]." -> ".$_POST['orderno'][$i]."<br />";
	}
}
?>
<html>
<body>
<form method="post">
<?php 
for($i=0;$i<5;$i++) {
?>
<input type='hidden' name='id[]' value='<?php echo $i; ?>'> 
Order <?php echo $i; ?>:<input type="text" name="orderno[]"><br />
<?php 
}
?>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>
<?php
if(isset($_POST['submit'])) {
	print "<pre>";
	print "Id array => <br />";
	print_r($_POST['id']);
	print "Order no array => <br />";
	print_r($_POST['orderno']);
	print "</pre>";
       for($i=0;$i< count($_POST['orderno']); $i++) { //there will be equal number of elements in both id array and orderno array. 
		echo $_POST['id'][$i]." -> ".$_POST['orderno'][$i]."<br />";
	}
}
?>
<html>
<body>
<form method="post">
<?php 
for($i=0;$i<5;$i++) {
?>
<input type='hidden' name='id[]' value='<?php echo $i; ?>'> 
Order <?php echo $i; ?>:<input type="text" name="orderno[]"><br />
<?php 
}
?>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>

Instead of for loop, you will have while($row = mysql_fetch_array($result)) . Instead of assigning $i as value to the hidden field, you will have the counter/id field of the table.
You can then map the values of the array entered by the user in the orderno field to id field.

Last edited by nav33n; Mar 4th, 2009 at 12:04 am. Reason: some more addition..

Ignorance is definitely not bliss!

*PM asking for help will be ignored*