PHP - $_get Function Transfering

Hi all, Im trying something which when a User clicks on there Rep they have it displays all the ranks, but on the same page, so far ive got this:


<?php
$view_rep = $_GET['repview'];
$thererep = $fetch->rep;

if (strip_tags($view_rep)){
echo ("<table align='center' class='table' border='1' cellpadding='0' cellspacing='0' width='50%'>
<tr>
<td class='header' align='center'>Your Rep</td>
</tr>
<tr>
<td>You Currently Have: ".makecomma($thererep)."</td>
</tr>
</table>");
}
?>
<font color='#000055'>Rep:</font> <a href='?repview' target='mainFrame'><?php echo("".makecomma($fetch->rep).""); ?></a>

(I haven't finished the whole echo(""); part yet as I was just testing it before I got to far.)

But when the click the Rep link it just shows there full stats instaid just the Rep.

Is anyone able to put me in the right direction on sorting this?
Thanks.

Hi..

I encountered problem in using $_GET to get the DATE_PROCESS.

here is my code:

Code: [Select]
<script>
function editloan(){

var dateprocess = document.getElementById('dateprocess').value;

alert(dateprocess);
window.location = "SSSLoan.php?dateprocess="+dateprocess;
}
</script>

Code: [Select]
<div id="searchname">
<form>
<p class="serif"><b>Search Lastname:</b></p>
<input type="text" name="ssssearch" size="20" onkeyup="fetchsuggest(this.value);">
<div>
<hr />
<ul id="suggest" style="overflow:auto; height:380px; width:auto;">
{section name=co_emp loop=$personalAll}
<li><a href="SSSgetdata.php?queryEmpID={$personalAll[co_emp].EMP_ID}">{$personalAll[co_emp].FULLNAME}</a></li> 
<hr />
{sectionelse}
<li>No records found</li>
{/section}
</ul>
</div>
</div> 
<div id="loanformmain">
<input type="button" name="sssbtn" value="SSS" onclick="loanFrm()">
<input type="button" name="hdmfbtn" value="HDMF" onClick="hdmfloanFrm()">
<input type="button" name="UTbtn" value="Union Dues/Trust Fund" onclick="utloanFrm()">
</div>
<div id="sssloan">
<fieldset>
<legend>SSS Loan</legend>
<p class="serif">
<label id="SSSLabel">SSS ID</label><label id="EMPIDLabel">EMP ID</label><label id="NAMELabel">NAME</label><label id="LOANLabel">LOAN</label><label id="AMORLabel">DEDUCTION</label>
<input type="text" name="SSS" value="{$sss}" size="8" style="background: #e2e2e2" readonly="readonly">
<input type="text" name="EMP_NO" value="{$empno}" size="8" style="background: #e2e2e2" readonly="readonly">
<input type="text" name="NAME" value="{$fullname}" style="background: #e2e2e2" readonly="readonly" size="35">
<input type="text" name="LOAN" value="{$LOAN}" size="9">
<input type="text" name="AMOR" value="{$AMOR}" size="9">
<input type="button" name="add" value="ADD" onclick="SSSAdd()">
<input type="hidden" name="dateprocess" value="{$dateprocess">
</p>
</legend>

</fieldset>
<div style="overflow:auto; height:300px; width:auto;">
<p>
<table border="1" class="stat">
<tr>
<td colspan="4" style="text-align:center">SSS ID</td>
<td colspan="4" style="text-align:center">EMP ID</td>
<td colspan="15" style="text-align:center">NAME</td>
<td colspan="4" style="text-align:center">LOAN</td>
<td colspan="4" style="text-align:center">DEDUCTION</td>
<td colspan="4" style="text-align:center">DATE PROCESS</td>
 
</tr>
{section name=att loop=$getsss}
  <tr>
    <td colspan="4" style="background: #e2e2e2" readonly="readonly">{$getsss[att].SSS}</td>
   <td colspan="4" style="background: #e2e2e2" readonly="readonly">{$getsss[att].EMP_NO}</td>   
    <td colspan="15" style="background: #e2e2e2" readonly="readonly">{$getsss[att].FULLNAME}</td>   
    <td colspan="4" style="background: #e2e2e2" readonly="readonly">{$getsss[att].SSSLoan}</td>
    <td colspan="4" style="background: #e2e2e2" readonly="readonly">{$getsss[att].SSSAmor}</td>
    <td colspan="4" style="background: #e2e2e2" readonly="readonly" id="dateprocess" onclick="editloan('{$getsss[att].DATE_PROCESS}')">{$getsss[att].DATE_PROCESS}</td>
  </tr>
{sectionelse}   
  <tr><td colspan="1">No DATA</td></tr>
{/section}
 
</table>
<table border="1">
<tr>
<td colspan="4" style="text-align:center"><b>TOTAL:</b></td>  <td colspan="5" style="background: #e2e2e2" readonly="readonly">{$Total_Loan}</td> 
</tr>
</table>
</p>
</form>
</div>
</div>     

Code: [Select]
<?php
include 'config.php';

$currentEmpID = $_SESSION['empID'];

$sql = "SELECT EMP_ID, CONCAT(LNAME, ', ',  FNAME, ' ', MI, '.') AS FULLNAME, SSS, HDMF, TIN FROM PERSONAL WHERE EMP_ID='$currentEmpID'";
$recPersonal = $conn->Execute($sql);

if (!$recPersonal) {
    print $conn->ErrorMsg();
}

if (!$recPersonal->BOF) {
    $recPersonal->MoveFirst();
}

$sss                = trim($recPersonal->fields['SSS']);          
$hdmf               = trim($recPersonal->fields['HDMF']);
$tin                = trim($recPersonal->fields['TIN']);

$smarty->assign('sss', $sss);


$sql = "SELECT EMP_ID, CONCAT(LNAME, ', ' , FNAME, ' ', MI) AS FULLNAME FROM PERSONAL ORDER BY LNAME ASC";
$recPersonalNav = $conn->GetAll($sql);
$smarty->assign('personalAll', $recPersonalNav);
// ========================================================================================================================

$sql = "SELECT em.EMP_NO, p.EMP_ID, CONCAT(LNAME, ', ',  FNAME, ' ', MI, '.') AS FULLNAME FROM PERSONAL p, EMPLOYMENT em  WHERE p.EMP_ID='$currentEmpID' AND em.EMP_ID = '$currentEmpID'"; 
   
$recPersonalHead = $conn->Execute($sql);
$fullName = $recPersonalHead->fields["FULLNAME"];
$empno = $recPersonalHead->fields["EMP_NO"];

$smarty->assign('empid', $currentEmpID);
$smarty->assign('fullname', $fullName);
$smarty->assign('empno', $empno);

//===============================SELECT SSSLoan===================================
$dateprocess = $_GET['dateprocess']; 

$sql = "SELECT s.EMP_NO, s.SSSLoan, s.SSSAmor, s.DATE_PROCESS FROM $PAYROLL.sssloan s, $ADODB_DB.employment em WHERE em.EMP_NO= s.EMP_NO AND s.DATE_PROCESS = '$dateprocess'"; 
$rsloan = $conn2->Execute($sql);

$LOAN = trim($rsloan->fields['SSSLoan']);
$AMOR = trim($rsloan->fields['SSSAmor']);

$dateprocess = $rsloan->fields['DATE_PROCESS'] ;

$smarty->assign('LOAN', $LOAN);
$smarty->assign('AMOR', $AMOR);
$smarty->assign('dateprocess', $dateprocess);

//============================SELECT ALL DATA FOR SSSLOAN==========================
$sql = "SELECT s.EMP_NO, em.EMP_ID, p.SSS, CONCAT(LNAME, ', ',  FNAME, ' ', MI, '.') AS FULLNAME, s.SSSLoan, s.SSSAmor, s.DATE_PROCESS FROM $ADODB_DB.PERSONAL p, $ADODB_DB.employment em, $PAYROLL.sssloan s WHERE s.EMP_NO = em.EMP_NO AND p.EMP_ID = '$currentEmpID' AND em.EMP_ID = '$currentEmpID'";

$rs = $conn2->GetAll($sql);

$smarty->assign('getsss', $rs); 

$sql = "SELECT s.EMP_NO, SUM(SSSAmor) AS Total_Loan FROM $PAYROLL.sssloan s, $ADODB_DB.employment em WHERE em.EMP_NO = s.EMP_NO AND em.EMP_ID = '$currentEmpID'" or die (mysql_error());
$rsTotal = $conn2->Execute($sql);

$Total_Loan = $rsTotal->fields['Total_Loan'];

$smarty->assign('Total_Loan', $Total_Loan); 

$smarty->display('header.tpl');
$smarty->display('loanForm.tpl');
$smarty->display('footer.tpl'); 
exit();
?>

when I click date in <td colspan="4" style="background: #e2e2e2" readonly="readonly" id="dateprocess" onclick="editloan('{$getsss[att].DATE_PROCESS}')">{$getsss[att].DATE_PROCESS}</td>

it result no value...it did not get the value that I click

Thank you in advance

First of All hello to all
I have done registration login script and when I starting to making the users profiles, I have problem in the $_GET function
well this is the code

<?php
$getid = $_GET['id'];

if (!$getid)
$getid = "1";

require('scripts/connect.php');
$query = mysql_query("SELECT * FROM users WHERE id='$getid'");
mysql_real_escape_string;
$numrows = mysql_num_rows($query);

if ($numrows == 1){
$row = mysql_fetch_assoc($query);

$id = $row['id'];
$firstname = $row['first_name'];
$lastname = $row['last_name'];
$user = $row['username'];
$avatar = $row['avatar'];
                $city = $row['city'];
                


echo "<div id='profile'>
<div id='leftside'>
<a href='profile.php?$user'><img src='avatars/$avatar' width='100px' 

height='100px' border='0'</a></img><br /><a href='profile.php?$user'>$firstname $lastname <br 

/>($user)<br /></a>$city
<br /></div>";
                                }
                                
                        else
                echo " You have to contact administrator";
                              

                             ?>
When I login as user id 1 then it display all right but when I go and  login as another user
it display the first users piture, name, surname & city can someone tell me what the problem is ? I know is this if (!$getid)
$getid = "1"; but why is this happen If someone tell me or point to the right direction I would be thank full

Okay im trying to make it so when some is on this link ("?serv=del&id=$ID") it displays a portlet of a yes/no form. onces yes/no is picked it goes to ("?serv=del&id=$ID&del=true"). I have no idea if im doing this right or if theres a better way of doing it. But trying to fix this problem has almost made me throw my computer threw my window. Thanks in advanced.

<?php
if(isset($_GET['serv']) && $_GET['id'] == $serverid && $_GET['del'] == 'true') {

if($_POST['ture']) {
mysql_query("DELETE FROM `notifications` WHERE `id`='$msgid'");
Echo "<center>Message Deleted</center>";
} else {
Echo "<center>Message delete request has been canceled.</center>";
}
} elseif(isset($_GET['serv']) && $_GET['id'] == $serverid) {
?>
<div class="usercp_body"><!--  UserCP Notification Manage Start -->
<div id="dash_chart" class="portlet" style="width:100%;margin: 0 auto;">

<div class="portlet-header">

<h4><center>All Servers For <?php echo $username; ?></center></h4>

</div>
<div class="portlet-content">

<form action="manage.php?serv=del&id=<?php echo $serverid; ?>&del=true" method="post">
<input type="submit" class="bgbtn blue" value="Yes" name="true" />
<input type="submit" class="bgbtn blue" value="No" name="false" />
</form>
</div>
</div>
</div>
<?php
}
?>