2 questions: 1) learning PHP/MySQL 2) writing XML

Hello All,

I am new to PHP/MySQL development. I have a lot of experience with
ASP.NET. I need some help/direction with the following:

1) Learning PHP and MySQL, especially

2) Learning how to write to (and read from) MySQL databases and writing
out XML documents using MySQL data

Helpful links are greatly appreciated.

"KJ" <n_o_s_p_a__m@mail.com> wrote in message
news:1161019406.438858.22380@m7g2000cwm.googlegrou ps.com...
> Hello All,
>
> I am new to PHP/MySQL development. I have a lot of experience with
> ASP.NET. I need some help/direction with the following:

hehe moving over from the dark side.... you'll be amazed at how good the
documentation is for PHP

>
> 1) Learning PHP and MySQL, especially
>

http://www.php.net/ a wealth of info such as http://www.php.net/links.php
which has a whole section on tutorials


and various at http://www.zend.com/

> 2) Learning how to write to (and read from) MySQL databases and writing
> out XML documents using MySQL data
>
http://devzone.zend.com/node/view/id/884

http://www.zend.com/codex.php?CID=15

and here's a real pearl which specifically addresses what you want to do:
http://www.zend.com/zend/spotlight/xml-sql-aug.php


> Helpful links are greatly appreciated.
>

also lots of books at your local library

welcome to PHP :-)

It's all in the manual:
http://www.php.net/manual/en/

If you want something more like ASP.NET, start with a decent
framework:
http://www.achievo.org/atk

(atk is up higher than .net in that it is all codebehinds, so to
speak. apart from the themes, there are no "pages" with tags in them
to worry about. that said, embedded smarty, scriptaculous, fckedit)

ATK looks cool, I'll definitely be investigating that further.

By the way, my target platform is Mac OS X, and I'm wondering if MySQL
is the best choice. My first choice for a free DB server would be
Oracle 10g Express, but it doesn't run on Mac.

For a second choice, would you recommend postgresql over MySQL? I am
partial to writing stored procedures...


R K wrote:
> It's all in the manual:
> http://www.php.net/manual/en/
>
> If you want something more like ASP.NET, start with a decent
> framework:
> http://www.achievo.org/atk
>
> (atk is up higher than .net in that it is all codebehinds, so to
> speak. apart from the themes, there are no "pages" with tags in them
> to worry about. that said, embedded smarty, scriptaculous, fckedit)

I don't know. Stick with MySQL, that was your original question.
Then try out phpMyAdmin, that will set the standard in your mind for
what constitutes a useful tool. If you're new to all this
stuff...later try out the other databases.