[gacuna]

Ok, here is the deal, well I already installed MySQL, but how do I create a new database? and well I also want to know how to install PHP, what do I do please help. How do I also create databases, please I need to create databases and stuff like that. Please help.

--Guillermo

[ 06-16-2001: Message edited by: gacuna ]

[xspriter]

Originally posted by gacuna:
<STRONG>Ok, here is the deal, well I already installed MySQL, but how do I create a new database? and well I also want to know how to install PHP, what do I do please help.

--Guillermo</STRONG>

gacuna,

To create a new database, simply type the following from shell:

<BLOCKQUOTE><font size="1"face="Geneva, Verdana, Arial">code:</font><HR><pre><font size=1 face=courier>mysqladmin -p create DATABASENAME</font>[/code]

Where DATABASENAME is whatever name you'd like to use. You can then create your tables within the database.

I can't stress enough the importance of good relational database design. Take the time to learn this properly. If you're new to MySQL (or even if you're not), I highly recommend that you pick up a reference book. I've used both of the following and found them helpful:

• MySQL & mSQL (O'Reilly)
• MySQL (Other New Riders)

As for PHP, you can download a nice installer package from the following website:

http://www.entropy.ch/software/macosx/

There are at least two great php resources on the internet, PHP.net and PHP Builder. I highly recommend both of those.

For books, I've used PHP Bible, but it left a lot to be desired. You might also try Beginning PHP4 which is supposed to be quite good.

You might also try the following:

PHP and MySQL Web Development
and
PHP Developer's Cookbook

Hope this helps.

[gacuna]

Originally posted by xspriter:
<STRONG>

gacuna,

To create a new database, simply type the following from shell:

&lt;BLOCKQUOTE&gt;&lt;font size="1"face="Geneva, Verdana, Arial"&gt;code:&lt;/font&gt;&lt;HR&gt;&lt;pre&gt;& amp;lt;font size=1 face=courier&gt;mysqladmin -p create DATABASENAME&lt;/font&gt;&lt;/pre&gt;&lt;HR&gt;&lt;/BLOCKQUOTE&gt;

Where DATABASENAME is whatever name you'd like to use. You can then create your tables within the database.

I can't stress enough the importance of good relational database design. Take the time to learn this properly. If you're new to MySQL (or even if you're not), I highly recommend that you pick up a reference book. I've used both of the following and found them helpful:

• MySQL & mSQL (O'Reilly)
• MySQL (Other New Riders)

As for PHP, you can download a nice installer package from the following website:

http://www.entropy.ch/software/macosx/

There are at least two great php resources on the internet, PHP.net and PHP Builder. I highly recommend both of those.

For books, I've used PHP Bible, but it left a lot to be desired. You might also try Beginning PHP4 which is supposed to be quite good.

You might also try the following:

PHP and MySQL Web Developmentand
PHP Developer's Cookbook

Hope this helps.</STRONG>

Ok, well I am trying to install this package called thatware, maybe you can check it out at atthat.com and well, I am having trouble with it maybe you could try to install it and maybe help me out, cause I already tried and have been partially succesfull.

Thanks,
--Guillermo

[theolein]

Guillermo it'd be better if you started from scratch I think. Also it would be better if you posted these questions under OSX-Developer or Web-developer.

To get mysql knowledge , once you have got it up and running, get yourself a book or go to mysql.com and work your way through the tutorial.

The link to phpbuilder.com is a good one and probably it would be better to post php specific questions there. Also , I don't mean to sound like a prick, but have you asked the people at atthat.com for help or read the faq?

[ 06-16-2001: Message edited by: theolein ]

[dawho9]

Another place to checkout is:
www.stepwise.com

They have directions on compling and installing both an updated version of Apache and PHP.

dw9

[parallax]

Moving over to Web Developer!

[torifile]

I've found that the article at webmonkey can't be beat. You should check it out. I've looked at others but that article has been the most helpful for me. And if you've got mysql installed, php shouldn't be a problem.

[Raman]

I've found that often the included documentation and "readme" files are a very good source. There's a good "MySQL for Dummies" file in the MySQL distribution that walks you through making your first database and issuing select statments, etc.. to it..