running sql on link click

Question

please view the following code.

<?php foreach($rows as $row): ?> 


<tr> 
    <td><?php echo htmlentities($row['username'], ENT_QUOTES, 'UTF-8');?></td> 
      <td><?php echo htmlentities($row['id'], ENT_QUOTES, 'UTF-8');?></td> 
    <td><?php echo htmlentities($row['starthol'], ENT_QUOTES, 'UTF-8'); ?></td> 
    <td><?php echo htmlentities($row['endhol'], ENT_QUOTES, 'UTF-8'); ?></td> 
    <td><?php echo htmlentities($row['days'], ENT_QUOTES, 'UTF-8'); ?></td> 
    <td><a href="#">Approve</a></td> 
    <td><a href="*">Reject</a></td> 

</tr>

This populate a table from a previously ran sql query. Basically, when approve is clicked,I want to run an SQL query that uses the id of the the row and updates a column in the table called "active".

UPDATE holidays 
SET active = "active"
WHERE holid = getid

Any advice on how to do this?

I am a php novice, so please go easy on me. Thank you.

you can use ajax to send back the status to backend and run sql query there. — Bhadra
– Bhadra, Commented Oct 1, 2013 at 10:49

Arun Killu · Accepted Answer · 2013-10-01 11:01:29Z

1

You should consider learning how to GET and POST

<td><a href="active.php?id=?"<?php echo $row['id']; ?> >Approve</a></td>

Server side code active.php(sample dont copy paste you must use post to update db state not get also mysql_* depricated)

$id = mysql_real_escape_string($_GET['id']);
mysql_query("UPDATE holidays 
SET active = 'active'
WHERE holid = $id")or die(mysql_error());
header('location:listingpage.php?msg=approved');

edited Oct 1, 2013 at 11:01

answered Oct 1, 2013 at 10:53

Arun Killu

14.3k5 gold badges38 silver badges66 bronze badges

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

1 Comment

Arun Killu Over a year ago

after updating most probably you need to redirect to listing page

Arun Killu · Accepted Answer · 2013-10-01 10:59:46Z

0

Are you able to get your query to run and return data? Assuming you have data, you will want to update your foreach() loop. If you want the loop to work over more than one line, you'll have to use curly braces ({ })

So your code would look more like:

<?php foreach($rows as $row) { ?> 

 ...

<?php } ?>

edited Oct 1, 2013 at 10:59

Arun Killu

14.3k5 gold badges38 silver badges66 bronze badges

answered Oct 1, 2013 at 10:56

DJ Sipe

1,38513 silver badges13 bronze badges

Collectives™ on Stack Overflow

running sql on link click

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related