PHP Classes
elePHPant
Icontem

CSV Creation: Create CSV files from MySQL table data

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2008-01-22 (7 years ago) RSS 2.0 feedStarStarStarStar 67%Total: 3,273 This week: 2All time: 1,008 This week: 570Up
Version License PHP version Categories  
csvcreation 0.1GNU General Publi...3Databases, Files and Folders
Description Author  

This class can be used to create CSV (Comma Separated Values) files from MySQL database table data.

It executes an SQL query to retrieve all the data in a given MySQL table and generates a CSV file with the table data.

The CSV file name is the table name followed by the .csv extension. The directory where the file is created is configurable.

The class can also iterate over all tables of a MySQL database and generate CSV files from their contents within a single class call.

Picture of Manimaran
Name: Manimaran <contact>
Classes: 1 package by
Country: India India
Age: 35
All time rank: 90648 in India India
Week rank: 555 Up43 in India India Up

Details provided by the author  
##########################################################################################
# csv creation , a php script that creates csv file form mysql database.
#
#   License: GPL
#
#   Manimaran V.   Mail: manimaranvel@yahoo.com
#
##########################################################################################


Installation 
    
      1.  Replace appropriate HOSTNAME,DBNAME,USER and PASSWORD from inc.csvcreation.php file

          $this->db_server = 'HOSTNAME';
          $this->db_name   = 'DBNAME';
          $this->db_user   = 'USER';
          $this->db_pass   = 'PASSWORD';
      
      2.  create a folder called temp in root folder

      3.  run the sample.php file that's it  

For further clarificatio mail me........
  Files folder image Files  
File Role Description
Plain text file inc.csvcreation.php Class class file for csv creation
Accessible without login Plain text file readme.txt Doc. Readme
Accessible without login Plain text file sample.php Example Sample example file

 Version Control Unique User Downloads Download Rankings  
 0%Total:3,273All time:1,008
 This week:2This week:570Up
User Ratings User Comments (2)  
 All time
Utility:87%StarStarStarStarStar
Consistency:87%StarStarStarStarStar
Documentation:62%StarStarStarStar
Examples:91%StarStarStarStarStar
Tests:-
Videos:-
Overall:67%StarStarStarStar
Rank:349