PHP + MySQL System

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
nasr
Forum Newbie
Posts: 13
Joined: Wed Jun 25, 2003 9:29 pm
Location: Cali

PHP + MySQL System

Post by nasr »

Good [insert time of day] to you.

Well, I want to set up a PHP and MySQL system to play with at my house. What are the latest and best programs to use.

Should I use Apache? IIS? a *nix system or a windows OS. What other programs you would recommend. Free preffered. Such as editing programs and the like, also if any tutorial sites.

thnx
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Re: PHP + MySQL System

Post by infolock »

nasr wrote:Good [insert time of day] to you.

Well, I want to set up a PHP and MySQL system to play with at my house. What are the latest and best programs to use.

Should I use Apache? IIS? a *nix system or a windows OS. What other programs you would recommend. Free preffered. Such as editing programs and the like, also if any tutorial sites.

<span style='color:blue' title='courtesy of method_man'>thanks</span>
As far as the OS goes, it's all according to what you are most comfortable with. Most people are windows users, and thus windows is a very good choice to start out with.

By web server means, again it's according to what you are comfortable with. If you don't have IIS installed, or you don't know how to use IIS, then just download apache and run it. It's free and very simple to install. There are all KINDS of howto's on installing/setting it up.

As far as what programs to suggest, phpmyadmin is a very good choice to start out with. It's the best web-based interface for mysql administration and can actually guide you into becoming more familiar with MySQL in general. However, I'd suggest you begin by learning MySQL via the command line first and then move on to the gui.

Tutorials are a dime a dozen. You can search google for PHP Tutorial, PHP <subject here> Tutorial, MySQL Tutorial, or any other combination (PHP MySQL Development) and you'll find thousands.

Best thing to do is read php.net's online manual though for a starting point. Once you get that starting point, the only thing left is for you to start coding and trying things out. When you run into a problem, research it! Then, if you still are having problems, post it here and one of us will be glad to help you out.

Good luck and hope this helps.
nasr
Forum Newbie
Posts: 13
Joined: Wed Jun 25, 2003 9:29 pm
Location: Cali

Post by nasr »

Thank you very much. I will do that. And hopefully learn something. Again thank you.

This is what I am going to install.

OS = Windows XP
Server = Apache
Database = MySQL
and Myphpadmin

thank you.
Sphen001
Forum Contributor
Posts: 107
Joined: Thu Mar 10, 2005 12:24 pm
Location: Land of the Beaver

Post by Sphen001 »

nasr wrote:Thank you very much. I will do that. And hopefully learn something. Again thank you.

This is what I am going to install.

OS = Windows XP
Server = Apache
Database = MySQL
and Myphpadmin

thank you.
Don't forget the PHP. There are two versions you can install: 4.3.11, and 5.0.4. PHP 4 is still in widespread use, but PHP 5 is gaining momentum. They are very similar, but have slight differences. Personally, I would go with PHP 5.

Hope this helps :D

Sphen001
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

On my development machine:

WinXP Pro:
Apache2.0.54
PHP5.0.4
MySQL4.1

Currently i'm thinking about downgrading to php4 and mysql3.23 again, because most hosts where my code is deployed seems to be running those versions..
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

Try Xampp: http://www.apachefriends.org/en/xampp-windows.html

Comes in all flavours and saves you a lot of hassle if you just want something to play with.

McGruff's Starter Pack might also come in handy: viewtopic.php?t=21400
User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

Post by neophyte »

Xampp looks great! I was going to suggest easyphp...

http://www.easyphp.org/telechargements.php3

I don't think they are running PHP 5.0.
Corvin Gröning
Forum Newbie
Posts: 16
Joined: Tue May 03, 2005 1:02 pm

Post by Corvin Gröning »

But a big drawback of apachefriend's XAMPP is that is contains a lot of scripts and applications (for example Perl) which you mostly never need.
Bacause this I build my own lamp (Linux + Apache + MySQL + PHP). I only installed scripts and applications which I really need.
This isn't very heavy and there are lots of tutorials about on the internet. So I recommend everyone to go this way.
Post Reply