$_POST getting set to 0

OBCENEIKON

I am having a problem with a form value gettting set to 0, and another getting set to empty.

I cannot find my problem, you can see what its doing at
http://www.rathenation.com/phpbb2/loot.php

EDIT
Rewrote a smaller version with same outcome...heres code

<?php

include('config.php');

require_once( 'DB.php' );
$db = DB::connect( "$dbms://$dbuser:$dbpasswd@$dbhost/$dbname" );

if (isset($_POST['submit'])) {

$member_select = $_POST['member_select'];
$loot_id = $_POST['item_id'];
$loot_name = $_POST['item_name'];

echo 'loot id = ' . $_POST['item_id'] . '<br />';

$sql = "INSERT INTO phpbb_raid_loot
(raid_id, raid_member, loot_id, loot_name)
	VALUES
('" . $_POST['raid_select'] . "', '" . $_POST['member_select'] . "', '" . $_POST['item_id'] . "', '" . $_POST['item_name'] . "')";
$result = $db->query($sql);

echo $sql;

}

echo '<form name="member_loot" method="post" action="' . $_SERVER['PHP_SELF'] . '">';
echo '<table border="0" cellpadding="3" cellspacing="1"  class="forumline">';
echo '<tr><th class="thCornerL" align="center">Member</th><th class="thTop" align="center">Loot</th><th class="thCornerR" align="center">Save</th></tr>';

$sql = "SELECT id, loot_id, loot_name FROM phpbb_raid_loot WHERE raid_id = '" . $_POST['raid_select'] . "' AND raid_member = '" . $_POST['member_select'] . "'";
$result = $db->query($sql);

if ($result->numRows() == 0) {

echo '<tr><td class="row1" align="center"><span class="gen">' . $_POST['member_select'] . '</span></td><td class="row1" align="center"><span class="gen">Lucy Item ID: <input type="text" name="item_id"> Item Name: <input type="text" name="item_name"></span></td><td class="row1" align="center"><input type="submit" value="Submit" name="submit"></tr>';

} else {

echo '<tr><td class="row1" align="center"><span class="gen">' . $_POST['member_select'] . '</span></td><td class="row1" align="center"><span class="gen">Lucy Item ID: <input type="text" name="item_id"> Item Name: <input type="text" name="item_name"></span></td><td class="row1" align="center"><input type="submit" value="Save" name="submit"></tr>';

$color1 = 'row1';
$color2 = 'row2';
$count = 0;

while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {

	$row_color = ($count % 2) ? $color1 : $color2;
	echo '<tr><td class="' . $row_color . '" align="center"><span class="gen"></span></td><td class="' . $row_color . '" align="center"><span class="gen">Lucy Item ID: <input type="text" name="item_id" value="' . $row['loot_id'] . '"> Item Name: <input type="text" name="item_name" value="' . $row['loot_name'] . '"></span></td><td class="row1" align="center"><input type="checkbox" name="' . $row['loot_name'] . '" value="' . $row['id'] . '"><input type="submit" value="Update" name="update"></tr>';
	$count++;

}

}

echo '</table>';
echo '<input type="hidden" name="member_loot" value="Edit">';
echo '<input type="hidden" name="member_select" value="Borrick">';
echo '<input type="hidden" name="raid_select" value="1">';
echo '</form>';

?>

tsinka

Hi,

first of all check if the table already contains empty values for the given raid_select and member_select.

I think the main problem is that you need to change the input names a little bit. With the given code using just one form without input names that are submitted as array you'll not get all the form data submitted. It doesn't matter which update button you click.

Please post the complete code as attachment.

You need at least to change the input names so that parts of the form data get submitted as array.

Thomas

OBCENEIKON

found it, think it was a value in my table, thanks 🙂

tsinka

I wasn't clear enough, too 🙂

If you load the page you posted you'll first get a form with just one line. Whatever you submit with this form will be correctly displayed on the second form as last line with some empty lines and everything you posted with the short form on the first page correctly being there.

I think the empty lines are caused by empty data already being stored in the table.

The problem with the second form:

If you submit data typed into the first line by clicking on Save you'll get the form with a new line at the end that contains a duplicate of the last line of the form before you clicked save.

Looking at the HTML source you'll see that e.g. the first input of each line has always the same name.

The problem is: the last line wins (overwrites the values of the previous lines including the first one with the save button).

So you need to make sure that the for data is submitted as array so you can work with the complete form data and not only with the data of the last line.

Short example:

After submitting the form you'll have something like

$_POST["data"] = array(dbid=>"aname", dbid2=>"aname2")

Thomas

tsinka

Ok,

didn't see your last post when I started to write my last post.

Thomas