phpeveryday.com

The best tutorial of php, php framework, php strategies, object oriented oriented,


PHP Excel Report: Import Data From Excel Using phpMyAdmin

Tag: excel, phpmyadmin   Category: PHP Application
post: 31 Dec 2007 read: 1,010


Import Excel Data Trick: We ever talk how about handling data at PHP using dom. Read here. Now, we use the popular mysql management tool for do it. This tool called "phpMyAdmin". Most of hosting use this tool to manage mysql data. Using this tool, we do not write any line codes. It is easy way.

For example, we have table like this at excel.

Now, save as CSV (Comma Separated Value).

Open your table at phpmyadmin. Klik tab import.

Next step, import csv file.




| Give Your Opinion | Recommend
Share and Bookmark to: These icons link to social bookmarking sites where readers can share and discover new web pages.
digg del.icio.us technorati Ma.gnolia BlinkList

Recommended articles by other readers:
Web Services: How PHP Kiss VB.NET? (Part 1)
Chart: How to Build Cool Animation Real Time Chart
Joomla: Fast Road to Understand Component Programming
Email: Send Attachement Mail
CAPTCHA - part 3 : "Are you human or ....?" (Build Your CAPTCHA)

What do You Think?
Your Name *:
Email *:
(Will not be published)
Website/URL:
Your Comment *:
* Required


615
posting