hi!
I am uploading file into mySQL database from web site. But it is unable to
upload it into database.
If you know how to upload the file from web site into mySQL, could you
please teach me how!
the database information is;
create table objects
b_col blob,
name varchar(30),
file_size varchar(30),
file_date datetime
}
-------------testform.php-------------
<form method="post" action="upload.php" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="512000">
<input type="file" name="UploadedFile"><br>
<input type="submit" value="SEND">
</form>
----------------------------------------------------
-------upload.php--------
$db = mysql_connect("localhost", "*****", "***");
mysql_select_db("*****",$db);
$sql_insert = "LOAD DATA LOCAL INFILE '$HTTP_POST_FILES[$UploadedFile]'INTO
TABLE objects";
mysql_query($sql_insert);
----------------------------------------------------
Regards,
Hiro
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
