public function export_csv() { if ($_REQUEST['submit_export']) { if ($_REQUEST['export'] == 'Excel') { global $wpdb; require 'export.inc.php'; $table = $wpdb->prefix . "EPR_user"; // this is the tablename that you want to export to csv from mysql. exportMysqlToCsv($table); } } }
<?php include_once "config.php"; include_once "utils.php"; include_once "RunSelector.php"; $host = 'localhost'; // MYSQL database host adress $db = 'cnipol'; // MYSQL database name $user = '******'; // Mysql Datbase user $pass = '******'; // Mysql Datbase password // Connect to the database $link = mysql_connect($host, $user, $pass); //print_r($_GET); $runSelector = new RunSelector(); mysql_select_db($db); $table = "run_info"; // this is the tablename that you want to export to csv from mysql. exportMysqlToCsv($table, $runSelector->sqlWhere);
$total_rows = $obj_setting->numberOfRows('contact', 'type = 101'); //number of rows in pages table } else { $total_rows = $obj_setting->numberOfRows('contact', "type = 101 and `name` like '%" . addslashes($_REQUEST['searchtext']) . "%' OR `email` like '%" . addslashes($_REQUEST['searchtext']) . "%'"); //number of rows in pages table for perticular search criteria } } if (!isset($_REQUEST['searchcombo'])) { if ($searchword == "" && $type != "") { $all_pages = $obj_setting->customQuery("SELECT * FROM contact where type = 101 order by {$field} {$orderby} limit {$eu}, {$limit} "); } else { if ($searchword != "" && $type != "") { $all_pages = $obj_setting->customQuery("SELECT * FROM contact where type = 101 and name like '%" . addslashes($searchword) . "%' or `email` like '%" . addslashes($searchword) . "%' order by {$field} {$orderby} limit {$eu}, {$limit} "); } else { $all_pages = $obj_setting->customQuery("SELECT * FROM contact where type = 101 order by {$field} {$orderby} limit {$eu}, {$limit} "); } } } else { if ($_REQUEST['searchtext'] == 'Search') { $all_pages = $obj_setting->customQuery("SELECT * FROM contact where type = 101 and order by {$field} {$orderby} limit {$eu}, {$limit} "); } else { $all_pages = $obj_setting->customQuery("SELECT * FROM contact where type = 101 and `name` like '%" . addslashes($_REQUEST['searchtext']) . "%' OR `desc` like '%" . addslashes($_REQUEST['searchtext']) . "%' order by {$field} {$orderby} limit {$eu}, {$limit} "); //number of rows in pages table for perticular search criteria } } if (isset($_REQUEST['exportMYSQLData'])) { $mysqlFilename = "index_page_inquiry_" . date("dMY") . ".csv"; $CSVraw = $obj_setting->customQuery("SELECT name,email,phone FROM contact where FIND_IN_SET(type,101) order by {$field} {$orderby} "); exportMysqlToCsv($CSVraw, $mysqlFilename); } unset($obj_setting);
<? include("includes/config_db.php"); $table= $_REQUEST['tb_name']; // this is the tablename that you want to export to csv from mysql. exportMysqlToCsv($table); function exportMysqlToCsv($table,$filename = 'export.csv') { $csv_terminated = " "; $csv_separator = " , "; $csv_enclosed = ' '; $csv_escaped = "\n"; $sql_query = 'SELECT * FROM '.$_REQUEST['tb_name'].' '; // Gets the data from the database $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; } // end for $out = trim(substr($schema_insert, 0, -1)); $out .= $csv_terminated; // Format the data while ($row = mysql_fetch_array($result)) { $schema_insert = ''; for ($j = 0; $j < $fields_cnt; $j++) { if ($row[$j] == '0' || $row[$j] != '')
<?php session_start(); exportMysqlToCsv('Export_Projects_without_licences.csv'); // export csv function exportMysqlToCsv($filename = 'export_csv_Expier.csv') { include "configFile.php"; // call export function if (isset($_GET['lName'])) { $lNameG = $_GET['lName']; } $conn = mysqli_connect($servername, $username, $password, $dbname); // Create connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $sql = "SELECT projects_219.pName,\n\t\t\t\t\t\tprojects_219.pID,\n\t\t\t\t\t\tprojects_219.StartDate,\n\t\t\t\t\t\tprojects_219.EndDate,\n\t\t\t\t\t\tprojects_219.Client,\n\t\t\t\t\t\tprojects_219.Country,\n\t\t\t\t\t\tprojects_219.Comments,\n\t\t\t\t\t\tprojects_219.Status,\n\t\t\t\t\t\tlicenses_proj_219.lcID, \n\t\t\t\t\t\tlicenses_proj_219.lcAmount, \n\t\t\t\t\t\tlicenses_proj_219.pID, \n\t\t\t\t\t\tlicenses_proj_219.pAmount \n\t\t\t\t\t\tFROM projects_219\n\t\t\t\t\t\tjoin licenses_proj_219 ON projects_219.pID = licenses_proj_219.pID \n\t\t\t\t\t\tWHERE licenses_proj_219.lcID = 0 AND licenses_proj_219.pAmount = 0 "; // Gets the data from the database $result = $conn->query($sql); $f = fopen('php://temp', 'wt'); $first = true; while ($row = $result->fetch_assoc()) { if ($first) { fputcsv($f, array_keys($row)); $first = false; } fputcsv($f, $row); } // end while $conn->close();
$finalstart = $_POST["start_date"] . ' 00:00:00'; $finalend = $_POST["end_date"] . ' 00:00:00'; $nquery .= " AND (t1.add_date BETWEEN '{$finalstart}' AND '{$finalend}') "; } if ($_SESSION['adminType'] == 'sub-admin') { $nquery .= " and t1.subadmin= " . $_SESSION['aid']; } $queryrws = "SELECT t1.firstname, t1.middlename, t1.lastname, t1.email, t1.mobile, t1.city, t1.state, t1.source, t1.sourcebank, t1.type, t4.full_name as owner, t1.contact_method, DATE_FORMAT(t1.add_date, '%d %M %Y %I:%i:%S') as \n Register_Date, IFNULL(t2.total_account,0) as total_account FROM tbl_userdetails AS t1 LEFT JOIN (SELECT userid, COUNT(*) AS total_account FROM tbl_accounts GROUP BY userid ) AS t2 ON t1.id = t2.userid left join tbl_admin as t4 on t1.owner=t4.id WHERE t1.id > 0 " . $nquery . ' ORDER BY t1.add_date'; $result_add = mysql_query_with_throw($queryrws); while ($row = mysql_fetch_assoc($result_add)) { $firstname = addslashes($row["firstname"]); $middlename = addslashes($row["middlename"]); $lastname = addslashes($row["lastname"]); $email = $row["email"]; $mobile = $row["mobile"]; $city = $row["city"]; $state = $row["state"]; $Register_Date = $row["Register_Date"]; $total_account = $row["total_account"]; $source = addslashes($array_source[$row["source"]]); $type = addslashes($array_custype[$row["type"]]); $owner = $row["owner"]; $contact_method = addslashes($array_conmethod[$row["contact_method"]]); $sourcebank = togetfieldvalue($row["sourcebank"], 'tbl_banks', 'bank'); $insert_query = mysql_query_with_throw("INSERT INTO `tbl_userexport_main` (`Firstname`, `Middlename`, `Lastname`, `Email`, `Mobile`, `City`, `State`, `Register_Date`, `Source`, `Source_Bank`, `Type`, `Owner`, `Contact_Method` , `total_account`) VALUES ('{$firstname}', '{$middlename}', '{$lastname}', '{$email}', '{$mobile}', '{$city}', '{$state}', '{$Register_Date}', '{$source}', '{$sourcebank}', '{$type}', '{$owner}', '{$contact_method}', '{$total_account}')"); } $export_query = "SELECT * FROM `tbl_userexport_main`"; $rand2 = mt_rand(1000, 9999); $filenamenew = 'CMD-User-List-' . $rand2 . "-" . date('d-m-Y') . ".csv"; exportMysqlToCsv($export_query, $filenamenew); }
<?php session_start(); exportMysqlToCsv('Export_License.csv'); // export csv function exportMysqlToCsv($filename = 'export_csv.csv') { include "configFile.php"; // call export function if (isset($_GET['lName'])) { $lNameG = $_GET['lName']; } $conn = mysqli_connect($servername, $username, $password, $dbname); // Create connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $sql = "SELECT licenses_contract_219.lName, \n\t\t\t\tlicenses_contract_219.lcID,\n\t\t\t\tlicenses_contract_219.cID,\t\t\t\t\n\t\t\t\tlicenses_contract_219.Amount, \n\t\t\t\tlicenses_contract_219.startDate, \n\t\t\t\tlicenses_contract_219.endDate, \n\t\t\t\tlicenses_contract_219.File, \n\t\t\t\tlicenses_contract_219.Comments \n\t\t\t\tFROM licenses_contract_219 \n\t\t\t\tWHERE lName = '{$lNameG}'"; // Gets the data from the database $result = $conn->query($sql); $f = fopen('php://temp', 'wt'); $first = true; while ($row = $result->fetch_assoc()) { if ($first) { fputcsv($f, array_keys($row)); $first = false; } fputcsv($f, $row); } // end while $conn->close();
$email = $row["email"]; $mobile = $row["mobile"]; $city = $row["city"]; $state = $row["state"]; $pincode = $row["pincode"]; $insertquery = mysql_query_with_throw("INSERT INTO `tbl_accounts_export` (`id`, `account_name`, `balance`, `bank`, `bankid`, `account_type`, `account_number`, `date_opened`, `date_closed`, `dateofbirth`, `pancard`, `principal`, `interest`, `other_charges`, `last_payment_date`, `last_payment_done`, `otherbank`, `dues_id`, `caption`, `notes`, `alert`, `status`, `userid`, `cibil_status`, `payin`, `add_date`, `firstname`, `middlename`, `lastname`, `email`, `mobile`, `city`, `state`, `pincode`) VALUES ({$id}, '{$account}', '{$balance}', '{$bank}', '{$bankid}', '{$product_type}', '{$account_no}', '{$date_opened}', '{$date_closed}', '{$dateofbirth}', '{$pancard}', '{$principal}', '{$interest}', '{$other_charges}', '{$last_payment_date}', '{$last_payment_done}', '{$otherbank}', '{$unikdueid}', '{$caption}', '{$notes}', '{$alert}', '{$status}', '{$userid}', '{$cibil_status}', '{$payin}', '{$add_date}', '{$firstname}', '{$middlename}', '{$lastname}', '{$email}', '{$mobile}', '{$city}', '{$state}', '{$pincode}')"); } if ($rwsapproval == 0) { $queryrws = 'SELECT id, account_name, bank, account_type, account_number, dateofbirth, pancard, otherbank, dues_id, caption, notes, status, payin, add_date FROM tbl_accounts_export WHERE bankid = ' . $_SESSION['bid'] . ' ORDER BY add_date DESC'; } else { $queryrws = 'SELECT id, account_name, bank, account_type, account_number, dateofbirth, pancard, date_opened, date_closed, principal, interest, other_charges, balance, last_payment_date, last_payment_done, cibil_status, otherbank, dues_id, caption, notes, status, payin, add_date FROM tbl_accounts_export WHERE bankid = ' . $_SESSION['bid'] . ' ORDER BY add_date DESC'; } $rand2 = mt_rand(1000, 9999); $filenamenew = str_replace(' ', '-', togetfieldvalue($_SESSION['bid'], 'tbl_banks', 'bank')) . '-User-Account-Data-' . $rand2 . "-" . date('d-m-Y') . ".csv"; echo mysql_num_rows(mysql_query_with_throw($queryrws)); exportMysqlToCsv($queryrws, $filenamenew); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>ADMIN CONSOLE // <?php echo $sitename; ?> Website</title> <link rel="stylesheet" href="resources/css/reset.css" type="text/css" media="screen" /> <link rel="stylesheet" href="resources/css/style.css" type="text/css" media="screen" /> <link rel="stylesheet" href="resources/css/invalid.css" type="text/css" media="screen" /> <link href="<?php echo $baseurl;
<?php session_start(); exportMysqlToCsv('Export_Project.csv'); // export csv function exportMysqlToCsv($filename = 'Project_csv.csv') { include "configFile.php"; // call export function if (isset($_GET['pName'])) { $pNameP = $_GET['pName']; } $conn = mysqli_connect($servername, $username, $password, $dbname); // Create connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $sql = "SELECT projects_219.pName,\n\t\t\t\tprojects_219.pID,\n\t\t\t\tlicenses_proj_219.lcID, \n\t\t\t\tlicenses_proj_219.lcAmount, \n\t\t\t\tlicenses_proj_219.pID, \n\t\t\t\tlicenses_proj_219.pAmount, \n\t\t\t\tlicenses_contract_219.lcID, \n\t\t\t\tlicenses_contract_219.lName, \n\t\t\t\tlicenses_contract_219.cID, \n\t\t\t\tlicenses_contract_219.Amount, \n\t\t\t\tlicenses_contract_219.startDate, \n\t\t\t\tlicenses_contract_219.endDate, \n\t\t\t\tlicenses_contract_219.File, \n\t\t\t\tlicenses_contract_219.Comments \n\t\t\t\tFROM projects_219\n\t\t\t\tjoin licenses_proj_219 ON projects_219.pID = licenses_proj_219.pID \n\t\t\t\tjoin licenses_contract_219 ON licenses_proj_219.lcID = licenses_contract_219.lcID \n\t\t\t\tWHERE pName = '{$pNameP}'"; // Gets the data from the database $result = $conn->query($sql); $f = fopen('php://temp', 'wt'); $first = true; while ($row = $result->fetch_assoc()) { if ($first) { fputcsv($f, array_keys($row)); $first = false; } fputcsv($f, $row); } // end while $conn->close();
//**Pendiente busqueda inventarios $xmov = CleanText($_GET["xmov"]); $invent = CleanText($_GET["xtitulo"]); $almacen = CleanText($_GET["alma"]); $xLocal = getNombreComercialLocal($idlocal); $almacen = $almacen ? $almacen : $xLocal; $xinvent = $xinvent ? $xinvent : 'none'; $selcvs = " DATE_FORMAT(FechaMovimiento, '%e/%m/%y %H:%i') as FechaMovimiento, " . " ges_usuarios.Identificacion as Usuario, " . " ges_locales.NombreComercial as Almacen, " . " CONCAT(ges_productos.CodigoBarras,' ',ges_productos_idioma.Descripcion,' '," . " ges_marcas.Marca,' ', " . " ges_modelos.Color,' ', " . " ges_detalles.Talla,' ', " . " ges_laboratorios.NombreComercial) as Producto, " . " ges_contenedores.Contenedor, " . " ges_productos.UnidadMedida, " . " ges_productos.UnidadesPorContenedor as UnidxCont, " . " KardexOperacion, " . " ges_kardex.TipoMovimiento, " . " (SELECT ges_kardexajusteoperacion.AjusteOperacion from ges_kardexajusteoperacion where ges_kardexajusteoperacion.IdKardexAjusteOperacion = ges_kardex.IdKardexAjusteOperacion AND ges_kardex.IdKardexAjusteOperacion > 0) as 'AjusteOperacion', " . " CantidadMovimiento, " . " ROUND(CostoUnitarioMovimiento,2) as CostoUnitarioMovimiento, " . " ROUND(CostoTotalMovimiento,2) as CostoTotalMovimiento, " . " SaldoCantidad, " . " IF ( ges_kardex.Observaciones like '', ' ',ges_kardex.Observaciones) " . " as Observaciones "; $sql = obtenerKardexMovimientosInventario($idlocal, $desde, $hasta, $xfamilia, $xmarca, $xope, $xmov, $xnombre, $xcodigo, $xinvent, $esInvent, false, $selcvs, false, false, false); $xinvent = str_replace("- ", "", $invent); $xinvent = str_replace(" ", "_", $xinvent); $xalmacen = str_replace(" ", "_", $almacen); $name = "gPOS_" . $xalmacen . "_" . $xinvent; $NombreArchivo = $name . ".csv"; $xtitulo = '"' . $almacen . ' ' . $invent . '"'; exportMysqlToCsv($sql, $NombreArchivo, $xtitulo); break; } function ProcesarSQL($cod, $Desde, $Hasta, $IdLocal, $IdFamilia, $IdSubsidia, $STSubsid, $IdProveedor, $IdUsuario, $Referencia, $CodigoBarra, $NumeroSerie, $Lote, $Partida, $TipoVenta, $esTPVOP, $LocalActual, $DNICliente, $TipoComprobante, $SerieComprobante, $EstadoComprobante, $EstadoPago, $Modalidad, $EstadoPromo, $TipoPromo, $TipoOperacion, $TipoOpCjaGral, $PeriodoVenta, $NombreCliente, $TipoCliente, $IdMarca, $CondicionVenta, $EstadoOS, $Prioridad, $Facturacion, $EstadoSuscripcion, $TipoSuscripcion, $TipoPagoSuscripcion, $Prolongacion, $IdCLiente, $Codigo, $EstadoPagoVenta, $Cobranza, $CodigoComprobante) { $Moneda = getSesionDato("Moneda"); if (function_exists("getSesionDato")) { $IdLang = getSesionDato("IdLenguajeDefecto"); } if (!$IdLang) { $IdLang = 1; } if ($PeriodoVenta == 'DAY') { $g_periodo = "{$PeriodoVenta}(FechaComprobante)"; } if ($PeriodoVenta == 'WEEK') {
include "includes/application_top.php"; ?> <html> <head> <title>Import products</title> <link rel="stylesheet" href="nusoap/soap.css"> <script type="text/javascript" src="nusoap/soap.js"></script> </head> <body> <?php include DIR_WS_INCLUDES . 'header.php'; ?> <?php ini_set("display_errors", 1); ini_set("memory_limit", "64M"); include "nusoap/lib/nusoap.php"; include "nusoap/functions.php"; $table = "visualproducts_selected"; exportMysqlToCsv($table, "csvdir/products.csv"); header("Location: ez_populate2.php?csvfile=products.csv"); ?> <div style="font-size: 12px;margin-top: 3px;"> <br> <span style="background-color: #6296FC;color:#ffffff;margin-left: 5px;padding: 5px;font-size : 13px;"> Import was completed succesfully </span> </div> </body> </html>
if (true === isset($_GET['export']) && false === empty($_GET['export'])) { $host = Config::$dbHost; $user = Config::$dbUser; $pass = Config::$dbPass; $db = Config::$dbDatabase; $table = Config::$dbTable; $from_date = $_GET['from_date']; $sql_query = "select * from {$table} where add_ts >= '{$from_date}'"; Logger::debug("Connecting to DB {$db} table {$table} user {$user} host {$host}"); Logger::debug("SQL query: {$sql_query}"); $link = mysql_connect($host, $user, $pass); mysql_select_db($db); $db = SingletonFactory::getInstance()->getSingleton(DB_MANAGER_CLASS_NAME); $dateString = date("Y-m-d-Hi"); $filename = "pa_ipn_export_{$dateString}_from_{$from_date}.csv"; $csvData = exportMysqlToCsv($table, $sql_query); if (true === empty($csvData)) { echo "An error occurred, your data is either empty or there's something wrong with the system. Please try again or e-mail dafydd@cantab.net"; } else { //Logger::debug("CSV data: " . print_r($csvData, true)); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Length: " . strlen($csvData)); header("Content-type: text/csv"); //header("Content-type: application/csv"); header("Content-Disposition: attachment; filename={$filename}"); echo $csvData; } } else { ?> <html>