$arrFields = array('', 'diseases', 'patients', 'symptoms', 'disease_symptoms', 'patient_symptoms');
$arrFieldCaptions = array('All tables', 'Diseases', 'Patients', 'Symptoms', 'Disease symptoms', 'Patient symptoms');
echo htmlSelect('tableName', $arrFields, $arrFieldCaptions, $tableName);
?>
</td>
</tr>
<tr>
<td align="center">
Sort records by
<?php
$arrFields = array('dateAdded', 'dateUpdated');
$arrFieldCaptions = array('Date created', 'Date modified');
echo htmlSelect('sort', $arrFields, $arrFieldCaptions, $sort);
$arrFields = array('desc', '');
$arrFieldCaptions = array('Newer first', 'Older first');
echo htmlSelect('sortDir', $arrFields, $arrFieldCaptions, $sortDir);
?>
</td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td class="tdHeader"> </td>
<td class="tdHeader"><div class="ColCaption">Username</div></td>
<td class="tdHeader"><div class="ColCaption">Group</div></td>
<td class="tdHeader"><div class="ColCaption">Table</div></td>
<td class="tdHeader"><div class="ColCaption">Created</div></td>
<td class="tdHeader"><div class="ColCaption">Modified</div></td>
<td class="tdHeader"><div class="ColCaption">Data</div></td>
<input type="submit" value="Find">
<input type="button" value="Reset" onClick="window.location='pageViewMembers.php';">
</td>
</tr>
<tr>
<td align="center">
Group
<?php
echo htmlSQLSelect("groupID", "select groupID, name from membership_groups order by name", $groupID);
?>
Status
<?php
$arrFields = array(0, 1, 2, 3);
$arrFieldCaptions = array('Any', 'Waiting approval', 'Active', 'Banned');
echo htmlSelect("status", $arrFields, $arrFieldCaptions, $status);
?>
</td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td class="tdHeader"> </td>
<td class="tdHeader"><div class="ColCaption">Username</div></td>
<td class="tdHeader"><div class="ColCaption">Group</div></td>
<td class="tdHeader"><div class="ColCaption">Sign up date</div></td>
<td class="tdHeader"><div class="ColCaption"><?php
echo $adminConfig['custom1'];
?>
<div class="page-header"><h1><?php
echo $Translation['rebuild thumbnails'];
?>
</h1></div>
<form method="get" action="pageRebuildThumbnails.php" target="_blank">
<?php
echo $Translation['thumbnails utility'];
?>
<br><br>
<b><?php
echo $Translation['rebuild thumbnails of table'];
?>
</b>
<?php
echo htmlSelect('table', array_keys($p), array_keys($p), '');
?>
<input type="submit" value="<?php
echo $Translation['rebuild'];
?>
">
</form>
<?php
include "{$currDir}/incFooter.php";
exit;
}
?>
<div class="page-header"><h1><?php
echo str_replace("<TABLENAME>", $t, $Translation['rebuild thumbnails of table_name']);
function htmlSQLSelect($name, $sql, $selectedValue, $class = "", $selectedClass = "")
{
$arrVal[] = '';
$arrCap[] = '';
if ($res = sql($sql, $eo)) {
while ($row = db_fetch_row($res)) {
$arrVal[] = $row[0];
$arrCap[] = $row[1];
}
return htmlSelect($name, $arrVal, $arrCap, $selectedValue, $class, $selectedClass);
} else {
return "";
}
}
<tr>
<td class="tdFormCaption">
Source member
</td>
<td class="tdCell">
<?php
$arrVal[] = '';
$arrCap[] = '';
$arrVal[] = '-1';
$arrCap[] = "All members of '" . htmlspecialchars(sqlValue("select name from membership_groups where groupID='{$sourceGroupID}'")) . "'";
if ($res = sql("select lcase(memberID), lcase(memberID) from membership_users where groupID='{$sourceGroupID}' order by memberID", $eo)) {
while ($row = mysql_fetch_row($res)) {
$arrVal[] = $row[0];
$arrCap[] = $row[1];
}
echo htmlSelect("sourceMemberID", $arrVal, $arrCap, $sourceMemberID);
}
?>
<input type="submit" value="<?php
echo $sourceMemberID ? "Update" : "Next Step";
?>
">
</td>
</tr>
<?php
}
// STEP 3
if ($sourceMemberID) {
?>
<tr>
<td class="tdCell" colspan="2">
This page allows you to upload a CSV file
(for example, one generated from MS Excel) and
import it to one of the tables of the database.
This makes it so easy to bulk-populate the database
with data from other sources rather than manually
entering every single record.
</div>
</td>
</tr>
<tr>
<td align="right" class="tdFormCaption" valign="top" width="250">
<div class="formFieldCaption">Table</div>
</td>
<td align="left" class="tdFormInput">
<?php
echo htmlSelect('tableName', array_keys($arrTables), array_values($arrTables), '');
?>
<br /><i>This is the table that you want to populate with data from the CSV file.</i>
</td>
</tr>
<tr>
<td align="right" class="tdFormCaption" valign="top">
<div class="formFieldCaption">CSV file</div>
</td>
<td align="left" class="tdFormInput">
<input type="file" name="csvFile" class="formTextBox"><br />
</td>
</tr>
<tr>
<td align="left" class="tdFormCaption" valign="top" colspan="2">
<div class="formFieldCaption"><input type="checkbox" id="TAO" onclick="toggleAdvancedOptions();"> <label for="TAO">Show advanced options</label></div>
<label>Type : <?php
htmlSelect('type', $ref->getTypeList(), $contraintes['type'], '', false, 'none', '-- tous --');
?>
</label>
<label>Utilisateur : <?php
htmlSelectDB('uti', $um->getUserList(), $contraintes['uti'], 'uti_id', array('uti_prenom', 'uti_nom'), 1, false, 0, '-- tous --');
?>
</label>
<label>État : <?php
htmlSelect('status', $statusLib, $contraintes['status'], 1, false, 'none', '-- tous --');
?>
</label>
<?php
foreach ($critereLib as $nom => $critere) {
echo '<label>', $critere, " : ";
htmlSelect("cri_{$nom}", $ref->getEntriesList($nom), $contraintes["cri_{$nom}"], '', false, 'none', '-- tous --');
echo "</label>\n";
}
?>
<input type="submit" value="Filtrer" name="filtrer" id="filtrer" />
</fieldset>
</form>
<?php
/* On affiche la liste des articles */
$am = new DocumentManager($db);
$infosPages = array();
$listeArticles = $am->getListPage($contraintes, $infosPages);
if (count($listeArticles) == 0) {
echo '<p>Aucun document ne correspond à ces critères.</p>', "\n";
<td align=right><font color=#FFFFFF><strong><?php
echo $lang_added["ad_pref_conf-pw"];
?>
 </strong></font></td>
<td><input type="password" name="pw2" size="10"></td>
</tr>
<tr>
<td align=right><font color=#FFFFFF><strong><?php
echo $lang_added["ad_pref_lang"];
?>
 </strong></font></td>
<td>
<?php
//FIXME: get this array automatically somehow
$languages = array(array('lang' => 'en', 'language' => 'English'), array('lang' => 'fr', 'language' => 'Francais'), array('lang' => 'de', 'language' => 'Deutsch'), array('lang' => 'tr', 'language' => 'Turkish'), array('lang' => 'bg', 'language' => 'Bulgarian'));
htmlSelect('language', $languages, $language, 'lang', 'language');
?>
</td>
</tr>
<tr>
<td align=right><font color=#FFFFFF><strong><?php
echo $lang_added["ad_pref_map-g-size"];
?>
 </strong></font></td>
<td>
<select name="map_grid_size">
<?php
if ($map_grid_size == 52) {
print "<option value='52' selected >52</option>";
} else {
print "<option value='52'>52</option>";
function htmlYearSelector($name, $data = '', $delimeter = '', $thnmulai = 2008, $thnakhir = 10, $params = '')
{
if ($data != '') {
$waktu = explode('-', $data);
#pre($waktu);
$dTglTerpilih = $waktu[2];
$dBlnTerpilih = $waktu[1];
$dThnTerpilih = $waktu[0];
//$dTglTerpilih = date('d');
} else {
$dTglTerpilih = date('d');
$dBlnTerpilih = date('m');
$dThnTerpilih = date('Y');
}
$s = '';
$akhir = date('Y') + $thnakhir;
for ($i = $thnmulai; $i <= $akhir; $i++) {
$dThn[$i] = $i;
}
$s .= $delimeter;
$namaThn = $name;
// build tahun selector
$s .= htmlSelect($namaThn, $dThn, $dThnTerpilih);
return $s;
}
