Wednesday, February 25, 2009

[PHP Classes] Quickly importing data from CSV file into PHP applications

PHP Classes
Icontem

Quickly importing data from CSV file into PHP applications

Advertisement

You are getting this message because you voluntarily subscribed to the PHP Classes site. To change your newsletter or alert messages delivery options, see the instructions at the bottom of this message.

    Summary:

    In this article you may learn how to quickly import data from CSV files into your application with help of PHP.

    It also covers a tool that provides a Web based user interface for importing CSV data into a MySQL database table with support for mapping CSV columns into arbitrary MySQL database table columns.

    More...

    Read the whole message and post your comments in the PHP Classes blog page.

    If you like this post, do not forget to vote on it in Digg and in DZone, so more readers may know about this article. Use the buttons in the post page that says "digg it" to vote on the article on Digg and "zone it" to vote on DZone.

    PHP Classes site tip of the day

    Web hosting comparisonsWeb hosting comparisons

    Every site needs a good Web hosting service. Some services are better in price, others in access speed, others in support response time, etc..

    Compare and find out which Web hosting companies provides the best services that match your needs using the Hosting Metrics service.

    Read about other interesting tips
If you are not interested in receiving any more messages like this one, send an empty message to unsubscribe-announcements@phpclasses.org or go to the user options page and uncheck the respective e-mail delivery option. There you can also switch the message format between text and HTML. Note that there are several mailing lists. If you want to unsubscribe from all lists at once, send an empty message to unsubscribe-content@phpclasses.org .
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes
Posted by at No comments:

[PHP Classes] Weekly newsletter of Wednesday - 2009-02-25

PHP Classes
Icontem

Weekly newsletter of Wednesday - 2009-02-25

Advertisement

You are getting this message because you voluntarily subscribed to the PHP Classes site. To change your newsletter or alert messages delivery options, see the instructions at the bottom of this message.
Advertisement
This newsletter is always available online and upto date at: http://www.phpclasses.org/newsletter/ .

Contents

Latest PHP specialists forum threads

Subject Updated on
send and receive sms
Sending and receiving sms without using any smsgateway		 2009-02-24
PDF problem?
PDF 2 HTML		 2009-02-22
convert encoding MySQL
How to convert a MySQL 4.0 DataBase to a MySQL 5.0 DataBase		 2009-02-21
combining spam blocker with an existing form
I have an existing php form and need to add this spam blocker...		 2009-02-21
runnable xml file
problem		 2009-02-21
PHP Login
Fieldset login/logout		 2009-02-20
SimpleXML
Problem parsing data		 2009-02-20
top 10 charts
top 10 charts php classes		 2009-02-19

Contents

Contents

Top friends of the site

Friends of the PHP Classes site is a initiative to provide recognition to the users that contribute to the growth of the site community.

For more information on how to become a friend of the site look here.

Rank Friend Referrals
1 Cesar D. Rodas 34
2 solomongaby 32
3 Khaled Al-Shamaa 22
4 lixlpixel 20
5 Alexander Skakunov 19
6 Protung Dragos 16
7 Olaf Lederer 14
8 Richard Munroe 10
9 Ehsanul Haque 7
10 Horst Nogajski 7

Contents

Browse all PHP User Groups by country

If you make part of a regional PHP User Group not listed here, submit your user group.

Contents

Innovation award results

Innovation Award Winners Congratulations to Md. Mahmud Ahsan!


Rank Class Author Score Points Prize
1 Facebook Notification Class
Send e-mail and notifications to Facebook users		 Md. Mahmud Ahsan 36.00% 7 One copy of the Zend Studio
2 SQL Parse and Compile
Parse and compose SQL queries programatically		 Tom Schaefer 20.00% 6 One copy of VS.PHP
3 adv_net
Analyze the local network with nmap		 Tomasz Malewski 16.00% 5
4 Console Progress Bar
Draw a progress bar in ANSI console		 Alex B. Snet 14.00% 4
5 Dash Media Player
Embed the Dash Media player in a Web page		 Travis Tidwell 8.00% 3 One book of choice by O'Reilly
6 Name Parser
Parse a person full name to retrieve its parts		 G. Miernicki 4.00% 2 One book of choice by Apress
7 IAF decoder coder
Parse and generate Outlook IAF configuration files		 ruslan kononov 2.00% 1

