Total members
11892
|It is currently Thu Oct 03, 2024 2:17 pm
Login
/
Join Codemiles
Home
Get Help
Software Development
Java
C/C++
C#
web development
PHP
Servelts/JSP
Scripting Languages
AJAX
ASP
SEO
Google SEO
Projects
Finished Projects
Jobs
Jobs posts
Database
Sql Server
Mysql
Communications
Networks
Cisco
Microsoft
Styles
PHPBB3 Styles
PHPBB3 Support
Tutorials
JAVA Tutorials
C/C++ Tutorials
XML/XSLT Tutorials
XSD Tutorials
PYTHON Tutorials
HTML/JavaScript Tutorials
PHP Tutorials
ASP/ASP.NET Tutorials
JSP/JSF/STRUCTS Tutorials
RUBY Tutorials
Photoshop Tutorials
Flash Tutorials
General Tutorials
Codes Snippets
Java Codes
C++ Codes
C# Codes
ASP/ASP.NET Codes
PHP Codes
HTML Codes
CSS Codes
JavaScript Codes
Matlab Codes
Blogs
Java
Java Basics
Java Variables
Java Methods
Java Arrays
Java Strings
Java OOP
Java Collections
Java I/O
Java Networking
Java Email
Java Threads
Java JDBC
Java Exceptions
Java Time
Java AWT
Java Swing
Java Events
Java Applet
Java XML
Java Image
Java Sound
Java Graphics
Java Algorithms
Java Projects
J2ME
Servlets/JSP
JSF
JMS
JPA
JAXB
Java FX
C/C++
C++ Basics
C++ Variables
C++ Loops
C++ Arrays
C++ Strings
C++ OOP
C++ I/O
C++ Inputs
C++ Threads
C++ Math
C++ Algorithms
C++ Sorting
C++ Data-Structure
C++ Projects
C++ MFC
C++ Graphics
PHP
PHP Basics
PHP Variables
PHP Strings
PHP Arrays
PHP Loops
PHP Functions
PHP OOP
PHP GET/POST
PHP Forms
PHP Validation
PHP I/O
PHP Networking
PHP Email
PHP Date
PHP Cookies
PHP Sessions
PHP Exceptions
PHP Graphics
PHP XML
PHP URL
PHP Database
PHP Projects
C#
C# Basics
C# Arrays
C# Algorithms
C# Forms
C# Serialization
C# Projects
HTML
HTML Heading
HTML Body
HTML Div
HTML Paragraph
HTML Link
HTML Image
HTML Table
HTML Form
HTML Font
HTML Direction
HTML List
HTML Inputs
HTML Span
HTML Popup
HTML Animation
HTML Meta
HTML Frame
HTML Background
HTML Comment
CSS
CSS Basics
CSS Align
CSS Font
CSS Border
CSS Link
CSS Background
CSS Cursor
CSS Display
ASP
ASP Basics
ASP Arrays
ASP Time
ASP Email
ASP MySQL
ASP Forms
ASP Cookies
ASP Strings
ASP I/O
ASP Time
ASP AJAX
ASP Reports
Javascript
JavaScript Basics
JavaScript Variables
JavaScript Arrays
JavaScript Validation
JavaScript Time
JavaScript Functions
JavaScript Events
JavaScript RSS
JavaScript ATOM
JavaScript Image
JQuery
JQuery Basics
JQuery Selector
JQuery Hide
JQuery Show
JQuery Toggle
JQuery Fade
JQuery Animate
JQuery Slide
JQuery Content
JQuery Image
JQuery Position
JQuery Rating
JQuery Table
JQuery GET/POST
JQuery Validation
JQuery UI
AJAX
AJAX Basics
AJAX Validation
AJAX Browser
AJAX Request
AJAX XML
AJAX & JavaScript
AJAX Projects
XSD
XSD Basics
XSD Elements
XSD Attributes
Python
Python Email
Python Algorithms
Python GEO
Python Exceptions
Python I/O
Python Database
Matlab
Matlab Basics
Matlab Image
Matlab Algorithms
Matlab Classifier
Matlab Project
R Scripts
R Analysis
R Classifiers
R Clustering
Weka
Weka Classifiers
Loading table data from a CSV file
Code:
<?php
$conn
=
mysql_connect
(
"localhost"
,
"someuser"
,
"secret"
);
$db
=
mysql_select_db
(
"cars"
);
$fh
=
fopen
(
"yourCSVFile.csv"
,
"r"
);
while (
$line
=
fgetcsv
(
$fh
,
1000
,
","
)) {
$year
=
$line
[
0
];
$make
=
$line
[
1
];
$color
=
$line
[
2
];
$query
=
"INSERT INTO carcollection SET year='$year', make='$make',color='$color'"
;
$result
=
mysql_query
(
$query
);
}
fclose
(
$fh
);
mysql_close
();
?>
_________________
M. S. Rakha, Ph.D.
Queen's University
Canada
Tweet
Author:
DrRakha
Posts:
2715
Have thanks:
74 time
Page
1
of
1
[ 1 post ]
Related Posts to :
Loading table data from a CSV file
NULL Data in table
-
Delete data from database table in php
-
show table data by clicking button
-
How to merge the data into file
-
How to make PHP form data saved into txt file
-
Reading selected data from a source file
-
Show loading image from JQuery
-
show loading status message until the applet is fully loaded
-
Encrypt/Decrypt a file from source file to target file.
-
Copy file to file in java code- implementation
-
Topic Tags
PHP Database
,
PHP Files and I/O