Getting two values from a mysql table using a checkbox

Question

So I have a mysql table for the charges of a hospital. My program currently only gets the price of the checked procedure. But now, I also want to get the procedure name when it is checked.

while($row = mysql_fetch_array($result)){

            echo '
            <tr>
                <td>'.$row[0].'</td>
                <td>'.$row[1].'</td>
                <td>'.$row[2].'</td>';
                $price=$row['price'];
            echo '<td><input type="checkbox" name="er[]" value="'.$price.'"></td>';
            echo "</tr>";

        }
        echo '</table>';

So basically I need to edit this part of the code:

$price=$row['price'];
echo '<td><input type="checkbox" name="er[]" value="'.$price.'">

It only gets the row for price. Can the value attribute have two values? I can't just make another checkbox cause that would be inappropriate.

Mani · Accepted Answer · 2012-12-15 05:15:14Z

1

change the code like this

<?
while($row = mysql_fetch_array($result)){

            echo '
            <tr>
                <td>'.$row[0].'</td>
                <td>'.$row[1].'</td>
                <td>'.$row[2].'</td>';
                $price=$row['price'];
        $procedure_name=$row['$procedure_name'];
            echo '<td><input type="checkbox" name="er" value="'.$price.','.$procedure_name.'"></td>';
            echo "</tr>";

        }
        echo '</table>';
?>

Then use explode()

answered Dec 15, 2012 at 5:15

Mani

8886 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1551672 Over a year ago

It says: Warning: explode() expects parameter 2 to be string, array I forgot to mention i have two files. One for the checkbox form and then a php file after submission. So I have to POST the variables used in the first file. And the er[] value has two values, the procedure name and the price.

Michael Villeneuve · Accepted Answer · 2012-12-15 04:54:21Z

1

You could simply put the name in another attribute (like title) and whenever you need to get the name you can use some javascript to retreive it.

$price=$row['price'];
echo '<td><input type="checkbox" name="er[]" value="'.$price.'" title="'.$name.'">

answered Dec 15, 2012 at 4:54

Michael Villeneuve

4,0434 gold badges28 silver badges40 bronze badges

1 Comment

user1551672 Over a year ago

Can't you retrieve it using simple POST method on php?

Collectives™ on Stack Overflow

Getting two values from a mysql table using a checkbox

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related