 |
|
thaicreate.txt
xxxxxxxxx|x|xxxxxxxxxxxxxx|x|xxxx|x|
xxxxxxxxx|x|xxxxxxxxxxxxxx|x|xxxx|x|
xxxxxxxxx|x|xxxxxxxxxxxxxx|x|xxxx|x|
xxxxxxxxx|x|xxxxxxxxxxxxxx|x|xxxx|x|
xxxxxxxxx|x|xxxxxxxxxxxxxx|x|xxxx|x|
xxxxxxxxx|x|xxxxxxxxxxxxxx|x|xxxx|x|
Code (PHP)
<html>
<head>
<title>ThaiCreate.Com PHP & Readfile</title>
</head>
<body>
<?
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database"); // Conect to MySQL
$objDB = mysql_select_db("mydatabase");
$strFileName = "thaicreate.txt";
$objFopen = fopen($strFileName, 'r');
if ($objFopen) {
while (!feof($objFopen)) {
$file = fgets($objFopen, 4096);
$arr = explode("|", $file);
$strSQL = "INSERT INTO table ";
$strSQL .="(f1,f2,f2,f4,f5,f6) ";
$strSQL .="VALUES ";
$strSQL .="('".$arr[0]."','".$arr[1]."','".$arr[2]."','".$arr[3]."','".$arr[4]."','".$arr[5]."') ";
$objQuery = mysql_query($strSQL);
}
fclose($objFopen);
}
?>
</body>
</html>
|
 |
 |
 |
 |
| Date :
2010-04-27 22:34:23 |
By :
webmaster |
|
 |
 |
 |
 |
|
|
 |
