mySQL and XP

[phpNoob]

Hi every one I hope I get the same great help as always.

I am trying to leaarn php and have a book to help me called "php in easy steps". In this book it suggest using the most up to versions of apache, mySQL and php but only gives installation instructions for apache 1.3.32 (of which I have installed apache 2 but cant get to appear in my browser)(it is however showing active in background services), Also mySQL is shown as ver. 3.32.49 but I installed 4.0.14b (in the book it says to configure mySQL change file c:\mysql\my-example.cnf)(howecer I cant find this file in the newer ver.) I havent got to installing the php yet as I cannot even get apache and mySQL working.

If its needed I have 2.6ghzP4, 1gb Ram, CDrw, Laptop. I am also using XP home (32bit) and have zone alarm installed (I have added 127.0.0.1 and localhost to my safe zone)

 

[snowboardr]

In all honesty I personaly would stay with MySQL version 3.23.51 and if you need help setting up MySQL I would check this out:

http://www.vzio.com/tutorials/mysql_database.asp

As far as Apache goes, I had a little trouble installing it on Windows XP a while ago, but I just upgraded to windows 2k3 server ent. and it was slightly difficult, but I got it going, I usually Run IIS though because I do more ASP then PHP, php i run on Apache.

I wish I could help you more as far as apache goes though, I really couldn't tell you what the problem is because I don't use it that often.

- Jason

 

[csniffer]

u say that Apache is not in browser, it shouldnt be. with MySql u dont need to move anything i dont think, if i remember right, just unzip and install, just be aware that it wont show in the start> programs menu. any more probs just ask

To err is human, to completely mess up takes a computer.

 

[cabernet]

I use both XP and RedHat for a real good test bed
however I have a little tutorial and D-load that works fine in 98 and XP
here is the link to:

http://www.lurkhere.com/apache768.html

cheers

 

[rzs0502]

Does your httpd.conf (in your bin dir of Apache) have an entry like the one below? Apache needs to be stopped and restarted.

Also, are you writing your script from within your Apache directory? You have to put your scripts in there and then execute ie.

http://localhost/test.php

You cannot open test.php alone.

ScriptAlias /php/ "c:/php/"
AddType application/x-httpd-php .php
Action application/x-httpd-php "/php/php.exe"

I also suggest downloading MySQL v 4.0.15 (latest stable release)

 

[phpNoob]

Hi everyone,

Thanks for all the great suggestions, I have now got Apache 2, My SQL and PHP working.

I am putting my php files in c:/apache/htdocs and then viewing them in the browser http:/localhost/example.php and have changed the apache httpd.conf file.

I restarted apache and the test

http://127.0.0.1

worked!
also test

http://localhost

worked too bringing up the apache page.

To test mySQL I put in the $connection = mysql_connect string from the PHP book and it worked

Also the <?php phpinfo(); ?> (saved in apache/htdocs) brought up the php info

I am now just learning variables, arguments, boolean values, statements etc etc. So if any one has any tutorial sites that they think will be usefull I'd apreciate also if anyone feels they have the time and patience to help a HNC student learn this wonderful language I'd love to have a few tekkie friends to call on in my times of need!

Thank you all and thank you TEK TIPS !!! This site rules!!!

I am thinking of writing a newbie guide in laymen terms for the new new newbies of the world!(as it took me nearly 2 weeks to get going)

&quot;Also if anyones interested I had BSoD the other day (I am running Apache 2, MySQL 3.32.51, php. Windows XP (specs above)and ZONE ALARM. So it seems the Apache/WinXP/ZA issue deeply discussed on the apache site IS NOT OVER!!! But since then no problems so maybe it was a one-off?&quot;

Also if any one can suggest any good sites for php snippets and/or code, php and html, php and mySQL, (or how I get the local sites onto a server (i.e.

http://www.oneandone.com)).

Also ne1 know a good search engine register or other ways of site ads. Thanx

 

[csniffer]

try this faq that is titled &quot;where can i find tutorials on php&quot;

faq434-4165


To err is human, to completely mess up takes a computer.