Jump to content


Photo

PHP + mySQL + Apache Import/Export VIA PHP code


  • Please log in to reply
2 replies to this topic

#1 Humpty

Humpty
  • Members
  • PipPipPip
  • Advanced Member
  • 132 posts

Posted 04 March 2006 - 08:04 AM

*** SOLVED ***
(well wasn't anythign to solve but no further help required thanks to
AndyB)


G'day guys.

Just need a push in the right direction here.

File contents = data for mySQL web database

I want to be able to upload a file, (I have the code already), and then import that into mySQL via some PHP code.

..Similar to phpMyAdmin.

Is there a function that does this, (if so what should I search google for)

if not, then I assume that I will need to PARSE the file with PHP code, (can do that code that sorts each row), need the code / function that is used to open the file (once on webserver) and input it 1 line at a time.

Am sure the rest of the code I can do, just is a lack of familiarality with the all the best / possible ways of doing this. (will also need to do the oposite Take from DB (can do that), output to file on web server (can't do that) and then download to PC (can do that) for import into PC based DB

if you are curious it is PC based Microsoft Access, and Webbased mySQL data that I am using here.

Everyhting I need on the PC based side of things I have covered using VisualBasic, just PHP file open/load/parsing that I need info on.

Thanks guys.
- Humpty
  #> Where does the light go when it goes out?

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 04 March 2006 - 12:33 PM

[a href=\"http://www.blue105.com/internet/support/mysql_offline.html\" target=\"_blank\"]http://www.blue105.com/internet/support/mysql_offline.html[/a] looks like simple answers to those questions.
Legend has it that reading the manual never killed anyone.
My site

#3 Humpty

Humpty
  • Members
  • PipPipPip
  • Advanced Member
  • 132 posts

Posted 04 March 2006 - 12:37 PM

wow,

Brief look makes heaps of sense, if not work then I'm sure I can sort it. cool thanks
- Humpty
  #> Where does the light go when it goes out?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users