Need help with a project for a non-profit organization

rkeppert

I am currently working on a database driven website, and have run into a few "stumbling blocks".

And before I have to go and pay for another coder to help with this project (as I don't have all the knowledge necessary for this, and at an expense that we can't really afford...) I figured I might be able to get some help here with it...

IThe data that I am working with is "sensitive" in nature. So I will disclose as much as I can.

I have created a database with the necessary fields for the project. I have also done the login system and the data entry page...

What I need assistance with is the following pages:

listing page displaying records in the database, where records would be displayed based on a session variable that is equal to a field in the db table. and include a button/link to update each record displayed.

details page displaying a single record selected from the listing page (the db table has a recnum field that is auto_increment) where all the fields from the db table would show.

search page which would search the db table by 3 text input fields, which would search their respective db table field names, and display those records based on the same type of page as the listing page, (which of course could call the details page and the update record page).

update page where the record could be called and all fields from the db table be placed into their respective fields for editing... (i do understand the UPDATE command, but can't get the record from the db table to display on the page).

a page where the details page could be made printer friendly.

Even if it is already pre-written scripts where I have to change a few items and the page background etc... would be fine as long as someone could point me to what exactly needs to be changed.

Any help on this is much appreciated. Thanks in advance.

Rob.

benracer

Hi,
I am sure you will find help here, if you have any problems with code errors be sure to post here.

rkeppert

I'm gonna post the code for the listing page that I have...

This page, as it is now, displays ALL records in the table... I need to change it so that it only displays results based on a session variable:


$_SESSION['constid']

Code in next post.... too long to fit here....

rkeppert


<?php
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);

?>

rkeppert

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>List of table: warr</title>
<link href="style/style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="scripts/myscripts.js"></script>
</head>
<body>

<form name="FilterForm" method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>">
<div id ="filter">
<table>
<tr><th colspan="3">FILTER</th></tr>
<tr><td>Constid:</td><td><input type="text" name="formdata[constid_min]" <?php $myData->getValue('constid_min'); ?>/></td><td><input type="text" name="formdata[constid_max]" <?php $myData->getValue('constid_max'); ?>/></td></tr>

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

rkeppert


<div id ="main">
<table>
<tr>
<th>&nbsp;</th>
<th><a href="list.php?order=recnum">Recnum:<?php $myData->setOrderImage("recnum"); ?></a></th>
<th><a href="list.php?order=lastname">Lastname:<?php $myData->setOrderImage("lastname"); ?></a></th>
<th><a href="list.php?order=firstname">Firstname:<?php $myData->setOrderImage("firstname"); ?></a></th>
<th><a href="list.php?order=sex">Sex:<?php $myData->setOrderImage("sex"); ?></a></th>
<th><a href="list.php?order=dob">Dob:<?php $myData->setOrderImage("dob"); ?></a></th>
<th><a href="list.php?order=constlname">Constlname:<?php $myData->setOrderImage("constlname"); ?></a></th>
<th><a href="list.php?order=constfname">Constfname:<?php $myData->setOrderImage("constfname"); ?></a></th>
<th><a href="list.php?order=constphnum">Constphnum:<?php $myData->setOrderImage("constphnum"); ?></a></th>
<th><a href="list.php?order=constid">Constid:<?php $myData->setOrderImage("constid"); ?></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['recnum'].'</td>';
echo '<td>'.$Resultset['lastname'].'</td>';
echo '<td>'.$Resultset['firstname'].'</td>';
echo '<td>'.$Resultset['sex'].'</td>';
echo '<td>'.$Resultset['dob'].'</td>';
echo '<td>'.$Resultset['constlname'].'</td>';
echo '<td>'.$Resultset['constfname'].'</td>';
echo '<td>'.$Resultset['constphnum'].'</td>';
echo '<td>'.$Resultset['constid'].'</td>';

echo '<td class="btn"><a href="delete.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/delete.gif" alt="Delete"/></a></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>';
}
?>
<tr><th colspan=12><a href="insert.php"><img src="style/insert.gif" alt="Insert"/></a></th></tr>
</table>
</div>

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

</body>

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