export_file.php

<?php
  require 'dbconnect.php';

  function export_data($export_array, $export_type) {
    $file_name = rand();
    switch ($export_type) {
      case 'json':
        $json_file = json_encode($export_array);
        $fp = fopen('export_files/'.$file_name.'.json', 'w');
        fwrite($fp, $json_file);
        fclose($fp);
        $return=$file_name.'.json';
        break;
      case 'xml':
        $xml = arrayToXml($export_array);
        $xml->asXML('export_files/'.$file_name.'.xml');
        $return=$file_name.'.xml';
        break;
      case 'csv':
        $fp = fopen('export_files/'.$file_name.'.csv', 'w');
        foreach ($export_array as $fields) {
          fputcsv($fp, $fields);
        }
        fclose($fp);
        $return=$file_name.'.csv';
        break;
    }
    return $return;
  }

  function add_activity_info($row, $activities, $conn) {
    $activities_check = "AND (";
    for ($i=0; $i < count($activities) ; $i++) {
      $activities_check.= "(".$activities[$i]. " IS NOT NULL) ";
      if($i != count($activities) -1) {
        $activities_check.="OR ";
      }
    }
    $activities_check.=")";

    $query_2 = sprintf("SELECT * FROM `user_activity` WHERE (userMapData_timestampMs = '%s') $activities_check",
    mysqli_real_escape_string($conn, $row["timestampMs"]));
    $result_2 = mysqli_query($conn, $query_2);
    if(!$result_2){
      return false;
    }
    else {
      $final_array =array();
      while ($row_2 = mysqli_fetch_assoc($result_2)) {
        foreach ($row_2 as $key => $value) {
          if($key == 'userMapData_timestampMs' || $key == 'userMapData_userId'){
            unset($row_2[$key]);
          }
        }
        //$row_2 += $userId;
        $final_array=array_merge($row, $row_2);
      }
      return $final_array;
    }
  }

  function arrayToXml($array, $rootElement = null, $xml = null) {
      $_xml = $xml;
      // If there is no Root Element then insert root
      if ($_xml === null) {
          $_xml = new SimpleXMLElement($rootElement !== null ? $rootElement : '<root/>');
      }
      // Visit all key value pair
      foreach ($array as $k => $v) {
          // If there is nested array then
          if (is_array($v)) {
              // Call function for nested array
              arrayToXml($v, $k, $_xml->addChild($k));
          }else {
              // Simply add child element.
              $_xml->addChild($k, $v);
          }
      }
      return $_xml;
  }
?>