Nominees to win the award of January of 2009

Class: Unicode Manipulation Picture of Rubens Takiguti Ribeiro
Description: Manipulate text with Unicode encodings
Author: Rubens Takiguti Ribeiro
Age: 24
Country: Brazil Brazil
Class: html2pcl Picture of Nurul Ferdous
Description: Convert HTML to PCL
Author: Nurul Ferdous
Age: ???
Country: Bangladesh Bangladesh
Class: Cartoonfy Picture of László Zsidi
Description: Process an image to make it look like a cartoon
Author: László Zsidi
Age: 35
Country: Hungary Hungary
Class: LR Parsing Tables Picture of Debug
Description: Generate parsing tables for context free grammars
Author: Debug
Age: 19
Country: United States United States
Class: GD Magic Picture of luigi de rosa
Description: Apply effects on images using only GD
Author: luigi de rosa
Age: 15
Country: Italy Italy
Class: Ads and content limit Picture of lee johnstone
Description: Keeps track of visitors to show limited ads a day
Author: lee johnstone
Age: 25
Country: Australia Australia
Class: Yahoo BBAuth Picture of Sadiqur Rahman
Description: Authenticate users with Yahoo accounts
Author: Sadiqur Rahman
Age: 24
Country: Bangladesh Bangladesh
Class: PHP Text Classifier Picture of alfan
Description: Classify text in categories using Bayesian method
Author: alfan
Age: 20
Country: Indonesia Indonesia
Class: Check Curly Braces Picture of raenkrus
Description: Check matching curly brackets in text files
Author: raenkrus
Age: ???
Country: Italy Italy
Class: NSGSC Picture of Danilo Castro
Description: Calculate quantum computing graph states
Author: Danilo Castro
Age: 28
Country: Brazil Brazil
Class: Cpanel Backup scheduler Picture of Sanjoy Ganguly
Description: Schedule a backup of a Cpanel hosting account
Author: Sanjoy Ganguly
Age: ???
Country: India India
Class: Torrent Pieces Hash Verification Picture of Charalampos Pournaris
Description: Compare downloaded data with torrent data
Author: Charalampos Pournaris
Age: 23
Country: Greece Greece
Class: DIV Based Table Generator Picture of Muhammad Arfeen
Description: Generate table like HTML layouts using only DIVs
Author: Muhammad Arfeen
Age: ???
Country: Pakistan Pakistan
Class: AIS_Util_MultibyteSort Picture of Christian
Description: Sort arrays with text encoded using Unicode
Author: Christian
Age: 26
Country: Germany Germany

Vote

Contents

Latest blog trackback links

Trackback Class Age in days
Autofill 1.1b
A few days ago a User of my Autofill ...		 Autofill 1.1 1
Simple Ajax and PHP application tutorial
This tutorial is a reference to an Aj...		 Simple AJAX 1
code #2. simple twitter php library
this is a simple twitter interface. y...		 Twitter 2
Geziehlte Werbung durch Produkt WebServices
Viele Werbemittel passen sich der Sei...		 eBay API 4
PHP ile XML dökümanlarin okunmasi
PHP ile XML formatindaki dökümanlari ...		 SimpleXML for PHP4 5
Klasse in Funktion nutzen
ich möchte gerne eine Klasse für Ical...		 IMC Objects 7
1-Click maintenance con PHP
Existen algunas tareas de mantenimien...		 Periodic site maintenance 7
RSS creator for HTML sites...
This is a class for creating a RSS...		 RSS Feed Generator 7
Image authentication with PHP
...		 KCAPTCHA 8
cPanel / WHM - a kind of rant
Anyone who knows me will know that I'...		 WHM XML API 10

Contents

Latest support forum threads

