Friday, August 17, 2012

how to upload image into database using php


how to upload file in database in php

how to upload image into database using php

step 1

1. create database demo


CREATE TABLE IF NOT EXISTS `table1` (
  `id` int(11) NOT NULL auto_increment,
  `file` longblob NOT NULL COMMENT 'file in binary',
  `type` varchar(250) NOT NULL,
  `name` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


2. create two file 


demo.php

photo.php


demo.php

<?php 

$con
=mysql_connect('localhost','root','');
mysql_select_db('demo',$con);

//print_r($_FILES);
if(isset($_REQUEST['sub'])){
 
$tpy=$_FILES['txtfile']['type'];
  
$name=$_FILES['txtfile']['name'];
   
$c=file_get_contents($_FILES['txtfile']["tmp_name"]);
mysql_query("insert into table1(file,type,name) values('".addslashes($c)."', '".$tpy."', '".$name."')");
}
$arr=mysql_query("select * from table1");
while(
$r=mysql_fetch_array($arr)){
// echo "<img src='photo.php?id=".$r[0]."'  />";
 
echo "<a href='photo.php?id=".$r[0]."'>Download here </a>";
 }
?>

<form action="" enctype="multipart/form-data" method="post">
<input type="file" name="txtfile"  />
<input type="submit" name="sub" value="submit"  />
</form> 

photo.php

<?php 

$con
=mysql_connect('localhost','root','');
mysql_select_db('demo',$con);

$arr=mysql_query("select * from table1 where id= '".$_REQUEST['id']."' ");
while(
$r=mysql_fetch_array($arr)){
header("Content-Disposition: attachment;filename=".$r['name']."");
$ty=$r[2];
header("Content-type:".$ty."");
echo 
$r[1];



}
?>

No comments:

Post a Comment

If you Satisfied , Please Leave a comment