Member Avatar for Barabus

First of - I'm almost a newbie. I messed around a bit with PHP 4 for a while until things got scary and they switched Globals on in 4.2 - where I had to then re-write my scripts all over again. It seems that with every upgrade you need to become more and more like a Nuclear Pysicist or Rocket Scientist to figure out what's going on with PHP.

I spent the entire day yesterday trying to install PHO 5 and Myql 5. I thought I had it licked until I installed phpMyAdmin and to my horror could not access MySql Server.

I got a #2003 error and by googling, that's how I discovered this site. However the suggestions here dod not right the problem. I think somewhere along the way I did something that got rid of this message but then got another one took its place. After hours of moving .dll files here and there, re-writing configuration scripts (without making a jot of difference) I decided 'enough was enough'.

Eventually I discovered that PHP apparently does not support MySQL. To me that's amazing. I thought the whole appeal of PHP was its ability to connect with MySQL. I then read what others had experienced on other sites and in other threads and eventually decided to follow suit and revert as 14 hours of trying to configure this lot just was not worth the effort.

Has anybody out there got a step by step guide to installing the following ver 5 config so that it works seemlessly as in version 4?

mysql-5.0.15-win32/Php 5.0.05/phpMyAdmin 2.6.4-pl3 and on IIS 5.1

I haven't had any software installation annoy me as much as this one did in quite a while but if it's possible to have a set up that works as cleanly as ver 4 without all the messing around please can you provide details.

Thanking you in advance

  • 9 Contributors
  • 15 Replies
  • 338 Views
  • 4 Months Discussion Span
  • Latest Post Latest Post by martinkorner

Recommended Answers

All 15 Replies

Member Avatar for leelee

Eventually I discovered that PHP apparently does not support MySQL. To me that's amazing.

It is amazing. It's also not the case.

Mysql support isn't included by default in PHP5, but it most certainly does support it.

Take a look at the the PHP mySQL reference where it says:

MySQL is not enabled by default, nor is the MySQL library bundled with PHP.

Member Avatar for Gary King

Just download WAMP for Windows or LAMP for Linux. I'm unsure if those complete packages still exist, but give it a try. It downloads the entire set for you and you can install it as a bundle... I believe.

Member Avatar for chizy2

Apache2Triad is also a package deal..

http://apache2triad.net/

apache2triad 1.5.3 is out

changelog folows :

fixed phppgadmin htaccess bug
updated phpPgAdmin to 3.5.3
updated Apache to 2.0.54
updated Python to 2.3.5
updated PostgreSQL to 8.0.3
updated OpenSSL to 0.9.7g
removed eontech uebimiau theme
added support for python psp scripts
hidden the apache2triad user from the XP Welcome Screen
fixed nextcode link on all pages
updated libmcrypt.dll
added null input check for changedomain script
updated SlimFTPd to 3.17
updated PHPsFTPd to 0.5
updated AWS

If you are a novice - DO NOT USE THIS PACKAGE - you must know server config and how to tweak the config files, but is a great package.

Member Avatar for Lightninghawk

PHP5 does indeed support MySQL. That's one of the reasons I even pay any attention to wanting to learn it. I use a lot of phpbb boards. Most use MySQL databases. I just ordered a PHP5 book that came in today. Most of the book talks about using PHP5 with MySQL Databases.

Member Avatar for martinkorner

If you are a novice - DO NOT USE THIS PACKAGE - you must know server config and how to tweak the config files, but is a great package.

I've just started with PHP and want to be able to test my PHP scripts without having to put them on the internet first.
Is there something which requires virtually no setup and will let me use my PHP scripts?

Martin

Member Avatar for leelee

Hi Martin,

There are lots of ways around this. You can probably download one of a few lamp- or wamp-like standalone applications that will enable you to practice on your local machine. A quick google search will give you the answers.

You can even do quite snazzy things like load apache and mysql onto usb memory sticks and the like.

I use the uniform server simply because it's the first one I ever encountered and I stuck with it since. Magic.

Member Avatar for Esopo

There are changes in PHP5 but those changes are for the better. Rest assure that everything that gets moved around from version to version has been given careful consideration. PHP5 is a much stronger language than PHP4, just as PHP4 is much stronger than PHP3.

To test my sites at home/work I have been using Reactor Server (WAMP) for quite a while:. They have a PHP4.x + Apache 1.x package and a PHP5 + Apache 2 package:

http://www.reactorserver.com/

