PHP to create an HTML Table with URLs from a CSV

Question

I'm very new to PHP (and all server side languages) but I'm trying to teach myself. I have an excel spreadsheet that I need to place on a website as a table. I was able to pull in a csv through PHP to create the HTML table. However, I need the last column ("Links") to contain hyperlinks of the word "Go" that once clicked bring you to its respective unique URL.

I would be incredibly grateful for any help.

Here is my PHP:

<!DOCTYPE html>
<html>
<head>
<link href="stylesheets/styles.css" rel="stylesheet" />
</head>
<body>
<?php
echo "<table>\n\n";
$f = fopen("market_research.csv", "r");
while (($line = fgetcsv($f)) !== false) {
    echo "<tr>";
    foreach ($line as $cell) {
            echo "<td>" . htmlspecialchars($cell) . "</td>";
    }
    echo "<tr>\n";
}
fclose($f);
echo "\n</table></body></html>";

?>

For reference, here is a screencap of my table: html table

Lastly, here is a screencap of the spreadsheet that I'm using:

spreadsheet

it might help you stackoverflow.com/questions/1258122/…

M Khalid Junaid
– M Khalid Junaid

2013-10-15 18:40:45 +00:00
Commented Oct 15, 2013 at 18:40 — M Khalid Junaid
– M Khalid Junaid, Commented Oct 15, 2013 at 18:40

Hamza Kubba · Accepted Answer · 2013-10-15 18:29:56Z

1

Change your for loop like this:

foreach ($line as $cell) {
    echo "<td>";
    if (substr($cell, 0, 4) == "http") { // if the cell starts with http (or https)
        echo "<a href='" . $cell . "'>Go</a>";
    } else {
        echo htmlspecialchars($cell);
    }
    echo "</td>";
}

answered Oct 15, 2013 at 18:29

Hamza Kubba

2,26715 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

PHP to create an HTML Table with URLs from a CSV

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related