hey guys... i'm having problems with something hope someone can help me out. Rite i've got this script from a forum it works fairly well but not completely,
i'm trying to upload image file into mssql database it works great, but next bit is I have to show all those images on a web browser, the problem is it only shows like 10%-20% of the image the rest is just blank. Below is a code for uploading and showing images.
hope someone can help me out, thanx in advance to anyone who helps me.
// upload.php
$fileName1 = $_FILES['userfile1']['name'];
$tmpName1 = $_FILES['userfile1']['tmp_name'];
$datastring1= file_get_contents($tmpName1);
$data1=unpack("H*hex", $datastring1);
$fileName2 = $_FILES['userfile2']['name'];
$tmpName2 = $_FILES['userfile2']['tmp_name'];
$datastring2 = file_get_contents($tmpName2);
$data2 = unpack("H*hex", $datastring2);
$fileName3 = $_FILES['userfile3']['name'];
$tmpName3 = $_FILES['userfile3']['tmp_name'];
$datastring3 = file_get_contents($tmpName3);
$data3 = unpack("H*hex", $datastring3);
$a = "0x".$data1['hex'];
$b = "0x".$data2['hex'];
$c = "0x".$data3['hex'];
$SQL="INSERT INTO Uploaded_Files(filename1, image1, filename2, image2, filename3, image3) VALUES
('$fileName1', $a, '$fileName2', $b, '$fileName3', $c);";
mssql_query($SQL) or die('Error, query failed');
if($SQL) { echo "success <a href='show.php'>SHOW</a>"; } else { echo "erro"; }
$SQL = "SELECT filename1, image1, filename2, image2, filename3, image3 FROM Uploaded_Files";
$SQL_Query = mssql_query($SQL);
$result = mssql_query($SQL);
$row = mssql_fetch_array($result);
$filename1 = $row['filename1'];
$filename2 = $row['filename2'];
$filename3 = $row['filename3'];
$ext1 = str_replace('.','',strstr($filename1, '.'));
$ext2 = str_replace('.','',strstr($filename2, '.'));
$ext3 = str_replace('.','',strstr($filename3, '.'));
//echo $ext1;
header("Content-type: image/jpg");
echo $row[1];
echo $row[3];
echo $row[5];
