Menu
▾
▴
[Memship-cvs] memship list2.php,NONE,1.1 liste-rader.php,1.1.1.1,1.2
|
From: <to...@us...> - 2002-08-29 19:33:09
|
Update of /cvsroot/memship/memship
In directory usw-pr-cvs1:/tmp/cvs-serv32738
Modified Files:
liste-rader.php
Added Files:
list2.php
Log Message:
Har laget ei ny fil som heter list2.php, som skal ta over for liste2.php
og en del av de andre liste-*.php-filene. Som den står nå kjører den
bare en select i "member", men den må bygges ut så den kan lage
spørringa si utfra inndata fra list.php, som også må lages.
--- NEW FILE: list2.php ---
<?php
include("includes/liblogin.php");
function print_table ($recordSet, $interactive)
{
/*
Created by: Tor Berg 21.08.02
External variables: $recordSet Database object to be displayed
$interactive TRUE for interactive mode
Description: This function prints a table containing all the data returned with
the object $recordSet, and also adds a header with the keys from the array
*/
if($interactive){
print "<form name=\"myForm\" action=\"list2.php\" method=\"post\">";
print "<table><tr><th>select";
}
else{
print "<table><tr>";
}
while(list($key, $val)= each($recordSet->fields)){
print "<th>";
print $key;
}
while(!$recordSet->EOF){
reset($recordSet->fields);
print "<tr>";
if ($interactive) {
list($key, $val)=each($recordSet->fields);
print "<td><input name=\"\" value=\"$val\" type=\"checkbox\">";
print "<td><a href=\"edit2.php?member=" . $val . "\">$val </a>";
}
while(list($key, $val)=each($recordSet->fields)){
print "<td>";
print $val;
}
print "</tr>";
$recordSet->MoveNext();
}
print "</table>";
if ($interactive) {
print '<br> <input name="vanlig2" type="submit" value="Begrens">
<input name="ren2" type="submit" value="Utskriftsvennlig">
<input name="giroer" type="submit" value="Giroer">
<input name="klistrelapper" type="submit" value="Klistrelapper">
<input name="sms" type="submit" value="Send melding"><br />
Font:<input name="font_size" type="text" value="24" size="2">
X:<input name="x" type="text" value="80" size="2">
Y:<input name="y" type="text" value="240" size="2">
PapirX:<input name="paper_x" type="text" value="595" size="3">
PapirY:<input name="paper_y" type="text" value="842" size="3">
Rotasjon:<input name="rotate" type="text" value="0" size="2">
<input name="adressefelt" type="submit" value="Adressefelt">
';
print "</form>";
}
}
//Main part starts here
include("includes/head.php");
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$recordSet = &$conn->Execute('select member,forename,surname,email from member');
if (!$recordSet) {
print $conn->ErrorMsg();
}
print_table($recordSet,TRUE);
?>
<?php
include("includes/tail.php");
?>
Index: liste-rader.php
===================================================================
RCS file: /cvsroot/memship/memship/liste-rader.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** liste-rader.php 2 Jul 2002 20:32:52 -0000 1.1.1.1
--- liste-rader.php 29 Aug 2002 19:33:04 -0000 1.2
***************
*** 1,33 ****
<?PHP
! $betaltres = pg_exec("SELECT * FROM betalt WHERE etternavn='$row[etternavn]' AND
! fornavn='$row[fornavn]' AND betalt.gruppenavn=ANY (SELECT gruppenavn
! FROM gruppe WHERE betalt.fornavn=gruppe.fornavn AND
! betalt.etternavn=gruppe.etternavn $grupper) ORDER BY år DESC");
! if (pg_numrows($betaltres) > 0) $betalt = pg_fetch_array($betaltres, 0);
! if ($vanlig) {
! $useme = implode(",",array("$row[etternavn]","$row[fornavn]"));
! echo "<input name=\"navn[$i]\" value=\"$useme\" type=\"checkbox\"></td><td>";
! echo "<a target=\"_new\" href=\"redigere2.php?medlem=" . htmlentities($row[fornavn]) .
! "%2C" . htmlentities($row[etternavn]) . "\">
$row[etternavn], $row[fornavn]</a></td><td> ";
! } else {
! echo "$row[etternavn], $row[fornavn]</td><td>";
! }
! if ($data[adresse] == "medlem.adresse") echo "$row[adresse]</td><td>";
! if ($data[postnr] == "medlem.postnr") echo "$row[postnr]</td><td>";
! if ($data[poststed] == "postnr.poststed") echo "$row[poststed]</td><td>";
! if ($data[telhjem] == "medlem.telhjem") echo "$row[telhjem]</td><td>";
! if ($data[teljobb] == "medlem.teljobb") echo "$row[teljobb]</td><td>";
! if ($data[telmob] == "medlem.telmob") echo "$row[telmob]</td><td>";
! if ($data[epost] == "medlem.epost") echo "$row[epost]</td><td>";
! if ($data[skolejobb] == "medlem.skolejobb") echo "$row[skolejobb]</td><td>";
! if ($data[kjønn] == "medlem.kjønn") echo "$row[kjønn]</td><td>";
! if ($data[regsentralt] == "medlem.regsentralt") echo "$row[regsentralt]</td><td>";
! if ($data[fondtype] == "medlem.fondtype") echo "$row[fondtype]</td><td>";
! if ($data[fondbank] == "medlem.fondbank") echo "$row[fondbank]</td><td>";
! if ($data[fondbeløp] == "medlem.fondbeløp") echo "$row[fondbeløp]</td><td>";
! if ($data[medlemstype] == "medlem.medlemstype") echo "$row[medlemstype]</td><td>";
! if ($data[ikkepost] == "medlem.ikkepost") echo "$row[ikkepost]</td><td>";
! if ($betalt && $data[betalt1] == "medlem.betalt1") echo "$betalt[beløp]</td><td>";
! if ($betalt && $data[betalt2] == "medlem.betalt2") echo "$betalt[år]</td><td>";
--- 1,80 ----
<?PHP
! function print_row ($item, $key){
! print "<td>$item ";
! }
!
! function print_table ($recordSet, $interactive)
! {
! /*
! Created by: Tor Berg 21.08.02
!
! External variables: $row results that are to be printed
!
! Description: This function prints out <tr> and </tr> tags, and the contents of array $row with "</td><td>" appended
!
! */
!
! print_r($recordSet->fields); //
!
! print "<table><tr>";
!
! while(current($recordSet->fields)){
! print "<th>";
! print key($recordSet->fields);
! next($recordSet->fields);
! }
!
!
! while(!$recordSet->EOF){
! print "<tr>";
!
! reset($recordSet->fields);
!
! while(current($recordSet->fields)){
! print "<td>";
! print current($recordSet->fields);
! next($recordSet->fields);
! }
!
! print "</tr><table>";
! $recordSet->MoveNext();
!
! }
!
!
!
!
! /*
! if ($interactive) {
! $useme = implode(",",array("$row[etternavn]","$row[fornavn]"));
! echo "<input name=\"navn[$i]\" value=\"$useme\" type=\"checkbox\"></td><td>";
! echo "<a target=\"_new\" href=\"redigere2.php?medlem=" . htmlentities($row[fornavn]) .
! "%2C" . htmlentities($row[etternavn]) . "\">
$row[etternavn], $row[fornavn]</a></td><td> ";
! } else {
! echo "$row[etternavn], $row[fornavn]</td><td>";
! }
! if ($data[adresse] == "medlem.adresse") echo "$row[adresse]</td><td>";
! if ($data[postnr] == "medlem.postnr") echo "$row[postnr]</td><td>";
! if ($data[poststed] == "postnr.poststed") echo "$row[poststed]</td><td>";
! if ($data[telhjem] == "medlem.telhjem") echo "$row[telhjem]</td><td>";
! if ($data[teljobb] == "medlem.teljobb") echo "$row[teljobb]</td><td>";
! if ($data[telmob] == "medlem.telmob") echo "$row[telmob]</td><td>";
! if ($data[epost] == "medlem.epost") echo "$row[epost]</td><td>";
! if ($data[skolejobb] == "medlem.skolejobb") echo "$row[skolejobb]</td><td>";
! if ($data[kjønn] == "medlem.kjønn") echo "$row[kjønn]</td><td>";
! if ($data[regsentralt] == "medlem.regsentralt") echo "$row[regsentralt]</td><td>";
! if ($data[fondtype] == "medlem.fondtype") echo "$row[fondtype]</td><td>";
! if ($data[fondbank] == "medlem.fondbank") echo "$row[fondbank]</td><td>";
! if ($data[fondbeløp] == "medlem.fondbeløp") echo "$row[fondbeløp]</td><td>";
! if ($data[medlemstype] == "medlem.medlemstype") echo "$row[medlemstype]</td><td>";
! if ($data[ikkepost] == "medlem.ikkepost") echo "$row[ikkepost]</td><td>";
! // if ($betalt && $data[betalt1] == "medlem.betalt1") echo "$betalt[beløp]</td><td>";
! // if ($betalt && $data[betalt2] == "medlem.betalt2") echo "$betalt[år]</td><td>";
! */
! echo("</tr>");
!
! //phpinfo();
! }
!
|
