Forums

<?php
global $mainframe;
	$database =& JFactory::getDBO();

	include_once JPATH_BASE.'/components/com_chronocontact/excelwriter/'."Writer.php";
	//echo $_POST['formid'];
	/*$formid = JRequest::getVar( 'formid', array(), 'post', 'array');
	$database->setQuery( "SELECT name FROM #__chrono_contact WHERE id='".$formid[0]."'" );
	$formname = $database->loadResult();*/
	
	$tablename = 'jos_tablename';
	$tables = array( $tablename );
 	$result = $database->getTableFields( $tables );
	$table_fields = array_keys($result[$tablename]);
	
	$database->setQuery( "SELECT * FROM ".$tablename."" );
	$datarows = $database->loadObjectList();
	
	$titcol = 0;
	foreach($table_fields as $table_field){
		if($titcol){$csvline .=",";}
		$csvline .= $table_field;
		$titcol++;
	}
	$csvline .="\n";
			
	$datacol = 0;
	$rowcount = 1;
	foreach($datarows as $datarow){
		foreach($table_fields as $table_field){
			if($datacol){$csvline .=",";}
			$csvline .= '"'.addslashes($datarow->$table_field).'"';
			$datacol++;
		}
		$csvline .="\n";
		$datacol = 0;
		$rowcount++;
	}
	
	if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
		$UserBrowser = "Opera";
	}
	elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
		$UserBrowser = "IE";
	} else {
		$UserBrowser = '';
	}
	$mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
	@ob_end_clean();
	ob_start();

	header('Content-Type: ' . $mime_type);
	header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

	if ($UserBrowser == 'IE') {
		header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
		header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
		header('Pragma: public');
	}
	else {
		header('Content-Disposition: attachment; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
		header('Pragma: no-cache');
	}
	print $csvline;
	exit();
?>

$database->setQuery( "SELECT * FROM ".$tablename."" );

$query = "SELECT * 
  FROM `#__content` AS c
  LEFT JOIN `#__comprofiler_fields` AS f ON c.`created_by` = f.`fieldid` ;
";

    <?php
    global $mainframe;
       $database =& JFactory::getDBO();

       include_once JPATH_BASE.'/components/com_chronocontact/excelwriter/'."Writer.php";
       //echo $_POST['formid'];
       /*$formid = JRequest::getVar( 'formid', array(), 'post', 'array');
       $database->setQuery( "SELECT name FROM #__chrono_contact WHERE id='".$formid[0]."'" );
       $formname = $database->loadResult();*/
       
       $tablename = 'jos_comprofiler';
       $tables = array( $tablename );
       $result = $database->getTableFields( $tables );
       $table_fields = array_keys($result[$tablename]);

$query = "SELECT *
  FROM `#__content` AS c
  LEFT JOIN `#__comprofiler` AS f ON c.`created_by` = f.`fieldid` ;
";
       
       $database->setQuery( "SELECT * FROM ".$tablename."");
       $datarows = $database->loadObjectList();
       
       $titcol = 0;
       foreach($table_fields as $table_field){
          if($titcol){$csvline .=",";}
          $csvline .= $table_field;
          $titcol++;
       }
       $csvline .="\n";
             
       $datacol = 0;
       $rowcount = 1;
       foreach($datarows as $datarow){
          foreach($table_fields as $table_field){
             if($datacol){$csvline .=",";}
             $csvline .= '"'.addslashes($datarow->$table_field).'"';
             $datacol++;
          }
          $csvline .="\n";
          $datacol = 0;
          $rowcount++;
       }
       
       if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "Opera";
       }
       elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "IE";
       } else {
          $UserBrowser = '';
       }
       $mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
       @ob_end_clean();
       ob_start();

       header('Content-Type: ' . $mime_type);
       header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

       if ($UserBrowser == 'IE') {
          header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
          header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
          header('Pragma: public');
       }
       else {
          header('Content-Disposition: attachment; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
          header('Pragma: no-cache');
       }
       print $csvline;
       exit();
    ?>

$query = "
  SELECT `recordtime`, `email`, `Contact` 
    FROM `$tablename` 
    WHERE `email` = '$email' 
";
$database->setQuery($query);

<?php
$fp = @fopen($path.$filename, "w");
fputcsv($fp, $data_array, $delimiter, $quote);
fclose($fp);
?>

<?php
if ( !$mainframe->isSite() ) return;
?>

    <?php
    global $mainframe;
       $database =& JFactory::getDBO();

       include_once JPATH_BASE.'/components/com_chronocontact/excelwriter/'."Writer.php";
       //echo $_POST['formid'];
       /*$formid = JRequest::getVar( 'formid', array(), 'post', 'array');
       $database->setQuery( "SELECT name FROM #__chrono_contact WHERE id='".$formid[0]."'" );
       $formname = $database->loadResult();*/
       
       $tablename = 'oywn_Reserveren';
       $tables = array( $tablename );
       $result = $database->getTableFields( $tables );
       $table_fields = array_keys($result[$tablename]);
       
       $database->setQuery( "SELECT * FROM ".$tablename."" );
       $datarows = $database->loadObjectList();
       
       $titcol = 0;
       foreach($table_fields as $table_field){
          if($titcol){$csvline .=",";}
          $csvline .= $table_field;
          $titcol++;
       }
       $csvline .="\n";
             
       $datacol = 0;
       $rowcount = 1;
       foreach($datarows as $datarow){
          foreach($table_fields as $table_field){
             if($datacol){$csvline .=",";}
             $csvline .= '"'.addslashes($datarow->$table_field).'"';
             $datacol++;
          }
          $csvline .="\n";
          $datacol = 0;
          $rowcount++;
       }
       
       if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "Opera";
       }
       elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "IE";
       } else {
          $UserBrowser = '';
       }
       $mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
       @ob_end_clean();
       ob_start();

       header('Content-Type: ' . $mime_type);
       header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

       if ($UserBrowser == 'IE') {
          header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
          header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
          header('Pragma: public');
       }
       else {
          header('Content-Disposition: attachment; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
          header('Pragma: no-cache');
       }
       print $csvline;
       exit();
    ?>

header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');

<?php
if ( !$mainframe->isSite() ) return;

       global $mainframe;
       $database =& JFactory::getDBO();

       include_once JPATH_BASE.'/components/com_chronocontact/excelwriter/'."Writer.php";
       //echo $_POST['formid'];
       /*$formid = JRequest::getVar( 'formid', array(), 'post', 'array');
       $database->setQuery( "SELECT name FROM #__chrono_contact WHERE id='".$formid[0]."'" );
       $formname = $database->loadResult();*/
       
       $tablename = 'jos_chronoforms_yourtable';
       $tables = array( $tablename );
       $result = $database->getTableFields( $tables );
       $table_fields = array_keys($result[$tablename]);
       
       $database->setQuery( "SELECT * FROM ".$tablename."" );
       $datarows = $database->loadObjectList();
       
       $titcol = 0;
       foreach($table_fields as $table_field){
          if($titcol){$csvline .="\t";}
          $csvline .= $table_field;
          $titcol++;
       }
       $csvline .="\n";
             
       $datacol = 0;
       $rowcount = 1;
       foreach($datarows as $datarow){
          foreach($table_fields as $table_field){
             if($datacol){$csvline .="\t";}
             $csvline .= '"'.addslashes($datarow->$table_field).'"';
             $datacol++;
          }
          $csvline .="\n";
          $datacol = 0;
          $rowcount++;
       }
       
       if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "Opera";
       }
       elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "IE";
       } else {
          $UserBrowser = '';
       }
       //Don't now if theres a difference here, so just used the same
       $mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/x-msdownload' : 'application/x-msdownload';
       @ob_end_clean();
       ob_start();

       header('Content-Type: ' . $mime_type);
       header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

       if ($UserBrowser == 'IE') {
          header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.xls"');
          //also dont know if this needs to be on for XLS
          //header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
          header('Pragma: public');
       }
       else {
          header('Content-Disposition: attachment; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.xls"');
          header('Pragma: no-cache');
       }
       print $csvline;
       exit();
    ?>

