links and pictures in mysql

[stuworx]

Hi all,

My first and no doubt of many questions:

how do i put links to websites and pictures in a mysql database?

[matt_wilkes]

Hi,

Although it's possible to store an image in a MySQL database, it's not generally something that would be recommended, as it is then difficult to manipulate, and will increase the size of the database unnecessarily.

A better solution would be to store the images in an image directory (eg website.com/images)

As for links, these could just be stored as normal text fields in the database, turning them into links when the html is output...

For example...

$dbh = mysql_connect("server","usr","password");
mysql_select_db("database");

$res = mysql_query("select * from table where etc etc");

while(list($ref, $image, $link)=mysql_fetch_row($res)){

print "<a href='$link'>";
print "<img src='http://website.com/images/$image'>";
print "</a><br>";

}
mysql_close();

The above simple code would get data from a database, and display the specified image as a clickable hyperlink linking to the address specified in the link field.

Hope this helps

Matt Wilkes