-
Notifications
You must be signed in to change notification settings - Fork 0
/
mail_express_trn_list.php
41 lines (33 loc) · 1.13 KB
/
mail_express_trn_list.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<?php
require_once("db.php");
$url = 'http://www.indianrail.gov.in/mail_express_trn_list.html';
$ch = curl_init($url);
set_time_limit(600);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$result = curl_exec($ch);
//echo $result;
error_reporting(E_ERROR | E_PARSE);
$dom = new DOMDocument('1.0', 'UTF-8');
$dom->loadHTML($result);
if($dom)
{
$xpath = new DOMXPath($dom);
$q = '///*[contains(concat(" ", normalize-space(@class), " "), " table_border ")]/tr';
$nodes = $xpath->query($q);
foreach($nodes as $tr){ // DOMNodesList implements traversable
echo "<br>";
$tds = $tr->childNodes;
$i = 0;
foreach($tds as $td){
$arr[$i]=$td->nodeValue;
$i++;
}
//var_dump($arr);
//echo"<br><=====><br>";
//echo ""
mysqli_query($con,"INSERT INTO `irl`.`trains` (`TrainNo`, `TrainName`, `Origin`, `DepartureTime`, `Destination`, `ArrivalTime`)
VALUES ('$arr[0]', '$arr[1]', '$arr[2]', '$arr[3]', '$arr[4]', '$arr[5]');") or die(mysqli_error($con));
}
}
else
echo "invalid DOMDocument <br>";