Re: [PHP] sharing info between websites with XML?
p80 wrote: On Sunday 12 December 2004 05:15 pm, Jason Wong wrote: On Sunday 12 December 2004 22:33, p80 wrote: eg do you want to only make available specific pre-defined bits of data to client websites, yes this is how I'd like to proceed OK, if there are only a limited number of these pre-defined bits of data then the easiest way is probably just output it as plain text (you don't say what kind of data you're sharing) in an easy to parse format (CSV, XML, whatever you're comfortable with). and in case i need it what if it's not pre-defined bits of data, how shoud it be handle? That's an open-ended question. If you can limit yourself to specific data-types in MySQL, PHP, and in the recipient/sending web-sites, you can build a fairly simple system where your XML includes the data-type of the information being sent, and you can use type information available from MySQL and PHP to send what you want. But there are more and more complexities as you add more and more types of data: int float text are simple enough, but then you go with char() and varchar() and throw in BLOB and ... If you want to support *ALL* data types, you've got a major project on your hands, though, especially as you'll find that converting data into and out of XML will make some things a lot more complex than they seem at first glance. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] sharing info between websites with XML?
p80 wrote: I have several website that use mysql as a database and I would like them to access each other DB. The problem is that I can't connect to each other mysql DB so I'm looking for a way to do so. Why aren't you able to connect to the other databases? cause hosters forbid it. Get somebody else to host your MySQL database that *does* allow remote connections, I guess... Or, if the amount of traffic is *REALLY* low, you could write PHP scripts on each host, that provide the data the other hosts need... Is that what prompted the XML question? Ah. Well, really, switching hosts is probably going to be the easiest solution -- Or convince your host to give you a custom database that is accessible to all your sites. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] sharing info between websites with XML?
On Tuesday 14 December 2004 02:08, Richard Lynch wrote: Get somebody else to host your MySQL database that *does* allow remote connections, I guess... Actually if the MySQL on the host was not compiled with SSL support then using remote access might not be such a good idea (if you value your data). In such a situation if you have SSH access to the host it would be better to use SSH forwarding instead, plus this method can be used regardless of whether MySQL allows remote access. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* You have only to mumble a few words in church to get married and few words in your sleep to get divorced. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] sharing info between websites with XML?
I have several website that use mysql as a database and I would like them to access each other DB. The problem is that I can't connect to each other mysql DB so I'm looking for a way to do so. I'm thinking of droping the mysql database in xml files that could be parse using php xml parser but I'm not sure if this is the best way to do it (sharing db's content). If it's the best way to do it tips would be welcome :) and if it's not the best way to do it could u please tell me what's the right way? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] sharing info between websites with XML?
On Sunday 12 December 2004 21:35, p80 wrote: I have several website that use mysql as a database and I would like them to access each other DB. The problem is that I can't connect to each other mysql DB so I'm looking for a way to do so. I'm thinking of droping the mysql database in xml files that could be parse using php xml parser but I'm not sure if this is the best way to do it (sharing db's content). If it's the best way to do it tips would be welcome :) and if it's not the best way to do it could u please tell me what's the right way? You're asking a very general question here. How you would approach this depends very much on what exactly it is that you're wanting to do. Perhaps if you could be more specific -- eg do you want to only make available specific pre-defined bits of data to client websites, does the client website have any need to change the data, does the data have to be encrypted whilst in transit, are all the websites under your control (more specifically can they be trusted), etc. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* A possum must be himself, and being himself he is honest. -- Walt Kelly */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] sharing info between websites with XML?
On Sunday 12 December 2004 22:33, p80 wrote: eg do you want to only make available specific pre-defined bits of data to client websites, yes this is how I'd like to proceed OK, if there are only a limited number of these pre-defined bits of data then the easiest way is probably just output it as plain text (you don't say what kind of data you're sharing) in an easy to parse format (CSV, XML, whatever you're comfortable with). I'm not sure about this yet. I know XML is pretty unsecure when it's not encrypted as it's only text. does php provide functions to ecrypt XML while on transit or should I use other technics than XML? If your webserver is SSL enabled you could just make the data available only via login on SSL. It's relatively easy to setup the clients to login automatically. PHP supports encryption if you install the necessary libraries and configure PHP accordingly (manual Mcrypt Encryption Functions). However the client has to be configured similarly so that it can decode the stuff. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* GOOD-NIGHT, everybody ... Now I have to go administer FIRST-AID to my pet LEISURE SUIT!! */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] sharing info between websites with XML?
On Sunday 12 December 2004 05:15 pm, Jason Wong wrote: On Sunday 12 December 2004 22:33, p80 wrote: eg do you want to only make available specific pre-defined bits of data to client websites, yes this is how I'd like to proceed OK, if there are only a limited number of these pre-defined bits of data then the easiest way is probably just output it as plain text (you don't say what kind of data you're sharing) in an easy to parse format (CSV, XML, whatever you're comfortable with). and in case i need it what if it's not pre-defined bits of data, how shoud it be handle? thanx in advance PAt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re: [PHP] sharing info between websites with XML?
From: p80 [EMAIL PROTECTED] I have several website that use mysql as a database and I would like them to access each other DB. The problem is that I can't connect to each other mysql DB so I'm looking for a way to do so. Why aren't you able to connect to the other databases? cause hosters forbid it. Then get another host or somewhere else to host your databases. Not a PHP issue, though. ---John Holmes... UCCASS - PHP Survey System http://www.bigredspark.com/survey.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] sharing info between websites with XML?
On Sunday 12 December 2004 03:16 pm, Jason Wong wrote: On Sunday 12 December 2004 21:35, p80 wrote: I have several website that use mysql as a database and I would like them to access each other DB. The problem is that I can't connect to each other mysql DB so I'm looking for a way to do so. I'm thinking of droping the mysql database in xml files that could be parse using php xml parser but I'm not sure if this is the best way to do it (sharing db's content). If it's the best way to do it tips would be welcome :) and if it's not the best way to do it could u please tell me what's the right way? eg do you want to only make available specific pre-defined bits of data to client websites, yes this is how I'd like to proceed does the client website have any need to change the data no it doesn't need to change it, only access it. does the data have to be encrypted whilst in transit I'm not sure about this yet. I know XML is pretty unsecure when it's not encrypted as it's only text. does php provide functions to ecrypt XML while on transit or should I use other technics than XML? are all the websites under your control (more specifically can they be trusted), etc. yes they can be trusted as they are partenairs but they are not all under my control thanx in advance Pat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] sharing info between websites with XML?
I have several website that use mysql as a database and I would like them to access each other DB. The problem is that I can't connect to each other mysql DB so I'm looking for a way to do so. Why aren't you able to connect to the other databases? cause hosters forbid it. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php