Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

[Jaan]

yea you should show the script.. then we can solve the problem

[coated_pill]

i have solved the corrupt problem.. i just wanna ask if what will i place in the tags of files extension to uploads .zip or .rar in my webhost..

what will i replace with this tags
# What type of files should be allowed to be uploaded ?
$allow_type = "audio/mpeg";

[Jaan]

PHP Code:

// .rar
$allow_type = "application/rar";
// .zip
$allow_type = "application/zip"; 


I get those by using this script:

PHP Code:


<?php
if($_GET['act'] == "show"){
echo $_FILES['files']['type'];
}else{
?>

<form action="?act=show" enctype="multipart/form-data" method="post">
<input type="file" name="files" />
<input type="submit" name="submit" />
</form>
<?php
}
?>

[coated_pill]

Originally Posted by Jaan

PHP Code:

// .rar
$allow_type = "application/rar";
// .zip
$allow_type = "application/zip"; 


I get those by using this script:

PHP Code:


<?php
if($_GET['act'] == "show"){
echo $_FILES['files']['type'];
}else{
?>

<form action="?act=show" enctype="multipart/form-data" method="post">
<input type="file" name="files" />
<input type="submit" name="submit" />
</form>
<?php
}
?>

by the way.. can i have a very detailed tutorials on how can i upload my files to my sub folder in my public_html folder..

A step step by step to do this with the explanation and example.. that would be highly appreciated.. thanks! i am just a newbie in php..

Thank you again!

[coated_pill]

Resolved ^_^

[-z-]

hi.. i have modified the code because i did not pass the id from other page.. an while i run the page .. it will call me to download the php file...pls advice .. i just want to retrieve the picture stored in the database and it is uploaded sucessfully from the previous tutorial provided.. thanks in advance

 $storedid = "1";
  $id = (int)$storedid;

if(!isset($id) || empty($id)){
die("Please select your image!");
}else{

$query = mysql_query("SELECT * FROM tbl_images WHERE id='$id'");
$row = mysql_fetch_array($query);
$content = $row['image'];

[Stucka]

Thank you

[techker]

why is that i get a download file when i call it in the browser?

viewimage.php?id=1

[Jaan]

hmm.. have you changed anything?

[techker]

nothing at all...