passing variables from views to controllers

Question

I'm going to try to explain this as best I can. I'm returning an array of results from my controller. I wish to send over the primary key of the selected row to another controller that will manage inserting the record into the Database when a user clicks the "add employee" button. My primary key is MOVIE_ID. It's currently returning an array of two MOVIE_ID {12341, 31351} like so. My questions are:

How do I associate each movie ID uniquely with that corresponding rows' button?
Can I pass a variable to a controller through the action="" attribute , do I need JS?

enter image description here

            <fieldset id= "results">

                <?php if (isset($results ) And count($results)) : ?>
                    <table id="box-table-a" summary="Employee Sheet">
    <thead>
        <tr>
            <th scope="col">Employee</th>
            <th scope="col">Salary</th>
            <th scope="col">Bonus</th>
            <th scope="col">Supervisor</th>
            <th scope="col">Action</th>
        </tr>


            <?php foreach ($results as $result) : ?>
                            <tr>
//Primary key <?php echo $result['MOVIE_ID!'];?>
<td><span class="Employee_name"><?php echo $result['Employee']; ?> </span></td>         
<td><span class="Salary"><?php echo $result['Salary']; ?> </span> </td>
<td><span class="Bonus"><?php echo $result['Bonus']; ?> </span> </td>
<td><span class="Supervisor_name"><?php echo $result['Supervisor']; ?> </span></td>
<td><input type="submit" value="add employee" > </td>

    </tr>

    <?php endforeach; ?>
        <?php endif; ?>
    </thead>
        <tbody>
    </fieldset>

Ja͢ck · Accepted Answer · 2012-08-28 06:47:39Z

1

One trick is to pass the id via the submit button, like so:

<input name="submit[12341]" type="submit" value="add employee" />

When clicked it would send submit[12341]=add+employee in the POST data (assuming you have wrapped everything inside a <form> tag). The other buttons will not be submitted, only the one that's clicked.

In PHP you can retrieve the id like so:

$id = key($_POST['submit']);

answered Aug 28, 2012 at 6:47

Ja͢ck

174k39 gold badges269 silver badges317 bronze badges

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

2 Comments

Undermine2k Over a year ago

The problem is, that data can be changed so I can't really hard-code in every ID for the movie it just needs to grab it in the order it was returned from the controller. So I would like to send for row 1, something like "Movie_ID[1]" or something... if you follow me?

Ja͢ck Over a year ago

@Undermine2k right, so you write ... name="submit[<?php echo $result['MOVIE_ID!'] ?>]" ...

Collectives™ on Stack Overflow

passing variables from views to controllers

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related