GD PHP Base64 Picture (png) error

Posted by hogofwar on Stack Overflow See other posts from Stack Overflow or by hogofwar
Published on 2010-06-12T12:48:02Z Indexed on 2010/06/12 12:52 UTC
Read the original article Hit count: 380

Filed under:
|
|
|
|

This is part of my code:

$con = mysql_connect("localhost","username","passs");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database", $con);
if(mysql_num_rows(mysql_query("SELECT name FROM xbox_user WHERE name = '$user'"))){
// Code inside if block if userid is already there
$result = mysql_query("SELECT name FROM xbox_user WHERE name = '$user'");

while($row = mysql_fetch_array($result))
  {
  if ($row['date'] > $row['date']+100){
  $src = imagecreatefrompng($result['XboxInfo']['TileUrl']);
  $base64= base64_encode(file_get_contents($result['XboxInfo']['TileUrl']));
  $date = date("Ymd");
mysql_query("UPDATE xbox_user SET date = '$date' SET avatar = '$base64' 
WHERE name = '$user'");
}else{
$encode = $row['avatar'];
//echo $encode;
$rand = rand(1, 1337);
file_put_contents('/tmp/'.$rand.'.png', base64_decode($row['avatar'])); //ERROR LINE
$src = imagecreatefrompng('/tmp/'.$rand.'.png');
unlink('/tmp/'.$rand.'.png');
}
} 
}else{
$src = imagecreatefrompng($result['XboxInfo']['TileUrl']);
$base64= base64_encode(file_get_contents($result['XboxInfo']['TileUrl']));
$date = date("Ymd");
mysql_query("INSERT INTO xbox_user (name, avatar, date)
VALUES ('$user', '$base64', '$date')");


}

It comes up with multiple errors but I feel this one should be addressed first as the other could just be caused by the first error:

Warning: imagecreatefrompng() [function.imagecreatefrompng]: '/tmp/628.png' is not a valid PNG file in /home/nah/public_html/experiment/xbox/draw3.php  on line 60

It also does create an entry in my mysql DB

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql