I don't know what i did now...

rkeppert

I'm designing a page where details from a table in my db are displayed, based on the logged in user.....

the logged in user has a session variable:

$_SESSION['constid'];

the list should only display records in the database which have the specific number from the session variable. there is also a "details" link which will open a new page with the entire form from the database with all fields filled in (readonly of course)

I can get all the records to display, but can't get only the records linked with the variable above to display... (it should be done on page load automatically, one of the many problems i'm having with this whole thing)

(code in next post... too long to fit in one post...)

thanks for any help...

rkeppert

<?php

header("Expires: Sat, 01 Jan 2000 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: post-check=0, pre-check=0",false);
session_cache_limiter();
session_start();

ini_set('display_errors', true); 
error_reporting( E_ALL ); 

require('config.php');

require('functions.php');

if (allow_access(Administrators) != "yes")

{
include ('no_access.html');

$constfname = $_SESSION['constfname'];
$constlname = $_SESSION['constlname'];
$constid    = $_SESSION['constid'];
$constphnum = $_SESSION['constphnum'];
$constcounty = $_SESSION['constcounty']; 


exit;
}

include('general/header.inc');
require_once('general/general.php');

if (isset($_GET['order']))     $myData->setOrderingInfo($_GET['order']);
if (isset($_GET['page']))      $myData->actPageNr = $_GET['page'];
if (isset($_POST['formdata'])) $myData->getWhereClause($_POST['formdata']);

$maxRecord = 20;
$sqlbase = "SELECT * FROM warr ".$myData->whereStr.$myData->getOrderString();
$sql = $sqlbase."LIMIT ".(($myData->actPageNr-1)*$maxRecord).",".$maxRecord;
$Result         = $MyDb->f_ExecuteSql($sql);
$ResultRowNr    = $MyDb->f_GetSelectedRows($Result);
$ResultTotalRow = $MyDb->f_ExecuteSql($sqlbase);
$totalRows      = $MyDb->f_GetSelectedRows($ResultTotalRow);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Listing</title>
<link href="style/style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="scripts/myscripts.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css">
<!--
body {
	background-color: #999999;
}
-->
</style></head>
<body>
<div align="center">
  <p><img src="const.jpg" width="207" height="189" /></p>
  <p>LISTING SCREEN <br>
    <br>
    </p>
</div>
<form name="FilterForm" method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>">
<div id ="filter">
  <div align="left"></div>
<table>
<tr><th colspan="3">FILTER</th></tr>
<tr><td>Constid:</td><td><input type="text" name="formdata[constid_val]" <?php echo $_SESSION['constid'];?>/></td>
                <td><select name="formdata[constid_mode]">
                    <option value="EXACTLY" <?php $myData->getSelected('constid_mode','EXACTLY');?>>Exactly
                    </select></td></tr>

<tr><th colspan="3"><button onClick="clearForm()">Clear</button><input name="SubmitFilter" type="submit" value="Search"/></th></tr>
</table></div>
</form>


<div id ="main">
<table>
<tr>
<th>&nbsp;</th>
<th><a href="list.php?order=lastname">Last Name:<?php $myData->setOrderImage("lastname"); ?></a></th>
<th><a href="list.php?order=firstname">First Name:<?php $myData->setOrderImage("firstname"); ?></a></th>
<th><a href="list.php?order=akaname">A.K.A.:<?php $myData->setOrderImage("akaname"); ?></a></th>
<th><a href="list.php?order=sex">Sex:<?php $myData->setOrderImage("sex"); ?></a></th>
<th><a href="list.php?order=dob">D.O.B.:<?php $myData->setOrderImage("dob"); ?></a></th>
<th><a href="list.php?order=crtnum">Crt Num:<?php $myData->setOrderImage("crtnum"); ?></a></th>
<th><a href="list.php?order=constlname">Const:<?php $myData->setOrderImage("constlname"); ?></a></th>
<th><a href="list.php?order=constphnum">Contact #:<?php $myData->setOrderImage("constphnum"); ?></a></th>


