insallation mysql, apache on win98 machi

Anon

hi there!
right now I have to use apache, mysql and win98 - this is my only chance to test some packages like phpnuke.
and here is my problem:
the mysql server is up and running and shows me a connection in the admin tool.
the apache is up and running (php is installed correctly - tested without a database).
when I open phpnuke´s admin or index the server is working, but when he´s finished I get a blank white screen. that means no error message or nuke screen appears!

does anyone knows what I am doing wrong?
Please help me!
thanx
grupie

ayzee01

I think the first thing that I would do is to physically check that mysql is talking to apache and php ok.

Create a test database in mysql and then create a small file that tests the database connection and pulls back some data. Then you'll know for a fact if its working or not.

If you need any help with the code, let me know.

Leon.

Anon

hi!
First thanks a lot for your help!
I did what you said: I wrote a script to connet to a little db (I have the code and the database creation file from the book "Galileo Computing / <openbook> / PHP 4" (www.galileocomputing.de)

I tried from the starting page of apache to connect to mysql througt PHPmyAdmin (installed through the setup programm) but the same.

both times I got the following error message:
Fatal error: Maximum execution time of 30 seconds exceeded in c:\apache\htdocs\xaver\uf02.php on line 9 (line 9 is "$db = mysql_connect();" ) and
Fatal error: Maximum execution time of 30 seconds exceeded in lib.inc.php on line 255

Then I connected to mysql with "mysqlFront" and there it worked. I can see everything and can manipulate all through this tool.

Is there anything at this moment that I did wrong?
Looking forward in receiving your answer
thany again
grupie

the test script:

<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<?php
$db = mysql_connect();
$res = mysql_db_query("firma",
"select * from personen");
$num = mysql_num_rows($res);
echo "$num Datensätze gefunden<br>";

for ($i=0; $i<$num; $i++) 
{ 
	$nn = mysql_result($res, $i, "name"); 
	$vn = mysql_result($res, $i, "vorname"); 
	$pn = mysql_result($res, $i, "personalnummer"); 
	$ge = mysql_result($res, $i, "gehalt"); 
	$gt = mysql_result($res, $i, "geburtstag"); 
	echo "$nn, $vn, $pn, $ge, $gt <br>"; 
} 
mysql_close($db);

?>
</body>

ayzee01

/*
Hi,

Youre installation of apache, php and mysql seems fine because you are able to execute php scripts and connect to mysql databases using mysqlfront.

So try this and let me know what happens.

Cheers,

Leon

Usually, you connect to the server by at least giving a server name and a user name.

an example would be:
$obj_conn = mysql_connect("localhost","root","password");

You would use the above line to connect to your local machine. Make sure to change password to the one you setup.

anyway,

try this...
*/

//--------------This is the connection bit

$obj_Conn = mysql_connect("replace with hostname", "replace with username", "replace with password") //connection object
or die("Could not connect to host"); //error handler

//-------------This is the query bit

$obj_RS = mysql_db_query("firma", "select * from personen")//recordset object
or die("Error whilst performing query"); //error handler

//------------This is the display results bit

while ($rows = mysql_fetch_array($obj_RS))
{
echo $rows["name"].", ";
echo $rows["vorname"].", ";
echo $rows["personalnummer"].", ";
echo $rows["gehalt"].", ";
echo $rows["geburtstag"]."<br>";
}

//-----------Free the result

mysql_free_result();

Anon

hi Leon!
I tried it and the result is following error message:

Fatal error: Maximum execution time of 30 seconds exceeded in c:\programme\apache group\apache\htdocs\test_phpmysql.php on line 4

Maybe I found something; at least it sounds for me tricky:
I am connecting with the mysqlfront with (localhost; root; ""; Port:3306; Timeout: 30) and the connection works. But when I take a look at WinMySqlAdmin and there to the my.ini Setup the user is defined with "gerhard" and the password with "xaver"!, but the GUI also works!!

Maybe here is the mistake, isn´t it.
thanks again
grupie