how to assign $row details to session variables when customer clicks on edit link

varai

Hello,

In the manage_credit_cards.php, I have a table of credit cards listed for a particular customer. In each row, an edit link, delete link, credit card number, expiry date and expiry status is displayed. When the customer wants to edit the credit card details, he/she will click on the edit link on the same row.

My question is when the customer clicks on the edit link, how can I assign the $row details to session variables?

I don't think an onclick event handler for <a href> will work here coz' that will mix up javascript (client side) and php (server side).

the code in red is where I want to assign the $row details to session variables.

can anyone please?

the following is my code:

<table cellpadding="3" style="width:98%;">

<tr  class="column_names" bgcolor="#cccccc" align=center>
					<th>Edit</th>
					<th>Delete</th>
					<th>Credit Card</th>
					<th>Expiry Date</th>
					<th>Expired?</th>
</tr>
<?php
while($row = mysql_fetch_array($result)) 
{ 
print
"<tr> 
[COLOR="Red"]<td width='10%'><a href='cr_card_disp.php?action=update_cr_card'>Edit</a></td>[/COLOR]
<td width='10%'><a href='cr_card_disp.php'>Delete</a></td>
<td width='30%'>".$row["cr_card"]."***********".$row["cr_no"]."</td> 
<td width='20%'>" .$row['exp_mth']."/".$row['exp_yr']."</td> 
<td width='30%' style='color:#ff0000;'>".$_SESSION['expiry_msg']."</td> 
</tr>
    <tr> 
    <td colspan='5'> 
   <hr size='1'>
    </td> 
    </tr> "; 

}//END OF WHILE LOOP 

print '</table>';

thank you!

bradgrafelman

Include some unique identifier (e.g. the value of an AUTO_INCREMENT column) in the query string for each row's edit/delete/etc. links. For example, instead of "?action=update_cr_card", you might have "?action=update_cr_card&card_id=1234".

varai

I don't have any AUTO_INCREMENT column for credit_card table. The primary key is a combination of cust_id, cr_card and cr_no. Is there any other way I can do this?

If there are no other options, then I will have to alter the credit_card table and add an AUTO INCREMENT column. This is going to cause a lot of modifications in my current codes.

Of course I also understand that I can't attach cr_card and cr_no to the query string.

thank you.

varai

Another method I thought of! Can I use the $_POST variables instead? However, I'm not using any forms in manage_credit_cards.php.

All the while in the other parts of my website, I have been passing credit card details via $_POST coz' there were forms involved in those pages.

Bjom

However, I'm not using any forms in manage_credit_cards.php.

change that part. change the <a></a> into a submit button and let the form point to itself (i.e. when you click it you will land on the same page, but there is now something in POST or GET that you can check for and react to)

varai

hi bradgrafelman,

ur unique identifier card_id mtd worked out great. I didn't have to make much changed to the rest of the code except for some small modification in the insert statement (to include the card_id).

thanks a lot.