unset($table_fields[0],$table_fields[1],$table_fields[2],$table_fields[3],$table_fields[4],$table_fields[7]);

$table_fields = array_keys($result[$tablename]);

$database->setQuery( "SELECT * FROM ".$tablename."" );

<?php
if ( !$mainframe->isSite() ) { return; }
// continue PHP here
?>

    <?php
    global $mainframe;
       $database =& JFactory::getDBO();

       include_once JPATH_BASE.'/components/com_chronocontact/excelwriter/'."Writer.php";
       //echo $_POST['formid'];
       /*$formid = JRequest::getVar( 'formid', array(), 'post', 'array');
       $database->setQuery( "SELECT name FROM #__chrono_contact WHERE id='".$formid[0]."'" );
       $formname = $database->loadResult();*/
       
       $tablename = 'jos_chronoforms_form_Year8To9_options';
       $tables = array( $tablename );
       $result = $database->getTableFields( $tables );
       $table_fields = array_keys($result[$tablename]);
unset($table_fields[0],$table_fields[1],$table_fields[2],$table_fields[3],$table_fields[4],$table_fields[4],$table_fields[8]);
         
       $database->setQuery( "SELECT Surname,Firstname,Username,Art,Drama,Music,ESOLa,Numeracya,Moari,French,Japanese,ESOLb,Literacy,Numeracyb,Technology,FoodTechnology,Graphics,ESOLc,Numeracyc FROM ".$tablename."" );
       $datarows = $database->loadObjectList();
       $titcol = 0;
       foreach($table_fields as $table_field){
          if($titcol){$csvline .=",";}
          $csvline .= $table_field;
          $titcol++;
       }
       $csvline .="\n";      
       $datacol = 0;
       $rowcount = 1;
       foreach($datarows as $datarow){
          foreach($table_fields as $table_field){
             if($datacol){$csvline .=",";}
             $csvline .= '"'.addslashes($datarow->$table_field).'"';
             $datacol++;
          }
          $csvline .="\n";
          $datacol = 0;
          $rowcount++;
       }       
       if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "Opera";
       }
       elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "IE";
       } else {
          $UserBrowser = '';
       }
       $mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
       @ob_end_clean();
       ob_start();

       header('Content-Type: ' . $mime_type);
       header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

       if ($UserBrowser == 'IE') {
          header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
          header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
          header('Pragma: public');
       }
       else {
          header('Content-Disposition: attachment; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
          header('Pragma: no-cache');
       }
       print $csvline;
       exit();
    ?>

<?php
if ( !$mainframe->isSite() ) { return; }
// continue PHP here
?>


<?php
    global $mainframe;
       $database =& JFactory::getDBO();

       include_once JPATH_BASE.'/components/com_chronocontact/excelwriter/'."Writer.php";
       //echo $_POST['formid'];
       /*$formid = JRequest::getVar( 'formid', array(), 'post', 'array');
       $database->setQuery( "SELECT name FROM #__chrono_contact WHERE id='".$formid[0]."'" );
       $formname = $database->loadResult();*/
       
       $tablename = 'inschrijvingen';
       $tables = array( $tablename );
       $result = $database->getTableFields( $tables );
       $table_fields = array_keys($result[$tablename]);
unset($table_fields[0],$table_fields[2],$table_fields[17]);
         
       $database->setQuery( "SELECT licentienummer, geboortejaar, naam, geslacht, categorie, onderdeel1, pronderdeel1, onderdeel2, pronderdeel2,onderdeel3,pronderdeel3,onderdeel4,pronderdeel4,startnummer,wedstrijd FROM ".$tablename."" );
       $datarows = $database->loadObjectList();
       $titcol = 0;
       foreach($table_fields as $table_field){
          if($titcol){$csvline .=",";}
          $csvline .= $table_field;
          $titcol++;
       }
       $csvline .="\n";      
       $datacol = 0;
       $rowcount = 1;
       foreach($datarows as $datarow){
          foreach($table_fields as $table_field){
             if($datacol){$csvline .=",";}
             $csvline .= '"'.addslashes($datarow->$table_field).'"';
             $datacol++;
          }
          $csvline .="\n";
          $datacol = 0;
          $rowcount++;
       }       
       if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "Opera";
       }
       elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "IE";
       } else {
          $UserBrowser = '';
       }
       $mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
       @ob_end_clean();
       ob_start();

       header('Content-Type: ' . $mime_type);
       header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

       if ($UserBrowser == 'IE') {
          header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
          header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
          header('Pragma: public');
       }
       else {
          header('Content-Disposition: attachment; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
          header('Pragma: no-cache');
       }
       print $csvline;
       exit();
    ?>

<?php
$westrijd = JRequest::getString('westrijd', '', 'post');

$field_array = array(
    'Licentie Nummer' => 'licentienummer',
    'Geboorte Jaar' => 'geboortejaar',
    'Naam' => 'naam',
    'Geslacht' => 'geslacht',
    'Categorie' => 'categorie',
    'Onder Deel 1' => 'onderdeel1',
    'Pronder Deel 1' => 'pronderdeel1',
    'Onder Deel 2' => 'onderdeel2',
    'Pronder Deel 2' => 'pronderdeel2',
    'Onder Deel 3' => 'onderdeel3',
    'Pronder Deel 3' => 'pronderdeel3',
    'Onder Deel 4' => 'onderdeel4',
    'Pronder Deel 4' => 'pronderdeel4',
    'Start Nummer' => 'startnummer',
    'Westrijd' => 'westrijd');

$title_array = $column_array = array();
foreach ( $field_array as $k => $v ) {
    $title_array[] = $k;
    $column_array[] = "`$v`";
}
$columns = implode(', ', $column_array);

$db =& JFactory::getDBO();
$query = "
    SELECT $columns 
        FROM `inschrijvingen` 
        WHERE `westrijd` = '$westrijd' ;
";

$db->setQuery($query);
$data = $db->loadAssocList();

$file_path = J_PATH_SITE.DS.'components'.DS.'com_chronocontact'.DS.'includes'.DS.'csv_export.csv';
$file = fopen($file_path, 'w');
fputcsv($file, $title_array);
foreach ( $data as $d ) {
    fputcsv($file, $d);
}
fclose($file);

echo "<a href='$file_path'>Klik hier</a> om uw bestand te downloaden";
?>

. . .
fclose($file);
$file_url = JURI::base().'components/com_chronocontact/includes/csv_export.csv';
echo "<a href='$file_url'>Klik hier</a> om uw bestand te downloaden";
?>

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">Actuele inschrijvingen RKHAV atleten</span> </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text"></span> </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Wedstrijd :</label>
    <select class="cf_inputbox validate-selection" id="select_2" size="1" title="selecteer wedstrijd"  name="wedstrijd">
    <option value="">selecteer wedstrijd</option>
      
<?php
if ( !$mainframe->isSite() ) { return; }

$db =& JFactory::getDBO();
$query = "
    SELECT *
		FROM `wedstrijden`
";
$db->setQuery($query);
$data = $db->loadObjectList();

if ( count($data) ) {
	foreach ( $data as $d ) {
		echo '<option value="'.$d->wedstrijdnaam.'">'.$d->wedstrijdnaam.'</option>';
	}
}
?>
    </select>    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text"></span> </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_button">
    <input value="bekijk inschrijvingen" name="button_1" type="submit" />
  </div>
  <div class="cfclear"> </div>
</div>

<?php
$wedstrijd = JRequest::getString('wedstrijd', '', 'post');

$field_array = array(
    'Licentienummer' => 'licentienummer',
    'Geboortejaar' => 'geboortejaar',
    'Naam' => 'naam',
    'Geslacht' => 'geslacht',
    'Categorie' => 'categorie',
    'Onderdeel1' => 'onderdeel1',
    'PRonderdeel1' => 'pronderdeel1',
    'Onderdeel2' => 'onderdeel2',
    'PRonderdeel2' => 'pronderdeel2',
    'Onderdeel3' => 'onderdeel3',
    'Pronderdeel3' => 'pronderdeel3',
    'Onderdeel4' => 'onderdeel4',
    'Pronderdeel4' => 'pronderdeel4',
    'StartNummer' => 'startnummer',
    'wedstrijd' => 'wedstrijd');

$title_array = $column_array = array();
foreach ( $field_array as $k => $v ) {
    $title_array[] = $k;
    $column_array[] = "`$v`";
}
$columns = implode(', ', $column_array);
$db =& JFactory::getDBO();
$query = "
    SELECT $columns 
        FROM `inschrijvingen` 
        WHERE `wedstrijd` = '$wedstrijd' ;
";

$db->setQuery($query);
$data = $db->loadAssocList();

$file_path = 'components'.DS.'com_chronocontact'.DS.'includes'.DS.'csv_export.csv';
$file = fopen($file_path, 'w');
fputcsv($file, $title_array);
foreach ( $data as $d ) {
    fputcsv($file, $d);
}
fclose($file);
$file_url = JURI::base().'components/com_chronocontact/includes/csv_export.csv';
echo "<a href='$file_url'>Klik hier</a> om uw bestand te downloaden";
?>

<?php
	$db = mysql_connect ('db', 'username', 'pass') or 
		die ('Unable to connect');
	mysql_select_db('dbname', $db) or die(mysql_error($db));
	//create the variables
	$tablename = jos_chronoforms_form_madre;
	$filename = '/' . $tablename . date("Y-m-d-H-i-s") . '.txt';
	echo $filename; //check the format of the file
	//Query for saving orders
	$query = "SELECT * FROM $tablename WHERE cf_user_id=65 INTO OUTFILE '$filename'";
	$result = mysql_query($query);
?> 

<?php
    global $mainframe;
       $db=& JFactory::getDBO();
       $user=& JFactory::getUser();
	//create the variables
	$tablename = jos_chronoforms_form_madre;
	$filename = '/' . $user->id . $tablename . date("Y-m-d-H-i-s") . '.csv';
        echo $filename;
	//Query for saving orders
	$query = "SELECT * FROM jos_chronoforms_form_madre WHERE cf_user_id=('".$user->id."') INTO OUTFILE '$filename'";

$db->setQuery($query);
$result = $db->query();
?> 

$tablename = jos_chronoforms_form_madre;

$tablename = "jos_chronoforms_form_madre";

<?php
	$db = mysql_connect ('host_db', 'db_user', 'password_db') or 
		die ('Unable to connect');
	mysql_select_db('database', $db) or die(mysql_error($db));
        $user=& JFactory::getUser();
	//Creates the variables
	$tablename = jos_chronoforms_form_madre;
	$filename = '/' . $tablename . date("Y-m-d-H-i-s") . '.txt'; //Used / at beginning of the file to tell the application to write it in the root
	//Query for saving the table
	$query = "SELECT * FROM $tablename WHERE cf_user_id=('".$user->id."') INTO OUTFILE '$filename'";
	$result = mysql_query($query);
?> 

$query = "SELECT * FROM $tablename WHERE cf_user_id=('".$user->id."') INTO OUTFILE '$filename'";

$query = "SELECT * FROM $tablename WHERE cf_user_id=$user->id INTO OUTFILE '$filename'";

<?php              
        include 'connection.php';
       
       //Creates the variables
       $tablename = "jos_chronoforms_staff";
       $filename = '/home/username/public_html/subdomainA/test/' . $tablename . '.csv'; 

       
       //Query for saving the table       
       $query = "SELECT * INTO OUTFILE '$filename' FROM $tablename  ";

       $result = mysql_query($query);
?>

<?php
if ( !$mainframe->isSite() ) { return; }

global $mainframe;
   $database =& JFactory::getDBO();

   include_once JPATH_BASE.'/components/com_chronocontact/excelwriter/'."Writer.php";
   //echo $_POST['formid'];
   /*$formid = JRequest::getVar( 'formid', array(), 'post', 'array');
   $database->setQuery( "SELECT name FROM #__chrono_contact WHERE id='".$formid[0]."'" );
   $formname = $database->loadResult();*/
   
   $tablename = 'jos_chronoforms_staff';
   $tables = array( $tablename );
   $result = $database->getTableFields( $tables );
   $table_fields = array_keys($result[$tablename]);
   
   $database->setQuery( "SELECT * FROM ".$tablename."" );
   $datarows = $database->loadObjectList();
   
   $titcol = 0;
   foreach($table_fields as $table_field){
      if($titcol){$csvline .=",";}
      $csvline .= $table_field;
      $titcol++;
   }
   $csvline .="\n";
         
   $datacol = 0;
   $rowcount = 1;
   foreach($datarows as $datarow){
      foreach($table_fields as $table_field){
         if($datacol){$csvline .=",";}
         $csvline .= '"'.addslashes($datarow->$table_field).'"';
         $datacol++;
      }
      $csvline .="\n";
      $datacol = 0;
      $rowcount++;
   }
   
   if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
      $UserBrowser = "Opera";
   }
   elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
      $UserBrowser = "IE";
   } else {
      $UserBrowser = '';
   }
   $mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
   @ob_end_clean();
   ob_start();

   header('Content-Type: ' . $mime_type);
   header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

   if ($UserBrowser == 'IE') {
      header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
      header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
      header('Pragma: public');
   }
   else {
      header('Content-Disposition: attachment; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
      header('Pragma: no-cache');
   }
   print $csvline;
   exit();
?>

include_once JPATH_BASE.'/components/com_chronocontact/excelwriter/'."Writer.php";

header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');

    <?php
    if ( !$mainframe->isSite() ) { return; }
//
           global $mainframe;
           $database =& JFactory::getDBO();

           include_once JPATH_BASE.'/components/com_chronocontact/excelwriter/'."Writer.php";
           //echo $_POST['formid'];
           /*$formid = JRequest::getVar( 'formid', array(), 'post', 'array');
           $database->setQuery( "SELECT name FROM #__chrono_contact WHERE id='".$formid[0]."'" );
           $formname = $database->loadResult();*/
           
           $tablename = '_mytable';
           $tables = array( $tablename );
           $result = $database->getTableFields( $tables );
           $table_fields = array_keys($result[$tablename]);
unset($table_fields[0],$table_fields[1],$table_fields[2],$table_fields[3],$table_fields[4],$table_fields[7]);
           $database->setQuery( "SELECT name FROM ".$tablename."" );
           $datarows = $database->loadObjectList();
           
           $titcol = 0;
           foreach($table_fields as $table_field){
              if($titcol){$csvline .="\t";}
              $csvline .= $table_field;
              $titcol++;
           }
           $csvline .="\n";
                 
           $datacol = 0;
           $rowcount = 1;
           foreach($datarows as $datarow){
              foreach($table_fields as $table_field){
                 if($datacol){$csvline .="\t";}
                 $csvline .= '"'.addslashes($datarow->$table_field).'"';
                 $datacol++;
              }
              $csvline .="\n";
              $datacol = 0;
              $rowcount++;
           }
           
           if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
              $UserBrowser = "Opera";
           }
           elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
              $UserBrowser = "IE";
           } else {
              $UserBrowser = '';
           }
           //Don't now if theres a difference here, so just used the same
           $mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/x-msdownload' : 'application/x-msdownload';
           @ob_end_clean();
           ob_start();

           header('Content-Type: ' . $mime_type);
           header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

           if ($UserBrowser == 'IE') {
              header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.xls"');
              //also dont know if this needs to be on for XLS
              //header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
              header('Pragma: public');
           }
           else {
              header('Content-Disposition: attachment; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.xls"');
              header('Pragma: no-cache');
           }
           print $csvline;
           exit();
        ?>

