Connecting to MySQL. Blank Screen :( - Webmaster Forums UK SEO SEM Webmaster Community Forum

#1 (**permalink**) 04-06-2005, 12:18 PM

I'm haveing some problems installin PHP and MySQL on PWS.
I have instaled PHP and that seems to be working fine (i checkd it with phpinfo() ) but when I run a file to test MySQL I get a blanck screen.

First I tried this:

PHP Code:
<?php
mysql_connect('localhost','USERNAME','PASSWORD');
mysql_select_db('test');

echo 'unless you see any error messages, everything should be fine';
?>

I then went to the mysql and php for dummies website and tried this;
PHP Code:
<html>
<head><title>Test MySQL</title></head>
<body>

<?php
$host="localhost";
$user="USERNAME";
$password="PASSWORD";

mysql_connect($host,$user,$password);
$sql="show status";
$result = mysql_query($sql);
if ($result == 0)
echo "<b>Error " . mysql_errno() . ": "
. mysql_error() . "</b>";
else
{
?>

<table border="1">
<tr><td><b>Variable_name</b></td><td><b>Value</b>
</td></tr>
<?php
for ($i = 0; $i < mysql_num_rows($result); $i++) {
echo "<TR>";
$row_array = mysql_fetch_row($result);
for ($j = 0; $j < mysql_num_fields($result); $j++)
{
echo "<TD>" . $row_array[$j] . "</td>";
}
echo "</tr>";
}
?>
</table>
<?php } ?>
</body></html>

I am using MySQL 4, PHP 5 and Personal Web Server on Win98

Any help would be greatly apprieciated, thank you.

#2 (**permalink**) 04-06-2005, 05:20 PM

Hi,

Please make sure that the MySql is started and if the username and password what you use is okay.

Also when you run the test and see the blank page, on the browser window please right mouse click and click to "View Source". On the opened source code please check if you see php/mysql code, if yes the php or the http server not working okay.

Booth code what you tried to use is okay.

Fir the first code you need to get the result:

"unless you see any error messages, everything should be fine"

For the second:

Variable_nameValue Aborted_clients2Aborted_connects1Bytes_received426 Bytes_sent1304890Com_admin_commands0 ...
..
.

Misi

crowebird · #3 (**permalink**) 04-06-2005, 05:50 PM

when I do my connect and querys I write it like this

$DBhost = "";
$DBuser = "";
$DBpass = "";
$DBname01 = "";
$table01 = "";

$DBconnect = @mysql_connect($DBhost,$DBuser,$DBpass);
$DBselecDB = @mysql_select_db($DBname01, $DBconnect);
$sql = "SELECT * FROM $table01 ... ";
$result = @mysql_query($sql, $DBconnect);

#4 (**permalink**) 04-06-2005, 06:39 PM

Whoa you loat do it really long, normally i just put

<?php
mysql_connect("localhost","username","password");
mysql_select_db("db_name");
?>

Just a bit shorter than the way you do it

#5 (**permalink**) 04-06-2005, 06:42 PM

Quote:

Originally Posted by seb_

PHP Code:
<?php
mysql_connect('localhost','USERNAME','PASSWORD');
mysql_select_db('test');

echo 'unless you see any error messages, everything should be fine';
?>

Oh btw with that ^^ You will not get any errors appearing, to get it to show the error you would have to add

mysql_connect('localhost','USERNAME','PASSWORD') or die ('There was a error, ' . mysql_error());

#6 (**permalink**) 04-06-2005, 08:03 PM

Hey,
Thanks for the replys! The source code only shows HTML as the server is fine and so is the PHP. PHPinfo isnt showing the MySQL module so I havent installed it right does any know where I can get a step by step guide to doing this as looking through the net has really confused me.
I have removed everything including my server and am going to reinstall tomorrow so i'm all fresh again. I might jus give up and download XAMP or TRIAD or summin but I really dnt wanna.