Subject Posted on Class
Very nice && useful package! Wraia douleia Giorgo!
Package rating comment		 2009-02-24 AdminPro class
Very nice! Thank you, it is exactly what I have been looking ...
Package rating comment		 2009-02-24 Synchronize DB
Hello, Very interesting class, great simplification of Photo...
Package rating comment		 2009-02-24 GD Image Manipulation
Hello, bug file.
Package rating comment		 2009-02-24 ExifSort
website integration example
integration + some bug fixes		 2009-02-23 PHPBB 3 Integration class
stalled at Connected.
script stalled at Connected.		 2009-02-23 E-mail address validation class
border image
unable to use border image for rounded border		 2009-02-23 Easy PHP Thumbnail
thats a very good class !! loool
Package rating comment		 2009-02-23 Easy PHP Thumbnail
Text style
Hexadecimal code		 2009-02-23 MsDoc Generator
How to send special chars?
How to send special chars (as €, á, é,...) without using unicode		 2009-02-22 SMPP Class

Contents

  • Latest package entries

  • Google Result Counter

    Picture of Dharmveer
    Author: Dharmveer
    Date: 2009-02-24 (1 day ago)
    Groups: Searching, Web services
    Description: This class can be used to retrieve the count of results for a Google search.

    It accesses the Google search site to send a request for a given keyword.

    The class parses the result page to retrieve the count of results found for that keyword.

  • Upload and list files

    Picture of András Zoltán-Gyárfás
    Author: András Zoltán-Gyárfás
    Date: 2009-02-24 (1 day ago)
    Groups: HTML, PHP 5, Files and Folders
    Description: This class can be used to Display and process forms to upload files.

    It can display an HTML form with fields to upload a file.

    The class can also process a form with an uploaded file by checking if the file if of one of the allowed file MIME types name extensions, and moving the file to a given directory if does not exist already.

    The class can also create the destination directory with the necessary permissions.

  • XtremeTemplate

    Picture of shahnur
    Author: shahnur
    Date: 2009-02-23 (2 days ago)
    Groups: Templates
    Description: This class implements a template engine that uses PHP scripts as templates.

    It can assign multiple template variables that are assigned as local variables before processing the template scripts.

    The class includes the template script that is executed with the template variables already assigned.

    The template script output is captured into the PHP output buffer to be returned as a template processing result string.

  • Nested set

    Picture of Mark Stuppacher
    Author: Mark Stuppacher
    Date: 2009-02-23 (2 days ago)
    Groups: HTML, PHP 5, Databases, Data types
    Description: This class can be used to manipulate an hierarchical tree of node stored in a MySQL database table.

    It can perform several types of operations to manipulate database records that represent the nodes the tree.

    Currently it can create the root node, insert a node, retrieve a node, retrieve the tree of nodes, display the tree as nested HTML lists, delete a node, get the path of the parents of a node and move nodes to the left or the right.

  • Easy PHP Thumbnail

    Picture of Jos Nutbroek
    Author: Jos Nutbroek
    Date: 2009-02-22 (3 days ago)
    Groups: Graphics
    Description: This class can be used to manipulate images and generate thumbnails.

    It can load images from files and generate thumbnails that can be saved to files or be generated as the current script output.

    The class can also perform other image manipulation functions like adding shadows, clip corners, apply the sepia image aging effect, add a border, add a binder to the image side, draw a copyright text, rotate, flip, crop and make the image square.

  • Usenet Downloader

    Picture of Nadir Latif
    Author: Nadir Latif
    Date: 2009-02-22 (3 days ago)
    Groups: Networking, Content management
    Description: This package can be used to retrieve newsgroup articles from NNTP servers.

    There is a generic NNTP class that can retrieve listings of groups, listing of group articles and the articles headers and bodies.

    There are other classes that can retrieve listing of groups from several different sites and insert the listings on a MySQL database table.

    Other classes can retrieve groups stored in the database and retrieve articles of those groups from the NNTP servers.

  • Skor PHP Template

    Picture of Auirio
    Author: Auirio
    Date: 2009-02-21 (4 days ago)
    Groups: PHP 5, Templates
    Description: This class implements a template engine that uses regular expressions to find placeholders to replace.

    It can read a template from a file and file placeholders to be replaced by template variable values.

    The class can assign individual variable values or arrays with several variable values.

    A separate sub-class extends the base class to support delimited template section replacements.

  • Mediaset TV

    Picture of luigi de rosa
    Author: luigi de rosa
    Date: 2009-02-21 (4 days ago)
    Groups: Web services, Video
    Description: This class can be used to get television programming of Mediaset network channels.

    It can access the Mediaset network site to retrieve the pages about television programs for a given day and time in one of the available network channels like Italia 1, Canale 5, Rete 4.

    The class returns an array with the name of the program, start and end time, date and channel.

  • Best MySQL Class

    Picture of Ian Aldrighetti
    Author: Ian Aldrighetti
    Date: 2009-02-20 (5 days ago)
    Groups: Databases
    Description: This class implements a MySQL database access wrapper. It can:

    - Connect to a given MySQL server and access given database
    - Execute SQL queries
    - Retrieve any errors, the number of affected rows, last inserted identifier, number of result columns and rows
    - Retrieve the query results into arrays or objects
    - Get information about the MySQL client and server
    - Create or drop a database
    - Retrieve the list of available databases or database tables
    - Check server connectivity
    - Get connection statistics and variable values

  • PHS_Error

    Picture of Andrei Orghici
    Author: Andrei Orghici
    Date: 2009-02-20 (5 days ago)
    Groups: Debug
    Description: This class can be used to keep track of application errors and warnings.

    Applications can call this class to store information about errors and warnings.

    The class stores in class variables backtrace information that include the PHP files, functions names and line numbers of the functions that were called to reach a point to where the errors or warnings were added.

  • Template Class / Viewer

    Picture of Ralf Mike Pretzlaw
    Author: Ralf Mike Pretzlaw
    Date: 2009-02-19 (6 days ago)
    Groups: PHP 5, Templates
    Description: This class implements a template engine that replaces marks with variable values.

    It can load a template from a static file or a PHP script that is executed to generate the template output

    The class can replace the template placeholder marks by values previous set to the class object variables.

  • Megavideo Downloader

    Picture of luigi de rosa
    Author: luigi de rosa
    Date: 2009-02-19 (6 days ago)
    Groups: PHP 5, Web services, Video
    Description: This class can be used to download video files from megavideo.com.

    It takes URL of a video page and retrieves a XML document of the video details.

    The class can extract several types of information about the video including its download URL.

  • PHP.ini

    Picture of Skiyo
    Author: Skiyo
    Date: 2009-02-18 (7 days ago)
    Groups: PHP 5, Language, Configuration
    Description: This class can be used to manage configuration options in the PHP.ini file.

    It can parse the php.ini file to extract the values of the PHP configuration options.

    The class can change the options values, add and remove new options or sections, and when done it can save the changes back to the php.ini file.

  • Whois Lookup

    Picture of Peter Schmalfeldt
    Author: Peter Schmalfeldt
    Date: 2009-02-18 (7 days ago)
    Groups: Networking, PHP 5
    Description: This class can be used to get details about domains or IP addresses with Whois protocol.

    It can connect to a Whois server for a for a given top level domain and perform a query to retrieve information about that domain.

    It class can also retrieve information for a given IP address using the arin.net Whois server.

Contents

This security report was provided by:

SecuritySpace.com

Get a complete security audit
Is your site vulnerable?
Don't wait for the hackers to find about it!
 

Free security audit
Check if your servers are at risk for free!
 

Contents

Contents

If you are not interested in receiving any more messages like this one, send an empty message to unsubscribe-newsletter@phpclasses.org or go to the user options page and uncheck the respective e-mail delivery option. There you can also switch the message format between text and HTML. Note that there are several mailing lists. If you want to unsubscribe from all lists at once, send an empty message to unsubscribe-content@phpclasses.org .
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes
Posted by at No comments:
Subscribe to: Comments (Atom)