redtroll Posted December 21, 2009 Share Posted December 21, 2009 Hi! I have an application that must do some inserts in a mysql db. This db is behind a firewall, and only port 80 is available. My first thougt is to use xml or csv, and in some way parse that using php. How can this be done? I can not use a web page with an send button, this has to be more or less automatic. I am brand new to php, so if possible give me example. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted December 21, 2009 Share Posted December 21, 2009 MySQL requires a port to listen on. The default is 3306. You will be unable to talk to the database server through your firewall. Quote Link to comment Share on other sites More sharing options...
oni-kun Posted December 21, 2009 Share Posted December 21, 2009 MySQL does not run through port 80. It's 3306, and is accessable serverside (or via your host normally) with full control. Yes, there are CSV and XML paring functions in PHP and should not be hard to implement provide you have knowledge to. There is no 'automatic' workings for these functions, you need to learn forms and sessions and the basics before you can even hope to use the CSV/SQL part of it.. Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted December 21, 2009 Share Posted December 21, 2009 MySQL does not run through port 80. It's 3306, and is accessable serverside (or via your host normally) with full control No. What if your database server is not on your webserver! There is nothing mentioned in the post regarding a webhost. This sounds like an internal configuration. If the database server is behind an internal firewall with only port 80 open then there is no way anything on the public side of the firewall will be able to talk to it. Doesn't matter how your planning to update the database i.e with CSV, XML or whatever. Quote Link to comment Share on other sites More sharing options...
redtroll Posted December 21, 2009 Author Share Posted December 21, 2009 This db is located at a webhotel. I was thinking of upload a file that will be parsed by php, and then use the values to be inserted to the mysql db. I will not try to access the db directly... Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted December 21, 2009 Share Posted December 21, 2009 I was thinking of upload a file that will be parsed by php, and then use the values to be inserted to the mysql db So how will you update the database? This db is located at a webhotel What the hell is a webhotel? Quote Link to comment Share on other sites More sharing options...
redtroll Posted December 22, 2009 Author Share Posted December 22, 2009 Webhotel = webhost, I guess that i a more common expression in europe. However, I found this site that have some kind of solution http://www.richtsoft.com/mysql_28_libmywitch.html I need a similar solution. Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted December 22, 2009 Share Posted December 22, 2009 You could program a web API on the server that has the database, but it would be a suboptimal solution compared to having direct access. Quote Link to comment Share on other sites More sharing options...
redtroll Posted December 22, 2009 Author Share Posted December 22, 2009 I do not need a direct access, but some way to send inserts. If a php front end receive and parse the information, it is fine with me. I heard of an method called SOAP, but I do not know how to use it. Quote Link to comment Share on other sites More sharing options...
redtroll Posted December 22, 2009 Author Share Posted December 22, 2009 i think something called WSDL might solve it, a web service 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.