Ir para conteúdo

POWERED BY:

Arquivado

Este tópico foi arquivado e está fechado para novas respostas.

peterhall

[Resolvido] exportar query

Por , em PHP

Recommended Posts

peterhall    0

peterhall
Postado

boas. criei este recordset através do dw, acrescentei o código encontrado aqui no forum para poder exportar apenas os dados onde o filtro são 2 campos de data, ou seja, os dados apresentados na página onde aplico este mesmo filtro entre datas, é para ser exportado para csv. a tabela sei como exportar, mas atendendo que neste caso é o conjunto de 2 tabelas para formar a query, n sei como fazê-lo e tentei desta forma, mas dá-me este erro ao abrir a folha de excel:

 

<br />

<b>Warning</b>: mysql_num_fields() expects parameter 1 to be resource, boolean given in <b>C:\wamp\www\TMN\teste_exp2.php</b> on line <b>59</b><br />

<br />

<b>Warning</b>: mysql_fetch_array() expects parameter 1 to be resource, boolean given in <b>C:\wamp\www\TMN\teste_exp2.php</b> on line <b>71</b><br />

 

o código:

 

exporta.php

<?php
 
$host = 'localhost'; // MYSQL database host adress
$db = 'tool_tmn'; // MYSQL database name
$user = 'root'; // Mysql Database user
$pass = ''; // Mysql Database password
 
// Conexão com o bando de dados
$link = mysql_connect($host, $user, $pass);
mysql_select_db($db);
 
require 'exporta.inc.php';
 
$table="$query_Recordset1"; // aqui vai o nome da tabela que voce quer exportar 

exportMysqlToCsv($table);
 
?>

exporta.inc.php

