dennismonsewicz Posted September 14, 2009 Share Posted September 14, 2009 I need direction in how to go about uploading a sql file and then parsing the file to dump the results into a database... and this sql file will contain the ability to create a table and then insert corresponding entries into that table. I know how to upload a file using PHP but I am not 100% certain on the parsing the data Quote Link to comment Share on other sites More sharing options...
corbin Posted September 15, 2009 Share Posted September 15, 2009 Just split on ; and use mysql_query on each individual query. Or, you could use exec() and hand the file off to the mysql binary. Quote Link to comment 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.