PHP - Locking User Based On Ip

Hi,

so far I have managed to set up a somewhat basic login website with a mysql database backend.

Once they have logged on they go to a "main menu" page.

What I need to define is that user A sees button A but only that button, etc.

(Then of course that same rule would have to apply if they tried to directly go to the page, but I am guessing I can do that in the same way that I currently do to force a login).

If anyone has any tutorials or sample code I would much appreciate it.

Thanks,

I have a "Users" table. I would like to find out the average users sign up in total. This table has a "joined date" column so I can track how many users sign up in a single day.

For e.g.

August 16 - 10 users

August 17 - 20 users

Auguest 18 - 30 users

The total average of user sign ups would be 20 users based on the above results.

So I am wondering how can I create this function?

This is my starting query.

$get_users = $db->prepare("SELECT user_id FROM users");
$get_users->execute();
$result_users = $get_users->fetchAll(PDO::FETCH_ASSOC);
if(count($result_users) > 0) {
  foreach($result_users as $row) {
    $user_id = $row['user_id'];
  }
}

 

I manage to display data using below query that will show value for each month. How to calculate average value starting july onwards(based on user selection).   Let say the value for element 'A'  are Jul=80, Aug= 80, Sep=90. If user select Aug then the average is 80 and if user select Sep then the average is 83.   Query:

$sql2 = "Select element,
	SUM(CASE WHEN Month = 'Jan' THEN total ELSE 0 END ) AS Jan,
	SUM(CASE WHEN Month = 'Feb' THEN total ELSE 0 END ) AS Feb,
	SUM(CASE WHEN Month = 'Mac' THEN total ELSE 0 END ) AS Mac,
	SUM(CASE WHEN Month = 'Apr' THEN total ELSE 0 END ) AS Apr,
	SUM(CASE WHEN Month = 'May' THEN total ELSE 0 END ) AS May,
	SUM(CASE WHEN Month = 'Jun' THEN total ELSE 0 END ) AS Jun,
	SUM(CASE WHEN Month = 'Jul' THEN total ELSE 0 END ) AS Jul,
	SUM(CASE WHEN Month = 'Aug' THEN total ELSE 0 END ) AS Aug,
	SUM(CASE WHEN Month = 'Sep' THEN total ELSE 0 END ) AS Sep,
	SUM(CASE WHEN Month = 'Oct' THEN total ELSE 0 END ) AS Oct,
	SUM(CASE WHEN Month = 'Nov' THEN total ELSE 0 END ) AS Nov,
	SUM(CASE WHEN Month = 'Dec' THEN total ELSE 0 END ) AS Dis
	FROM tbl_ma GROUP BY element";
	$rs2 = mysql_query($sql2);
	$getRec2 = mysql_fetch_assoc($rs2);

Below is how print the data:

