conn.PHP:
<?PHP $id=mysql_connect('localhost','root','root'); mysql_select_db("db_database12",$id); MySQL_query("set names gb2312"); ?>
index.PHP:
<html> <head> <meta http-equiv="Content-Type" content="text/Html; charset=gb2312"> <title>以二進制形式上傳文件到數據庫</title> <style type="text/CSS"> <!-- body { margin-left: 0px; margin-top: 00px; margin-right: 0px; margin-bottom: 0px; } --> </style></head> <script language="Javascript"> function file1(form1){ if(form1.file.value==""){ alert("上傳文件不能為空!!"); form1.file.focus(); return;} form1.submit();} </script> <body> <table width="462" height="162" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="140" height="68"> </td> <td width="246"> </td> <td width="69"> </td> </tr> <form name="form1" method="post" action="index_ok.PHP"> <tr> <td height="28"> </td> <td align="left" valign="middle"><input name="file" type="file" size="22"></td> <td> </td> </tr> <tr> <td height="30"> </td> <td align="center" valign="top"><input type="submit" name="Submit" value="提交" onClick="file1(form1);"></td> <td> </td> </tr> </form> <tr> <td height="36"> </td> <td> </td> <td> </td> </tr> </table> </body> </Html>
function.PHP:
<?php session_start(); include("conn.php"); $data=date("Y-m-d"); $file1="file_name1"; if($Submit==true){ $query=MySQL_query("insert into tb_file1 (file_name,file_text,data)values('$file1','$file','$data')"); if($query==true){ echo "文件上傳成功!!"; echo "<meta http-equiv=\"refresh\" content=\"3 url=index.php\">"; }else{ echo "上傳失敗!!"; echo "<meta http-equiv=\"refresh\" content=\"3 url=index.PHP\">";}} ?>