<th colspan="2">&nbsp;</th>
</tr>
<?php
$row = 0;
while ($Resultset = $MyDb->f_GetRecord($Result)) {
$str = (($row++ % 2) == 0 ) ? '<tr>' : '<tr class="odd">';
echo $str;
echo '<td class="btn"><a href="detail.php?recnum='.$Resultset['recnum'].'&lastname='.$Resultset['lastname'].'&firstname='.$Resultset['firstname'].'&midname='.$Resultset['midname'].'&akaname='.$Resultset['akaname'].'&addr1='.$Resultset['addr1'].'&addr2='.$Resultset['addr2'].'&aptnum='.$Resultset['aptnum'].'&city='.$Resultset['city'].'&state='.$Resultset['state'].'&zipcode='.$Resultset['zipcode'].'&homeph='.$Resultset['homeph'].'&otherph='.$Resultset['otherph'].'&sex='.$Resultset['sex'].'&race='.$Resultset['race'].'&ethnicity='.$Resultset['ethnicity'].'&dob='.$Resultset['dob'].'&ssn='.$Resultset['ssn'].'&defht='.$Resultset['defht'].'&defwt='.$Resultset['defwt'].'&defeye='.$Resultset['defeye'].'&defhair='.$Resultset['defhair'].'&oln='.$Resultset['oln'].'&olnstate='.$Resultset['olnstate'].'&vehreg='.$Resultset['vehreg'].'&vehstate='.$Resultset['vehstate'].'&county='.$Resultset['county'].'&crtnum='.$Resultset['crtnum'].'&docketnum='.$Resultset['docketnum'].'&violdate='.$Resultset['violdate'].'&warnum='.$Resultset['warnum'].'&warctrl='.$Resultset['warctrl'].'&wardate='.$Resultset['wardate'].'&casetype='.$Resultset['casetype'].'&warstatus='.$Resultset['warstatus'].'&otn='.$Resultset['otn'].'&livescan='.$Resultset['livescan'].'&nciccode='.$Resultset['nciccode'].'&costs='.$Resultset['costs'].'&cfee='.$Resultset['cfee'].'&wfee='.$Resultset['wfee'].'&tfees='.$Resultset['tfees'].'&constlname='.$Resultset['constlname'].'&constfname='.$Resultset['constfname'].'&constphnum='.$Resultset['constphnum'].'&constid='.$Resultset['constid'].'&constcounty='.$Resultset['constcounty'].'&chg1sect='.$Resultset['chg1sect'].'&chg1subs='.$Resultset['chg1subs'].'&chg1desc='.$Resultset['chg1desc'].'&chg2sect='.$Resultset['chg2sect'].'&chg2subs='.$Resultset['chg2subs'].'&chg2desc='.$Resultset['chg2desc'].'&chg3sect='.$Resultset['chg3sect'].'&chg3subs='.$Resultset['chg3subs'].'&chg3desc='.$Resultset['chg3desc'].'&chg4sect='.$Resultset['chg4sect'].'&chg4subs='.$Resultset['chg4subs'].'&chg4desc='.$Resultset['chg4desc'].'&chg5sect='.$Resultset['chg5sect'].'&chg5subs='.$Resultset['chg5subs'].'&chg5desc='.$Resultset['chg5desc'].'&photo='.$Resultset['photo'].'&markst1='.$Resultset['markst1'].'&markdesc1='.$Resultset['markdesc1'].'&markst2='.$Resultset['markst2'].'&markdesc2='.$Resultset['markdesc2'].'&markst3='.$Resultset['markst3'].'&markdesc3='.$Resultset['markdesc3'].'&markst4='.$Resultset['markst4'].'&markdesc4='.$Resultset['markdesc4'].'&markst5='.$Resultset['markst5'].'&markdesc5='.$Resultset['markdesc5'].'"><img src="style/detail.gif" alt="Detail"/></a></td>';
echo '<td>'.$Resultset['lastname'].'</td>';
echo '<td>'.$Resultset['firstname'].'</td>';
echo '<td>'.$Resultset['akaname'].'</td>';
echo '<td>'.$Resultset['sex'].'</td>';
echo '<td>'.$Resultset['dob'].'</td>';
echo '<td>'.$Resultset['crtnum'].'</td>';
echo '<td>'.$Resultset['constlname'].' '.$Resultset['constfname'].'</td>';
echo '<td>'.$Resultset['constphnum'].'</td>';

echo '<td class="btn"><a href="update.php?recnum='.$Resultset['recnum'].'&lastname='.$Resultset['lastname'].'&firstname='.$Resultset['firstname'].'&midname='.$Resultset['midname'].'&akaname='.$Resultset['akaname'].'&addr1='.$Resultset['addr1'].'&addr2='.$Resultset['addr2'].'&aptnum='.$Resultset['aptnum'].'&city='.$Resultset['city'].'&state='.$Resultset['state'].'&zipcode='.$Resultset['zipcode'].'&homeph='.$Resultset['homeph'].'&otherph='.$Resultset['otherph'].'&sex='.$Resultset['sex'].'&race='.$Resultset['race'].'&ethnicity='.$Resultset['ethnicity'].'&dob='.$Resultset['dob'].'&ssn='.$Resultset['ssn'].'&defht='.$Resultset['defht'].'&defwt='.$Resultset['defwt'].'&defeye='.$Resultset['defeye'].'&defhair='.$Resultset['defhair'].'&oln='.$Resultset['oln'].'&olnstate='.$Resultset['olnstate'].'&vehreg='.$Resultset['vehreg'].'&vehstate='.$Resultset['vehstate'].'&county='.$Resultset['county'].'&crtnum='.$Resultset['crtnum'].'&docketnum='.$Resultset['docketnum'].'&violdate='.$Resultset['violdate'].'&warnum='.$Resultset['warnum'].'&warctrl='.$Resultset['warctrl'].'&wardate='.$Resultset['wardate'].'&casetype='.$Resultset['casetype'].'&warstatus='.$Resultset['warstatus'].'&otn='.$Resultset['otn'].'&livescan='.$Resultset['livescan'].'&nciccode='.$Resultset['nciccode'].'&costs='.$Resultset['costs'].'&cfee='.$Resultset['cfee'].'&wfee='.$Resultset['wfee'].'&tfees='.$Resultset['tfees'].'&constlname='.$Resultset['constlname'].'&constfname='.$Resultset['constfname'].'&constphnum='.$Resultset['constphnum'].'&constid='.$Resultset['constid'].'&constcounty='.$Resultset['constcounty'].'&chg1sect='.$Resultset['chg1sect'].'&chg1subs='.$Resultset['chg1subs'].'&chg1desc='.$Resultset['chg1desc'].'&chg2sect='.$Resultset['chg2sect'].'&chg2subs='.$Resultset['chg2subs'].'&chg2desc='.$Resultset['chg2desc'].'&chg3sect='.$Resultset['chg3sect'].'&chg3subs='.$Resultset['chg3subs'].'&chg3desc='.$Resultset['chg3desc'].'&chg4sect='.$Resultset['chg4sect'].'&chg4subs='.$Resultset['chg4subs'].'&chg4desc='.$Resultset['chg4desc'].'&chg5sect='.$Resultset['chg5sect'].'&chg5subs='.$Resultset['chg5subs'].'&chg5desc='.$Resultset['chg5desc'].'&photo='.$Resultset['photo'].'&markst1='.$Resultset['markst1'].'&markdesc1='.$Resultset['markdesc1'].'&markst2='.$Resultset['markst2'].'&markdesc2='.$Resultset['markdesc2'].'&markst3='.$Resultset['markst3'].'&markdesc3='.$Resultset['markdesc3'].'&markst4='.$Resultset['markst4'].'&markdesc4='.$Resultset['markdesc4'].'&markst5='.$Resultset['markst5'].'&markdesc5='.$Resultset['markdesc5'].'"><img src="style/update.gif" alt="Update"/></a></td>';
echo '</tr>';
}
?>
</table>
</div>

<div id ="navigation">
<?php setPager($myData->actPageNr,ceil($totalRows/$maxRecord)); ?>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</div>

</body>

</html>
<?php
$_SESSION['usr']=serialize($myData);
?>

rkeppert

I think maybe I should clarify exactly what I am trying to do...

I have a page with text fields in it (named exactly the same as my db table's field names. (coincidentally, it is a copy of the page that is used to insert the data into the db, however all fields have been made "readonly")

When a user logs in, 5 session variables are created, one of them being a unique identifier for that person (which comes out of another table in the database). They are presented with a menu, where they can enter data (which I actually have working just fine), bring up a table listing of their entered data (which is still not working right), or search all records in the database by "lastname" (which I really haven't done much with yet, as I would rather get the other portions right first before confusing myself with more code to think about).

When the user clicks to bring up the list of their entered data, the code I have shows a few records, enough that the person can identify which record they need to work with (with two options, 1 - get detailed page 2 - update record) neither of which are working at all.

The very large code listing is the listing page, which shows the data, only I can't figure out how to get it to only display the individual user's data. I had it work for about 10 minutes and then it just stopped working I also don't like that it is trying to pass all the data from the database through the address bar. I'm sure there's another way to do it, however I can't figure it out.

If anyone has any questions, please feel free to ask, I can provide coding from other pages if necessary.

Thanks.