<?php require_once('Connections/tool_tmn.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$colname_Recordset1 = "-1";
if (isset($_GET['liga'])) {
  $colname_Recordset1 = $_GET['liga'];
}
$colname1_Recordset1 = "-1";
if (isset($_GET['colname1'])) {
  $colname1_Recordset1 = $_GET['colname1'];
}
mysql_select_db($database_tool_tmn, $tool_tmn);
$query_Recordset1 = sprintf("SELECT in_rfplansite_tble1.dataa, in_rfplansite_tble2.datad, in_rfplansite_tble1.BSS_NAME, in_rfplansite_tble1.SITE_NUMBER, IF(in_rfplansite_tble1.fm_site_type=in_rfplansite_tble2.fm_site_type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.fm_site_type)) AS fm_site_type,  IF(in_rfplansite_tble1.bts_type=in_rfplansite_tble2.bts_type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bts_type)) AS bts_type,  IF(in_rfplansite_tble1.siteGeneration=in_rfplansite_tble2.siteGeneration,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.siteGeneration)) AS siteGeneration,  IF(in_rfplansite_tble1.lcf_id=in_rfplansite_tble2.lcf_id,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.lcf_id)) AS lcf_id,  IF(in_rfplansite_tble1.bsp_lcf_type=in_rfplansite_tble2.bsp_lcf_type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bsp_lcf_type)) AS bsp_lcf_type,  IF(in_rfplansite_tble1.carrierDisableTm=in_rfplansite_tble2.carrierDisableTm,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.carrierDisableTm)) AS carrierDisableTm,  IF(in_rfplansite_tble1.carriersInsPwrFl=in_rfplansite_tble2.carriersInsPwrFl,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.carriersInsPwrFl)) AS carriersInsPwrFl,  IF(in_rfplansite_tble1.csfp_alg=in_rfplansite_tble2.csfp_alg,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.csfp_alg)) AS csfp_alg,  IF(in_rfplansite_tble1.csfp_flow=in_rfplansite_tble2.csfp_flow,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.csfp_flow)) AS csfp_flow,  IF(in_rfplansite_tble1.phase_lock_gclk=in_rfplansite_tble2.phase_lock_gclk,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.phase_lock_gclk)) AS phase_lock_gclk,  IF(in_rfplansite_tble1.clkSrcFailResPer=in_rfplansite_tble2.clkSrcFailResPer,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.clkSrcFailResPer)) AS clkSrcFailResPer,  IF(in_rfplansite_tble1.gproc_slots=in_rfplansite_tble2.gproc_slots,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.gproc_slots)) AS gproc_slots,  IF(in_rfplansite_tble1.lta_alarm_range=in_rfplansite_tble2.lta_alarm_range,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.lta_alarm_range)) AS lta_alarm_range,  IF(in_rfplansite_tble1.num_audit_retries=in_rfplansite_tble2.num_audit_retries,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.num_audit_retries)) AS num_audit_retries,  IF(in_rfplansite_tble1.poorInitialAssign=in_rfplansite_tble2.poorInitialAssign,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.poorInitialAssign)) AS poorInitialAssign,  IF(in_rfplansite_tble1.rach_load_type=in_rfplansite_tble2.rach_load_type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.rach_load_type)) AS rach_load_type,  IF(in_rfplansite_tble1.rf_res_ind_period=in_rfplansite_tble2.rf_res_ind_period,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.rf_res_ind_period)) AS rf_res_ind_period,  IF(in_rfplansite_tble1.rsl_rate=in_rfplansite_tble2.rsl_rate,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.rsl_rate)) AS rsl_rate,  IF(in_rfplansite_tble1.tchBusyCrtThrshd=in_rfplansite_tble2.tchBusyCrtThrshd,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.tchBusyCrtThrshd)) AS tchBusyCrtThrshd,  IF(in_rfplansite_tble1.tchBusyNrmThrshd=in_rfplansite_tble2.tchBusyNrmThrshd,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.tchBusyNrmThrshd)) AS tchBusyNrmThrshd,  IF(in_rfplansite_tble1.waitForReselect=in_rfplansite_tble2.waitForReselect,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.waitForReselect)) AS waitForReselect,  IF(in_rfplansite_tble1.mms_config_type=in_rfplansite_tble2.mms_config_type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.mms_config_type)) AS mms_config_type,  IF(in_rfplansite_tble1.ts_alloc_flag=in_rfplansite_tble2.ts_alloc_flag,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ts_alloc_flag)) AS ts_alloc_flag,  IF(in_rfplansite_tble1.gclk_qwarm_flag=in_rfplansite_tble2.gclk_qwarm_flag,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.gclk_qwarm_flag)) AS gclk_qwarm_flag,  IF(in_rfplansite_tble1.phase_lock_retry=in_rfplansite_tble2.phase_lock_retry,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.phase_lock_retry)) AS phase_lock_retry,  IF(in_rfplansite_tble1.Calibrate_flag=in_rfplansite_tble2.Calibrate_flag,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Calibrate_flag)) AS Calibrate_flag,  IF(in_rfplansite_tble1.Configtypelastcal=in_rfplansite_tble2.Configtypelastcal,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Configtypelastcal)) AS Configtypelastcal,  IF(in_rfplansite_tble1.ber_loss_daily=in_rfplansite_tble2.ber_loss_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ber_loss_daily)) AS ber_loss_daily,  IF(in_rfplansite_tble1.ber_loss_hourly=in_rfplansite_tble2.ber_loss_hourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ber_loss_hourly)) AS ber_loss_hourly,  IF(in_rfplansite_tble1.red_loss_daily=in_rfplansite_tble2.red_loss_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_loss_daily)) AS red_loss_daily,  IF(in_rfplansite_tble1.red_loss_hourly=in_rfplansite_tble2.red_loss_hourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_loss_hourly)) AS red_loss_hourly,  IF(in_rfplansite_tble1.red_loss_oos=in_rfplansite_tble2.red_loss_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_loss_oos)) AS red_loss_oos,  IF(in_rfplansite_tble1.red_loss_restore=in_rfplansite_tble2.red_loss_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_loss_restore)) AS red_loss_restore,  IF(in_rfplansite_tble1.red_time_oos=in_rfplansite_tble2.red_time_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_time_oos)) AS red_time_oos,  IF(in_rfplansite_tble1.red_time_restore=in_rfplansite_tble2.red_time_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_time_restore)) AS red_time_restore,  IF(in_rfplansite_tble1.remoteLossRestore=in_rfplansite_tble2.remoteLossRestore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remoteLossRestore)) AS remoteLossRestore,  IF(in_rfplansite_tble1.slip_loss_daily=in_rfplansite_tble2.slip_loss_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.slip_loss_daily)) AS slip_loss_daily,  IF(in_rfplansite_tble1.slip_loss_hourly=in_rfplansite_tble2.slip_loss_hourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.slip_loss_hourly)) AS slip_loss_hourly,  IF(in_rfplansite_tble1.slip_loss_oos=in_rfplansite_tble2.slip_loss_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.slip_loss_oos)) AS slip_loss_oos,  IF(in_rfplansite_tble1.slip_loss_restore=in_rfplansite_tble2.slip_loss_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.slip_loss_restore)) AS slip_loss_restore,  IF(in_rfplansite_tble1.sync_loss_restore=in_rfplansite_tble2.sync_loss_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_loss_restore)) AS sync_loss_restore,  IF(in_rfplansite_tble1.sms_dl_allowed=in_rfplansite_tble2.sms_dl_allowed,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sms_dl_allowed)) AS sms_dl_allowed,  IF(in_rfplansite_tble1.sms_tch_chan=in_rfplansite_tble2.sms_tch_chan,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sms_tch_chan)) AS sms_tch_chan,  IF(in_rfplansite_tble1.sms_ul_allowed=in_rfplansite_tble2.sms_ul_allowed,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sms_ul_allowed)) AS sms_ul_allowed,  IF(in_rfplansite_tble1.cbs_outage_cntr=in_rfplansite_tble2.cbs_outage_cntr,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.cbs_outage_cntr)) AS cbs_outage_cntr,  IF(in_rfplansite_tble1.carrierFreeImmed=in_rfplansite_tble2.carrierFreeImmed,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.carrierFreeImmed)) AS carrierFreeImmed,  IF(in_rfplansite_tble1.add_access_class=in_rfplansite_tble2.add_access_class,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.add_access_class)) AS add_access_class,  IF(in_rfplansite_tble1.emerg_reserved=in_rfplansite_tble2.emerg_reserved,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.emerg_reserved)) AS emerg_reserved,  IF(in_rfplansite_tble1.register_exp=in_rfplansite_tble2.register_exp,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.register_exp)) AS register_exp,  IF(in_rfplansite_tble1.cbch_1=in_rfplansite_tble2.cbch_1,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.cbch_1)) AS cbch_1,  IF(in_rfplansite_tble1.cbch_2=in_rfplansite_tble2.cbch_2,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.cbch_2)) AS cbch_2,  IF(in_rfplansite_tble1.cbch_3=in_rfplansite_tble2.cbch_3,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.cbch_3)) AS cbch_3,  IF(in_rfplansite_tble1.cipher_comp_ms=in_rfplansite_tble2.cipher_comp_ms,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.cipher_comp_ms)) AS cipher_comp_ms,  IF(in_rfplansite_tble1.ho_complete=in_rfplansite_tble2.ho_complete,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ho_complete)) AS ho_complete,  IF(in_rfplansite_tble1.channel_teardown=in_rfplansite_tble2.channel_teardown,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.channel_teardown)) AS channel_teardown,  IF(in_rfplansite_tble1.bts_audit=in_rfplansite_tble2.bts_audit,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bts_audit)) AS bts_audit,  IF(in_rfplansite_tble1.modeRRModifyAck=in_rfplansite_tble2.modeRRModifyAck,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.modeRRModifyAck)) AS modeRRModifyAck,  IF(in_rfplansite_tble1.bssmap_t8=in_rfplansite_tble2.bssmap_t8,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bssmap_t8)) AS bssmap_t8,  IF(in_rfplansite_tble1.bssmap_t10=in_rfplansite_tble2.bssmap_t10,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bssmap_t10)) AS bssmap_t10,  IF(in_rfplansite_tble1.bssmap_t11=in_rfplansite_tble2.bssmap_t11,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bssmap_t11)) AS bssmap_t11,  IF(in_rfplansite_tble1.ms_sapi3_est=in_rfplansite_tble2.ms_sapi3_est,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ms_sapi3_est)) AS ms_sapi3_est,  IF(in_rfplansite_tble1.btsAuditResponse=in_rfplansite_tble2.btsAuditResponse,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.btsAuditResponse)) AS btsAuditResponse,  IF(in_rfplansite_tble1.bssmap_t14=in_rfplansite_tble2.bssmap_t14,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bssmap_t14)) AS bssmap_t14,  IF(in_rfplansite_tble1.bcch_info=in_rfplansite_tble2.bcch_info,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bcch_info)) AS bcch_info,  IF(in_rfplansite_tble1.sacch_info=in_rfplansite_tble2.sacch_info,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sacch_info)) AS sacch_info,  IF(in_rfplansite_tble1.channel_act=in_rfplansite_tble2.channel_act,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.channel_act)) AS channel_act,  IF(in_rfplansite_tble1.mode_modify=in_rfplansite_tble2.mode_modify,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.mode_modify)) AS mode_modify,  IF(in_rfplansite_tble1.initSyncTimer=in_rfplansite_tble2.initSyncTimer,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.initSyncTimer)) AS initSyncTimer,  IF(in_rfplansite_tble1.ulSyncTimer=in_rfplansite_tble2.ulSyncTimer,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ulSyncTimer)) AS ulSyncTimer,  IF(in_rfplansite_tble1.dlSyncTimer=in_rfplansite_tble2.dlSyncTimer,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.dlSyncTimer)) AS dlSyncTimer,  IF(in_rfplansite_tble1.hdsl_snr_hourly=in_rfplansite_tble2.hdsl_snr_hourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_hourly)) AS hdsl_snr_hourly,  IF(in_rfplansite_tble1.hdsl_snr_daily=in_rfplansite_tble2.hdsl_snr_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_daily)) AS hdsl_snr_daily,  IF(in_rfplansite_tble1.hdsl_snr_hrly_prd=in_rfplansite_tble2.hdsl_snr_hrly_prd,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_hrly_prd)) AS hdsl_snr_hrly_prd,  IF(in_rfplansite_tble1.hdsl_snr_daly_prd=in_rfplansite_tble2.hdsl_snr_daly_prd,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_daly_prd)) AS hdsl_snr_daly_prd,  IF(in_rfplansite_tble1.hdsl_snr_oos=in_rfplansite_tble2.hdsl_snr_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_oos)) AS hdsl_snr_oos,  IF(in_rfplansite_tble1.hdsl_snr_restore=in_rfplansite_tble2.hdsl_snr_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_restore)) AS hdsl_snr_restore,  IF(in_rfplansite_tble1.hdsl_losw_oos=in_rfplansite_tble2.hdsl_losw_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_losw_oos)) AS hdsl_losw_oos,  IF(in_rfplansite_tble1.hdsl_losw_restore=in_rfplansite_tble2.hdsl_losw_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_losw_restore)) AS hdsl_losw_restore,  IF(in_rfplansite_tble1.static_sync_timer=in_rfplansite_tble2.static_sync_timer,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.static_sync_timer)) AS static_sync_timer,  IF(in_rfplansite_tble1.percent_traf_cs=in_rfplansite_tble2.percent_traf_cs,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.percent_traf_cs)) AS percent_traf_cs,  IF(in_rfplansite_tble1.ts_sharing=in_rfplansite_tble2.ts_sharing,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ts_sharing)) AS ts_sharing,  IF(in_rfplansite_tble1.dynet_retry_time=in_rfplansite_tble2.dynet_retry_time,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.dynet_retry_time)) AS dynet_retry_time,  IF(in_rfplansite_tble1.longitude=in_rfplansite_tble2.longitude,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.longitude)) AS longitude,  IF(in_rfplansite_tble1.latitude=in_rfplansite_tble2.latitude,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.latitude)) AS latitude,  IF(in_rfplansite_tble1.guiState=in_rfplansite_tble2.guiState,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.guiState)) AS guiState,  IF(in_rfplansite_tble1.remote_loss_daily=in_rfplansite_tble2.remote_loss_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remote_loss_daily)) AS remote_loss_daily,  IF(in_rfplansite_tble1.remoteLossHourly=in_rfplansite_tble2.remoteLossHourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remoteLossHourly)) AS remoteLossHourly,  IF(in_rfplansite_tble1.remote_loss_oos=in_rfplansite_tble2.remote_loss_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remote_loss_oos)) AS remote_loss_oos,  IF(in_rfplansite_tble1.remote_time_oos=in_rfplansite_tble2.remote_time_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remote_time_oos)) AS remote_time_oos,  IF(in_rfplansite_tble1.remoteTimeRestore=in_rfplansite_tble2.remoteTimeRestore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remoteTimeRestore)) AS remoteTimeRestore,  IF(in_rfplansite_tble1.sync_loss_daily=in_rfplansite_tble2.sync_loss_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_loss_daily)) AS sync_loss_daily,  IF(in_rfplansite_tble1.sync_loss_hourly=in_rfplansite_tble2.sync_loss_hourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_loss_hourly)) AS sync_loss_hourly,  IF(in_rfplansite_tble1.sync_loss_oos=in_rfplansite_tble2.sync_loss_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_loss_oos)) AS sync_loss_oos,  IF(in_rfplansite_tble1.sync_time_oos=in_rfplansite_tble2.sync_time_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_time_oos)) AS sync_time_oos,  IF(in_rfplansite_tble1.sync_time_restore=in_rfplansite_tble2.sync_time_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_time_restore)) AS sync_time_restore,  IF(in_rfplansite_tble1.SW_Loadversion=in_rfplansite_tble2.SW_Loadversion,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.SW_Loadversion)) AS SW_Loadversion,  IF(in_rfplansite_tble1.Cabinet_Count=in_rfplansite_tble2.Cabinet_Count,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Cabinet_Count)) AS Cabinet_Count,  IF(in_rfplansite_tble1.Cabinet_Type=in_rfplansite_tble2.Cabinet_Type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Cabinet_Type)) AS Cabinet_Type,  IF(in_rfplansite_tble1.Frequency_Type=in_rfplansite_tble2.Frequency_Type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Frequency_Type)) AS Frequency_Type,  IF(in_rfplansite_tble1.Path_Count=in_rfplansite_tble2.Path_Count,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Path_Count)) AS Path_Count,  IF(in_rfplansite_tble1.RSL_Count=in_rfplansite_tble2.RSL_Count,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.RSL_Count)) AS RSL_Count,  IF(in_rfplansite_tble1.RTF_Count_Per_Site=in_rfplansite_tble2.RTF_Count_Per_Site,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.RTF_Count_Per_Site)) AS RTF_Count_Per_Site,  IF(in_rfplansite_tble1.Cell_Count_Per_Site=in_rfplansite_tble2.Cell_Count_Per_Site,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Cell_Count_Per_Site)) AS Cell_Count_Per_Site,  IF(in_rfplansite_tble1.RTF_Count_Per_Cell=in_rfplansite_tble2.RTF_Count_Per_Cell,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.RTF_Count_Per_Cell)) AS RTF_Count_Per_Cell,  IF(in_rfplansite_tble1.n_900=in_rfplansite_tble2.n_900,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.n_900)) AS n_900,  IF(in_rfplansite_tble1.n_1800=in_rfplansite_tble2.n_1800,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.n_1800)) AS n_1800,  IF(in_rfplansite_tble1.DualBand_Enabled=in_rfplansite_tble2.DualBand_Enabled,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.DualBand_Enabled)) AS DualBand_Enabled FROM in_rfplansite_tble1 INNER JOIN in_rfplansite_tble2 ON (in_rfplansite_tble1.SITE_NUMBER=in_rfplansite_tble2.SITE_NUMBER) AND (in_rfplansite_tble1.BSS_NAME=in_rfplansite_tble2.BSS_NAME) WHERE in_rfplansite_tble1.dataa=%s and  in_rfplansite_tble2.datad=%s GROUP BY in_rfplansite_tble1.dataa, in_rfplansite_tble2.datad, in_rfplansite_tble1.BSS_NAME, in_rfplansite_tble1.SITE_NUMBER", GetSQLValueString($colname_Recordset1, "date"),GetSQLValueString($colname1_Recordset1, "date"));
$Recordset1 = mysql_query($query_Recordset1, $tool_tmn) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

mysql_free_result($Recordset1);

function exportMysqlToCsv($table,$filename = 'exportado.csv')
{
        $csv_terminated = "\n";
        $csv_separator = ";";
        $csv_enclosed = '"';
        $csv_escaped = "\\";
        $sql_query = '$query_Recordset1'; //Modifique aqui para gerar a consulta desejada
        // Buscando os dados do BD
        $result = mysql_query($sql_query);
        $fields_cnt = mysql_num_fields($result);
        $schema_insert = '';
        for ($i = 0; $i < $fields_cnt; $i++)
        {
                $l = $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed,
                        stripslashes(mysql_field_name($result, $i))) . $csv_enclosed;
                $schema_insert .= $l;
                $schema_insert .= $csv_separator;
        }
        $out = trim(substr($schema_insert, 0, -1));
        $out .= $csv_terminated;
        
        while ($row = mysql_fetch_array($result))
        {
                $schema_insert = '';
                for ($j = 0; $j < $fields_cnt; $j++)
                {
                        if ($row[$j] == '0' || $row[$j] != '')
                        {
                                if ($csv_enclosed == '')
                                {
                                        $schema_insert .= $row[$j];
                                } else
                                {
                                        $schema_insert .= $csv_enclosed .
                                        str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $row[$j]) . $csv_enclosed;
                                }
                        } else
                        {
                                $schema_insert .= '';
                        }
                        if ($j < $fields_cnt - 1)
                        {
                                $schema_insert .= $csv_separator;
                        }
                } // end for
                $out .= $schema_insert;
                $out .= $csv_terminated;
        } // end while
        header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
        header("Content-Length: " . strlen($out));

        //header("Content-type: text/x-csv");
        //header("Content-type: text/csv");
        header("Content-type: application/csv");
        header("Content-Disposition: attachment; filename=$filename");
        echo $out;
        exit;
}

