Glad I could be of assistance. I had a hard time getting the hang of MySQL, so I downloaded phpMyAdmin (www.phpmyadmin.net), set it up, and watched the SQL commands fly.
Try this: mysql -u <user> -p <return> (it should ask you for a password) Here's a grand question: What do you want to do with PHP? Interactive forms? Interactive content? Website counter? etc... As far as tools that make PHP, I know of one that will do some PHP for you. Dreamweaver MX. I haven't used it myself, but it looks pretty slick. I prefer to do my PHP manually (text editor all the way). I tried ActiveState's Komodo for a while ($30 personal license, $300 commercial or so) but it's not as slick and clean as a plain jane text editor. I'm sure there are other tools that will assist you with PHP. The great thing about PHP is that it integrates flawlessly with existing HTML. Just put the PHP tags in an html file (rename it .php if that's the only server mapping for PHP) and it will be parsed right among the HTML. There are also lots of resources on the web like phpbuilder.com and a few others. Check the links page on php.net. And if you've got the funds, get a good book. Just be careful that PHP 4.2.x and beyond have a new way of accessing variables (see http://www.php.net/manual/en/security.registerglobals.php for more info) with register_globals turned off. And above all, have fun! -Dash Hard work may not kill you, but why take chances? On Wed, 20 Nov 2002, Joe Finlinson wrote: > Thank you for your help... by some miracle and with your advice things seem > to be working ok. However, I am having a heck of a time figuring out how > mysql works into the whole thing. I was trying to follow a tutorial that > came with dreamweaver, and it just gets me all confused. I setup a user and > password but at the command prompt I can't manage to log in. How do you do > the sql stuff? Also, once all this is going how would I go about actually > installing a php script into my webpage... or better yet... what kinds of > tools are out there to help me write php? > > > > > > "Dash McElroy" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Alright, I'll take the bait. > > > > 1. If you've got IIS installed, why are you trying to install Apache? > > Choose one or the other. > > > > 2. Configuration for either server should be drop dead easy. The PHP > > installer exe file should configure IIS (I don't use IIS, fortunately), > > and the zip file contains what you should use for Apache. Put it in c:\php > > (or wherever...). Apache config is easy for a localhost install. You'll > > have to change a few lines and add a few. > > > > a. For an Apache server without a DNS entry, change the following line to > > reference your IP: > > > > ServerName xxx.xxx.xxx.xxx > > > > b. Add these lines for PHP > > > > LoadModule c:/php/sapi/php4apache.dll > > AddType application/x-httpd-php .php > > > > c. Change this line if you want index.php to be a valid initial page: > > > > DirectoryIndex index.html > > > > to > > > > DirectoryIndex index.php index.html > > > > d. Restart Apache. > > > > 3. Get MySQL from MySQL.com and install it where you want. MySQL should be > > the easiest thing to install of the three. Set up a user and a password > > for PHP. I initially learned MySQL (scratch that - still learning) using > > the root user (very dangerous) until got a grasp of it's permissions. > > Definitely don't do that for code that others will use. > > > > Good luck! > > > > -Dash > > > > Immortality -- a fate worse than death. > > -- Edgar A. Shoaff > > > > On Wed, 20 Nov 2002, Joe Finlinson wrote: > > > > > I am using a machine running Windows XP pro... I managed to install IIS > just > > > fine. However, it seems that I am having major traumas getting PHP, > Apache, > > > and mysql to function. I have tried downloading some pre-configured > kits > > > from various sites with no luck. Can any of you suggest a place where I > can > > > download the software... and give me some advice on configuring it. > > > > > > Thanks in advance, > > > Joe > > > > > > > > > > > > -- > > > PHP Windows Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php