本文整理汇总了PHP中getDetailedTableInfo2函数的典型用法代码示例。如果您正苦于以下问题：PHP getDetailedTableInfo2函数的具体用法？PHP getDetailedTableInfo2怎么用？PHP getDetailedTableInfo2使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了getDetailedTableInfo2函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: if
if($id) {
echo "<option value=\"".getDetailedTableInfo2("vl_users","id='$id'","role")."\">".getDetailedTableInfo2("vl_users","id='$id'","role")."</option>";
} else {
echo "<option value=\"\" selected=\"selected\">Select Role</option>";
}
?>
<option value="Lab Technologist">Lab Technologist</option>
<option value="Lab Manager">Lab Manager</option>
<option value="Other">Other</option>
</select></td>
</tr>
<? if($id && $option!="remove") { ?>
<tr>
<td>Last Login</td>
<td><?php
echo $id ? getFormattedDate(getDetailedTableInfo2("vl_users", "id='{$id}'", "lastLogin")) : "Unavailable";
?>
</td>
</tr>
<? } ?>
</table></td>
</tr>
<tr>
<td style="border-top:1px solid #cccccc; padding-top:10px">
<input type="submit" name="button" id="button" value=" Save " />
<? if($task=="modify") { ?>
<button type="button" id="button" name="button" value="button" onclick="document.location.href='?act=users&nav=configuration'"> Cancel </button>
<input name="id" type="hidden" id="id" value="<?php
echo $id;
?>
"> 示例2: logResultOverride
/**
* function to log result overrides
*/
function logResultOverride($sampleID,$worksheetID,$result) {
global $datetime,$trailSessionUser;
//validate
$sampleID=validate($sampleID);
$worksheetID=validate($worksheetID);
$result=validate($result);
$id=0;
$id=getDetailedTableInfo2("vl_results_override","sampleID='$sampleID' and worksheetID='$worksheetID'","id");
//avoid duplicates
if(!$id) {
//insert into vl_results_override
mysqlquery("insert into vl_results_override
(sampleID,worksheetID,result,created,createdby)
values
('$sampleID','$worksheetID','$result','$datetime','$trailSessionUser')");
} else {
//log table change
logTableChange("vl_results_override","result",$id,getDetailedTableInfo2("vl_results_override","id='$id'","result"),$result);
//update vl_results_override
mysqlquery("update vl_results_override set result='$result' where id='$id'");
}
}示例3:
</tr>
</table>
</td>
<td style="padding: 0px 0px 0px 10px" align="right">Value:</td>
<td style="padding:0px 0px 0px 5px"><input type="text" name="suspectedTreatmentFailureValue" id="suspectedTreatmentFailureValue" value="<?php
echo $suspectedTreatmentFailureValue;
?>
" class="search_pre" size="7" maxlength="10" /></td>
<td align="right">Sample Type:</td>
<td style="padding:0px 0px 0px 5px">
<select name="suspectedTreatmentFailureSampleTypeID" id="suspectedTreatmentFailureSampleTypeID" class="search">
<?
$query=0;
$query=mysqlquery("select * from vl_appendix_sampletype order by position");
if($suspectedTreatmentFailureSampleTypeID) {
echo "<option value=\"$suspectedTreatmentFailureSampleTypeID\" selected=\"selected\">".getDetailedTableInfo2("vl_appendix_sampletype","id='$suspectedTreatmentFailureSampleTypeID' limit 1","appendix")."</option>";
} else {
echo "<option value=\"\" selected=\"selected\">Select Sample Type</option>";
}
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
echo "<option value=\"$q[id]\">$q[appendix]</option>";
}
}
?>
</select>
</td>
</tr>
</table>
</div>
</fieldset>示例4: getDetailedTableInfo2
<td width="70%"><input type="text" name="appendix" id="appendix" class="search" size="25" value="<?php
echo $id ? getDetailedTableInfo2("vl_appendix_tbtreatmentphase", "id='{$id}'", "appendix") : "";
?>
"></td>
</tr>
<tr>
<td>Position</td>
<td><select name="position" id="position" class="search">
<?
//get max number of records
$position=0;
if(!$id) {
$position=getDetailedTableInfo3("vl_appendix_tbtreatmentphase","appendix!=''","count(id)","num");
$position+=1;
} else {
$position=getDetailedTableInfo2("vl_appendix_tbtreatmentphase","id='$id'","position");
}
echo "<option value=\"$position\" selected=\"selected\">$position</option>";
for($j=1;$j<=50;$j++) {
echo "<option value=\"$j\">$j</option>";
}
?>
</select></td>
</tr>
</table></td>
</tr>
<tr>
<td style="border-top:1px solid #cccccc; padding-top:10px">
<input type="submit" name="button" id="button" value=" Save " />
<? if($task=="modify") { ?>
<button type="button" id="button" name="button" value="button" onclick="document.location.href='?act=atbtreatmentphase&nav=configuration'"> Cancel </button>示例5: mysqlnumrows
</td>
<td class="<?php
echo $count < mysqlnumrows($xquery) ? "vl_tdstandard" : "vl_tdnoborder";
?>
" align="center"><a <?php
echo $sampleURL;
?>
><?php
echo number_format((double) $numberSamples);
?>
</a></td>
<td class="<?php
echo $count < mysqlnumrows($xquery) ? "vl_tdstandard" : "vl_tdnoborder";
?>
"><?php
echo getDetailedTableInfo2("vl_facilities", "id='" . getDetailedTableInfo2("vl_samples", "patientID='{$q['id']}'", "facilityID") . "'", "facility");
?>
</td>
<td class="<?php
echo $count < mysqlnumrows($xquery) ? "vl_tdstandard" : "vl_tdnoborder";
?>
"><div class="vls_grey" style="padding:3px 0px 0px 0px"><a href="/samples/manage.patients/modify/<?php
echo $q["id"];
?>
/">Edit Patient Information</a></div></td>
</tr>
<? } ?>
</table>
</div>
</td>
</tr>示例6: getDetailedTableInfo2
</strong><br /><a href="?act=facilities&districtID=<?php
echo $districtID;
?>
&nav=configuration">Return to previous page</a></td>
</tr>
</table>
<? } ?>
</td>
<td width="35%" valign="top" style="padding:3px 0px 0px 12px">
<div>
<table border="0" align="center" cellpadding="0" cellspacing="0" style="border:1px solid #d5d5d5" width="100%">
<tr>
<td style="padding:10px"><table width="100%" border="0" class="vl">
<tr>
<td><strong>MANAGE FACILITIES IN <?php
echo getDetailedTableInfo2("vl_districts", "id='{$districtID}'", "district");
?>
DISTRICT</strong></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td bgcolor="#d5d5d5" style="padding:10px">Create, Delete or Manage Facilities</td>
</tr>
</table></td>
</tr>
</table>
</div>
<div style="padding:10px 0px 0px 0px">
<script Language="JavaScript" Type="text/javascript">示例7: logDownloadedVLClinicalForms
/**
* log search query
* @param: $refNumber
*/
function logDownloadedVLClinicalForms($refNumber) {
global $datetime,$trailSessionUser;
if(!getDetailedTableInfo2("vl_logs_downloadedclinicalforms","refNumber='$refNumber' limit 1","id")) {
mysqlquery("insert into vl_logs_downloadedclinicalforms
(refNumber,created,createdby)
values
('$refNumber','$datetime','$trailSessionUser')");
}
}示例8: getDetailedTableInfo2
$result=0;
$result=getVLResult($machineType,$worksheetID,$sampleReferenceNumber,$factor);
//dispatch details
$scheduledDate=0;
$scheduledDate=getDetailedTableInfo2("vl_logs_samplerepeats","sampleID='$sampleID' and oldWorksheetID='$worksheetID' limit 1","created");
$by=0;
$by=getDetailedTableInfo2("vl_logs_samplerepeats","sampleID='$sampleID' and oldWorksheetID='$worksheetID' limit 1","createdby");
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table border="0" cellspacing="0" cellpadding="0" class="vl">
<tr>
<td class="tab_active">FORM: <?php
echo getDetailedTableInfo2("vl_samples", "id='{$sampleID}'", "formNumber");
?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td style="border:1px solid #CCCCFF; padding:20px">
<table width="100%" border="0" class="vl">
<tr>
<td>
<div style="height: 280px; overflow: auto; padding:3px">
<table width="92%" border="0" class="vl">
<tr>
<td>
<fieldset style="width: 100%">示例9: month
$query=0;
$query=mysqlquery("select distinct month(a.created) theMonth,year(a.created) theYear,a.facilityID facilityID,
CASE
WHEN (round(datediff(now(),b.dateOfBirth)/365)<5 or b.dateOfBirth='0000-00-00') then 1
WHEN round(datediff(now(),b.dateOfBirth)/365)>=5 and round(datediff(now(),b.dateOfBirth)/365)<=9 then 2
WHEN round(datediff(now(),b.dateOfBirth)/365)>=10 and round(datediff(now(),b.dateOfBirth)/365)<=18 then 3
WHEN round(datediff(now(),b.dateOfBirth)/365)>=19 and round(datediff(now(),b.dateOfBirth)/365)<=25 then 4
WHEN round(datediff(now(),b.dateOfBirth)/365)>=26 then 5
END theAgeCategory
from vl_samples a,vl_patients b where a.patientID=b.id order by a.created");
if(mysqlnumrows($query)) {
//sample type IDs
$dbsSampleTypeID=0;
$dbsSampleTypeID=getDetailedTableInfo2("vl_appendix_sampletype","appendix='DBS' limit 1","id");
$plasmaSampleTypeID=0;
$plasmaSampleTypeID=getDetailedTableInfo2("vl_appendix_sampletype","appendix='Plasma' limit 1","id");
$array=array();
while($q=mysqlfetcharray($query)) {
//process last portion of output based on age category
switch($q["theAgeCategory"]) {
case 1: //age is < 5
//samples_received
echo "$q[theMonth], $q[theYear], $q[facilityID], $q[theAgeCategory], ".getDetailedTableInfo3("vl_samples a,vl_patients b","a.patientID=b.id and month(a.created)='$q[theMonth]' and year(a.created)='$q[theYear]' and a.facilityID='$q[facilityID]' and (round(datediff(now(),b.dateOfBirth)/365)<5 or b.dateOfBirth='0000-00-00')","count(a.id)","num")."<br>";
break;
case 2: //age >= 5 && age <= 9
//samples_received
echo "$q[theMonth], $q[theYear], $q[facilityID], $q[theAgeCategory], ".getDetailedTableInfo3("vl_samples a,vl_patients b","a.patientID=b.id and month(a.created)='$q[theMonth]' and year(a.created)='$q[theYear]' and a.facilityID='$q[facilityID]' and round(datediff(now(),b.dateOfBirth)/365)>=5 and round(datediff(now(),b.dateOfBirth)/365)<=9 and b.dateOfBirth!='0000-00-00'","count(a.id)","num")."<br>";
break;
case 3: //age >= 10 && age <= 18
//samples_received示例10:
<fieldset style="width: 100%">
<legend><strong>PATIENT SAMPLES</strong></legend>
<div style="padding:5px 0px 0px 0px">
<table width="100%" border="0" class="vl" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" class="vl_tdsub"><strong>Form #</strong></td>
<td width="20%" class="vl_tdsub"><strong>Sample Reference #</strong></td>
<td width="20%" class="vl_tdsub"><strong>Status</strong></td>
<td width="40%" class="vl_tdsub"><strong>Date Captured</strong></td>
</tr>
<?
$count=0;
while($q=mysqlfetcharray($query)) {
$count+=1;
$status=0;
$status=getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]'","outcome");
if($count<$num) {
echo "<tr>
<td class=\"vl_tdstandard\">$q[formNumber]</td>
<td class=\"vl_tdstandard\"><a href=\"/verify/find.and.edit/$q[id]/1/\">$q[vlSampleID]</a></td>
<td class=\"vl_tdstandard\">".($status?$status:"Pending")."</td>
<td class=\"vl_tdstandard\">".getFormattedDate($q["created"])." at ".getFormattedTimeLessS($q["created"])."</td>
</tr>";
} else {
echo "<tr>
<td class=\"vl_tdnoborder\">$q[formNumber]</td>
<td class=\"vl_tdnoborder\"><a href=\"/verify/find.and.edit/$q[id]/1/\">$q[vlSampleID]</a></td>
<td class=\"vl_tdnoborder\">".($status?$status:"Pending")."</td>
<td class=\"vl_tdnoborder\">".getFormattedDate($q["created"])." at ".getFormattedTimeLessS($q["created"])."</td>
</tr>";
}示例11: echo
<td class="vl_error">There are No Results matching the Search Criteria <strong><?php
echo $searchQuery;
?>
</strong>!</td>
</tr>
</table>
<?
} else {
?>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td class="vl_error">No <?php
echo $machineType;
?>
Results Found<?php
echo ($facilityID || $worksheetID ? " within " : "") . ($facilityID && !$worksheetID ? getDetailedTableInfo2("vl_facilities", "id='{$facilityID}' limit 1", "facility") . " Facility" : "") . (!$facilityID && $worksheetID ? getDetailedTableInfo2("vl_samples_worksheetcredentials", "id='{$worksheetID}' limit 1", "worksheetReferenceNumber") . " Worksheet" : "") . ($facilityID && $worksheetID ? getDetailedTableInfo2("vl_facilities", "id='{$facilityID}' limit 1", "facility") . " Facility and " . getDetailedTableInfo2("vl_samples_worksheetcredentials", "id='{$worksheetID}' limit 1", "worksheetReferenceNumber") . " Worksheet" : "");
?>
</td>
</tr>
</table>
<?
}
}
?>
</div>
</td>
</tr>
</table>
<!-- End Printed/Not Printed Items -->
</td>
</tr>示例12:
echo "<option value=\"$q[id]\">$q[hub]</option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<td>District</td>
<td>
<select name="districtID" id="districtID" class="search">
<?
$query=0;
$query=mysqlquery("select * from vl_districts order by district");
if($districtID) {
echo "<option value=\"$districtID\" selected=\"selected\">".getDetailedTableInfo2("vl_districts","id='$districtID'","district")."</option>";
} else {
echo "<option value=\"\" selected=\"selected\">Select District</option>";
}
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
echo "<option value=\"$q[id]\">$q[district]</option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<td>Date Received <font class="vl_red">*</font></td>
<td>示例13: while
$count=0;
$q=array();
while($q=mysqlfetcharray($query)) {
$count+=1;
$patientID=0;
$patientID=getDetailedTableInfo2("vl_samples","id='$q[sampleID]'","patientID");
$artNumber=0;
$artNumber=getDetailedTableInfo2("vl_patients","id='$patientID'","artNumber");
$otherID=0;
$otherID=getDetailedTableInfo2("vl_patients","id='$patientID'","otherID");
$sampleID=0;
$sampleID=getDetailedTableInfo2("vl_samples","id='$q[sampleID]'","vlSampleID");
$created=0;
$created=getDetailedTableInfo2("vl_samples_verify","sampleID='$q[sampleID]'","created");
$createdby=0;
$createdby=getDetailedTableInfo2("vl_samples_verify","sampleID='$q[sampleID]'","createdby");
?>
<tr>
<td class="<?php
echo $count < $num ? "vl_tdstandard" : "vl_tdnoborder";
?>
">
<div><strong><?php
echo $artNumber ? "ART Number" : "";
echo $artNumber && $otherID ? "/" : "";
echo $otherID ? "OtherID" : "";
?>
:</strong> <?php
echo $artNumber ? $artNumber : "";
echo $artNumber && $otherID ? "/" : "";
echo $otherID ? $otherID : "";示例14: getDetailedTableInfo2
<td style="padding:5px 0px; border-bottom: 1px solid #efefef"><?php
echo $activeTB;
?>
</td>
</tr>
<tr>
<td style="padding:5px 0px; border-bottom: 1px solid #efefef"><strong>TB Treatment Phase</strong></td>
<td style="padding:5px 0px; border-bottom: 1px solid #efefef"><?php
echo getDetailedTableInfo2("vl_appendix_tbtreatmentphase", "id='{$tbTreatmentPhase}' limit 1", "appendix");
?>
</td>
</tr>
<tr>
<td style="padding:5px 0px"><strong>ARV Adherence</strong></td>
<td style="padding:5px 0px"><?php
echo getDetailedTableInfo2("vl_appendix_arvadherence", "id='{$arvAdherence}' limit 1", "appendix");
?>
</td>
</tr>
</table>
</div>
</fieldset>
</td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td><img src="/images/spacer.gif" width="10" height="10" /></td>
</tr>示例15: getDetailedTableInfo2
echo $id ? getDetailedTableInfo2("vl_admins", "id='{$id}'", "email") : "";
?>
"></td>
</tr>
<tr>
<td>Phone</td>
<td><input type="text" name="phone" id="phone" class="search" size="25" value="<?php
echo $id ? getDetailedTableInfo2("vl_admins", "id='{$id}'", "phone") : "+";
?>
"></td>
</tr>
<? if($id && $option!="remove") { ?>
<tr>
<td>Last Login</td>
<td><?php
echo $id ? getFormattedDate(getDetailedTableInfo2("vl_admins", "id='{$id}'", "login")) : "Unavailable";
?>
</td>
</tr>
<? } ?>
</table></td>
</tr>
<tr>
<td style="border-top:1px solid #cccccc; padding-top:10px">
<input type="submit" name="button" id="button" value=" Save " />
<? if($task=="modify") { ?>
<button type="button" id="button" name="button" value="button" onclick="document.location.href='?act=admins&nav=configuration'"> Cancel </button>
<input name="id" type="hidden" id="id" value="<?php
echo $id;
?>
">