PHP - Php - Saving Image To Mysql As Blob Issues

I have created a image using imagepng() and then right-click'd and saved it. I then added it to the database by using phpMyAdmin to upload it directly into a field called 'avatar' which is a BLOB. The code the view the image back is the following:

header("Content-type: image/png");
echo mysql_result(mysql_query("SELECT `avatar` FROM `rscd_players` WHERE `username` = 'Kryptix'"), 0);

Now when I try and add the imagepng() directly to the database it doesn't work. I've tried multiple things. Here's the code:

ob_start(); imagepng($char_image); $pngimagedata = ob_get_contents(); ob_end_clean();

mysql_query("UPDATE `rscd_players` SET `avatar` = " . $pngimagedata . " WHERE `username` = 'Kryptix'");

Here's the full code: http://pastebin.com/jqsKc9Qd

This is the query that phpMyAdmin produces: http://pastebin.com/nuypNuwJ

This is the query that the above code produces: http://pastebin.com/NPWmi5eb

phpMyAdmin is 2.2kB, my code is 4.4kB

Any idea? I've been trying all night...

Hello,
I am storing files that my users upload to the website as a blob in mysql database. Here is the code that does uploading:
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = mysql_real_escape_string($content);
fclose($fp);
if(!get_magic_quotes_gpc())
{
   $fileName = addslashes($fileName);
}
$query = mysql_query("INSERT INTO documents (idapplicant, fileType, fileSize, fileData, fileName)
         VALUES ('$idapplicant','$fileType','$fileSize', '$content','$fileName')",$db);

Here is the code for download:
echo "File found:".@mysql_result($result, 0, "fileID"); //always correct
$data = @mysql_result($result, 0, "fileData");
$name = @mysql_result($result, 0, "fileName");
$size = @mysql_result($result, 0, "fileSize");
$type = @mysql_result($result, 0, "fileType");

header("Content-length: $size");
header("Content-type: $type");
header("Content-Disposition: attachment; filename=$name");
echo $data;

I can upload/download files no problem. However, I noticed problem with GIF files. All GIF files are just dark screen after downloading. All other files (PDF, JPEG) looked just fine. I compared files (before upload and after download) in HEX editor and found that the first byte on all files is set to A0 (it is added in front of all the data) and the last byte is deleted!
I have tried:
$content = addslashes($content);

instead of:
$content = mysql_real_escape_string($content);
with the same results
I also tried removing this line of code and in that case no file would be uploaded at all!
Any idea?
Thank you

Hi guys,

This is my first time to insert PDF into MySQL BLOB.
Below is my form that i used

Code: [Select]
<?php
<form enctype="multipart/form-data" name="frmUploadFile" action="ulf-exec.php" method="post">

<select name="title"  id="title">
                      <option>xxx</option>
                      <option>yyy</option>
                      <option>zzz</option>
                    </select>
                  </label>
<input name="des" type="text" class="dropdownlists1" id="des"></td>
<input name="fileUpload" type="file" class="dropdownlists1" id="fileUpload" size="20" border=""></td>
<input type="submit" name="button" id="button" value="Submit">

 </form>
?>
I have prepared my database based on the required but decided to test with echo just to confirm there's no issue with the code
The action="ulf-exec.php" :
Code: [Select]
<?php

function clean($str) {
$str = @trim($str);
if(get_magic_quotes_gpc()) {
$str = stripslashes($str);
}
return mysql_real_escape_string($str);
}

//Sanitize the POST values
$title = clean($_POST['title']);
$des = clean($_POST['des']);
$fileUpload = $_POST['fileUpload'];

if(empty($des) || $fileUpload == "none")

die("You must enter both a description and file");


$fileHandle = fopen($fileUpload, "r");
$fileContent = fread($fileHandle, $fileUpload_size);
$fileContent = addslashes($fileContent);


$date = date('d').'-'.date('m').'-'.date('y');
$time = date('h').':'.date('i').':'.date('s');

echo "<h1>File Uploaded</h1>";

echo "The details of the uploaded file are shown below:<br><br>";

echo "<b>File name:</b> $fileUpload_name <br>";

echo "<b>File type:</b> $fileUpload_type <br>";

echo "<b>File size:</b> $fileUpload_size <br>";

echo "<b>Uploaded to:</b> $fileUpload <br><br>";

echo "<a href='uploadfile.php'>Add Another File</a>";
?>

This is the error:
Code: [Select]
Warning: fopen() [function.fopen]: Filename cannot be empty in /ulf-exec.php on line 30

Warning: fread(): supplied argument is not a valid stream resource in ulf-exec.php on line 31

i've found a pagination script of the internet but the image comes up blank. I've stored it in a largeblob. When i check the html it says 'array[name]' as the image pz help me heres the code:

<?php

//connection stuff here

$page = 1;
if ( isset( $_GET['page'] ) ) {
$page = (int) $_GET['page'];
}

$query = mysql_query("SELECT COUNT(*) FROM `upload`",$link);
list( $total ) = mysql_fetch_row( $query );
$total = ceil( $total / $perPage );
$start = ( $perPage * ( $page - 1 ) );
$limit = '';
$show = true;
if ( $total > 1 ) {
$limit = " LIMIT {$start}, {$perPage}";
}
else {
$show = false;
}

$query = mysql_query("SELECT * FROM `upload` ORDER BY `id`{$limit}");
while( $row = mysql_fetch_assoc( $query ) ) {
echo "<img src=\"{$row['file_name']}\" alt=\"{$row['name']}\" title=\"{$row['name']}\" />";
}

if ( $show ) {
$prev = $page - 1;
$next = $page + 1;
if ( $prev > 0 ) {
echo "<a href=\"{$thispage}?page={$prev}\">[PREV]</a>";
}
if ( $next < $total ) {
echo "<a href=\"{$thispage}?page={$next}\">[NEXT]</a>";
}
}

?>

Hi everyone, i am just trying to learn php for a bit of fun really and started making a sort of 'facebook' website. I am having trouble however trying to display different users images, for example when trying to find a correct 'friend' only the image of the last result is being shown for all people with the same name... here is my code below, if anyone can help me out that would be great

file 1

$count=1; 

while ($numids>=$count){
  echo "<form method=\"post\" action=\"friendadded.php\">";
  $frienduserid=$_SESSION["passedid[$ii]"];
  $friendfirstname=$_SESSION["passedfirstname[$ff]"];
  $friendlastname=$_SESSION["passedlastname[$ll]"];
  $_SESSION['friendsuserpicid'] = $frienduserid;
  echo "<table width=\"700\" height=\"50\" border=\"1\" align=\"center\">";
  echo "<tr>";
  echo "<th></th>";
  echo "<th>First Name</th>";
  echo "<th>Last Name</th>";
  echo "</tr>";
  echo "<tr>";
  echo "<td><center>";
  echo "<img border=\'0\' src=\"frienduserpic.php\" width=\"80\" height=\"80\" align=\"middle\"/>";
  echo "</center></td>";
  echo "<td><center>";
  echo $friendfirstname;
  echo "</center></td>";
  echo "<td><center>";
  echo $friendlastname;
  echo "</center></td>";
  echo "</tr>";
  echo "</table>";
  echo "<center><input type=\"submit\" value=\"Add this friend\" name=\"Add Friend\"></center><br/>";  

  $ii=$ii+1;
  $ff=$ff+1;
  $ll=$ll+1;
  $count=$count+1; 
  
  echo "</form>";
}




file 2

session_start();
$passeduserid=$_SESSION['friendsuserpicid'];
$timespost=$_SESSION['postednum'];
$host= 
$username=
$password=
$db_name= 
$tbl_name=
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$query = mysql_query("SELECT * FROM $tbl_name WHERE picid='".$passeduserid."'");
$row = mysql_fetch_array($query);
$content = $row['image'];
header("Content-type: image/jpeg");
echo $content;


Thanks in advance

it should display the image but nothing appears. what have i done wrong?

Code: [Select]
echo "<img src=\"photo.php?id=$studentid\" alt='photo' />";
photo.php
Code: [Select]
<?php

$id= $_GET['id'];

 $getphoto= mysql_query("SELECT photo FROM Student WHERE SID=$id LIMIT 1");

$row5 = mysql_fetch_assoc($getphoto);

$photogot = $row5['PHOTO'];
header("Content-type: image/gif");

   print $photogot;
 


?>

Hi everyone,

I've read lots of tutorials on this, but something is not clicking in my brain with it.  I think my coding is close, but, as of right now, all I get is a red x for the image when I try to display the image.  Let me share my code as a starting point - I would truly appreciate any helpful comments or blatant errors that are pointed out or shared with me.

Here is the upload image form and code (so they clicked the item name and then go into this):

if($_REQUEST['modifyfeatured'])
{
$id=$_REQUEST['modid'];

$sqlid="SELECT * FROM product WHERE id='$id'";
$resultid=mysql_query($sqlid, $dbh);
$idrow = mysql_fetch_array($resultid);

echo "<p>";
echo "Fill out the form below to add a short text line (i.e. 20% Off!) and/or an image (like the new note).<br>";
echo "You are modifying the following item: <p><b>";
echo $idrow['product_id'];
echo " ";
echo $idrow['title'];
echo "</b><p>";

?>
<table border="0" cellpadding="2" cellspacing="0">
<tr>
<td>
<form method="post" enctype="multipart/form-data">
<input type="hidden" name="id" value="<? echo $id; ?>">
Short Text Message:
</td><td>
<input type="Text" name="message"></td></tr>
<tr><td>Small Image:</td><td>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile" type="file" id="userfile"></td></tr>
<tr><td>&nbsp;</td><td>
<input name="upload" type="submit" class="box" id="upload" value="Submit">
</td></tr></table>
</form>
<?

}
//then when the click the upload link, here is the code for that:

if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$message=$_REQUEST['message'];
$id=$_REQUEST['id'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}

include 'library/config.php';
include 'library/opendb.php';

//$query = "INSERT INTO featured_prods (name, size, type, image, message ) ".
//"VALUES ('$fileName', '$fileSize', '$fileType', '$content', '$message')";

$query="UPDATE featured_prods SET name='$fileName', size='$fileSize', type='$fileType', image='$content', message='$message' WHERE id='$id'";

//$sqldone="UPDATE product SET product_id='$product_id', title='$title', description='$description', regular_price='$regular_price', sale_price='$sale_price', stat='$stat', weight='$weight', close_out='$close', additional='$additional', additionalpix='$additionalpix_name' WHERE  id='$id'";

//$resultdone=mysql_query($sqldone, $dbh);

mysql_query($query) or die('Error, query failed'); 
include 'library/closedb.php';

echo "<br>File $fileName uploaded<br>";
} //end if upload is hit


