Jump to content

Link with Variable in Echo Statement


gunthertoody
 Share

Recommended Posts

I have to put a link that can be clicked around the first name and last name variables in the echo statement below.  I also need to add a variable from the Select query to the link such as: 'www.phpfreaks.com/admin/customers.php?page=1&cID="VARIABLE HERE" &action=edit'

 

I've tried a bunch of things and none seem to work.

 

 

while($row = mysql_fetch_array($result)){

 

 

echo '<tr><td>' . $row['customers_firstname'] . " " . $row['customers_lastname'] . '</td><td>' .

 

 

date("M. d, Y", strtotime($row['date'])) . '</td><td>' . $row['plan_id'] . '</td></tr>';

 

David

Link to comment
Share on other sites

Okay. I got the link to work, but only with a static ID. What is the proper syntax for a variable in the bold text? Do I have to qualify it somehow? The variable from the select statement is "customers_history.customers_id".

 

  $bg = ($bg=='#ffffff' ? '#e7e8e8' : '#ffffff'); //For Alternate Row Colors
   
   echo '<tr bgcolor="' . $bg . '"><td><a href="https://www.phpfreaks.com/admin/customers.php?page=1&cID=[b]['customers_history.customers_id'][/b]&action=edit">' . $row['customers_firstname'] . " " . $row['customers_lastname'] . '</a></td><td>' . date("M. d, Y", strtotime($row['date'])) . '</td><td>';

 

Link to comment
Share on other sites

Okay, I think I got most of the syntax right, but how do I pull the variable (customers_history.customers_id) from the SELECT statement and make it populate in the link below?

 

$query = "SELECT customers_history.customers_id, customers_history.date, customers_history.status, customers_history.plan_id, customers.customers_firstname, customers.customers_lastname FROM customers_history LEFT JOIN customers ON customers_history.customers_id = customers.customers_id WHERE customers_history.status ='1' OR customers_history.status = '4' ORDER BY date DESC LIMIT 10";


echo '<tr bgcolor="' . $bg . '"><td><a href="https://www.example/admin/customers.php?page=1&cID=<?=[b]$customers_history.customers_id[/b]>&action=edit">' . $row['customers_firstname'] . " " . $row['customers_lastname'] . '</a></td><td>' . date("M. d, Y", strtotime($row['date'])) . '</td><td>';

Link to comment
Share on other sites

Thanks, but I'm a novice and completely lost as to the proper syntax for a variable inside an href. What is the proper syntax?

 

echo '<tr bgcolor="' . $bg . '"><td><a href="https://www.example.com/admin/customers.php?page=1&cID=<?=$row['customers_history.customers_id'];?>&action=edit">' . $row['customers_firstname'] . " " . $row['customers_lastname'] . '</a></td><td>' . date("M. d, Y", strtotime($row['date'])) . '</td><td>';

Link to comment
Share on other sites

I tend to like to keep some sort of structure, so I would tend to do something like:

echo "";
echo "";
echo "{$row['customers_firstname']} {$row['customers_lastname']}";
echo "";
echo "" . date('M. d, Y', strtotime($row['date'])) . "";
echo "";

Link to comment
Share on other sites

Thanks. I'm learning bit by bit and I like the structure you put it in.

 

Regarding the functionality. It works except "customers_history.customers_id" won't populate into the browser. It goes straight from "ID=" to "&action".

 

I tend to like to keep some sort of structure, so I would tend to do something like:

echo "<tr bgcolor='{$bg}'>";
echo "<td>";
echo "<a href='https://www.example.com/admin/customers.php?page=1&cID={$row['customers_history.customers_id']}&action=edit'>{$row['customers_firstname']} {$row['customers_lastname']}</a>";
echo "</td>";
echo "<td>" . date('M. d, Y', strtotime($row['date'])) . "</td>";
echo "<td>";

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.