image upload in DB MYSQL (windows XP)

[nanban]

hello friends,
I am trying to upload image in to database but its not working
Iam working this in Win XP .is there any changes to be made with
php.ini file pls mension the changes to be made in .ini file i had tried lot of codes i took this code from phpbuilder if u have any other code pls send me and help me.
thanx and regards,
Nanban.

<?php
if ($submit) {
MYSQL_CONNECT("localhost","root","");
mysql_select_db("image");

$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
echo $data;
exit;
$result=MYSQL_QUERY("INSERT INTO binary_data (description,bin_data,filename,filesize,filetype) ".
    "VALUES ('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')");

$id= mysql_insert_id();
print "<p>This file has the following Database ID: <b>$id</b>";

MYSQL_CLOSE();

}
else
{
?>

<form method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
File Description:<br>
<input type="text" name="form_description"  size="40">
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="10000000000">
<br>File to upload/store in database:<br>
<input type="file" name="form_data"  size="40">
<p><input type="submit" name="submit" value="submit">
</form>

<?php

}

?>

[bad76]

Hi,
for more help you have to say qhat is the error: when you execute this, what is the result ?

The .ini don't care, i think.

The problem may be $submit that not setted the first time.

Try to rewrite the if in this way:

if (isset($submit)) {

see you

P.S:a little pub🙂 : check my www, in coding/avatar you can get some hint...

[DigitalExpl0it]

some help

here is a upload example

<?
$data = "";
//Get the file
$filetoopen = "print.gif";
$fp = fopen($filetoopen, "rb");
while(!feof($fp)) {
	$data .= fread($fp, 1024);
}
fclose($fp);

$data = addslashes($data);
$data = addcslashes($data, "\0");

//conenct to database
if(!($dblink = mysql_connect("localhost", "root", ""))) {
	print("Unable to connect to database!");
	exit();
}

mysql_select_db("filestore", $dblink);

//insert image
$Query = "INSERT INTO images VALUES('".$filetoopen."', '$data')"; 

if(!mysql_query($Query, $dblink)) {
	print("Insert failed!");
}
?>

[DigitalExpl0it]

get file from database

<?
if(!($dblink = mysql_connect("localhost", "root", ""))) {
	print("Unable to connect to database!"); 
	exit();
}

  mysql_select_db("filestore", $dblink); 
    $Query = "SELECT data FROM images WHERE name='".addslashes($_REQUEST["file"])."'"; 

if(!($dbresult = mysql_query($Query, $dblink))) {
	print("Bad file!"); 
	exit();
}

 $row = mysql_fetch_row($dbresult); 
   $data = $row[0]; 
   $mimetype = array( 
		'doc'=>'application/msword', 
		'eps'=>'application/postscript', 
		'htm'=>'text/html', 
		'html'=>'text/html', 
		'jpg'=>'image/jpeg', 
		'gif'=>'image/gif', 
		'pdf'=>'application/pdf', 
		'txt'=>'text/plain', 
		'xls'=>'application/vnd.ms-excel' 
		); 

 $p = explode('.', $_REQUEST["file"]); 
 $pc = count($p); 
 // header("Content-Type: ".$mimetype[$p[$pc - 1]]."\n"); 
  if($pc > 1 AND isset($mimetype[$p[$pc - 1]])) {
    header("Content-Type: ".$mimetype[$p[$pc - 1]]."\n"); 
  } else {
		header("Content-Type: application/octet-stream\n"); 
	    header("Content-length: ".strlen($data)."\n"); 
  }
   		header("Content-Transfer-Encoding: binary\n"); 
		header("Content-length: ".strlen($data)."\n"); 

 print($data); 
?>

[DigitalExpl0it]

database setup

make a table called images

add two fields

name and data

name = varchar(64) primary
data = longblob

[nanban]

Hai friends,
I'm trying to just upload a file to the web server through PHP, and when I do so it uploads it fine, but it gives the file no size (0 K). The file about 10 K, but for some reason it isn't uploading it correctly?
so please help me.

thanks and regards,
Nanban.
😕

[tsinka]

Can you post your most recent code ?