[RESOLVED] PHP Session Help (with Apache)

Kerant

Hey everyone.

I have just installed PHP and Apache on my new laptop with Windows Vista.

When I try to load a site I've been working on I am experiencing problems. Normal pages will load without problems, but any pages with session data on dont seem to load, and I am faced with a blank screen.

Is there any reason why this might be happening? Could sessions be disabled on PHP or Apache or something?

Thanks for any help.

Kieron

j_70

Have you looked in your Apache log? This will very likely tell you what is wrong.

Kerant

[Tue Aug 26 13:37:52 2008] [error] [client 127.0.0.1] PHP Notice: A session had already been started - ignoring session_start() in C:\Apache\htdocs\latest\logout.php on line 2, referer: http://localhost/latest/

I am getting different errors but the most frequent is this.

I have tried removing session_start() and I have checked through all of my files and there are no duplicates of session_start() so I'm really not sure what the problem is.

j_70

Most likely you have a session_start() in one of you includes or you have it multiple times on a page. Either way the interpreter is just ignoring the second session_start directive, so it is likely that there is some other problem. Are there any other error messages in the Apache log?

Kerant

The other one I spotted was to do with something else.

[Tue Aug 26 11:58:13 2008] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined function mysql_query() in C:\Apache\htdocs\latest\news-result.php on line 14, referer: http://localhost/latest/news-archive.php

This leads me to believe that there is a problem with PHP rather than sessions specifically because any PHP queries I try to run seem to just product blank pages which is making me very confused.

Is there any reason PHP would not be working properly, or do you know of any ways to fix this? :S

Thanks a lot.

j_70

What is on this line?

PHP Fatal error: Call to undefined function mysql_query() in
C:\Apache\htdocs\latest\news-result.php on line 14

Do you have MySQL configured in php.ini?

Kerant

j_70;10883860 wrote:
What is on this line?

PHP Fatal error: Call to undefined function mysql_query() in
C:\Apache\htdocs\latest\news-result.php on line 14

Do you have MySQL configured in php.ini?

$result=mysql_query("SELECT * FROM newstbl
		WHERE date = '$date'");

I haven't configured MySQL specifically on the PHP.ini - is there anything specific I should do?

j_70

You need to have a few .dll's on your system and un-comment a few lines in php.ini. See:

http://us2.php.net/manual/en/mysql.installation.php

Kerant

Ok I need to revise my original question abit really.

Basically I have now realised that it is MySQL that is the error, not PHP.

PHP and MySQL are both installed fine, seperately. I cannot get them to work together.

I am using Windows Vista and it seems a lot of people have had similar problems and there seems to be no definite solution that I can find.

Is there anybody that knows the changes I have to make in order for PHP to recognise I have MySQL installed?

Thanks very much

EDIT - Sorted it myself. Found out that PHP 5 does not load the MySQL module automatically, so I had to run the installer again to make sure that the module was installed. - Thanks for the help.