How do you display Hyperlinks in MYSQL table

ken72

Hi All,

I have a MYSQL Database table which I would like to display a bunch of hyperlinks (one hyperlink per row) but I dont want the user to see the actual webpage addresss. eg: a row will say Product 1 but when the user clicks on it they will be directed to www.myhomepage/product1.htm. Does anyone out there know how to do this or can point me to a website that will teach me?

BTW: I am using PHP as my scripting language if this is relavent.

Thank you in advance.

Kindest regards,

Ken

bastien

this would mean that you have potentially hundreds of pages to maintain...

here is a better idea

create one page that acts as a template
then store all the relevant data about each product in the DB and access the data via PHP...fill the template with the data and presto one page for as many products as you like...way easier to maintain cause it is only one page

to access the product include a catelog page where a thumbnail of the item(s) is/are shown and make the image a link with the product name stored in the link to look like this

hth

ken72

OK, Thank you. I think I understand all that. But how do you actually put <a href=www.mypage/product1><img src="/images/somename.jpg"></a>
as an item in your MySQL database.

Sorry, I was not too clear ...but this was actually the question I wanted to ask. ie: what type is it
and do I have to put "" around. I tried just uploading it as is to MYSQL but it does not like that.

chrusie70

i am a beginner... so its only a hint with this example

you have a base "shop" and the table "link" with entrys:

[FONT=courier new]
iddescriptionlink_pic______picture
1gun'o'matic/pic/gun.gif/pic/gun_hi.jpg
2marvin_____/pic/sadbot.gif/pic/sadbot_hi.jpg
3.....
[/FONT]

in your first page you have to connect to shop "base"
select the table "link"
fetch the row with id of your interest with "SELECT id, link_pic FROM link"
and store it to a array called $row_link
you have to read the count of the rows you got and store it to [COLOR]$count[/COLOR]
then for example bring it all at once with a for-loop:

[FONT=courier new]
<?php 
for ($i=1;$i<=$count;$i++) {
echo " <a href = \"http://www.yourdomain.com/product.php?product_id=" 
. $row_link['id'] . " \"><img src=\" " 
. $row_link['link_pic'] . " \"></a> ";
}
?> 
[/FONT]

and of course you have to build a reference page for all your products.... the product.php where you place all the important data about the product and load those through the id you recieve from your first page

you get the id with $_GET['id'] if you use newest php4 and $HTTP_GET_VARS['id'] with older

you can query your "product" table with:
sprtintf("SELECT * FROM product WHERE id=%d", $id)

where %d stands for integer id

i hope it helps a little... as i said i could made some errors so i do not write code only but explain the stucture... 😉

chris

chrusie70

sorry errata!!

it was

in your first page you have to connect to shop "base"

it should be

in your first page you have to connect to "shop" base