PHP Forum

**Smudly** · 07-11-2010, 05:28 PM

Hello,

I have a page called rates.php, that calculates the rate a user earns credits on my website. Inside this rates page, I've included my connect.php page to connect to the database, and also included admin.php which check if the user is an admin. If they are not an admin, it redirects them to the member's page. I am trying to include this rates.php page inside my stats.php page. Inside the stats page I need to do a calculate to determine the user's rate, and echo it out to the screen.

Now here is the issue. If I include rates.php, it is going to include the admin.php & connect.php pages. This is going to cause problems. How do I include only the code after my includes inside my rates.php page? I need it to ignore the admin.php page and connect.php page only when it is included inside stats.php

Any suggestions?
The code is show below:

rates.php here:

PHP Code:


			
<?php
session_start();
/// Include Admin Page Here ///
include('inc/admin.php');
include('inc/connect.php');

$user = $_SESSION['username'];

$sql = mysql_query("SELECT * FROM `users` WHERE `username` ='".$user."'");
$row = mysql_fetch_assoc($sql);

$sql2 = mysql_query("SELECT * FROM `userstats` WHERE `username` ='".$user."'") or die(mysql_error());
$row2 = mysql_fetch_assoc($sql2);

$member = $row['member'];
$level  = $row2['level'];

$addrate = .005;

if ($member == 0) {
    $rate = ($level*$addrate+.50);
    $rate = number_format($rate, 3, '.', '');
}

if ($member == 1) {
    $rate = ($level*$addrate+1);
    $rate = number_format($rate, 3, '.', '');
}

if ($member == 9) {
    $rate = ($level*$addrate+1);
    $rate = number_format($rate, 3, '.', '');
}

?>

stats.php here:

PHP Code:


			
<?php
session_start();
if(isset($_SESSION['username'])){

$username = $_SESSION['username'];

include('inc/connect.php');
include ('rates.php');
    $statssql = mysql_query("SELECT * FROM `userstats` WHERE `username`='$username'"); 
    $row = mysql_fetch_assoc($statssql); 


}
else{
    header("Location: index.php");
}
?>
<html>
<head>
<title>Stats</title>
<link rel="stylesheet" type="text/css" href="styles/stats.css" />
</head>
<body>

</body>
</html>

admin.php here:

PHP Code:


			
<?php
// Include this file for Admin Only Pages

//session start and get variable

session_start();
$user = $_SESSION['username'];


include('inc/connect.php');

//query
$get = mysql_query("SELECT * FROM users WHERE username='$user'");
while ($row = mysql_fetch_assoc($get))
{
$admin = $row['member'];
}


if ($admin!=9)
    header('Location:http://www.mysite.com/index.php');

?>

Also, if there is a better way to check if the user is an admin, rather than including the admin.php page, please let me know.

Thanks!

**CouponGuy** · 05:35 PM

In stats.php, you could set a variable like

PHP Code:


			
$stats = true;

before including any scripts.

Then if you want to NOT include something, you can check $stats to see if it was included from stats.php or not.

**Kelpie** · 07-12-2010, 06:38 AM

Alternatively, don't include rates.php in the stats page.
Instead have the code you want both pages to use as a separate file, and have rates.php and stats.php include that file

**kani alavi** · 07-12-2010, 08:43 AM

you can also make the code you want to include in both rates.php and stats.php as a function probably in a separate file may be called functions.php and include that functions.php file whenever you want to call function to make use of the code. hope it helps.