 |
|
พี่ครับช่วยดูให้หน่อย
ผมทำแล้วไม่รู้ว่าเออเรอตรงไหนอ่ะ
มันแจ้งว่า Parse error: syntax error, unexpected T_VARIABLE in C:\AppServ\www\in2.php on line 15
Code (PHP)
<html>
<head>
<title>ThaiCreate.Com PHP & CSV To MySQL</title>
</head>
<body>
<?
$objConnect = mysql_connect("localhost","root","admin") or die("Error Connect to Database"); // Conect to MySQL
$objDB = mysql_select_db("med");
$objCSV = fopen("officer.csv", "r");
while (($objArr = fgetcsv($objCSV, 1000, ",")) !== FALSE) {
$strSQL = "INSERT INTO officer ";
$strSQL .="(of_tname,of_name,of_tnameen,of_nameen,of_username,of_password,of_positions,unitid,permission,permenu) ";
$strSQL .="VALUES ";
$strSQL .="('".$objArr[0]."','".$objArr[1]."','".$objArr[2]."' ";
$strSQL .=",'".$objArr[3]."','".$objArr[4]."','".$objArr[5]."' ";
$strSQL .=",'".$objArr[6]."','".$objArr[7]."','".$objArr[8]."','".$objArr[9]."') ";
$objQuery = mysql_query($strSQL);
}
fclose($objCSV);
echo $strSQL;
echo "Import Done.";
?>
</table>
</body>
</html>
Tag : PHP, MySQL
|
|
|
 |
 |
 |
 |
| Date :
2012-01-31 14:55:37 |
By :
Clamore |
View :
952 |
Reply :
3 |
|
 |
 |
 |
 |
|
|
|
|
 |
