Jump to content

Recommended Posts

[b]*** SOLVED ***[/b]
[i](well wasn't anythign to solve but no further help required thanks to
[b]AndyB[/b])[/i]

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.
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.