Okay, now here is the code trying to display the image:

<? $featuredquery="SELECT * FROM featured_prods";
$featuredresult=mysql_query($featuredquery, $dbh);
while($featuredrow=mysql_fetch_array($featuredresult)){

$id=$featuredrow['id'];
$prodquery="SELECT * FROM product WHERE id='$id'";
$prodresult=mysql_query($prodquery, $dbh);
$prodrow=mysql_fetch_array($prodresult);

echo $prodrow['title'];
echo "<br>";
echo $featuredrow['message'];
echo "<br>";
?>
<img src="getimage.php?id=<?echo $id;?>" alt="cover" />
<?
}


And here is the code for getimage.php:

<?
$id=$_GET["id"];
$result = mysql_query("select image from featured_prods where id='$id'"); 
$row = mysql_fetch_row($result); 
         
$data = base64_decode($row[0]); 
         
$im = imagecreatefromstring($row[0]); 
imagejpeg($im);

header('Content-type: ' . image/jpeg); // 'image/jpeg' for JPEG images
echo $data;

?>


Again, any help would be appreciated.  I'm a real rookie here, and I appreciate everyone's time and effort to assist me very much. 

I have a base64 encoded image -> http://pastebin.com/698ES5t0   Im trying to export this as a png file.  

 
  $picture =  {data on paste bin}; 
 
 
 $picture = base64_decode($picture); 
 
