Top rated packages with tag csv mysql

Recommend this page to a friend!

			All class groups	>	Search tags: csv mysql

	1. CSV Creation		csv mysql

Supplied by: Manimaran <e-mail contact>

Create CSV files from MySQL table data

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.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (93.8%)`	`Good (93.8%)`	`Sufficient (75.0%)`	`Perfect (100.0%)`	`-`	`-`	`Sufficient (73.8%)`	85
Month:	Not yet rated by the users

	2. rs2csv		csv mysql

Supplied by: Sean Natoewal <e-mail contact>

Convert a MySQL record set to a CSV file.

This class can be used to convert a result set which has been generated by PHP's built-in MySQL functions to a comma separated values (CSV) file.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Sufficient (78.8%)`	`Sufficient (76.9%)`	`Sufficient (71.2%)`	`Sufficient (78.8%)`	`-`	`-`	`Sufficient (62.1%)`	653
Month:	Not yet rated by the users

	3. Create CSV		csv mysql

Supplied by: Ellery Leung <e-mail contact>

Generate CSV files from MySQL query results

This is a very simple class that can be used to generate CSV files from MySQL query results.

It can execute a MySQL database query and use the results to format the contents of a CSV file.

The CSV file contents is returned as a string, so it can be served for download or stored in a server file.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (91.7%)`	`Good (91.7%)`	`-`	`Sufficient (66.7%)`	`-`	`-`	`Sufficient (61.7%)`	691
Month:	Not yet rated by the users

	4. csv2mysql database migration tool		csv mysql

Supplied by: Mark Williamson <e-mail contact>

convert fields in a csv into SQL

This class creates sql to import into tables in any mysql table - you specify the fieldname in the csv - and the mysql field in your db that this relates to. It supports database queries to get values to go into final sql (so you can link tables) and it supports running custom functions to get values for the final sql too. - and static values for other fields.
It does some validation on the final sql to check that you have all the fields that are required etc.
There is also some (experimental) xls file import support providing you have xlhtml installed on the machine the class is running on. (it will locate it and moan if you haven't) This works if the excel file only has 1 page but if it has multiple pages then im working on it ;)

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (86.5%)`	`Sufficient (76.9%)`	`Sufficient (69.2%)`	`-`	`-`	`-`	`Not sure (57.9%)`	964
Month:	Not yet rated by the users

	5. Quick CSV import		csv mysql

Supplied by: Alexander Skakunov <e-mail contact>

Import CSV data into a MySQL database table

This class can be used to import data from CSV (Comma Separated Value) files into a given MySQL database table.

It parses a given CSV file to extract the field names. Then it imports the data into the MySQL database using a LOAD DATA INFILE query to import the data in a much faster way than using SQL INSERT queries.

If necessary, the class can also create the database table using the CSV file headers to retrieve the table field names.

UPDATE: From now you can set the encoding table which is used to parse the file.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Sufficient (71.1%)`	`Sufficient (72.4%)`	`-`	`Sufficient (72.4%)`	`-`	`-`	`Not sure (50.0%)`	1474
Month:	Not yet rated by the users

Copyright (c) Icontem 1999-2012	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products