<?php
header("Content-Type: text/html; charset=utf-8");
global $mainframe;
   $database =& JFactory::getDBO();

   include_once JPATH_BASE.'/components/com_chronocontact/excelwriter/'."Writer.php";
   //echo $_POST['formid'];
   /*$formid = JRequest::getVar( 'formid', array(), 'post', 'array');
   $database->setQuery( "SELECT name FROM #__chrono_contact WHERE id='".$formid[0]."'" );
   $formname = $database->loadResult();*/
   
   $tablename = 'ddt_chronoforms_congviec';
   $tables = array( $tablename );
   $result = $database->getTableFields( $tables );
   $table_fields = array_keys($result[$tablename]);
   
   $database->setQuery( "SELECT * FROM ".$tablename."" );
   $datarows = $database->loadObjectList();
   
   $titcol = 0;
   foreach($table_fields as $table_field){
      if($titcol){$csvline .=",";}
      $csvline .= $table_field;
      $titcol++;
   }
   $csvline .="\n";
         
   $datacol = 0;
   $rowcount = 1;
   foreach($datarows as $datarow){
      foreach($table_fields as $table_field){
         if($datacol){$csvline .=",";}
         $csvline .= '"'.addslashes($datarow->$table_field).'"';
         $datacol++;
      }
      $csvline .="\n";
      $datacol = 0;
      $rowcount++;
   }
   
   if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
      $UserBrowser = "Opera";
   }
   elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
      $UserBrowser = "IE";
   } else {
      $UserBrowser = '';
   }
   $mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
   @ob_end_clean();
   ob_start();

   header('Content-Type: ' . $mime_type);
   header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

   if ($UserBrowser == 'IE') {
      header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
      header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
      header('Pragma: public');
   }
   else {
      header('Content-Disposition: attachment; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
      header('Pragma: no-cache');
   }
   print $csvline;
   exit();
?>

<?php
if ( !$mainframe->isSite() ) { return; }
global $mainframe;
$db =& JFactory::getDBO();

// this array has  'Excel column title' => 'database_column_name' 
$column_array = array (
  'Radio 0' => 'radio0', 
  'Radio 1' => 'radio1', 
  'First Name' => 'firstname', 
  'Last name' => 'lastname', 
  'Username' => 'username', 
  'Address' => 'address'
);

$select = array();
$titles = array();
$csv = array();
foreach ( $column_array as $k => $v ) {
  $select[] = $db->nameQuote($v);
  $titles[] = $k;
}
$select = implode (', ', $select);

// replace _mytable with your table name
$query = "
  SELECT $select
    FROM `#__mytable` ;
 ";
$db->setQuery($query);
$data = $db->loadObjectList();
         
$csvline = "";
// build title row
$csv[] = implode("\t", $titles);

foreach( $data as $datarow ) {
  $temp = array();
  foreach( $datarow as $d ) {
    $temp[] = addslashes($d);
  }
  $csv[] = implode("\t", $temp);
}
$csvline = implode("\n", $csv);

$filename = "ChronoForms export - ".date("j_n_Y").".xls";

jimport('joomla.environment.browser');
$browser =& JBrowser::getInstance();
$UserBrowser = $browser->getBrowser();

$mime_type = 'application/x-msdownload';
@ob_end_clean();
ob_start();
header('Content-Type: ' . $mime_type);
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
if ( $UserBrowser == 'ie' ) {
  header('Content-Disposition: inline; filename="$filename"');
  header('Pragma: public');
} else {
  header('Content-Disposition: attachment; filename="$filename"');
  header('Pragma: no-cache');
}
print $csvline;
exit();
?>

    <?php
    if ( !$mainframe->isSite() ) { return; }
    global $mainframe;
    $db =& JFactory::getDBO();

    // this array has  'Excel column title' => 'database_column_name'
    $column_array = array (
      'Radio 0' => 'radio0',
      'Radio 1' => 'radio1',
      'First Name' => 'firstname',
      'Last name' => 'lastname',
      'Username' => 'username',
      'Address' => 'address'
    );

    $select = array();
    $titles = array();
    $csv = array();
    foreach ( $column_array as $k => $v ) {
      $select[] = $db->nameQuote($v);
      $titles[] = $k;
    }
    $select = implode (', ', $select);

    // replace _mytable with your table name
    $query = "
      SELECT $select
        FROM `#__mytable` ;
    ";
    $db->setQuery($query);
    $data = $db->loadObjectList();
             
    $csvline = "";
    // build title row
    $csv[] = implode("\t", $titles);

    foreach( $data as $datarow ) {
      $temp = array();
      foreach( $datarow as $d ) {
        $temp[] = addslashes($d);
      }
      $csv[] = implode("\t", $temp);
    }
    $csvline = implode("\n", $csv);

    $filename = "ChronoForms export - ".date("j_n_Y").".xls";

    jimport('joomla.environment.browser');
    $browser =& JBrowser::getInstance();
    $UserBrowser = $browser->getBrowser();

    $mime_type = 'application/x-msdownload';
    @ob_end_clean();
    ob_start();
    header('Content-Type: ' . $mime_type);
    header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
    if ( $UserBrowser == 'ie' ) {
      header('Content-Disposition: inline; filename="'.$filename.'"');
      header('Pragma: public');
    } else {
      header('Content-Disposition: attachment; filename="'.$filename.'"');
      header('Pragma: no-cache');
    }
    print $csvline;
    exit();
    ?>

<?php
if ( !$mainframe->isSite() ) { return; }
global $mainframe;

// control admin login
$user =& JFactory::getUser();
if ($user->usertype<>"Super Administrator") { ?>
<div class="form_item">
  <div class="form_element cf_heading">
    <h1>Admin area it is not allowed access to unauthorized parties.</h1>
  </div>
  <div class="cfclear"> </div>
</div>

<?php } else { ?>

<div class="form_item">
  <div class="form_element cf_heading">
    <h1 class="cf_text">Exports tables to spreadsheet</h1>
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Tabelle</label>
    <select class="cf_inputbox required" id="select_0" size="1" title=""  name="tabella">
    <option value="">Choose the table</option>
 	
<?php
 //read for dropdown

    $db =& JFactory::getDBO();         
    //$query = "SHOW TABLES LIKE '%chronoforms%'";
    $query = "SHOW TABLES ";
    $db->setQuery($query);
    $nomes = $db->loadResultArray();
print_r($nomes);
    $nome_options = "";
      $i=0;
      foreach ( $nomes as $v ) {
      $nome_options .= "<option value='".$nomes[$i]."' >".$nomes[$i]."</option>";
      $i++;
      }

     echo $nome_options;
?>      
    </select>
    <a class="tooltiplink" onclick="return false;"><img height="16" border="0" width="16" class="tooltipimg" alt="" src="components/com_chronocontact/css/images/tooltip.png"/></a>
				<div class="tooltipdiv">Table :: Choose the table</div>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Separator fields</label>
    <select class="cf_inputbox required" id="select_1" size="1" title=""  name="separatore">
    <option value="">Choose a separator</option>
    <option value=",">Comma</option>
    <option value=";">Semicolon</option>
    <option value="|">Vertical bar</option>
    <option value="tab">Tab</option>
     
    </select>
    <a class="tooltiplink" onclick="return false;"><img height="16" border="0" width="16" class="tooltipimg" alt="" src="components/com_chronocontact/css/images/tooltip.png"/></a>
				<div class="tooltipdiv">Separator :: Choose the separator.</div>
  </div>
  <div class="cfclear"> </div>
</div>



<div class="form_item">
  <div class="form_element cf_button">
    <input value="Submit" name="button_2" type="submit" /><input type="reset" name="reset" value="Reset"/>
  </div>
  <div class="cfclear"> </div>
</div>
<?php } ?>

<?php
if ( !$mainframe->isSite() ) { return; }
// continue PHP here
    global $mainframe;
       $database =& JFactory::getDBO();
       include_once JPATH_BASE.DS.'administrator'.DS.'components'.DS.'com_chronocontact'.DS.'excelwriter'.DS."Writer.php";

       $separatore= JRequest::getVar('separatore','','post');
if( $separatore=="tab") {$separatore="\t";}
       $tablename = JRequest::getVar('tabella','','post');
       $tables = array( $tablename );
       $result = $database->getTableFields( $tables );
       $table_fields = array_keys($result[$tablename]);
       //unset($table_fields[0],$table_fields[2],$table_fields[17]);
         
       $database->setQuery( "SELECT * FROM ".$tablename."" );
       $datarows = $database->loadObjectList();
       $titcol = 0;
       foreach($table_fields as $table_field){
          if($titcol){$csvline .=$separatore;}
          $csvline .= $table_field;
          $titcol++;
       }
       $csvline .="\n";      
       $datacol = 0;
       $rowcount = 1;
       foreach($datarows as $datarow){
          foreach($table_fields as $table_field){
             if($datacol){$csvline .=$separatore;}
             $csvline .= '"'.addslashes($datarow->$table_field).'"';
             $datacol++;
          }
          $csvline .="\n";
          $datacol = 0;
          $rowcount++;
       }       
       if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "Opera";
       }
       elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
          $UserBrowser = "IE";
       } else {
          $UserBrowser = '';
       }
       $mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
       @ob_end_clean();
       ob_start();

       header('Content-Type: ' . $mime_type);
       header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

       if ($UserBrowser == 'IE') {
          header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("d_m_Y").'.csv"');
          header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
          header('Pragma: public');
       }
       else {
          header('Content-Disposition: attachment; filename="' . "ChronoForms - ".$tablename." - ".date("d_m_Y").'.csv"');
          header('Pragma: no-cache');
       }
       print $csvline;
       exit();
    ?>

    //$query = "SHOW TABLES LIKE '%chronoforms%'";
    $query = "SHOW TABLES ";

