CMS Made Simple Forums

aidank wrote: I am testing my Apache/PHP/MySQL installation by creating a file called testMysql.php, source code below

';
}
mysql_close();
?>

When I load the page((http://localhost:8080/test/testMysql.php), the page appears to be blank.

$connection = mysql_connect("localhost", "root", "******");
if (!$connection) {
    die("Could not connect: " . mysql_error());
}
echo "Connected successfully";


$database = mysql_select_db("cms");
$database = mysql_select_db("cms", $connection);
if (!$database) {
    die ("Can't use cms: " . mysql_error());
}
echo "DB Connected successfully";


$result = mysql_query("SELECT name FROM help_category", $connection);
if (!$result) {
    die("Invalid query: ". mysql_error() ."\n". "Whole query: $query");
}
if (mysql_num_rows($result) > 0) {
while($row = mysql_fetch_array($result, MYSQL_NUM)) {
echo $row[0] . '';
}
}
else echo "Empty result!";

aidank wrote: Hi Alby,

Thanks for the advice but I am still having problems here.

...............

Here is some of examples of the php test files I have been running on localhost:8080:

';
}
mysql_close();
?>

Any ideas on how I should resolve this issue would be greatly appreciated as I am a novice when it comes to DBs etc

aidank wrote: Yes I tried your code and I just get a complete blank page back. No error messages appear. When I place other pieces of normal test around your code, they are displayed so the file itself is been found and displayed by Apache, it just coming back blank.

ini_set('display_errors', true)
error_reporting(E_ALL);

$connection = mysql_connect("localhost", "root", "******");
if (!$connection) {
    die("Could not connect: " . mysql_error());
}
echo "Connected successfully";


$database = mysql_select_db("cms");
$database = mysql_select_db("cms", $connection);
if (!$database) {
    die ("Can't use cms: " . mysql_error());
}
echo "DB Connected successfully";


$result = mysql_query("SELECT name FROM help_category", $connection);
if (!$result) {
    die("Invalid query: ". mysql_error() ."<br>\n". "Whole query: $query");
}
if (mysql_num_rows($result) > 0) {
   while($row = mysql_fetch_array($result, MYSQL_NUM)) {
      echo $row[0] . '<br>';
   }
}
else echo "Empty result!";