 |
|
Code (PHP)
<html>
<head>
</head>
<body>
<?php
copy($_FILES["fileCSV"]["tmp_name"],$_FILES["fileCSV"]["name"]); // Copy/Upload CSV
$objConnect = mysql_connect("localhost","root","123456") or die("Error Connect to Database"); // Conect to MySQL
$objDB = mysql_select_db("project_one");
mysql_query("SET NAMES UTF8");
$objCSV = fopen($_FILES["fileCSV"]["name"], "r");
while (($objArr = fgetcsv($objCSV, 1000, ",")) !== FALSE) {
$strSQL = "INSERT INTO teachers ";
$strSQL .="(teacher_ID,username,password,name,last_name,position,position2,major,level,email,Tel,school_ID,status,photo,status_user) ";
$strSQL .="VALUES";
$strSQL .="('".$objArr[0]."' ,'".$objArr[1]."' ,'".$objArr[2]."') ";
$strSQL .="('".$objArr[3]."' ,'".$objArr[4]."' ,'".$objArr[5]."') ";
$strSQL .="('".$objArr[6]."' ,'".$objArr[7]."' ,'".$objArr[8]."') ";
$strSQL .="('".$objArr[9]."' ,'".$objArr[10]."' ,'".$objArr[11]."') ";
$strSQL .="('".$objArr[12]."' ,'".$objArr[13]."' ,'".$objArr[14]."')";
$objQuery = mysql_query($strSQL);
}
fclose($objCSV);
unlink($_FILES["fileCSV"]["name"]);
echo "Upload & Import Done.";
?>
</table>
</body>
</html>
Tag : PHP
|
|
|
 |
 |
 |
 |
| Date :
2014-12-20 00:37:17 |
By :
supattra_BEER |
View :
805 |
Reply :
6 |
|
 |
 |
 |
 |
|
|
|
|
 |
