CODEWITHSUNDEEP
phphtmlsession
B. Smith
B. Smith

Reputation: 1

Session Value always equals last instance

I have a page that is running an SQL query. I am displaying information for each row that the query results in. I am now trying to implement a way to update the information for the things being displayed.

My understanding is that in order to get information from one page to another you need to use sessions.

My code is displaying the information from the MySQL tables, then underneath it is giving the user the choice to edit the information in a form then send it to another file

Upvotes: 0

Views: 40

Answers (1)

Carl Binalla
Carl Binalla

Reputation: 5401

One way of easily doing this is to use <input type="hidden"> so that you can include $row['Toy_ID'] in your form.

Something like this:

$row = $result->fetch_assoc();
while ($row){

    echo "Toy Name: " . $row['Toy_Name'] . "<br>" . 
     "Store Name: . $row['Store_Name'] . "<br>" . 
     "Cost: " . $row['Cost'] . "";

    echo "<form action='update.php' method='post'>" . 
    "<input type='hidden' name='toyid' value='".$row['Toy_ID']."'>" . // here's the hidden input, which you can call by using `$_POST['toyid']`
    "<label>Toy Name: </label><input name='tname'; value='" . $row['Toy_Name'] . "'><br>" . 
    "<label>Store Name: </label><input name='storename'; value='" . $row['Store_Name'] . "'><br>" .
    "<label>Cost: </label><input name='cost'; value='" . $row['Cost'] . "'><br>" . 
    "<input type='submit' value='Submit'>" .            
    "</form></div><br><br>";


    $row = $result->fetch_assoc();
}

Then change your query to make use of $_POST['toyid'] instead of $_SESSION['toyid']

Upvotes: 1

Related Questions