|
 |
| |
ช่วยด้วยครับคนเก่งๆ ช่วยเรื่อง php ดึง file txt ไป คิวรี่ sql ช่วยตอบทีครับ T-T |
| |
 |
|
|
 |
 |
|
ผมใช้คำสั่งนี้ดึงข้อมูล ครับ
อันนี้ตัวดึงมาโชว์หน้าเว็ป
Code (PHP)
<html>
<head>
<title> PHP & Send Hackspeed</title>
</head>
<body>
<?
@header ('Content-type: text/html; charset=utf-8');
$strFileName = "2011_03_24_21_49_09_Hack_Map.log";
$objFopen = fopen($strFileName, 'r');
if ($objFopen) {
while (!feof($objFopen)) {
$file = fgets($objFopen, 4096);
echo $file."<br>";
}
fclose($objFopen);
}
?>
</body>
</html>
อันนี้ ตัว คิวรี่ครับ
Code (PHP)
<html>
<head>
<title>ThaiCreate.Com PHP & Text To MySQL</title>
</head>
<body>
<?
$msserver = 'localhost';
$msuser = 'sa';
$mspass = '123456789';
$dbaccount = 'mydatabase';
$conn = mssql_connect($msserver,$msuser,$mspass);
$con = mssql_select_db($dbaccount,$conn) or die("Not connect to SQL");
$objCSV = fopen("2011_03_24_21_49_09_Hack_Map.log", "r");
while (($objArr = fgetcsv($objCSV, 70)) !== FALSE) {
$strSQL = "INSERT INTO cut_ip ";
$strSQL .="(ip,strContent,strID) ";
$strSQL .="VALUES ";
$strSQL .="('".$objArr[5]."','".$objArr[2]."','".$objArr[3]."')";
$objQuery = mssql_query($strSQL);
}
fclose($objCSV);
echo "Import Done.";
?>
</table>
</body>
</html>
แล้วมันออกมาเป็นแบบนี้
Code
2011-03-24 23:24:01 MOVE 0x40000 223.207.48.119 NPCAdmm 638693 0x3028b (380497.156250,4272.104492,329084.656250)->(53805.437500,5383.204590,741620.875000) 526227.000000
2011-03-24 23:27:06 MOVE 0x40000 223.207.48.119 NPCAdmm 638693 0x3028b (1073448.375000,3317.737061,1166106.500000)->(1073751.375000,3218.721191,1155965.250000) 10146.258789
2011-03-24 23:27:06 MOVE 0x40000 223.207.48.119 NPCAdmm 638693 0x3028b (1073448.375000,3317.737061,1166106.500000)->(1073751.375000,3218.721191,1155965.250000) 10146.258789
2011-03-24 23:27:06 MOVE 0x40000 223.207.48.119 NPCAdmm 638693 0x3028b (1073448.375000,3317.737061,1166106.500000)->(1073771.250000,3218.720703,1155715.125000) 10396.861328
2011-03-24 23:27:06 MOVE 0x40000 223.207.48.119 NPCAdmm 638693 0x3028b (1073448.375000,3317.737061,1166106.500000)->(1073771.250000,3218.720703,1155715.125000) 10396.861328
2011-03-24 23:27:06 MOVE 0x40000 223.207.48.119 NPCAdmm 638693 0x3028b (1073448.375000,3317.737061,1166106.500000)->(1073791.125000,3218.720459,1155465.000000) 10647.478516
2011-03-24 23:27:06 MOVE 0x40000 223.207.48.119 NPCAdmm 638693 0x3028b (1073448.375000,3317.737061,1166106.500000)->(1073791.125000,3218.720459,1155465.000000) 10647.478516
2011-03-24 23:32:30 MOVE 0x40000 1.1.152.158 HowiZ€R 638415 0x3028b (382109.968750,4272.184082,327054.062500)->(383256.468750,4266.851563,338476.000000) 11479.335938
2011-03-24 23:32:30 MOVE 0x40000 1.1.152.158 HowiZ€R 638415 0x3028b (382109.968750,4272.184082,327054.062500)->(383256.468750,4266.851563,338476.000000) 11479.335938
2011-03-24 23:32:30 MOVE 0x40000 1.1.152.158 HowiZ€R 638415 0x3028b (382109.968750,4272.184082,327054.062500)->(383256.468750,4266.851563,338476.000000) 11479.335938
2011-03-24 23:32:30 MOVE 0x40000 1.1.152.158 HowiZ€R 638415 0x3028b (382109.968750,4272.184082,327054.062500)->(383256.468750,4266.851563,338476.000000) 11479.335938
2011-03-24 23:32:30 MOVE 0x40000 1.1.152.158 HowiZ€R 638415 0x3028b (382109.968750,4272.184082,327054.062500)->(383253.781250,4266.994141,338446.125000) 11449.341797
2011-03-24 23:32:30 MOVE 0x40000 1.1.152.158 HowiZ€R 638415 0x3028b (382109.968750,4272.184082,327054.062500)->(383253.781250,4266.994141,338446.125000) 11449.341797
2011-03-24 23:36:03 MOVE 0x40000 110.169.183.206 KilleRSweeTz 638563 0x30183 (211180.812500,12958.680664,708096.875000)->(240902.546875,12770.153320,601086.312500) 111061.593750
2011-03-24 23:36:03 MOVE 0x40000 110.169.183.206 KilleRSweeTz 638563 0x30183 (211180.812500,12958.680664,708096.875000)->
ผมอยากทราบว่าเราจะดึงคำว่า MOVE IP และตัวเลข 638693 ไป คิวรี่เข้า sql ยังไงพอมีวิธีไหมครับท่านเทพ !!
Tag : PHP, Ms SQL Server 2008
|
ประวัติการแก้ไข
2013-06-29 03:30:59
2013-06-29 03:36:54
|
 |
 |
 |
 |
| Date :
2013-06-29 03:29:37 |
By :
gotcoltd |
View :
792 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ถ้าจำนวนข้อความในแต่ละแถวเท่ากันลองใช้ substr ตัดข้อความตำแหน่งที่ต้องการ แล้วเอาไปใช้งานครับ 
php-substr
|
ประวัติการแก้ไข
2013-06-29 14:08:40
| |
|
|
| |
| Date :
2013-06-29 14:07:36 |
By :
Manussawin |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ท่าน GuEmboy แต่ละแถว ข้อความไม่เท่ากัน มีวิธี ตัดค่า ที่เราต้องการได้ไหมครับ
|
| |
|
|
| |
| Date :
2013-06-29 15:12:12 |
By :
gotcoltd |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 04
|
