query("select experiment_id, title, date_format(exp_date, '%c/%e/%y') as exp_date, ".
"trim(',' from keywords) as keywords, description, bedcount from experiment ".
"where experiment.researcher_id = ?", $_SESSION['researcher_id']);
// individual experiments profile
//
function generateTable($exp, $fields) {
$ret = "\n";
foreach(array_keys($fields) as $f) {
$ret .= "| $f | ";
}
$i = 0;
while($r = $exp->fetchRow()) {
$class = '';
if($i % 2 == 1) {
$class = ' class="oddrow"';
}
$ret .= "";
foreach($fields as $k) {
if($k == 'title' || $k == 'description') {
$r[$k] = "$r[$k]"; // link to exp.php, details for one experiment
}
$ret .= "$r[$k] | ";
}
$ret .= "
\n";
$i++;
}
$ret .= "
\n";
return $ret;
}
$fields = array('Title' => 'title', 'Date' => 'exp_date', 'Keywords' => 'keywords', 'Description' => 'description', 'BED Files' => 'bedcount');
$title = "Home";
require_once 'header.inc.php';
?>
Welcome, [Logout]
'search_genome'));
$search_genome->insertElt('', '[any]');
$search_method = new DBSelectForm('method', 'select method_id, name from method', array('id' => 'search_method'));
$search_method->insertElt('', '[any]');
?>
Search BED files:
Advanced search »
numRows()) {
print "You have no existing experiments in the system.
\n";
print "";
} else {
print "Experiments:
\n";
print generateTable($exp, $fields);
}
// admins can see whole experiments
if($_SESSION['admin']) {
print "
Other people's experiments:
\n";
$result = $db->query("select experiment_id, title, date_format(exp_date, '%c/%e/%y') as exp_date, ".
"trim(',' from keywords) as keywords, description, bedcount, concat(firstname,' ', lastname) as owner from experiment join researcher using(researcher_id) ".
"where experiment.researcher_id <> ?", $_SESSION['researcher_id']); // show experiments not belong to mine
$fields['Owner'] = 'owner';
print generateTable($result, $fields); // add 'owner' column
print 'View all BED files at once »
';
}
?>