47 replies to this topic

[phillw]

I said I'd be back !! - lol

After a little head scratching, i realised blob is limited to 64k - So i changed to mediumblob (16Mb) and all is well.

Now the $64,000 question - Obviously, i don't want to be firing down lots of pics at this resolution (some of them are 1:1 scale engineering drawings, that may need to be printed). They are about 200k in size.

I see MySQL has a function to display thumb-nails - Am i better using this, or would it better to store a low-res version of the image in the database ?

I'm guessing saving the images at 92dpi for display purposes, and 'persueding' the code to switch over to the larger image when I select printer as the output would be logical. But before I commit to one way - can you suggest which path I should follow ?

Depending on the recommendation, it makes my next question of how to tell the display program which image to choose. My two CSS's may have to come to my help, here !!!

Once again, thanks for a well written and easy to follow tutorial - It didn't take very long to work out why the images weren't saving - and the ammendment was made easy owing to your clear commenting & use of variable names.

Regards,

Phill.

[Vswe]

Thanks Jordan, this helped me. At last I will be able to +rep you

[ezcat]

Need some education. I looked around but didn't find an answer I understood or it doesn't matter anyway.

On this line:
<input name="image" accept="image/jpg" type="file">

My question is; what does accept="image/jpg" do for me? I can use this same code to upload jpg or pdf files. Should I worry about this to upload different file types?

Thanks,
Jon

[debtboy]

Just saw this for the first time...
Great tutorial +rep

[phillw]

Need some education. I looked around but didn't find an answer I understood or it doesn't matter anyway.

On this line:
<input name="image" accept="image/jpg" type="file">

My question is; what does accept="image/jpg" do for me? I can use this same code to upload jpg or pdf files. Should I worry about this to upload different file types?

Thanks,
Jon

I'm not too sure on the uploading of file types - but you do need to declare the mime type for them to display correctly.

Or, at least that's my understanding of the subject. If you declare a mime type of jpg and output a pdf file - it won't display correctly.
If anyone knows different, please correct me.

Phill.

[ezcat]

I do understand that you need the correct mime type to display the image.

My question is for uploading the image.

Jon

[scumbogs]

Cant wait in the nest tutorial i relly nid this tutorial for our proposal project in schools ^^

[frozie]

This is my code

<?php

require_once("startsession.php");

include_once("mysql.php");

$database = "binary";

?>

<form enctype="multipart/form-data" action="" method="post" name="changer">

<input name="MAX_FILE_SIZE" value="102400" type="hidden">

<input name="image" accept="image/jpeg" type="file">

<input value="Submit" type="submit">

<?php



// Make the connect to MySQL or die

// and display an error.

$link = mysql_connect($host, $username, $password);

if (!$link) {

    die('Could not connect: ' . mysql_error());

}



// Select your database

mysql_select_db ($database);  





if (isset($_FILES['image']) && $_FILES['image']['size'] > 0) { 



      // Temporary file name stored on the server

      $tmpName  = $_FILES['image']['tmp_name'];  

       

      // Read the file 

      $fp      = fopen($tmpName, 'r');

      $data = fread($fp, filesize($tmpName));

      $data = addslashes($data);

      fclose($fp);

      



      // Create the query and insert

      // into our database.

      $query = "INSERT INTO tbl_images ";

      $query .= "(image) VALUES ('$data')";

      $results = mysql_query($query, $link);

      

      // Print results

      print "Thank you, your file has been uploaded.";

      

}

else {

   print "No image selected/uploaded";

}



// Close our MySQL Link

mysql_close($link);

?>  

But in the database or the images/jpeg dot show image or anything in the database

[raman_di]

Hi!,

I am looking for the full script of image into database and show in php.After lot of searches I found your script which is working till ad.html and image into mysql.The real problem is like it is only showing show.php as Please select your image!.

I am not understanding where did the error occur.i even downloaded you script and tried the same thing is what it says.Please do help me its urgent for me for a portal I am doing where I need to upload images for each person registering and displaying their details.


Thanks and Regards,
Ram.

[bobmacans]

This will be of great help to people. You have done a great job.

[Roger]

The original poster is no longer with CodeCall. If you have any question regarding this posting, please start a new thread in the appropriate section of the forum (and reference this thread).

Thank you.