URL Link from HTML form to PHP page

Question

I have read a lot of submissions, I haven't been able to find an answer to my exact question.

I am filling out an HTML form that is sent into mysql database - I am good there.

The results are displayed using php in a html table. I would like the website URL to show as a hyperlink. Everything I do results in an error.

Does anyone know how I can update my code to allow for the website url to show as a hyperlink?

[$dbname = "seller";

 // Create connection
 $conn = new mysqli($servername, $username, $password, $dbname);
 // Check connection
 if ($conn->connect_error) {
     die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT website, url, price, name, email FROM listing";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
     echo "<table><tr><th>Website</th><th>URL</th><th>Price</th><th>Contact      Name</th><th>Email</th></tr>";
     // output data of each row
     while($row = $result->fetch_assoc()) {
         echo "<tr><td>" . $row["website"]. "</td><td>" . $row["url"]. "  </td><td>" . $row["price"]. "</td><td>" . $row["name"]. "</td><td> " .    $row["email"]. "</td></tr>";
     }
     echo "</table>";
} else {
     echo "0 results";
}

$conn->close();
?>]

Thanks

Wrap the url within an anchor. '<a href="' . $row['url'] . '">Caption</a>' — Dave Chen
– Dave Chen, Commented Jul 16, 2016 at 6:23

L Barnard · Accepted Answer · 2016-07-16 06:27:10Z

3

Have you tried this...

echo "<tr><td></td><td><a href='" . $row['url']. "'>" . $row['website']. "</a>  </td><td>" . $row["price"]. "</td><td>" . $row["name"]. "</td><td> " .    $row["email"]. "</td></tr>";

You could also just change 'Link to website' to " . $row["website"]. " for it to display the link

answered Jul 16, 2016 at 6:27

L Barnard

634 bronze badges

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

Comments

Charlie Fish · Accepted Answer · 2016-07-16 06:24:32Z

1

If you use an a tag it should work.

<a href="' . $row['url'] . '">URL</a>

answered Jul 16, 2016 at 6:24

Charlie Fish

21k23 gold badges108 silver badges205 bronze badges

Comments

Alonso Urbano · Accepted Answer · 2016-07-16 06:28:27Z

1

echo "<tr><td><a href=\"{$row['url']}>{$row['website']}</a></td>...etc

You should also consider closing the tags to get a cleaner code:

<?php if ($condition) { ?>
    <div>HTML code!</a>
<?php } ?>

answered Jul 16, 2016 at 6:28

Alonso Urbano

2,2611 gold badge23 silver badges26 bronze badges

3 Comments

Reed Over a year ago

I am new to php, where in my code would I put this? Thanks again for your help.

Alonso Urbano Over a year ago

You have to surround the text you want to be a link with <a> , like this: <a href=\"{$row['url']}>{$row['url']}</a>. I guess you are new to HTML as well, as this a problem related to HTML and not PHP.

Reed Over a year ago

Yes and no. I have been working with HTML for a while. I am just really getting back into it and trying to improve my skills. So, sometimes I over think answers thinking I am missing something. I closed all my tags. Thanks for replying back.

Rasclatt · Accepted Answer · 2016-07-16 06:47:01Z

1

Add an anchor tag <a href=""> inside the table data tag <td> inside your while loop.

Change this line:

echo "<tr><td>".$row["website"]."</td><td>".$row["url"]."  </td><td>".$row["price"]."</td><td>".$row["name"]."</td><td> ".$row["email"]."</td></tr>";

Into this:

echo "<tr><td><a href='".$row["website"]."'>".$row["website"]."</a></td><td>".$row["url"]."  </td><td>".$row["price"]."</td><td>".$row["name"]."</td><td> ".$row["email"]."</td></tr>";

edited Jul 16, 2016 at 6:47

Rasclatt

12.5k3 gold badges28 silver badges33 bronze badges

answered Jul 16, 2016 at 6:30

Rhod Pumaras

337 bronze badges

Comments

Rahul Sharma · Accepted Answer · 2016-07-16 07:21:38Z

1

That will be great if you can show me the error otherwise Try this:

while($row = $result->fetch_assoc()) {
     echo "<tr><td>" . $row["website"]. "</td><td><a href='".$row["url"]."'>Link</a> </td><td>" . $row["price"]. "</td><td>" . $row["name"]. "</td><td> " .    $row["email"]. "</td></tr>";
 }

edited Jul 16, 2016 at 7:21

answered Jul 16, 2016 at 6:29

Rahul Sharma

6221 gold badge7 silver badges25 bronze badges

2 Comments

Reed Over a year ago

It actually made the url an extension of my website. Example: google.com/url so it didn't actually make it a url to the clients page.

Reed Over a year ago

Disregard, figured it out.

Imran Shad · Accepted Answer · 2016-07-16 08:12:42Z

0

use this

echo '<tr><td>' . $row["website"]. '</td><td><a href=" ' . $row["url"]. ' ">'; echo $row["name"];    echo'  </a> </td><td>' . $row["price"]. '</td><td>' . '</td><td> ' .    $row["email"]. '</td></tr>';

instead of

echo "<tr><td>" . $row["website"]. "</td><td>" . $row["url"]. "  </td><td>" . $row["price"]. "</td><td>" . $row["name"]. "</td><td> " .    $row["email"]. "</td></tr>";

answered Jul 16, 2016 at 8:12

Imran Shad

5813 bronze badges

Comments

Szabolcs Dombi · Accepted Answer · 2016-07-16 08:18:42Z

0

use <a> tag, please see this link.

'<a href="' . $row['url'] . '">' . $row['url'] . '</a>'

edited Jul 16, 2016 at 8:18

answered Jul 16, 2016 at 6:24

Szabolcs Dombi

5,7914 gold badges43 silver badges73 bronze badges

Collectives™ on Stack Overflow

URL Link from HTML form to PHP page

7 Answers 7

Comments

Comments

3 Comments

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

3 Comments

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related