APACHE, POSTGRESQL, PHP configuration... ON WINDOWS

[oceanebelle]

Help I need to make a working environment

technologies are the following:
APACHE 2
POSTGRESQL 7.4.7
PHP 4.3.10
FEDORA CORE 2

I have to convert existing ASP code into PHP and I would like to do development in Windows first...

any ideas?

[john tindell]

Well PHP and Apache2 are avalible on windows, VisualAd wrote a nice tutorial on who to install and set them up, he also included MySQl but im not sure how similar that is to PostGreSQL.

[EDIT]
Heres the link
http://www.vbforums.com/showthread.php?t=330825

[john tindell]

Turns out that PostgreSQL is avalible on Windows, and there was me thinking it wasn't, Im afraid that i don't know how to install it or anything but heres some links that should help

http://www.postgresql.org/ftp/binary/v8.0.3/win32/
http://www.databasejournal.com/featu...le.php/3064861

[oceanebelle]

Hmmm... I guess version 8 would have to do... the japanese is quite specific and the system is to be run on Fedora Core.. but original code is from ASP so I need to develop on windows.

I have been researching on cygwin... running the right version of Postgresql there but there's too much to download. It's not working at all. *sigh*

[CornedBee]

MySQL is very similar to PostgreSQL in syntax, but PostgreSQL has more features. (MySQL 5 is very close to PGSQL in features, but it's not very stable yet.)
MySQL is easy to install in Windows. So if you use PEAR:B for your database access, you could develop it with MySQL first, assuming you don't use any of these features: Stored procedures, views, triggers, foreign keys or cursors.

[oceanebelle]

The part I'm going to develop are Master Screens so I guess that part is still fine... I havn't seen the code yet though. I guess I have to start that already.

[visualAd]

I believe there is an ASP module for Apache, but it is not stable. What problems are you having with PostgreSQL?

[oceanebelle]

I'm still with PHP 4 configuration. I decided to use Postgre 8 so I guess I'll tackle with it when I'm done with PHP 4.

Aren't 4 and 5 a little bit the same on configuration?
Somehow, the files cannot be parsed by the PHP engine even the Html part.

[CornedBee]

What do you mean, cannot?

[oceanebelle]

well, I made a default.html and in the body "hello php" file placed it in the htdocs and accessed it with

http://localhost/default.html

shouldn't the browser show the text "hello php"? Right now it shows the text with all the html tags and the "hello php" text

[visualAd]

It needs to be a file with a .php extension. You also need to ensure you have the correct Apache configuation, to allow files with a .php extension to be sent through the PHP interpreter.

[oceanebelle]

I also have the .php file but even that one is not parsed.

I didn't follow your tutorial since it's 5.. I needed the one for the 4 and I found it on PHP.net ... , I think I followed every instruction too.

edit: Oh, followed instructions but still won't work

[CornedBee]

Are you sure PHP is installed? And enabled in the Apache config?

[oceanebelle]

I'm sooooo embarrassed , The installation was ok already.. I wasted all this time to nothing... sorry VisualAd, cornedBee, I should have checked the files IN NOTEPAD,... my using dreamweaver was the prob... the code that i thought will be the code, is actually the content so I thought it was not parsed.

Sorry I caused you all this trouble, but installation for PHP and APACHE is already okey. I should have known better , I didn't pay attention to the teeny tiny detail of where I was placing the test code. ..*sigh*

Again sorry everyone

[oceanebelle]

Shows what a bad NOOB I am, I should be banned... (but please don't, I still have a lot to learn )

[visualAd]

What was the problem?

[oceanebelle]

I mistook the content as the source. so I thought APACHE was not parsing the files correctly.

[oceanebelle]

, I am in POstgresql part of the installation... and I have installed POStGresql already and I have configured the PHP.ini (uncomment the extension)... but whenever I execute pg_connect, an error message that says ...

Call to undefined function: pg_connect() in G:\MACRO\HTDocs\DBConn.php on line 2

what could possibly be wrong with my settings again?

[oceanebelle]

*sigh* NVM, when I got back from lunch the function worked already. I don't know what happened but hey as long as the environment for windows is now ok... I guess its fine.

[oceanebelle]

I guess I do now... the cache was not cleared.