How to link an image map with a database?

Asked By benjamin 460 points N/A Posted on - 11/23/2012

Hello fellows,

How to link an image map with a database? I am using PHP programming language for my upcoming website project about mapping and determining specific location. I’m just wondering how to link the map to the database? I am using MySQL database system. Your answers are very much welcome.

Regards,

Benjamin.

• Status: Open
• Question Views: 827
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Lecky cruz 0 points N/A #92390

How to link an image map with a database?

Hi Benjamin,

First store image in table, define column as long blob type then upload your image, open it  read the contents from mysql escape all the special characters

mysql_escap_string() after then insert in the table

whenever you want to see your image write your PHP page which can perform so then reference it in your image like

<img src="myimage server.php?imageid=5324">

myimageserver.php will headers output which is followed by contents of longblob column in table for example

header("Content-Type: image/jpegn");
header("Content-Transfer-Encoding: binary");
echo $row['imageblob'];

About Lecky cruz

Questions
4

Answers
102

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 11/23/2012
• Question Category: Misc Databases