Member Avatar for kirtan_thakkar

Hi, I am beginner in PHP and MYSQL ...
Before using mysql i have created database in text files..
Now I have to convert it into the table of mysql database..
The things i want to do is ..
first open the specific folder and into that open the sub folder and in each sub folder there are text files..
Than open the text files, read the data and add into the sql table and add the folder name to the another field..
Can any one help me how to code it??
Please.. And explain if you want how u have code it???
Thanks..

  • 2 Contributors
  • 1 Reply
  • 116 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by drjohn
Member Avatar for drjohn

Extract the files, and try loading them into a spreadsheet, such as excel. Then save as as text file, tab delimited. ~then create your database tables with th ecolumns in the same order as in your file. then use the mysql load data infile or load data local infile command to insert the data in bulk.

This is a manual process.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.