?>

Compartilhar este post

Link para o post
Compartilhar em outros sites

peterhall    0

peterhall
Postado

a tua query nao tah encontrando nada, e está retornando FALSE

 

é estranho, pq criei da mesma forma a query, mas em vez de aplicar filtro para exportar, abri numa tabela dinamica e resultou... o que estará de errado na query para exportação??

Compartilhar este post

Link para o post
Compartilhar em outros sites

peterhall    0

peterhall
Postado

 

a tua query nao tah encontrando nada, e está retornando FALSE

 

é estranho, pq criei da mesma forma a query, mas em vez de aplicar filtro para exportar, abri numa tabela dinamica e resultou... o que estará de errado na query para exportação??

 

boas de novo. resolvi a questão (+/-) mas dá-me este erro:

 

<br />

<b>Notice</b>: Undefined variable: header in <b>C:\wamp\www\TMN\export_cell_data.php</b> on line <b>58</b><br />

<br />

<b>Notice</b>: Undefined variable: data in <b>C:\wamp\www\TMN\export_cell_data.php</b> on line <b>77</b><br />

 

o processo:

 

criei uma nova página com recordset e a informação pretendida de 2 tabelas, dentro criei 2 variáveis para que qd premir o botão para imprimir, aplique o filtro, no meu caso por 2 campos data (antes e depois). de seguida, adicionei este código no final da página, corrigi as variáveis para a do meu query e abriu, mas com o erro em cima, já verifiquei e aparentemente está td ok, alguém pode dar uma luz??

 

