PHP and... XML or MySQL?

mbstevens wrote:
 > Steve Greenaway wrote:
 >
  >> A lot of information seems to be out there regarding the use of PHP
  >> and MySQL together. I can't find many books about PHP and XML. Is
  >> there a reason for this? Or is it just because PHP has only recently
  >> supported XML in a thorough way?
  >>
  >> I guess what I'm trying to ask is, what's a better method these days
  >> for data management, assuming I'll be using PHP to create the web
  >> pages?
  >>
 >
 > Data bases like MySQL are great for storing and retrieving data
 > quickly and flexibly. XML is great for translation and interaction
 > between data and programs with disparate data formats -- and OK for
 > storing data if you don't mind the speed of serial access. It's easy
 > enough to get data out of a database into XML, and vice versa. The
 > "better method" you're looking for depends on what you're planning to
 > do with the web pages.
 >
 > You should also consider Perl/CGI as well as PHP.

As long as the site doesnt depend on the info being saved. All my experience
with cgi is that it overloads the server and loses the files its writing to
at the time.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: PHP and... XML or MySQL? 

Viper wrote:

  >> You should also consider Perl/CGI as well as PHP.
 >
 > As long as the site doesnt depend on the info being saved. All my
 > experience with cgi is that it overloads the server and loses the files
 > its writing to at the time.

Nah. You're just holding your elbow at the wrong angle.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: PHP and... XML or MySQL? 

Following up to Viper's post since I don't seem to have mbstevens' here...

Kermit the Frog stuck a mic in Viper's face, who said:
 >mbstevens wrote:
  >>
  >> Data bases like MySQL are great for storing and retrieving data
  >> quickly and flexibly. XML is great for translation and interaction
  >> between data and programs with disparate data formats -- and OK for
  >> storing data if you don't mind the speed of serial access. It's easy
  >> enough to get data out of a database into XML, and vice versa. The
  >> "better method" you're looking for depends on what you're planning to
  >> do with the web pages.
  >>
  >> You should also consider Perl/CGI as well as PHP.

What do you mean by serial access? I guess I know even less about
databases than I thought I did.

 >As long as the site doesnt depend on the info being saved. All my experience
 >with cgi is that it overloads the server and loses the files its writing to
 >at the time.

That's not so nice.

--
- Steve
"I think a good friend would recommend CLR to all his friends."<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: PHP and... XML or MySQL? 

Steve Greenaway wrote:

 > What do you mean by serial access? I guess I know even less about
 > databases than I thought I did.

A database knows where the information is stored, whereas you might have to
read through a big file to find something stored in an XML file. It's this
reading through that I meant by serial access, although you *actually* have
*random* access to any file on the server -- it's just no good to you if
you don't know the address you're looking for inside a file. A database
knows more about the physical location of the data stored inside, so it
can get to it much more quickly.

  >>As long as the site doesnt depend on the info being saved. All my
  >>experience with cgi is that it overloads the server and loses the files
  >>its writing to at the time.
 >
 > That's not so nice.
 >
He probably forgot to lock a file or something.
I've never run across this.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: PHP and... XML or MySQL? 

Steve Greenaway <macfisto.TakeThisOut@engsoc.org> wrote in
news:cte8ip$8kj$1@driftwood.ccs.carleton.ca:

 > A lot of information seems to be out there regarding the use of PHP
 > and MySQL together. I can't find many books about PHP and XML. Is
 > there a reason for this? Or is it just because PHP has only recently
 > supported XML in a thorough way?
 >
 > I guess what I'm trying to ask is, what's a better method these days
 > for data management, assuming I'll be using PHP to create the web pages?

I'd say - apples and oranges.
If you have some data, and you want it to persist,
you have to store it somewhere/somehow. If that data
happens to be in XML format, then you could store it
in a database(e.g. MySQL), or maybe in files. Or you
could store the data in a database in appropriate
fields(e.g. text, numeric, etc), and have PHP serve
it as XML, HTML, plain text, PDF, etc.

--
Dave Patton
Canadian Coordinator, Degree Confluence Project
<a style='text-decoration: underline;' href="http://www.confluence.org/" target="_blank">http://www.confluence.org/</a>
My website: <a style='text-decoration: underline;' href="http://members.shaw.ca/davepatton/" target="_blank">http://members.shaw.ca/davepatton/</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: PHP and... XML or MySQL? 

On 28 Jan 2005 20:50:33 GMT, Steve Greenaway <macfisto RemoveThis @engsoc.org> wrote:

 > I guess what I'm trying to ask is, what's a better method these days
 > for data management, assuming I'll be using PHP to create the web pages?

I would recommend PostgreSQL. Last year we moved from MySQL to PostgreSQL.
More robust and powerful. Works with most platforms.

--
Using Opera's revolutionary e-mail client: <a style='text-decoration: underline;' href="http://www.opera.com/mail/" target="_blank">http://www.opera.com/mail/</a>
Discover Opera: <a style='text-decoration: underline;' href="http://members.surfeu.fi/jerkku/" target="_blank">http://members.surfeu.fi/jerkku/</a>
<a style='text-decoration: underline;' href="http://www.auriance.com" target="_blank">http://www.auriance.com</a> - <a style='text-decoration: underline;' href="http://www.auriance.net" target="_blank">http://www.auriance.net</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: PHP and... XML or MySQL? 

Unknown User wrote:

 > I would recommend PostgreSQL. Last year we moved from MySQL to PostgreSQL.
 > More robust and powerful. Works with most platforms.

I agree with you there -- PostgreSQL is a much better database than MySQL
-- and for any situation where you have the choice, go for it.

Unfortunately, many people have to host their sites on other people's
servers and don't get the choice.

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ <a style='text-decoration: underline;' href="http://tobyinkster.co.uk/contact" target="_blank">http://tobyinkster.co.uk/contact</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: PHP and... XML or MySQL?