To Upload DataBase:
$filename=$_FILES['imgfile']['name'];
    $img="C:\\PHP\\uploadtemp\\".$_FILES['imgfile']['name'];
    
  #
$fh = fopen($_FILES['imgfile']['tmp_name'], "rb");
#
$imgdata = addslashes(fread($fh, filesize($_FILES['imgfile']['tmp_name'])));
#
fclose($fh);
$imgdata store to database as variable
Retrive Image Form Database:
      $UserId=$_REQUEST['get'];
    //$UserId=1;   
     $dbconn = mysql_connect('localhost','root','admin') or exit("SERVER Unavailable");
       $db=mysql_select_db('test',$dbconn) or exit("DB Unavailable");
     $query = "SELECT Image FROM UserLogin where UserId=$UserId";
     $result = mysql_query($query, $dbconn) or die('Check Sql Statement');
     $result_data = mysql_fetch_array($result, MYSQL_ASSOC);
     $img=$result_data['Image'];
   
   
if (!empty($img))
{
    header("Content-Type: image/jpeg");
    $img=$result_data['Image'];
    echo $img;
}
else
{
    $imgfile="../Image/NotFound.jpg";   
    $img=imagecreatefromjpeg($imgfile);
    header("Content-Type: image/jpeg");
    imagejpeg($img);
}
exit();
?>
No comments:
Post a Comment