// $select = "SELECT * FROM table_name"; -- mantive esta linha para no caso de querer exportar só uma tabela

$export = mysql_query ( $query_Recordset1 ) or die ( "Sql error : " . mysql_error( ) );

$fields = mysql_num_fields ( $export );

for ( $i = 0; $i < $fields; $i++ )
{
    $header .= mysql_field_name( $export , $i ) . "\t";
}

while( $row = mysql_fetch_row( $export ) )
{
    $line = '';
    foreach( $row as $value )
    {                                            
        if ( ( !isset( $value ) ) || ( $value == "" ) )
        {
            $value = "\t";
        }
        else
        {
            $value = str_replace( '"' , '""' , $value );
            $value = '"' . $value . '"' . "\t";
        }
        $line .= $value;
    }
    $data .= trim( $line ) . "\n";
}
$data = str_replace( "\r" , "" , $data );

if ( $data == "" )
{
    $data = "\n(0) Records Found!\n";                        
}

header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=tmn_file.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";

Compartilhar este post

Link para o post
Compartilhar em outros sites

William Bruno    1501

William Bruno
Postado

você precisa inicializar a variavel:

$header = '';//essa linha
for ( $i = 0; $i < $fields; $i++ )
{
    $header .= mysql_field_name( $export , $i ) . "\t";
}

