list/edit help

gleemonex

Hello.

I have a list bveing generated from a database.
This list is made up of links with ?id= apapeded to the end, so the link will then open up the appropriate page when it is clicked.

What I'm looking to do is add a checkbox next to each item, and with javascript ( which i know how to do) submit the form on checkbox click.

Here's the code i have so far.

while ($row = mysql_fetch_array($result)) {
echo '<tr>';
		echo '<td><a href="titleEdit.php?id=' . $row['id'] . '">' . $row['title'] . '</td>';
		 '<td><input type="checkbox" name="enabled" value="0"></td>';
		echo '</tr>';

	}

So, when someone clicks on the box, it should set the value of "eanbled" for the row with the correct ID to 1 ( boolean).

My issues are.

1) How to get it to POST to itself and show the updated list correctly. Including when I first come to the page and there is no POST yet.

2) How to only change the "enabled" value on the row with the same ID, since all the checkboxes have the same name.

thanks to all

Roger_Ramjet

Change the name to include the row id and submit to self

echo '<form name="select" action="<?=$_SERVER['PHP_SELF']?>" method="post" onSubmit="return val_select();">';

while ($row = mysql_fetch_array($result)) { 
echo '<tr>'; 
        echo '<td>' . $row['title'] . '</td>'; 
        echo '<td><input type="checkbox" name="' . $row['id'] . '" value="' . $row['id'] . '"></td>'; 
        echo '</tr>'; 

    }

should just about do it. Not tested and written very quickly, but you should get the idea

gleemonex

ya that's great.. i can wrap my head around it now.

I had a follow up.
Is there a way to make unchecking a box send a value as well, or some way to make it so unchecking clears out whatever is in the cell?

The DB column is defaulted to a value of 1, but it doesnt go back to default after unchecking.

Probably something easy 😃

Roger_Ramjet

Another piece of javascript and the onclick event for the check box.

gleemonex

i know this isn't a Javascrupt thread, but instead of starting a new one.

Here's what I have,

The only problem with this is that i think there might be a small syntax error.

Since every row has a yesno field, there are obviously multiple fields of the same name.

I've usually targeted these by doing document.whatever[2], but since the # of rows change all the time on this page, I left it out.

Is that incorrect?
It (the JS) doesn't seem to be working, just yet so..