<?php 
while ($row = mysql_fetch_assoc($rs2)) {
?>
<tr>
<td style="color:black;background-color:#f5efef"><div align="left"><?php echo $row['element']; ?></div></td>
<?php if( $year != '2014' ){ ?>
<?php if( 1 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Jan']; ?></div></td><?php endif; ?>
<?php if( 2 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Feb']; ?></div></td><?php endif; ?>
<?php if( 3 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Mac']; ?></div></td><?php endif; ?>
<?php if( 4 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Apr']; ?></div></td><?php endif; ?>
<?php if( 5 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['May']; ?></div></td><?php endif; ?>
<?php if( 6 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Jun']; ?></div></td><?php endif; ?>
<?php } ?>
<?php if( 7 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Jul']; ?></div></td><?php endif; ?>
<?php if( 8 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Aug']; ?></div></td><?php endif; ?>
<?php if( 9 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Sep']; ?></div></td><?php endif; ?>
<?php if( 10 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Oct']; ?></div></td><?php endif; ?>
<?php if( 11 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Nov']; ?></div></td><?php endif; ?>
<?php if( 12 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Dis']; ?></div></td><?php endif; ?>
<td><div align="center" style="color:black"><?php //echo average; ?></div></td>
</tr>                                  
<?php } ?>

 

Hi, I want to update user information in the database but it doesn't do anything. No data entered upon form submission. Please anyone if you can help would be great. Thank you.

Code: [Select]
<?php
ini_set ("display_errors", "1");
error_reporting(E_ALL);
$host = "";//edited out
$database  = "";
$username  = "";
$password  = "";
 
$tbl_name   = "users";
$link = mysqli_connect($host, $username, $password);
$conn = mysql_connect($host, $username, $password) or die("Could not connect: " . mysql_error());
mysql_select_db($database);
 
session_start();
 
IF (isset($_SESSION['userid'])){
$userid=$_SESSION['userid'];
 echo $userid;
}

//$currentUser = $_SESSION['myusername']; 

//do some cleanup//
IF (isset($_POST['submit'])){

$first =  $_POST['first'];
$last = $_POST['last'];
$dob = $_POST['dob'];
$gender =  $_POST['gender'];
 
$country =  $_POST['country'];
$state =   $_POST['state'];
$town =   $_POST['town'];
$zip =  $_POST['zip'];
$email =  $_POST['email'];
 


$first = mysql_real_escape_string( '$first');
$last = mysql_real_escape_string(  '$last');
$dob = mysql_real_escape_string(  '$dob');
$gender = mysql_real_escape_string(  '$gender');
 
$country = mysql_real_escape_string(  '$country');
$state = mysql_real_escape_string(  '$state');
$town = mysql_real_escape_string(  '$town');
$zip = mysql_real_escape_string(  '$zip');
$email = mysql_real_escape_string(  '$email');
 
 
};
IF (isset($_SESSION['userid'])){
$userid=$_SESSION['userid'];
}
ELSE{
$getuserid=mysql_query ("SELECT id FROM users ORDER BY id DESC limit 1") or die(mysql_error());
WHILE ($gtuserid = mysql_fetch_array($getuserid)) {
$theuserid=$gtuserid['id'];
$userid=$theuserid;
$_SESSION['userid']=$theuserid;
$userid=$_SESSION['userid'];
}//$getuserid
}// IF ELSE (isset($_SESSION['userid']))
 

/////UPDATE SECTION///// 
IF (isset($_POST['submit'])){
mysql_query ( "UPDATE users SET firstname='$first', lastname='$last', dob = '$dob', gender='$gender',    country='$country', state='$state', town='$town', zip='$zip', email='$email'   WHERE id=$userid") or die(mysql_error());  
}//IF ($_POST['update']=="Update")


 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Connection</title>
<style type="text/css">
body {
font-family:Calibri;
font-size:1em;
}
.title {
font-size:1.6em;
font-weight:strong;
}
.links a{
font-size::1.2em;
text-decoration:none;
}
.links a:hover{
font-size::1.2em;
color:#0066FF;
text-decoration:none;
}
</style>
</head>
<body>
<p><span class="title">Add your personal information/span></p>
 
 <form action="thebeast.php" method="post">
    <p>
    <input type="text" name="first" size="20" id="first"  />
  First name<br />
    <input type="text" name="last" size="20"  id="name" />
    Last name<br />
    <input name="dob" type="text" size="20" id="dob"  ; } ?>
    Date of Birth<br />
    <input type="text" name="gender" size="20" id="gender"   />
  Gender <br />
  <input type="text" name="country" size="20" id="country"   />
  Country<br />
  <input type="text" name="state" size="20" id="state"   />
  State<br />
    <input type="text" name="town" size="20" id="town"  />
    Town<br />
    <input type="text" name="zip" size="20" id="zip"  />
Zip Code<br />
    <input type="text" name="email" size="40" id="email"   />
    Email<br />
    <br />
     
 
     
 
     
   <input type="submit" name="submit" value="Add your information" />
     
       
</form> 
 
 
 
 
 
</body>
</html>

I'm not totally new to php but I'm no guru either. I'm building an intranet and have three seperate user roles, user - manager - admin. There are some menu items I don't want to allow simple users to see. This will expand later to give them different views of a page as well (some can view/others can edit). As it stands the login validation is holding they're user level in $SESSION. To give you an idea take a look at what I'm trying to do:

Code: [Select]
function usermenu($usermenu) {
if($user_level=0)
echo ("<ul id="gooeymenu2" class="solidblockmenu">
<li><a href="main.php">Home</a></li>
<li><a href="forms.php">Forms</a></li>
<li><a href="/support/index.php" target="_new">Support</a></li>
<li><a href="documents.php">Documents</a></li>
<li><a href="admin/index.php">Admin</a></li>
<li><a href="logout.php">Logout</a></li>
</ul>
<script>
gooeymenu.setup({id:'gooeymenu2', selectitem:1, fx:'swing'})
</script>" ");

else($user_level=1,2)
echo ("<ul id="gooeymenu2" class="solidblockmenu">
<li><a href="main.php">Home</a></li>
<li><a href="forms.php">Forms</a></li>
<li><a href="/support/index.php" target="_new">Support</a></li>
<li><a href="documents.php">Documents</a></li>
<li><a href="new.php">New Adviser</a></li>
<li><a href="admin/index.php">Admin</a></li>
<li><a href="logout.php">Logout</a></li>
</ul>
<script>
gooeymenu.setup({id:'gooeymenu2', selectitem:1, fx:'swing'})
</script>" ");

Any help would be great, thanks in advance.

Jason