mesma coisa com o $data

Compartilhar este post

Link para o post
Compartilhar em outros sites

peterhall    0

peterhall
Postado

você precisa inicializar a variavel:

$header = '';//essa linha
for ( $i = 0; $i < $fields; $i++ )
{
    $header .= mysql_field_name( $export , $i ) . "\t";
}

mesma coisa com o $data

 

 

corrigido. aqui fica o código completo, tanto exporta para .xls da tabela mysql como de uma query:

 

<?php 
require_once('Connections/database.php'); 

$select = "SELECT * FROM table_name";

$export = mysql_query ( $select ) or die ( "Sql error : " . mysql_error( ) );

$fields = mysql_num_fields ( $export );

$header = '';
for ( $i = 0; $i < $fields; $i++ )
{
    $header .= mysql_field_name( $export , $i ) . "\t";
}
$data = '';
while( $row = mysql_fetch_row( $export ) )
{
    $line = '';
    foreach( $row as $value )
    {                                            
        if ( ( !isset( $value ) ) || ( $value == "" ) )
        {
            $value = "\t";
        }
        else
        {
            $value = str_replace( '"' , '""' , $value );
            $value = '"' . $value . '"' . "\t";
        }
        $line .= $value;
    }
	$data .= trim( $line ) . "\n";
}
$data = str_replace( "\r" , "" , $data );

if ( $data == "" )
{
    $data = "\n(0) Records Found!\n";                        
}

header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=tmn_file.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";
?>

Compartilhar este post

Link para o post
Compartilhar em outros sites
Ir para a lista de tópicos PHP
×

Informação importante

Ao usar o fórum, você concorda com nossos Termos e condições.

  Aceito