 |
|
คือฟิวชื่อกับแผนกไม่บันทึกคะ

myfile.sql
Code (SQL)
CREATE TABLE `myfiles` (
`FilesID` int(4) NOT NULL auto_increment,
`FilesName` varchar(100) NOT NULL,
`Name` varchar(50) NOT NULL,
`Department` varchar(50) NOT NULL,
`Datesave` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`FilesID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- dump ตาราง `myfiles`
--
INSERT INTO `myfiles` VALUES (1, 'เพื่à¸à¸™à¸Šà¸§à¸™à¹€à¸žà¸·à¹ˆà¸à¸™ TPBR.pdf', '', '', '2018-05-31 08:42:21');
INSERT INTO `myfiles` VALUES (2, 'UOB.txt', '', '', '2018-05-31 08:42:21');
INSERT INTO `myfiles` VALUES (3, 'รายà¸à¸²à¸£à¸›à¸£à¸°à¹€à¸¡à¸´à¸™.pdf', '', '', '2018-05-31 08:42:21');
INSERT INTO `myfiles` VALUES (4, 'Manaul Calandar.pdf', '', '', '2018-05-31 08:42:21');
INSERT INTO `myfiles` VALUES (12, '20180409 CPS Homebrand Trolley Bin Liner 240L 4pk.pdf', '', '', '2018-05-31 11:08:42');
INSERT INTO `myfiles` VALUES (11, '20180409 CPS Homebrand Trolley Bin Liner 240L 4pk.pdf', '', '', '2018-05-31 08:45:10');
INSERT INTO `myfiles` VALUES (13, '22222.pdf', '', '', '2018-05-31 11:22:53');
ส่วนของฟอร์มคะ uploadfile1.php
Code (PHP)
<form name="form1" method="post" action="uploadfile2.php" enctype="multipart/form-data">
<div class="col-lg-12">
<div class="row">
<div class="col-lg-5">
<div class="form-group">
<label> ชื่อไฟล์</label>
<input name="Name" class="form-control" id="Name" placeholder="ระบุ ชื่อไฟล์" required="required"/></textarea>
</div></div>
<div class="col-lg-3">
<div class="form-group">
<label>เอกสารของแผนก</label>
<select name="Department" class="form-control" id="Department" placeholder="ระบุเอกสารของแผนก" required />
<option value=""></option>
<option>HR</option>
<option>QMR</option>
<option>DCC</option>
<option>CI</option>
<option>PUR</option>
<option>MSC</option>
<option>PRO</option>
<option>QC</option>
<option>STORE</option>
<option>MTN</option>
<option>ACC</option>
<option>PPC</option>
<option>SHE</option>
<option>IT</option>
<option>ผู้บริหาร</option>
</select>
</div></div></div>
<div class="row">
<div class="col-lg-4">
<div class="form-group">
<label>เลือกไฟล์เอกสาร</label>
<input type="file" name="filUpload">
</div></div></div>
<div class="row">
<div class="col-lg-4">
<div class="form-group">
<button class="btn btn-success" name="btnSubmit" type="submit" value="Submit">เพิ่มข้อมูล</button>
</div></div></div>
</form>
uploadfile2.php
Code (PHP)
<?php
/*
echo "<pre>";
print_r($_POST);
echo "</pre>";
exit();
*/
if(copy($_FILES["filUpload"]["tmp_name"],"myfile/".$_FILES["filUpload"]["name"]))
{
echo "Copy/Upload Complete<br>";
//*** Insert Record ***//
$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("mydatabase");
$strSQL = "INSERT INTO myfiles ";
$strSQL .="(FilesName,Name,Department) VALUES ('".$_FILES["filUpload"]["name"]."','".$_POST["txtName"]."','".$_POST["txtDepartment"]."')";
$objQuery = mysql_query($strSQL) or die ("Error in query: $sql " . mysql_error());
mysql_close();;
}
?>
<a href="uploadfile1.php">ดูข้อมูล</a>
Tag : PHP, MySQL
|
ประวัติการแก้ไข 2018-05-31 13:28:49 2018-05-31 13:29:55 2018-05-31 13:36:31
|
 |
 |
 |
 |
Date :
2018-05-31 13:27:55 |
By :
panthipa |
View :
758 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
 |