Import MySQL table data into PHP

[dsudhakara]

I am in learning stage,Now I created table in mysql thur php coding and I want to Import the data thru php coding

[Atli]

Hi dsudhakara. Welcome to The Scripts!

What kind of data are you trying to import?
Have you tried this yourself?
Can we see your code?

[Motoma]

I am in learning stage,Now I created table in mysql thur php coding and I want to Import the data thru php coding

In that case, you will need to read your data, and perform an INSERT for each row of data you read.

If this is not helpful, please use more verbosity in describing what you are having problems with.

[pbmods]

Heya, dsudhakara.

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

[dsudhakara]

Hi dsudhakara. Welcome to The Scripts!

What kind of data are you trying to import?
Have you tried this yourself?
Can we see your code?

In Excel data trying to import.

Example,

Phone number :__MUNGED__
First name : Raj
Last name : Anu
address1 :chn
address2 :blr
state :TN
city :Chn
zip : 23232
id :1

I have created this fields thru php .Now I created one button click that button
that excel file data insert to recently created that table.

[Motoma]

In Excel data trying to import.

Example,

Phone number :__MUNGED__
First name : Raj
Last name : Anu
address1 :chn
address2 :blr
state :TN
city :Chn
zip : 23232
id :1

I have created this fields thru php .Now I created one button click that button
that excel file data insert to recently created that table.

I am sorry, but you have not pointed out what part of the process you are getting caught up on.

Your system will need to do a number of things:

* Upload the data file.
* Parse the data set
* Establish a connection to the database
* Perform SQL INSERT statements

What are you having trouble with?