Downloads
Reactor 1.3 (PHP 5):
http://prdownloads.sourceforge.net/reactorsrv/Reactor1.3.exe?download

Reactor 1.2 (PHP 4):
http://prdownloads.sourceforge.net/reactorsrv/Reactor1.2.exe?download

Basically Reactor is one of the many All-in-one packages that are "good to go". Just download the 30+Mbs file and run for a pre-setup fully working server. I would advise that anybody using this spends a couple of hours reading about PHP & Apache setup, just so that they can know the kind of things that get tweaked (such as globals).

Member Avatar for martinkorner

I've Installed WAMP and there's a picture of a dial at the bottom right of my screen, but it says "None of 2 services are running" - if I right click in the only options are: About... , Help File and Exit.

Can anyone help???

Martin

Member Avatar for leelee

Is the dial a problem?
Is the WAMP installation working (and which did you go for)?
What does it say in the "about" section?
What does it say in the "help file" section?
What happens when you exit?

Member Avatar for LuuLamHong

Hi!
I've been trying to install Apache 1.3 and PHP on Windows XP.
http://127.0.0.1 works, but http://localhost doesn't work. My hosts file
contains a pointer to localhost. My http.conf file contains ServerName
localhost

When I try to access http://localhost my browser redirects to a server
page.

Any pointers on how to debug this? I do have some 'server'-like apps
installed (p2p, ...).

Thanks!

Member Avatar for martinkorner

Is the dial a problem?
Is the WAMP installation working (and which did you go for)?
What does it say in the "about" section?
What does it say in the "help file" section?
What happens when you exit?

The dial's not a problem, but it says it's not working.
I went for "wamp5_1.6.1"
about says:

WAMP5 Version 1.6.1
Created by Roms (Romain Bourdon)
Sources are available at SourceForge
http://www.wampserver.com

help file says stuff about installing, un-installing etc.

When I click exit, it removes the dial from the taskbar.

Member Avatar for Troy

I've just started with PHP and want to be able to test my PHP scripts without having to put them on the internet first.
Is there something which requires virtually no setup and will let me use my PHP scripts?

Check out my WAMP HOWTO at http://www.troywolf.com/articles/wamp_howto.htm. It's a bit dated now--not the very latest versions of everything, but I'm sure with a few head scratches you can use my HOWTO to get your local workstation turned into an Apache, MySql, PHP, phpMyAdmin server.

Member Avatar for martinkorner

Great guide, but i'm really stuck at finding the download!

Can you give me a direct link to one please because all the one's I try come up with a page of folders and files and I can't find the download anywhere in them. :-|

Martin

Member Avatar for Troy

Can you give me a direct link to one please because all the one's I try come up with a page of folders and files and I can't find the download anywhere in them.

My guide does provide exact download links as well as explanatory text about which files to download.

You say "direct link to one". One what? If you are looking for a single download file that you simply double-click and it installs a working PHP-processing webserver, that ain't what my guide is, and that is not what you are going to find. There are a couple projects out there that attempt to make the full WAMP solution a single install, but they all have their problems.

Understand that the acronym WAMP stands for 4 seperate products--each of which require their own installation and configuration. (Windows, Apache, MySql, PHP) "WAMP" is not a single product or program you install. (Perhaps you are already aware of this--I don't know.) Of course "LAMP" is Linux, Apache, MySql, and PHP. My HOWTO explains a WAMP setup because #1, most newbs and many professionals do their dev work on Windows--so that's where the need is to setup a simple test webserver. #2, if you are working with Linux, you probably don't need my help setting these things up--you have already been baptized by the fire of Linux configuration nightmares! :) (PS: I love linux, and it's my server OS of choice, but I have to admit that every new thing I've done on Linux was a major frustrating headache. :))

If you simply need a webserver to test some PHP code locally---and you do not need a database such as MySQL, then only do the first 2 steps of my HOWTO--which explain installing and configuring both Apache (webserver) and PHP (programming language).

Member Avatar for martinkorner

Sorry I've not got back to you for so lony (DANIWEB didn't e-mail me to tell me I had a replyhttp://www.daniweb.com/techtalkforums/newreply.php?do=newreply&noquote=1&p=170163#
Roll Eyes (Sarcastic))

When I said "one" I meant one exact link to the download (I got a list of hundreds and wasn't sure what was what) - Sorry I wasn't too precise :o .

Anyway I think I've downloaded it now + I'm gonna go back to your tutorial and see if I can get any further...

Thanks
Martin

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.