Humpty Posted March 4, 2006 Share Posted March 4, 2006 [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 databaseI 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 DBif 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. Quote Link to comment https://forums.phpfreaks.com/topic/4072-php-mysql-apache-importexport-via-php-code/ Share on other sites More sharing options...
AndyB Posted March 4, 2006 Share Posted March 4, 2006 [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. Quote Link to comment https://forums.phpfreaks.com/topic/4072-php-mysql-apache-importexport-via-php-code/#findComment-14136 Share on other sites More sharing options...
Humpty Posted March 4, 2006 Author Share Posted March 4, 2006 wow,Brief look makes heaps of sense, if not work then I'm sure I can sort it. cool thanks Quote Link to comment https://forums.phpfreaks.com/topic/4072-php-mysql-apache-importexport-via-php-code/#findComment-14138 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.