Fetch 1 row as a link ()

Asked Mar 18 '14 at 12:52

Active Jul 12 '17 at 18:30

Viewed 137 times

I'm fetching some rows from my database into a HTML table like this:

    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $dbh->prepare("SELECT sportnaam, beschrijving, link FROM sporten");
$stmt->execute();
$arrValues = $stmt->fetchAll(PDO::FETCH_ASSOC);

// open the table
print "<table >\n";
print "<tr>\n";

// add the table headers
foreach ($arrValues[0] as $key => $useless){
    print "<th></th>";
}
print "</tr>";
// display data
foreach ($link as $rows){
    print "<tr>";
}
foreach ($arrValues as $row){
    print "<tr>";
    foreach ($row as $key => $val){
    print "<p>$val</p>";
    }
    print "</tr>\n";
}
// close the table
print "</table>\n";
}

The problem is that I'd like to print the link (which I selected above) as a actual link. (so like a href ...) But I've no idea how to do this and looked everywhere for a solution.

edited Jul 12 '17 at 18:30

Brian Tompsett - 汤莱恩

5,753
72
57
129

asked Mar 18 '14 at 12:52

Stana37

link is an actual row in your database? what data do you store in that specific row? You could make it clickable something like: `The Link'; }; ?>` – Kees Sonnema Mar 18 '14 at 12:59
Yes it is. The data is a youtube link, but the problem is that Sportname and description shouldn't be clickable. – Stana37 Mar 18 '14 at 13:01
Could you give the output which is given from the link row? – Kees Sonnema Mar 18 '14 at 13:02
It's outputting normal links but not clickable. – Stana37 Mar 18 '14 at 13:10
just a http://ksjflkds.com link? – Kees Sonnema Mar 18 '14 at 13:12
Yes, but it's not clickable! – Stana37 Mar 18 '14 at 13:14
Yes I understand. You're trying to use $link as $row, but what is $link? You did not define that somewhere. – Kees Sonnema Mar 18 '14 at 13:15
Oh i just saw I pasted the code wrong oops!.I'll keept trying but thanks anyway! – Stana37 Mar 18 '14 at 13:19

Fetch 1 row as a link ()

0 Answers0