Php - How can I edit a certain row in my html table and update my db?

Question

I'm fairly new to php and I know the question has been asked a lot, but please bear with me. I've managed to populate an html table with a mySql database. At the end of each row is a check in button that resets the date on the row. My question is how, can I keep track of which row the button belongs too so I know to only update that row?

I have an ID on each row so I know I can use that when updating to the table, but I'm just uncertain how to associate each button to it's respective row. Here's a snippet:

while ($row = mysql_fetch_array($result)) {
    echo "<tr>";
    echo "<td class='text-left'>".$row[card_id]</td>";
    echo "<td class='text-left'>".$row[status]</td>";
    //current student
    echo "<td class='text-left'>".$row[user_id]."</td>";
    echo "<td class='text-left'>".$row[end_date]."</td>";

    //Early Check In button
    echo "<td class='text-left'><button class='checkInBtn'></button></td>";
    echo "</tr>";
}

your html is broken. you are outputting MULTIPLE id=checkInBtn, which is illegal. an id MUST be unique across the ENTIRE document. — Marc B
– Marc B, Commented Oct 11, 2016 at 18:47
the php also has errors. if you can clean up your code it would get you better answers. — Funk Doc
– Funk Doc, Commented Oct 11, 2016 at 18:49
Please stop using mysql_* functions. These extensions have been removed in PHP 7. Learn about prepared statements for PDO and MySQLi and consider using PDO, it's really pretty easy. — Jay Blanchard
– Jay Blanchard, Commented Oct 11, 2016 at 18:51
Can you be more specific in your question that we can help you.. — user6063698
– user6063698, Commented Oct 11, 2016 at 19:02

azdonald · Accepted Answer · 2016-10-11 18:52:26Z

1

One way to do it is to have a "click event" attached to the button with the ID of that row passed to the event, so any time the button is clicked, you know which row it was based on the ID.

answered Oct 11, 2016 at 18:52

azdonald

3361 gold badge3 silver badges16 bronze badges

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

Comments

migueref · Accepted Answer · 2016-10-11 18:52:44Z

1

You can send the id to a js function using click event. You can also create a form, inside the form you can create an input hidden and assign it the value, and you can use this value when user submit the buttom.

With this id you can modify the info, and create other view to modify it.

answered Oct 11, 2016 at 18:52

migueref

3021 silver badge7 bronze badges

2 Comments

Will Tuttle Over a year ago

I see. Could you show me a small example of how that would look? something like <button onclick="checkInFunction(<?php echo $id?>))">Click me</button> ?

migueref Over a year ago

You can send data in url and receive data with get. Example: <a href="delete.php?id=<?php echo $r->id; ?>">Delete</a> In your delete.php you can receive it like this: <?php $id = $_GET['id']; echo "id : ".$identificador;

Collectives™ on Stack Overflow

Php - How can I edit a certain row in my html table and update my db?

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related