Pass variables from one table to another in another PHP page [duplicate]

Question

I'm doing an assignment in school where we should simulate a web retail store that sends products from a database via PHP to the end user. The user should then be able to add the products to the cart by a checkbox and press a button that takes them to the cart, where only the selected items from the product table should show.

I've made some great progress, but I'm stuck on this teeny tiny problem, which is: I can't figure out how to present the selected items in a table. Let me show you how my product table looks like right now:

And the code:

<form action="selected_products.php" method="POST">
<table>
    <tr>
        <th>Select</th>
        <th>Product-ID</th>
        <th>Product Name</th>
        <th>Price SEK</th>
    <tr>

<?php
// Print out all entries in a table
foreach ($rows as $value) {
    extract($value);

    echo "<tr><td><input type='checkbox' name='SelectedData[]' alt='Checkbox' value='$id&$name&$price'></td>";
    echo "</td><td>".$id.'';
    echo "</td><td>".$name.'';
    echo "</td><td>".$price.'';
    echo "</td></tr>";
}
?>
</table>
<br>
<input type="submit" value="Add to cart" />
</form>

When the user selects the products with the checkbox and presses the button, it takes them to the selected_products.php page, which would look like this:

And the code:

<table>
    <tr>
        <th>Product-ID</th>
        <th>Product Name</th>
        <th>Price SEK</th>
    <tr>
<?php
if(!empty($_POST['SelectedData'])) {
    foreach($_POST['SelectedData'] as $selected) {
            echo "<tr><td>".$selected.'';
            echo "</td></tr>";
    }
}
?>

So, my question is: how can I make the selected products fill out the entire table, instead of being mushed up in one column like they are now? I do pass it with value='$id&$name&$price', but how can I make this value string to put every entry in its corresponding column on the selected_products.php page?

You need to split string by explode function, but what if your product name is L&T or H&P ? — Niklesh Raut
– Niklesh Raut, Commented Nov 28, 2016 at 9:05
Instead of using "&", just like @mplungjan said, use pipe "|" for imploding set of values. — L. Herrera
– L. Herrera, Commented Nov 28, 2016 at 9:13
I'd suggest the usage of a custom delimiter instead of single characters like &, | etc. for e.g ~!~ — Clyde Lobo
– Clyde Lobo, Commented Nov 28, 2016 at 9:14

Christoph Diegelmann · Accepted Answer · 2016-11-28 09:16:49Z

5

As already answered in the comments you could use explode() to solve this problem.

foreach($_POST['SelectedData'] as $selected) {
    list($id, $name, $price) = explode("&", $selected);
    echo "<tr><td>".$id.'';
    echo "</td><td>".$name.'';
    echo "</td><td>".$price.'';
    echo "</td></tr>";
}

but this is a rather bad idea because it allows everybody to fill it with whatever they want. This is because everybody can send a post request with any content they want. A better way would be to set selected to the id of the item and then read the data you need from the database again using the id of the item. This way only items that are in the database can be displayed.

answered Nov 28, 2016 at 9:16

Christoph Diegelmann

2,03416 silver badges27 bronze badges

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

1 Comment

tsvenbla Over a year ago

Thank you everyone! I have read about explode before, but I wasn't sure on how to use it, or if it would work on my project. Thank you all once again!

m1crdy · Accepted Answer · 2016-11-28 09:15:42Z

3

Split your string at &.

explode("&",$selected);

This creates an array which holds the values in seperate.

[0] => 3
[1] => Samsung 960 Pro
[2] => 3150

Good look with your project ;)

UPDATE: Like @mplungjan said: use pipe for seperating the values. Then go

explode("|", $selected);

edited Nov 28, 2016 at 9:15

answered Nov 28, 2016 at 9:09

m1crdy

1,4012 gold badges26 silver badges60 bronze badges

3 Comments

mplungjan Over a year ago

unless he has an AT&T computer - do note I commented this 10 minutes ago

m1crdy Over a year ago

That´s right. He should care about this – but this is the answer to what he asked for.

mplungjan Over a year ago

So mark it as duplicate of the link in the comment I gave

Collectives™ on Stack Overflow

Pass variables from one table to another in another PHP page [duplicate]

2 Answers 2

1 Comment

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Linked

Related