måske kunne du lave en side med noget ala <img src="showimage.php?id=2" />
"S. Hansen" <skidt_fjern_dette@tele2adsl.dk> skrev i en meddelelse
news:5ok9j2h81kcnb0tge6981ga8lnq2utbqci@4ax.com...
>
> Flg script henter et billede fra mysql og downlader det som en fil der
> kan vises i windows billed og fax fremviser.
>
> Hvordan ændres dette så billedet i stedet vises i internet explore.
>
> <?
> if(isset($_GET['id']))
> {
>
> mysql_connect("localhost", "db", "kode");
> mysql_select_db("db");
>
> $id = $_GET['id'];
> $query = "SELECT name, type, size, content FROM upload WHERE id
> = '$id'";
> $result = mysql_query($query) or die('Error, query failed');
> list($name, $type, $size, $content) = mysql_fetch_array($result);
>
> header("Content-Disposition: attachment; filename=$name");
> header("Content-length: $size");
> header("Content-type: $type");
> echo $content;
>
>
> exit;
> }
>
> ?>
> <html>
> <head>
> <title>Download File From MySQL</title>
> <meta http-equiv="Content-Type" content="text/html;
> charset=iso-8859-1">
> </head>
>
> <body>
> <?
>
> mysql_connect("localhost", "db", "kode");
> mysql_select_db("db");
>
> $query = "SELECT id, name FROM upload";
> $result = mysql_query($query) or die('Error, query failed');
> if(mysql_num_rows($result) == 0)
> {
> echo "Database is empty <br>";
> }
> else
> {
> while(list($id, $name) = mysql_fetch_array($result))
> {
> ?>
> <a href="download.php?id=<?=$id;?>"><?=$name;?></a> <br>
> <?
> }
> }
>
> ?>
> </body>
> </html>
>
>
>
>
>
> Hvis jeg bruger flg alene
>
> mysql_connect("localhost", "db", "kode");
> mysql_select_db("db");
>
> $id = 2;
> $query = "SELECT name, type, size, content FROM upload WHERE id
> = '$id'";
> $result = mysql_query($query) or die('Error, query failed');
> list($name, $type, $size, $content) = mysql_fetch_array($result);
>
> header("Content-Disposition: attachment; filename=$name");
> header("Content-length: $size");
> header("Content-type: $type");
> echo $content;
>
> får jeg kun udskrevet ascii værdierne i IE og ikke billedet.
>
> Håber i kan fortælle mig hvad der er galt.
>
>
> MVH
> Steen