Advertisement
Guest User

Untitled

a guest
Mar 27th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.72 KB | None | 0 0
  1. function get_array_needed() {
  2.     $servername = "localhost";
  3.     $username = "algolhos_unisitc";
  4.     $password = "Un1s1t_commerce";
  5.     $dbname = "algolhos_unisitc";
  6.  
  7.     // Create connection
  8.     $conn = new mysqli($servername, $username, $password, $dbname);
  9.     // Check connection
  10.     if ($conn->connect_error) {
  11.         die("Connection failed: " . $conn->connect_error);
  12.     }
  13.  
  14.     $sql = "SELECT codice_target FROM customer";
  15.     $result = $conn->query($sql);
  16.     $rtoclass = array();
  17.  
  18.     if ($result->num_rows > 0) {
  19.         // output data of each row
  20.         while($row = $result->fetch_assoc()) {
  21.             echo "id: " . $row["id_customer"]. " - Codice target: " . $row["codice_target"]."<br>";
  22.             $rtoclass[] = $row;
  23.         }
  24.     } else {
  25.         echo "0 results";
  26.     }
  27.  
  28.     $conn->close();
  29.     return $rtoclass;
  30. }
  31.     $obj->set_arr_needed( get_array_needed() ); // change $obj with the instance name writeToFile() is using...
  32.     public function writeToFile($ae, $sorted_fields, $elements)
  33.     {
  34.         $url = $this->getFileUrl($ae->filename, $ae->type);
  35.  
  36.         $file = @fopen( $url, 'w' );
  37.         //add labels for export data ==== Nascosto da Dario
  38.         //if($ae->add_header)
  39.           //$this->filewrite($ae, $sorted_fields, $file);
  40.  
  41.         $i = 0;
  42.         while ($element = $this->nextRow($elements))
  43.         {
  44.             if ($i == $this->rowsNumber - 1)
  45.             {
  46.                 $this->lastElement = $element;
  47.             }
  48.  
  49.             Configuration::updateGlobalValue("AdvancedExport_CURRENT", (string)$i);
  50.             //progress bar
  51.             $this->getDataFromObject($element, $file, $sorted_fields, $ae);
  52.             $i++; //progress bar
  53.         }
  54.  
  55.         //close file
  56.         if($file)
  57.             fclose($file);
  58.  
  59.         return $url;
  60.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement