session_start();
include("Connections/db.php");
mysql_select_db($database_db, $db);
$maxrows = 20;
$currentpage = $_SERVER["PHP_SELF"];
$pagenr = 0;
$totalrows=0;
$totalen=0;
$totalpages=0;
$user = $_SESSION['user'];
$password = $_SESSION['pass'];
$sql="SELECT Surname FROM users WHERE Username='$user' and Password='$password'";
$result=mysql_query($sql) or die (mysql_error());
$result2=mysql_fetch_array($result);
$surname= $result2[0];
if (isset ($_GET['data']))
{
$data=$_GET['data'];
}
else
{
$data=0;
}
if (isset ($_GET['pagenr']))
{
$pagenr=$_GET['pagenr'];
}
else
{
$pagenr = 0;
}
$startrow = $pagenr * $maxrows;
?>
<HTML>
<HEAD>
<TITLE>Information Center</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="pragma" content="no-cache">
<link href="clm.css" rel="stylesheet" type="text/css" />
</HEAD>
<BODY>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.1/jquery.min.js"></script>
<script type="text/javascript">
function SubmitThisRow()
{
<?php
//$data=0;
echo $gegevens->Country;
echo $gegevens->Site;
?>
}
</script>
<table width="100%">
<td align="left"><img src="Pictures\Systems.jpg" height="110" width="250"></td>
<td align="left"><font style="font-family:sans-serif; font-size:16px; color:white;"><b>Information Center</b></font></td>
<td align="right"><img src="Pictures\logo.jpg"></td>
</table>
<table border="0" width="100%">
<tr>
<td>
<table border="0" width="150">
<tr><tr><tr>
<td align="center"><h3><b>Welcome, <?php printf ($surname) ?> </b></h3></td>
</tr>
<tr><tr>
<tr>
<td align="center">
<a href="<?php printf ("?data=1"); ?> ">
Login Data
</a>
</td>
</tr>
<tr><tr>
<tr>
<td align="center">Troubleshoot guide</td>
</tr>
<tr><tr>
<tr>
<td align="center">
<a href="<?php printf ("?data=2"); ?> ">
<img src="Pictures\FP.jpg">
</a>
</td>
</tr>
<tr><tr>
<tr>
<td align="center">
<a href="<?php printf ("?data=3"); ?> ">
<img src="Pictures\US_pic1.jpg">
</a>
</td>
</tr>
<tr><tr>
<tr>
<td align="center">
<a href="<?php printf ("?data=4"); ?> ">
<img src="Pictures\pic1.jpg">
</a>
</td>
</tr>
<tr><tr>
<tr>
<td align="center">
<a href="<?php printf ("?data=5"); ?> ">
<img src="Pictures\Max.jpg">
</a>
</td>
</tr>
</table>
</td>
<td>
<?php
switch ($data)
{
case 0 : echo "Awaiting instructions";
break;
case 1 :
$rights="SELECT Region from users where Username = '$user'";
$right=mysql_query ($rights) or die (mysql_error());
$rights2=mysql_fetch_array($right);
$right= $rights2[0];
if ($right == 'HQ')
{
$aantal=0;
$querystring = "";
if (!empty($_SERVER['QUERY_STRING']))
{
$params= explode("&",$_SERVER['QUERY_STRING']);
$newparams= array();
foreach ($params as $param)
{
if (stristr($param,"pagenr") == false && stristr($param,"totalrows") == false)
{
array_push($newparams,$param);
}
}
if (count($newparams) != 0)
{
$querystring = "&" .implode("&",$newparams);
}
}
$sql2 = "SELECT Country, Site from account order by Region, Country, Site";
$landen = mysql_query ($sql2) or die (mysql_error());
$limiet = sprintf("%s LIMIT %d, %d",$sql2,$startrow,$maxrows);
$data = mysql_query ($limiet) or die (mysql_error());
$sql3 = "SELECT * from account";
$totaal = mysql_query ($sql3) or die (mysql_error());
$totalrows = mysql_num_rows($totaal);
$totalpages = ceil ($totalrows/$maxrows)-1;
print ("<TABLE border=2>
<th>Country</th>
<th>Site Name</th>
<tr>");
$classtr= 1;
while ($gegevens = mysql_fetch_object($data))
{
?Site=$gegevens->Site;
?Country=$gegevens->Country;
print ("<tr class=\"tr$classtr\" onClick='SubmitThisRow(this)' onMouseOver=\"this.className='trover'\" onMouseOut=\"this.className='tr$classtr'\">
<td>$gegevens->Country</td>
<td>$gegevens->Site</td>
</tr>
");
$classtr=($classtr == 1) ? 2 : 1;
}
print ("</TABLE>");
}
else
{
$aantal=0;
$querystring = "";
if (!empty($_SERVER['QUERY_STRING']))
{
$params= explode("&",$_SERVER['QUERY_STRING']);
$newparams= array();
foreach ($params as $param)
{
if (stristr($param,"pagenr") == false && stristr($param,"totalrows") == false)
{
array_push($newparams,$param);
}
}
if (count($newparams) != 0)
{
$querystring = "&" .implode("&",$newparams);
}
}
$sql2 = "SELECT Country, Site from account where Region = '$right' order by Region, Country, Site";
$landen = mysql_query ($sql2) or die (mysql_error());
$limiet = sprintf("%s LIMIT %d, %d",$sql2,$startrow,$maxrows);
$data = mysql_query ($limiet) or die (mysql_error());
$sql3 = "SELECT * from account where Region = '$right' ";
$totaal = mysql_query ($sql3) or die (mysql_error());
$totalrows = mysql_num_rows($totaal);
$totalpages = ceil ($totalrows/$maxrows)-1;
print ("<TABLE border=2>
<th>Country</th>
<th>Site Name</th>
<tr>");
$classtr= 1;
while ($gegevens = mysql_fetch_object($data))
{
print ("<tr class=\"tr$classtr\" onClick='SubmitThisRow(this)' onMouseOver=\"this.className='trover'\" onMouseOut=\"this.className='tr$classtr'\">
<td>$gegevens->Country</td>
<td>$gegevens->Site</td>
</tr>
");
$classtr=($classtr == 1) ? 2 : 1;
}
print ("</TABLE>");
}
break;
case 2 : include ("FP.html");
break;
case 3 : include ("PM.html");
break;
case 4 : include ("G.html");
break;
case 5 : include ("Max.html");
break;
$querystring = "";
$querystring = sprintf ("&totalrows=%d%s",$totalrows,$querystring);
}
?>
</td>
<table align="center">
<tr><td><?php if ($pagenr > 0) { ?><td align="center"><a href="<?php printf("%s?pagenr=%d%s",$currentpage,0,$querystring); ?>"><img src="Pictures\First.gif"></a> <?php } ?></td>
<td><?php if ($pagenr > 0) { ?> <a href="<?php printf("%s?pagenr=%d%s",$currentpage,max(0,$pagenr-1),$querystring); ?>"><img src="Pictures\Previous.gif"></a> <?php } ?></td>
<td><?php if ($pagenr < $totalpages) { ?> <a href="<?php printf("%s?pagenr=%d%s",$currentpage,min($totalpages,$pagenr+1),$querystring); ?>"><img src="Pictures\Next.gif"></a> <?php } ?></td>
<td><?php if ($pagenr < $totalpages) { ?> <a href="<?php printf("%s?pagenr=%d%s",$currentpage,$totalpages,$querystring); ?>"><img src="Pictures\Last.gif"></a></td> <?php } ?></td>
</table>
</tr>
</table>
</BODY>
</HTML>
[size=xsmall]
Toevoeging op 24/12/2013 15:35:19:[/size]
Beste,
dit is mijn code tot nu. Eigenlijk log je in, en kom je op deze page terecht.
Hier, als je dus op klant data (login data eigenlijk) klikt in de linkerkolom krijg je de tabel, en hangt er vanaf welke rechten de user heeft. 'HQ' zal alles kunnen zien, en iemand met minder rights (hangt van regio van de persoon af) zal ie enkel de klanten voor die regio zien
[size=xsmall]
Toevoeging op 24/12/2013 15:58:11:[/size]
O ja, ivm Ajax. Wil niet persé via javascript werken, zocht gewoon wat info via google over hoe ik best data via onClick doorgeef en kwam daar op uit ...
