Featured
-
How Regression Testing Detects Integral Errors In Business Processes
Humans are forever changing and evolving and so to
by kristina.rigina -
Get Display Banner Advertising Opportunity on FindNerd Platform
“Do you have a product or service that nee
by manoj.rawat -
Android O Released with Top 7 New Features for App Developers
Android was founded by Andy Rubin, Rich Miner, Nic
by sudhanshu.tripathi -
Top 5 Features That Make Laravel the Best PHP Framework for Development
Laravel is a free open source Web Framework of PHP
by abhishek.tiwari.458 -
Objective C or Swift - Which Technology to Learn for iOS Development?
Swift programming language is completely based on
by siddharth.sindhi
Tags
How to Create excel files in php
Applications that are written in php most of the times need to export data for some purposes. In this tutorial, we will learn "How to export that data in Excel CSV fomat?" CSV is known as the EXCEL spreadsheet that have the data in a gr...
Save MySQL query results into a text or CSV file
Hello Readers!
MySQL provides an easy mechanism for writing the results of a select statement into a text file on the server.
Given a query such as
SELECT order_id,product_name,qty FROM orders
which returns three columns of data, t...
How to get any File Name to PHP File using Command Line?
In Ubuntu system, first check for the PHP. For checking open the terminal, using command
**Ctrl +Alt +T**
and type whereis php
If PHP present in system, above command display the path of PHP
Make a PHP file from where you can acce...
How to create CSV file in java?
Sometime we need to generate CSV from data as per requirement. You can easily create CSV file by following the below steps:
Write the following Maven configuration in pom.xml file in your project:
<dependency>
<groupid>net....
How to read data from CSV file in Java?
Sometimes we need to read data from a CSV file as per requirement. You can easily read the data from CSV file by following the below steps:
Write the following Maven configuration in pom.xml file in your project:
<dependency>
...
How to download any CSV file while working with PHP
/* Header file to includes.
fopen is use to open a file in write mode here.
fputcsv function is use to output the CSV file having the name of columns and data coming from database. */
header('Content-Type: text/csv; charset=utf-8');
header('...
How to import/export data using CSV in PostgreSQL
To export a table data from Postgres database to a CSV file, use the "COPY to" command. You can create a CSV file using MS-Excel or directly create a file from the command.
Syntax: COPY (SELECT * FROM table_name) to E'C:\Users\main\Documents\...