file_put_contents('/home/picture.png', $Picture);
 
 

    Now this creates a file picture.png and i can open it in Preview/Gimp etc.   However, if i upload the file to my website, the image does not render in chrome/firefox, however it does render in Safarai.    It seems that there is no height/width/depth data.

Hi,

I have managed to get the code working to store a .jpg file in the database under the longblob type.

Now all i have left to do is to retrieve that image and display it.

So far i have this:

list.php
Code: [Select]
while($r = mysql_fetch_array($sql)) { //for each record
...
echo "     <img src=  getoutside.php?id='".$r[apartmentId].  " '>     ";

getoutside.php
Code: [Select]
<?php
header("Content-type: image/jpg"); // act as a jpg file to browser
    $nId = $_GET['id'];
include 'dbase.php'; //connect to database
    $sqlo = "SELECT outside FROM apartment WHERE apartmentId = $nId";

$oResult = mysql_query($sqlo);

$oRow = mysql_fetch_array($oResult);
$sJpg = $oRow["outside"];
echo $sJpg;
?>
The result from this is a box with a red cross in it.
Can anyone find a problem with this code please?

Thanks

I using..

Code: [Select]
echo '<img src="data:image/jpg/png/jpeg;base64,' . base64_encode( $row['image'] ) . '" height="150" />';
This is showing up images great in firefox, safari and chrome, but in internet explorer it shows a nice red cross, and I assume it is because of the encoding?

Does anyone know how to get working in internet explorer as well?

Pretty urgent job!

Much appreciated for your help!

Hello   Is it possible to save data from saved htm table from other website in our mysql database system   as I have problem that there is one htm page where i can get data but i want to save it in mysql table. as data is large on htm page  it was hard to copy so i want access it direct from php and save it in mysql table   please guide   awaiting your valuable reply.   Thank in advance

I have figured out far enough to loop through my table and return a list of check boxes that will be matched to a product. My issue now, is i cannot figure out the proper way to loop through them after they are selected and return them as checked/unchecked for the given product. Thought there is some MySQL involved, that part isn't the problem, I know how to insert into a database or update...when the product is selected from a drop down, I need to be able to populate the checkboxes.

Here is the code i am using to initially display all of the categories to choose from...

<ul class="categories">
  <?php 
    $query = "SELECT * FROM products";
    $result = mysql_query($query) or die(mysql_error());
    while ($row = mysql_fetch_assoc($result)) {
 $category = $row['category'];
 $catId    = $row['id'];  
 echo "<li><input class='catCheck' type='checkbox' name='p_cat[]' value='$catId' /> $category</li>";
    }
  ?>
</ul>



   Thanks guys....

Hi

I'm really new to php and could really do with some help.

I am using the following script

http://test.dpetroff.ru/jquery.iviewer.test/test/

which basically allows me to position an image within a DIV area

My question is, how can I get PHP to save just the image within the DIV area, so it's almost acting like a crop tool

I've tried a few things but so far not managed to get anything working

Hi Guys,

Using this code i am able to overlay a logo onto an image:


<?php
   // Load the image where the logo will be embeded into
   $image = imagecreatefromjpeg("box.jpg");

   // Load the logo image
   $logoImage = imagecreatefrompng("logo.png");
   imagealphablending($logoImage, true);

   // Get dimensions
   $imageWidth=imagesx($image);
   $imageHeight=imagesy($image);

   $logoWidth=imagesx($logoImage);
   $logoHeight=imagesy($logoImage);  

   // Paste the logo
   imagecopy(
      // source
      $image,
      // destination
      $logoImage,
      // destination x and y
      $imageWidth-$logoWidth, $imageHeight-$logoHeight,
      // source x and y
      0, 0,
      // width and height of the area of the source to copy
      $logoWidth, $logoHeight);

   // Set type of image and send the output
   //header("Content-type: image/png");
   //imagePng($image);
   imagejpeg($logoImage, "imageWithLogo.jpg", 100);
   
   // Release memory
   imageDestroy($image);
   imageDestroy($imageLogo);
?>


this part:

   //header("Content-type: image/png");
   //imagePng($image);

shows me the complete image with the logo ontop, what i'm having trouble with is saving the image.

any help would be appreciated

thanks guys

Graham