Jump to content

Archived

This topic is now archived and is closed to further replies.

hansman

Storing Hyperlinks in MySQL

Recommended Posts

what type of field would i use to store " [a href=\"http://www.mydomain.com/\" target=\"_blank\"]http://www.mydomain.com/[/a] " in MySql
and how would i out put it as a link in PHP


thanks in advance for your help

Share this post


Link to post
Share on other sites
VARCHAR(255) will do for storing a hyperlink, it can store a maximun of 255 characters

now to get the hyperlink out of the database I'd use this:

[code]<?php

//connect to database here

$sql = "SELECT hyperlink_col FROM table_name";
$result = mysql_query($sql);

while($row = myql_fetch_array($result))
{
    echo "<a href=\"" . $row['hyperlink_col'] . \">Link</a>";
}

?>[/code]
Note, make sure you change hyperlink_col with the actual column name that stores the hyperlink and change table_name with the actuall name of the table you use that stores the hyperlink column in.

Share this post


Link to post
Share on other sites

×

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.