0
<?php
  $host='localhost';
  //Change the user,password and database variables as desired
  $user='root';
  $pass='';
  $dbname='imagedb';
  $link=mysql_connect($host,$user,$pass) or die(mysql_error());
  $db=mysql_select_db($dbname) or die(mysql_error());
?>



<html>
<head>
<title>Uploading image to MySQL database and displaying it</title>
<script src="mootools1_2.js" type="text/javascript" language="javascript"></script>
<script src="ajax.js" type="text/javascript" language="javascript"></script>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<fieldset>
<legend>Upload Form</legend>
<form enctype='multipart/form-data' name='frmupload' action='' method='POST'>
<input type="hidden" name="MAX_FILE_SIZE" value="524288" />
<input name='filename' type='file'>
<input type='submit' value='Submit' name='submit'>
</form>
</fieldset>
<?php
include("dbconnect.php");
 
if(isset($_POST['submit'])){
 
if(is_uploaded_file($_FILES['filename']['tmp_name'])){
 
	$maxsize=$_POST['MAX_FILE_SIZE'];		
	$size=$_FILES['filename']['size'];
 
	// getting the image info..
	$imgdetails = getimagesize($_FILES['filename']['tmp_name']);
	$mime_type = $imgdetails['mime']; 
 
	// checking for valid image type
	if(($mime_type=='image/jpeg')||($mime_type=='image/gif')){
	  // checking for size again
	  if($size<$maxsize){
	    $filename=$_FILES['filename']['name'];	
	    $imgData =addslashes (file_get_contents($_FILES['filename']['tmp_name']));
	    $sql="INSERT into image(name,image,type,size) values ('$filename','$imgData','".$mime_type."','".addslashes($imgdetails[3])."')";					
	    mysql_query($sql,$link) or die(mysql_error());
	  }else{
	    echo "<font class='error'>Image to be uploaded is too large..Error uploading the image!!</font>";
	  }
	}else{
	  echo "<font class='error'>Not a valid image file! Please upload jpeg or gif image.</font>";
	}
 
}else{			
  switch($_FILES['filename']['error']){
	case 0: //no error; possible file attack!
	  echo "<font class='error'>There was a problem with your upload.</font>";
	  break;
	case 1: //uploaded file exceeds the upload_max_filesize directive in php.ini
	  echo "<font class='error'>The file you are trying to upload is too big.</font>";
	  break;
	case 2: //uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the html form
	  echo "<font class='error'>The file you are trying to upload is too big.</font>";
	  break;
	case 3: //uploaded file was only partially uploaded
	  echo "<font class='error'>The file you are trying upload was only partially uploaded.</font>";
	  break;
	case 4: //no file was uploaded
	  echo "<font class='error'>You must select an image for upload.</font>";
	  break;
	default: //a default error, just in case! 
	  echo "<font class='error'>There was a problem with your upload.</font>";
	  break;
  }		
}	
 
}
 
//List Images Part
$sql='SELECT * from image';
$query=mysql_query($sql) or die(mysql_error);
$listimage = "<fieldset>
		<legend>List Images</legend>	
	 ";
$listimage.= "
<table cellpadding='1' cellspacing='1' width='300' class='tablecss'>
  <tr class='tablecss'>
	<td nowrap class='label'>Image Name</td>
	<td class='label'>Type</td>
	<td class='label'>Size</td>
  </tr>";
$imageexist=false;
while($result=mysql_fetch_array($query)){
  $imageexist=true;		  			
  $listimage.= "
  <tr class='whiterow'>
	<td><a href='javascript:void(0)' onclick='ajaxrequest(\"".$result['id']."\")'>".$result['name']."</a></td>
	<td>".str_replace('image/','',$result['type'])."</td>
	<td nowrap>".$result['size']."</td>
  </tr>";										
}
 
$listimage.= "
</table>
</fieldset>";
 
if($imageexist){
	echo $listimage;
}
 
echo "<div id='imageframe'></div>";					
?>
</body>
</html>

<?php
  $id=$_GET['id'];
  echo "<b>IMAGE:</b> <br><img src='createimgsource.php?image_id=".$id."' />";
?>



<?php
  include("dbconnect.php");
  $id=$_GET['image_id'];
  $sql="SELECT * from image where id='$id'";
 
  $query=mysql_query($sql) or die(mysql_error());
 
  while($result=mysql_fetch_array($query)){		
    header("Content-type:".$result['type']);
    header('Content-Disposition: inline; filename="'.$result['name'].'"');
    echo $result['image'];			
  }
?>

Please anyone help me
I want to display 10 image at a time.

Thanks
Naresh

Edited by Ezzaral: Added code tags. Please use them to format any code that you post.

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by rnrajput
0

Next Problem
I want to fetch images from mysql in php .
I have created database and table.
But No Ideal fetch Images from mysql.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.