Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 03 Mar 2009, 03:30
Red Blaze's Avatar
Red Blaze Red Blaze is offline
 
Join Date: Jan 2003
Real name: Frank E.
PHP and MySQL issue

Ok, this is the first time I successfully installed Apache 2.2, PHP5, and MySQL 5 onto my computer for a developing environment so I don't have to upload constantly. Laptop to be more specific, Windows XP Home Edition.

It renders php very well, except for pages that have mysql involved. For instance, I have have page that has a config.php included at the very top with the following content.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

As I commented out line by line, I came to realize that $conn = mysql_connect is the culprit. I used This Website and followed everything as close as possible. Considering they were using MySQL 4, and not 5.

What I want to know is why won't it tell me an error. It just gives me a flat out blank page. Any ideas to lighten my way? x.x
Reply With Quote
  #2  
Old 03 Mar 2009, 04:35
TigerC10's Avatar
TigerC10 TigerC10 is offline
 
Join Date: Apr 2006
You probably haven't enabled the PHP extension for MySQL - or if you have, you might have set the extension directory improperly.

Check out this page:
http://www.php-mysql-tutorial.com/wi...and-mysql.aspx

And go to the "Modifying PHP Configuration File ( php.ini )" section.
__________________
~TigerC10~
Reply With Quote
  #3  
Old 03 Mar 2009, 05:35
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
Check the error_log file of your Apache installation. It should tell you the error. Additionally, you should enable error_reporting in PHP's configuration for debugging purposes.
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #4  
Old 03 Mar 2009, 17:45
Red Blaze's Avatar
Red Blaze Red Blaze is offline
 
Join Date: Jan 2003
Real name: Frank E.
Alrighty, I followed the link showed to me and I've got it set up right. Now I turned on my laptop today and I got this new little problem.

"httpd.exe: Could not reliably determine the server's fully qualified domain name, using ***.***.*.* for ServerName"

And now, when I got to a page that has a mysql connect involved, Apache2 crashes.

I recently got this error today just as I started my laptop. This wasn't showing last night.

========================

Maybe it'll help if I post where Apache, PHP and MySQL are installed in.

Apache: C:\Server\Apache 2
PHP C:\php
MySQL C:\Server\mysql

in php.ini, which is in Apache 2 directory, I have two edits:
extension_dir = C:\php\ext\
and
extension=php_mysql.dll <- just uncommented

And this is the "Error Signature" I get when Apache crashes:
szAppName : httpd.exe szAppVer : 2.2.11.0 szModName : php5ts.dll
szModVer : 5.2.9.9 offset : 0000ac7a

Last edited by Red Blaze; 03 Mar 2009 at 18:33.
Reply With Quote
  #5  
Old 04 Mar 2009, 00:15
TigerC10's Avatar
TigerC10 TigerC10 is offline
 
Join Date: Apr 2006
Sounds like you don't have your httpd.conf file set up properly.

http://httpd.apache.org/docs/1.3/windows.html#use

Check your ServerName variable and make sure it's set to "localhost" or "127.0.0.1" or even your machine's IP address. That's the URL you'll be using to access your test site (http://localhost/ etc.) in your browser. Do not set this your your actual domain name, as your domain name most likely does not point to this test environment.
__________________
~TigerC10~
Reply With Quote
  #6  
Old 04 Mar 2009, 04:18
vbplusme's Avatar
vbplusme vbplusme is offline
 
Join Date: Sep 2008
Real name: Michael
ServerName localhost:80

its commented out by default...
__________________
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 13:23.

Layout Options | Width: Wide Color: