MySQL & PHP on Windows?

[Pauly]

I've seen this done before, but I honestly can't remember how. What I'm looking to do, is install MySQL & PHP on my laptop, which is running 'Windows Home'. I have an ongoing project that needs more commitment than I'm giving it, and since my connection to the net is always 'promised', I need to work on it offline too.

Where do I start? Maybe I'll need Apache in too? Help me please!

[rich w]

http://www.apachefriends.org/en/xampp.html

[Jamie]

See my posts in this thread, Pauly. http://www.iwdn.net/showthread.php?t=4003

[jos]

XAMPP rulez!8)

[Dan]

I use WAMP5. It works, but Apache seems to crash a lot.

You also have to remember that it doesn't install things like sendmail/qmail. I forgot a few times and wondered why I couldn't send any mail() :)

[BigBison]

http://www.appservnetwork.com/

Stick with the version 4 apps running on Apache 1, IMHO.

[Pauly]

Thanks guys :)

[Pauly]

After fiddling about for a bit, I finally got one :D

[Jamie]

Which one did you use, Pauly?

[Gerrit]

Old thread, I know..

Any of you guys using the package specially made for windows by Firepages (http://www.firepages.com.au/)?

I have it installed here and it works like a charm - installation is really easy.

[froggy]

That's phpDev423, right, Gerrit?

I feel stupid for asking this, but where the frig do you install this thing (is the default c:/phpdev okay?) and then how do you get it running? I thought I'd downloaded and installed it, but when I ran it (started the Apache server) it took me to http://localhost and requested a username and password... I haven't been able to find anything that tells me what the username/pass should be and leaving them blank brought up an error.

I'm only installing this dang thing so I can use php includes on my page and have them work in my production environment (my laptop running WinXP Pro).

[Gerrit]

Yes, it's phpdev 4.23
I installed it 'outof the box' in the default dir. When I start the batch file (C:\phpdev\2K-NT-XP-phpdev_start.bat), it will start Apache, PHP and MySQL, open a tab in Firefox (my default browser) and the contents of the www folder (under phpdev) is shown.
No password or username is asked at all.

[Jamie]

PHPDev is a great piece of kit. :)

(is the default c:/phpdev okay?)

Yep. That's where I have mine installed

how do you get it running?

Go in to the PHPDev folder at "c:/phpdev". You should see an MS-DOS Batch File called "2K-NT-XP-phpdev_start". Double click that. Double clicking that will enable http://localhost

To change which folder http://localhost points to, you'll need to edit the Apache config file. I change this folder each time I'm working on a new clients site. Here is what you do:

Go to "C:\phpdev\Apache\conf"
Open "httpd.conf" in a text editor
Use your text editors search function to find the term "DocumentRoot"
A few lines down, you will see this: "DocumentRoot "C:\My\Default\Document\Root\Directory"" (The directory will be different, of course). You need to change that to the directory that you want http://localhost to point to.
Scroll down about 25 lines, and you should see this:

# This should be changed to whatever you set DocumentRoot to.
#
<Directory "C:\My\Default\Document\Root\Directory">

You need to change that to the same directory that you just changed the document root setting to.

Once you've changed those two settings, save the file, and start up PHPDev. (It's probably best to make any changes to that file with PHPDev closed)

[Gerrit]

snip...
You need to change that to the same directory that you just changed the document root setting to. ..snip


That's one way to do it.. I have a folder - called websites - under the www folder. In there all 'my websites' are stored, in the same file structure as they are online.

[froggy]

Okay... I'm not a total idiot.... I've tried both of those things. I've installed to the default, I've installed to c:/inetpub, I've installed to default and changed the root directory and the first time I ran it it asked for a username and password and then gives me this page:

error '8002801c'

Error accessing the OLE registry.

/iisHelp/common/500-100.asp, line 17

Now it just gives me that page and doesn't ask for username and password.

[Gerrit]

Hmm.. were you logged in with admiistrator rights when you installed phpdev? If not, delete the whole package, log in with admin rights and reinstall.

[froggy]

Yeah, I was/am logged in as the computer administrator with full rights and privileges thereof. :)

I've tried changing the php.ini file so the globals are On, I've tried changing the httpd.conf file so the server is my laptop's ip.

:? I'm stumped.

[Gerrit]

:? I'm stumped.

Same here.. When I installed it I didn't change a thing. I just installed it, started the batch file and it worked as advertized.

[froggy]

WTF?!?!

So frustrated as h-e-double-hockey-sticks I shut down my laptop last night and went home. This morning, I start her up and for giggles try it out and even though I got this message:

[Wed Feb 21 08:30:23 2007] [warn] pid file c:/phpdev/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
Apache/1.3.27 (Win32) PHP/4.2.3 running...

It appears to be running fine now.....

:?

[Gerrit]

Good to hear it's running fine :)
I still don't have a clue what went wrong..

[Jamie]

I've had problems with locahost directing to my old directory if I didn't shut down Apache properly. Maybe when you tried changing the root in the Apache config file it didn't register it properly because Apache wasn't disabled.

I dunno... I'm just guessing. :)

[froggy]

Aside from now being able to locally test any php code I might include on my pages (I'm not 100% sold on that just yet), one of the neatest things I came across in this software was the forum software.

Is this something I can upload to my website and customize to fit the feel of my site (if so, how)? Or is this just meant as an example of what php can do?

I hadn't really considered putting a forum onto our site, but if the capability is there, it might add something to our site that my boss would be pretty interested in.

[Gerrit]

The forum software included in the phpdev package is Invision Powerboard. It's one of the many free forum packages available.
Other popular free packges are Phpbb, SMF, punBB.

If you have the $$ to buy a license you could check out vBulletin (the software used on this forum).

Your host needs to have PHP and MySQL installed to run a forum.

<edit>All forum packages are customizable to reflect the look and feel of your site</edit>

[BigBison]

error '8002801c'

Error accessing the OLE registry.

/iisHelp/common/500-100.asp, line 17

This is an IIS error, not an Apache error. Those two webservers will get along fine unless they're both fighting for port 80 -- and it looks to me like that's exactly what they're doing. Either run Apache on another port, or disable IIS to avoid all sorts of oddball M$ errors.