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 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
| <?php
// INFORMATIONS A SAISIR
$url = 'http://www.vola-racing.com/circuitpro/circuitalainprost/update.php?dir=circuitpro:circuitalainprost&index=0';
$data = utf8_decode(substr(file_get_contents($url), 8, -1));
$numero = '25';
// BASE DE DONNEE SQLITE
$doc = new DOMDocument();
$doc->loadHTML($data);
$xpath = new DOMXPath($doc);
try
{
$dbh = new PDO("sqlite::memory:");
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e)
{
exit($e->getMessage());
}
$dbh->query("CREATE TABLE race (clt INTEGER, num INTEGER, driver, lastlap TIME, interval TIME, lap INTEGER, blank)");
$stmt = $dbh->prepare("INSERT INTO race VALUES (?, ?, ?, ?, ?, ?, ?)");
foreach($xpath->query('//tr') as $line)
{
$values = array();
foreach ($xpath->query('td', $line) as $child)
{
$values[] = $child->nodeValue;
}
$stmt->execute($values);
}
$query = $dbh->query("SELECT * FROM `race` WHERE `num`='$numero' LIMIT 1");
$driver = $query->fetchObject();
// Notre pilote
$suivant = $driver->clt - 1;
$precedent = $driver->clt + 1;
// Pilote précédent
$query = $dbh->query("SELECT * FROM `race` WHERE `clt`='$precedent' LIMIT 1");
$driverprecedent = $query->fetchObject();
// Pilote suivant
$query = $dbh->query("SELECT * FROM `race` WHERE `clt`='$suivant' LIMIT 1");
$driversuivant = $query->fetchObject();
echo "dernier chrono notre pilote: ", $driver->lastlap, "<br>";
echo "dernier chrono pilote precedent: ",$driverprecedent->lastlap;
echo '<br>';
//Calcul de l'écart de chrono entre notre pilote et le pilote precedent/suivant
$diff= "SELECT strftime('%f','$driver->lastlap') - strftime('%f','$driverprecedent->lastlap')";
echo "difference de temps entre notre pilote et pilote precedent: ", $diff;
?> |
Partager