$tablename = 'jos_chronoforms_NEW_HR_Application';

			$file = fopen($save_path.$file_name, 'w');
			if ( $file === false ) {
				$form->validation_errors['CSV Export'] = 'Unable to open the file.';
				return;
			}

			//fputcsv($file, $titles);
			// add data rows to the file
			foreach ( $data as $d ) {
				fputcsv($file, $d, $delimiter, $enclosure);
			}
			fclose($file);

cf_id	uid	recordtime	ipaddress	cf_user_id
1	IYzExZT###YzQ0MThk9f9763#3#719c5c7d1d962###b1b9440	2012-02-13 - 09:14:45	##.###.###.##	64

<?php
if ( $form->data['file_input'] ) {
  $form->data['file_input'] = 'yes';
} else {
  $form->data['file_input'] = 'no';
}
?>

WHERE cf_user_id='user_id'

WHERE cf_user_id={cfu_id}

{cfu_id}

WHERE cf_user_id={cod_user}

{cfu_id}

<?php
global $mainframe;
   $database =& JFactory::getDBO();

   include_once JPATH_BASE.'/components/com_chronocontact/excelwriter/'."Writer.php";  
   
   $tablename = 'UsersProfiles';
   $tables = array( $tablename );
   $result = $database->getTableFields( $tables );
   $table_fields = array_keys($result[$tablename]);
   
   $database->setQuery( "SELECT * FROM ".$tablename."" );
   $datarows = $database->loadObjectList();
   
   $titcol = 0;
   foreach($table_fields as $table_field){
      if($titcol){$csvline .=",";}
      $csvline .= $table_field;
      $titcol++;
   }
   $csvline .="n";
         
   $datacol = 0;
   $rowcount = 1;
   foreach($datarows as $datarow){
      foreach($table_fields as $table_field){
         if($datacol){$csvline .=",";}
         $csvline .= '"'.addslashes($datarow->$table_field).'"';
         $datacol++;
      }
      $csvline .="n";
      $datacol = 0;
      $rowcount++;
   }
   
   if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
      $UserBrowser = "Opera";
   }
   elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
      $UserBrowser = "IE";
   } else {
      $UserBrowser = '';
   }
   $mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
   @ob_end_clean();
   ob_start();

   header('Content-Type: ' . $mime_type);
   header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

   if ($UserBrowser == 'IE') {
      header('Content-Disposition: inline; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
      header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
      header('Pragma: public');
   }
   else {
      header('Content-Disposition: attachment; filename="' . "ChronoForms - ".$tablename." - ".date("j_n_Y").'.csv"');
      header('Pragma: no-cache');
   }
   print $csvline;
   exit();
?>