cannot display mysql data in tables

caresh · Jun 3, 2005

Hi i am trying to run a select statement that display the results in a table on my page but its not going. Can someone plz tell me why its not going
==============================================this is the error that i get :

".$row['username']." ".$row['password']." ".$row['email']." ".$row['compname']." ".$row['actype']." ".$row['accountnr']." ".$row['moneytype']." ".$row['value']." Edit | Delete "; } if($action == "delete") { echo "Are you sure you want to delete this user?
Yes

No

"; exit; } else if($delete == "final" && isset($userid)) { $sql = "DELETE FROM users WHERE userid = '$userid'"; $result = @mysql_query($sql) or die(mysql_error()); echo "

User successfully deleted
"; exit; } ?>
To go Back to Admininstration Page click here.

Username Email Address: Companyname accountname accountnumber moneytype ( EUR,USD,POUND) accountvalue ";
}
else if($submit && $action == "edit" && isset($userid))
{ if(!$submit && $action == "edit" && isset($compname) && !empty($password)or !empty($actype) or !empty($value)or !empty($username) or !empty($accountnr) or !empty($moneytype) or !empty($email))
{ $sql = "UPDATE users SET compname='$compname', actype='$actype', username='$username', value='$value',accountnr='$accountnr', moneytype='$moneytype',email='$email',PASSWORD = '$password' WHERE userid = '$userid'"; $result = @mysql_query($sql) or die(mysql_error()); }
} ?>
To go Back to Admininstration Page click here.

=================================
AND THIS IS THE CODE BEHIND:

$connect = mysql_connect("$user_hostname", "$user_username", "$user_password");
mysql_select_db("$user_database", $connect);

$PHP_SELF = str_replace(stristr($PHP_SELF, '?'),'',$PHP_SELF);

echo "<center><table border=1><tr>
<td align=center>Userid</td>
<td align=center>Username</td>
<td align=center>Password</td>
<td align=center>email</td>
<td align=center>compname</td>
<td align=center>actype</td>
<td align=center>accountnr</td>
<td align=center>moneytype</td>
<td align=center>value</td>
<td align=center>Option</td>
</tr></center>";

$sql = " SELECT userid , username , PASSWORD , email , compname , accountnr , moneytype , actype , value FROM users ORDER BY username ";
$result = @mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
echo "<tr>
<td>".$row['userid']."</td>
<td>".$row['username']."</td>
<td>".$row['password']."</td>
<td>".$row['email']."</td>
<td>".$row['compname']."</td>
<td>".$row['actype']."</td>
<td>".$row['accountnr']."</td>
<td>".$row['moneytype']."</td>
<td>".$row['value']."</td>
<td>
<a href=$PHP_SELF?action=edit&userid="$row['userid']">Edit</a> |
<a href=$PHP_SELF?action=delete&userid="$row['userid']">Delete</a></td></tr> ";
}

if($action == "delete")
{
echo "Are you sure you want to delete this user?
<a href=$PHP_SELF?delete=final&userid=$userid>Yes</a>
<a href=$PHP_SELF>No</a>";
exit;
}
else if($delete == "final" && isset($userid)) {
$sql = "DELETE FROM users WHERE userid = '$userid'";
$result = @mysql_query($sql) or die(mysql_error());
echo "<center>User successfully deleted</center>";
exit;
}
?>
<h3>To go Back to Admininstration Page <a href="friendy456one.php"> click here.</a></h3>

Icheb · Jun 3, 2005

Not really DA related. But as it's a problem with PHP I'll answer it anyways.

It looks like your Apache is outputting the raw php code, instead of the result.

You should check your httpd.conf & do a recompile with customapache sys (I recomment ./build update && ./build all) to be on the safe side.

You can verify the problem with:

Code:

<html>
<head>
<title>test</title>
</head><body>
<h2>Below this there is a phpinfo thing</h2><br>
<?php
phpinfo();
?>
</body>
</html>

And save it to <filename>.php and run it from your browser, if you look at the source of the page and there is the php code in it, you still have a wrong config.

Note that these issues should be solved within a few min on a production server, or just take the entire httpd offline as visitors are now able to see the mysql passwords etc...

cannot display mysql data in tables

caresh

New member

Icheb

Verified User