Hi. I have a problem with a Fedora Core 3 server build running Apache 2.0.52-3, PHP 4.3.9-3, MySQL-server 3.23.58-13. It also has the php-mysql-4.3.9-3 installed.
The problem - bringing up Mozilla browser on localhost (for testiing purposes) the index.php page displayes fine, except the mysql_query results do not show up. Nothing within the PHP tags show up, not even errors.
I've substituted the phpinfo (); within the php tags and it displayed the php info page with no problems. So, I can only think that it has to do with mysql or Mozilla.
Here is a sample code:
<?php
$command = "/usr/bin/mysql -u root -pfr33bas3 < mydbtest.txt | sed /Database/d | sed /mysql/d | sed /test/d | sed /snort/d | sed /snortcenter/d";
$dblist = exec($command, $db);
foreach($db as $list) {
print "The following link is for the Results contained in Database <a href=ipsh.php?database=$list>$list</a> scanned on:<br>";
mysql_connect("xxx.xxx.xxx.xxx", "root", "xxxxxxxx");
$timedate = mysql_query(
"select timestamp from $list.timestamps where id = 1");
while ($row = mysql_fetch_assoc($timedate)) {
$date = $row["timestamp"];
print "<b>$date</b>";
}
print "<br><br><br><br>";
}
?>
I have had this working on other systems, mainly RH builds, so I know it works.
Also, this is being run from a VMWare image, but I'm not sure if that would make a difference.
Thanks in advance,
cmarchman
The problem - bringing up Mozilla browser on localhost (for testiing purposes) the index.php page displayes fine, except the mysql_query results do not show up. Nothing within the PHP tags show up, not even errors.
I've substituted the phpinfo (); within the php tags and it displayed the php info page with no problems. So, I can only think that it has to do with mysql or Mozilla.
Here is a sample code:
<?php
$command = "/usr/bin/mysql -u root -pfr33bas3 < mydbtest.txt | sed /Database/d | sed /mysql/d | sed /test/d | sed /snort/d | sed /snortcenter/d";
$dblist = exec($command, $db);
foreach($db as $list) {
print "The following link is for the Results contained in Database <a href=ipsh.php?database=$list>$list</a> scanned on:<br>";
mysql_connect("xxx.xxx.xxx.xxx", "root", "xxxxxxxx");
$timedate = mysql_query(
"select timestamp from $list.timestamps where id = 1");
while ($row = mysql_fetch_assoc($timedate)) {
$date = $row["timestamp"];
print "<b>$date</b>";
}
print "<br><br><br><br>";
}
?>
I have had this working on other systems, mainly RH builds, so I know it works.
Also, this is being run from a VMWare image, but I'm not sure if that would make a difference.
Thanks in advance,
cmarchman
