<?php include "posdscan.class.php"; include "functions.php"; saveHit(); if (isset($_POST['dscan'])) { $dscan = $_POST['dscan']; $objects = parseDscan($dscan); $key = saveDscan($objects); //Save to file file_put_contents("scans/" . $key, $dscan); header('Location: /dscan/' . $key); //print_r($objects); } ?> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content=""> <!-- Latest compiled and minified CSS --> <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css"> <?php include "../switcher.php"; ?> <link rel="stylesheet" href="/dscan/css/custom.css"> <!-- Optional theme --> <!-- Latest compiled and minified JavaScript -->
<?php include "functions.php"; $list = getDscanList(); //Connect MySQL include "config.php"; $db = new PDO('mysql:host=' . $mysql_host . ';dbname=' . $mysql_db . ';charset=utf8', $mysql_user, $mysql_pass); foreach ($list as $scan) { $raw = file_get_contents("scans/" . $scan['key']); $dscan = parseDscan($raw); echo $scan['key'] . "... "; //Build SQL for object dump $sql = "INSERT INTO dscanObjects(`scan`, `name`, `type`, `distance`) VALUES "; for ($i = 0; $i < count($dscan); $i++) { $sql .= "(:" . $i . "scan, :" . $i . "name, :" . $i . "type, :" . $i . "distance),"; } $sql = rtrim($sql, ","); $st = $db->prepare($sql); //Bind values for ($i = 0; $i < count($dscan); $i++) { $st->bindValue(":" . $i . "scan", $scan['id'], PDO::PARAM_INT); $st->bindValue(":" . $i . "name", $dscan[$i]['name'], PDO::PARAM_STR); $st->bindValue(":" . $i . "type", $dscan[$i]['type'], PDO::PARAM_STR); $st->bindValue(":" . $i . "distance", $dscan[$i]['distance'], PDO::PARAM_INT); } //Execute the dump $st->execute(); echo " Done!\n"; }