Implementing hyperlink html in php with MySql database

Question

For example I have a order_number from MySQL database.

The code below will print out Order Number:order_number. I want to make a hyperlink to the order_number. Is it possible to do so?

while ($row = mysql_fetch_array($result)) {
     echo '<b>'.'Order Number: '.'</b>' .$row['order_number'].'<br />';
 }

Is this code below correct for the order_number hyperlink?

while ($row = mysql_fetch_array($result)) {
     echo '<b>'.'Order Number: '.'</b>' ."<a href="www.testpage.com/jobs/order_number">$row['order_number']</a>".'<br />';
 }

I'm even sure it is possible to increment each page with the new order_number.

i.e: order_number = 11111 --> www.testpage.com/jobs/11111

order_number = 22222 --> www.testpage.com/jobs/22222

Ah but what is the link for a specific order_number? http://website.com/orders/order_number, etc? — ಠ_ಠ
– ಠ_ಠ, Commented Aug 8, 2013 at 17:05
Sorry for not be specific, the link should www.website.com/jobs/order_number — Bun S.
– Bun S., Commented Aug 8, 2013 at 17:08
I understand. See my solution. The order_number is linked within the url outputted. — ಠ_ಠ
– ಠ_ಠ, Commented Aug 8, 2013 at 17:17

Kim G. · Accepted Answer · 2013-08-08 17:13:08Z

1

Your quotes are mixed up. Try the example below. I put it on two lines to make it more readable.

while ($row = mysql_fetch_array($result)) {
     echo '<b>Order Number:</b>';
     echo '<a href="www.testpage.com/jobs/order_number">' . $row['order_number'] . '</a><br />';
}

I suppose you also should place the order number somewhere in the href attribute, maybe like this:

while ($row = mysql_fetch_array($result)) {
     echo '<b>Order Number:</b>';
     echo '<a href="www.testpage.com/jobs/' . $row['order_number'] . '">' . $row['order_number'] . '</a><br />';
}

answered Aug 8, 2013 at 17:13

Kim G.

1964 bronze badges

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

Comments

ಠ_ಠ · Accepted Answer · 2013-08-08 17:14:34Z

1

You needed to link the variable in the url that you are outputting as well. To easily create the string, I bound the variable from $row into a new variable.

while ($row = mysql_fetch_array($result)) {
    $order_num = $row['order_number']

    echo "<b>Order Number:</b>" .
         "<a href='www.testpage.com/jobs/$order_num'>$order_num</a><br />";
 }

answered Aug 8, 2013 at 17:14

ಠ_ಠ

3,08830 silver badges43 bronze badges

Comments

VortexMath396 · Accepted Answer · 2013-08-08 17:15:05Z

1

Variables are accessed through double quotes and ignored in single quote cases...

Try

echo '<b>'.'Order Number: '.'</b><a href='www.website.com/jobs/"$row['order_number']"'>$row['order_number']</a>

answered Aug 8, 2013 at 17:15

VortexMath396

661 silver badge4 bronze badges

Comments

Patrick Desjardins · Accepted Answer · 2013-08-08 17:16:00Z

1

You have a quote problem between ' and ".

while ($row = mysql_fetch_array($result)) {
     echo '<b>'.'Order Number: '.'</b>' ."<a href="www.testpage.com/jobs/order_number">$row['order_number']</a>".'<br />';
 }

As you can see you are using double quote when you start the link (a) tag. You should keep using the single quote.

while ($row = mysql_fetch_array($result)) {
     echo('<b>Order Number:</b><a href="www.testpage.com/jobs/order_number">'.$row['order_number'].'</a><br />');
 }

You also doesn't need to use that much quotes. You can have several string within the same quote.

answered Aug 8, 2013 at 17:16

Patrick Desjardins

142k89 gold badges298 silver badges346 bronze badges

Comments

Rejayi CS · Accepted Answer · 2013-08-09 04:18:52Z

1

Try like this

while ($row = mysql_fetch_array($result)) {
      echo '<b>'.'Order Number: '.'</b>' .'<a href="www.example.com/sample.php?orderNumber='.$row['order_number'].'">'.$row['order_number'].'</a><br />';
}

OR

while ($row = mysql_fetch_array($result)) {
     $orderNumber=$row['order_number'];
     echo "<b>Order Number : </b><a href='www.example.com/sample.php?orderNumber=$orderNumber'>$orderNumber</a>";
}

edited Aug 9, 2013 at 4:18

answered Aug 8, 2013 at 17:12

Rejayi CS

1,0511 gold badge10 silver badges23 bronze badges

Collectives™ on Stack Overflow

Implementing hyperlink html in php with MySql database

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related