[SOLVED] problem show upload or How to extract the files?

[Hany_h2004]

I have the code php

 

My SQL

 

^{CREATE  TABLE  `files` ( `id` INT UNSIGNED NOT  NULL  AUTO_INCREMENT ,}

^{`filename` VARCHAR( 255  )  NOT  NULL ,}

^{`filesize` INT NOT  NULL ,}

^{`filetype` VARCHAR( 255  )  NOT  NULL ,}

^{`filedata` BLOB NOT  NULL ,}

^{PRIMARY  KEY (  `id`  )}

^);

 

and

 

HTML Form:

 

_{<form method="post" action="upload.php" enctype="multipart/form-data">}

_{<input type="hidden" name="MAX_FILE_SIZE" value="1000000" />}

_{<input type="text" name="filename" /><br />}

_{<input type="file" name="filedata" /><br />}

_{<input type="submit" name="submit" value="submit" /><br />}

_</form>

 

Code PHP

 

^<?

^{// ضع بيانات قاعدة البيانات لديك هنا}

^{mysql_connect("localhost", "root", "");}

^{mysql_select_db("dbname");}

^{// لا تقم بالتعديل أسفل هذا السطر}

 

^{if($_FILES['filedata']['tmp_name'] != "")}

^{

    ^{$fileName = $_FILES['filedata']['name'];}

    ^{$tmpName  = $_FILES['filedata']['tmp_name'];}

    ^{$fileSize = $_FILES['filedata']['size'];}

    ^{$fileType = $_FILES['filedata']['type'];}

    ^{$fo = @fopen($tmpName, "r");}

    ^{$data = @fread($fo, filesize($tmpName));}

    ^{$data = addslashes($data);}

^}

^{$result = @mysql_query("INSERT INTO `files` VALUES ('', '$fileName', '$fileSize', '$fileType', '$data')");}

^if($result)

^{

    ^{echo ">>>";}

^}

^else

^{

    ^{echo ">>>";}

^}

 

^?>

 

How to extract the files?

 

--------------------------------------

code php

 

mysql

upload.php

 

and like picture

 

show files,date, size files downloads

 

plzzzzzzzzzzzzz

 

I have project in University.....

 

topic

<<<<Center Download>>>>>>

 

 

 

 

 

 

 

[attachment deleted by admin]

[Hany_h2004]

I have code uplond.php and MySQL

The MySQL

CREATE  TABLE  `files` ( `id` INT UNSIGNED NOT  NULL  AUTO_INCREMENT ,

`filename` VARCHAR( 255  )  NOT  NULL ,

`filesize` INT NOT  NULL ,

`filetype` VARCHAR( 255  )  NOT  NULL ,

`filedata` BLOB NOT  NULL ,

PRIMARY  KEY (  `id`  )

);

HTML Form:

<form method="post" action="upload.php" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="1000000" />
<input type="text" name="filename" /><br />
<input type="file" name="filedata" /><br />
<input type="submit" name="submit" value="submit" /><br />
</form>

Code PHP

]<?

mysql_connect("localhost", "root", "");
mysql_select_db("dbname");


if($_FILES['filedata']['tmp_name'] != "")
{
    $fileName = $_FILES['filedata']['name'];
    $tmpName  = $_FILES['filedata']['tmp_name'];
    $fileSize = $_FILES['filedata']['size'];
    $fileType = $_FILES['filedata']['type'];
    $fo = @fopen($tmpName, "r");
    $data = @fread($fo, filesize($tmpName));
    $data = addslashes($data);
}
$result = @mysql_query("INSERT INTO `files` VALUES ('', '$fileName', '$fileSize', '$fileType', '$data')");
if($result)
{
    echo ">>>";
}
else
{
    echo ">>>";
}

?> [/sup] 

 

My Question

How to extract the files? 

How display files?

-----------------

 

 

I have project in University.....

can you anyone help my plazzz

 

I want website <<<<center Downlod>>>>

 

upload and show like the picture??

[Hany_h2004]

plzzzzzzzzzzzzzzzzzz

 

help me