"Example_Session")); $db = new DB_Example; // That's a DB_Sql subclass. $t = new Table; // For formatting results $t->heading = "on"; // We want table headings.. // Define Functions // Option function printOption($ovalue="", $olabel="") { printf(" \n"); } // Option List function printOptionList ($table="viewkeyword_j", $vfld="kwd", $lfld="", $order="", $wfld="", $wval="", $encode=true) { if ($lfld == "") { $lfld = $vfld; } if ($order == "") { $order = $vfld; } $sql = "select $vfld as value, $lfld as label from $table "; if ($wfld != "") { $sql .= "where $wfld ~* '^$wval' "; } $sql .= "order by $order"; @$result = pg_exec($sql); if ($result == false) { printf("SQL:\"$sql\" Failed."); exit; } $rows = pg_numrows($result); for ($rec = 0; $rec < $rows; $rec++) { if ($encode == true) { $ovalue = base64_encode(pg_result($result,$rec,0)); } else { $ovalue = pg_result($result,$rec,0); } $olabel = pg_result($result,$rec,1); printOption($ovalue, $olabel); } } // Link function printLink($table="viewkeyword_j",$field="", $label="", $value="", $order="yomi") { global $PHP_SELF; if ($label == "") { exit; } if ($value == "") { $value = base64_encode($label); } print("$label\n"); } ?>
|
|