Advertisement
Guest User

db

a guest
Oct 19th, 2017
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.29 KB | None | 0 0
  1.         $content = Parser::getData();
  2.  
  3.         $sqlHash = "SELECT * FROM `logs` WHERE `hash` = ?";
  4.         $sqlView = "SELECT * FROM  `views` WHERE `view` = ?";
  5.         $sqlRequest = "SELECT * FROM  `requests` WHERE `hash` = ?";
  6.  
  7.         foreach ($content as $row) {
  8.             $hash = md5($row);
  9.             $resultLogs = $adapter->query($sqlHash, [$hash]);
  10.  
  11.             if(count($resultLogs) === 0) {
  12.                 $a = unserialize($row);
  13.                 $view = $a['view'];
  14.                 $request = $a['request'];
  15.                 $hashRequest = md5($request);
  16.                 if(isset($a['assets'][0])) {
  17.                     $assets = $a['assets'][0];
  18.                 }
  19.                 $resultViews = $adapter->query($sqlView, [$view]);
  20.                 if(count($resultViews) === 0){
  21.                     $statement = $adapter->createStatement("INSERT INTO `views` (view) VALUES ('$view')");
  22.                     $idV = $statement->execute()->getGeneratedValue();
  23.                 } else {
  24.                     $idV = $resultViews->toArray()[0]['id'];
  25.                 }
  26.                 $resultRequests = $adapter->query($sqlRequest, [$hashRequest]);
  27.                 if(count($resultRequests) === 0){
  28.                     $statement = $adapter->createStatement("INSERT INTO `requests` (request, hash) VALUES ('$request', '$hashRequest')");
  29.                     $idR = $statement->execute()->getGeneratedValue();
  30.                 } else {
  31.                     $idR = $resultRequests->toArray()[0]['id'];
  32.                 }
  33.  
  34.                 $statement = $adapter->createStatement("INSERT INTO `logs` (id_v, id_r, hash)
  35.                                                        VALUES ('$idV', '$idR', '$hash' )");
  36.  
  37.                 $idLog = $statement->execute()->getGeneratedValue();
  38.                 if(isset($assets)) {
  39.                     foreach ($assets as $asset) {
  40.                         $statement = $adapter->createStatement("INSERT INTO `assets` (asset) VALUES ('$asset')");
  41.                         $idAsset = $statement->execute()->getGeneratedValue();
  42.  
  43.                         $statement = $adapter->createStatement("INSERT INTO `logs_assets` (id_l, id_a) VALUES ('$idLog', '$idAsset')");
  44.                         $statement->execute();
  45.                     }
  46.                 }
  47.  
  48.             }
  49.  
  50.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement