当前位置: 首页>>代码示例>>PHP>>正文


PHP getDetailedTableInfo2函数代码示例

本文整理汇总了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'">&nbsp;&nbsp;Cancel&nbsp;&nbsp;</button>
              <input name="id" type="hidden" id="id" value="<?php 
echo $id;
?>
"> 
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.users.php

示例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'");
	}
}
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:27,代码来源:functions.samples.php

示例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&nbsp;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>
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.samples.modify.deprecated.php

示例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'">&nbsp;&nbsp;Cancel&nbsp;&nbsp;</button>
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.appendix.tbtreatmentphase.php

示例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&nbsp;Patient&nbsp;Information</a></div></td>
                            </tr>
                        <? } ?>
 	               </table>
				  </div>
              </td>
            </tr>
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.samples.patients.manage.php

示例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>&nbsp;</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">
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.facilities.php

示例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')");
	}
}
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:13,代码来源:functions.debug.php

示例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:&nbsp;<?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%">
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.preview.results.repeat.scheduled.php

示例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
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:index.test.php

示例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&nbsp;#</strong></td>
                              <td width="20%" class="vl_tdsub"><strong>Sample&nbsp;Reference&nbsp;#</strong></td>
                              <td width="20%" class="vl_tdsub"><strong>Status</strong></td>
                              <td width="40%" class="vl_tdsub"><strong>Date&nbsp;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"])."&nbsp;at&nbsp;".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"])."&nbsp;at&nbsp;".getFormattedTimeLessS($q["created"])."</td>
											</tr>";
								}
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.preview.samples.php

示例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>
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.results.default.php

示例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&nbsp;Received&nbsp;<font class="vl_red">*</font></td>
                          <td>
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.envelopes.modify.php

示例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 : "";
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.samples.repeat.php

示例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&nbsp;Treatment&nbsp;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&nbsp;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>
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.verify.preview.php

示例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'">&nbsp;&nbsp;Cancel&nbsp;&nbsp;</button>
              <input name="id" type="hidden" id="id" value="<?php 
echo $id;
?>
"> 
开发者ID:CHAIUganda,项目名称:ViralLoad,代码行数:31,代码来源:tpl.admins.php


注:本文中的getDetailedTableInfo2函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。