本文整理汇总了PHP中mysqlquery函数的典型用法代码示例。如果您正苦于以下问题：PHP mysqlquery函数的具体用法？PHP mysqlquery怎么用？PHP mysqlquery使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysqlquery函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: getMailMessage
/**
* function to get the status of the invite sent to the user
* @param: $contact
*/
function getMailMessage($name) {
$query=0;
$query=mysqlquery("select * from vl_emails_outgoing where lower(name)='".strtolower($name)."'");
if(mysqlnumrows($query)) {
return mysqlresult($query,0,'description');
}
}
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:11，代码来源:functions.mailmessages.php
示例2: logError
function logError($name,$description,$url,$user) {
global $datetime;
mysqlquery("insert into vl_errors
(name,description,url,user,created)
values
('$name','$description','$url','$user','$datetime')");
}
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:7，代码来源:functions.errors.php
示例3: getSubordinateOperationsStaff
/**
* OPERATIONS STAFF FUNCTIONS
*/
function getSubordinateOperationsStaff($supervisor) {
$query=0;
$query=mysqlquery("select id from vl_users where reportsTo='$supervisor'");
if(mysqlnumrows($query)) {
$staff=array();
while($q=mysqlfetcharray($query)) {
$staff[]=$q["id"];
}
return $staff;
}
}
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:15，代码来源:functions.staff.php
示例4: insertVLResults
function insertVLResults($machineType="", $values="", $repeats="", $merged_values=""){
$values = trim($values, ",");
$repeats = trim($repeats, ",");
$merged_values = trim($merged_values, ",");
if($machineType=="roche"){
mysqlquery("insert into vl_results_roche
(worksheetID,PatientName,PatientID,OrderNumber,OrderDateTime,
SampleID,SampleType,BatchID,Test,Result,Unit,Flags,AcceptedOp,
AcceptedDateTime,Comment,GeneralLotNumber,GeneralLotExpirationDate,
SamplePrepKitLotNumber,SamplePrepKitLotExpirationDate,PCRKitLotNumber,PCRKitExpirationDate,
LPCLowLimit,LPCHighLimit,MPCLowLimit,MPCHighLimit,
HPCLowLimit,HPCHighLimit,PreparationInstrumentID,PreparationStartDateTime,
PreparationEndDateTime,PreparationRackPos,PreparationRackID,PreparationRackType,
PreparationTubeID,PreparationTubeType,PreparationTubePos,PreparationBatchID,
AmplificationInstrumentID,AmplificationStartDateTime,AmplificationEndDateTime,AmplificationTCID,
AmplificationRackID,AmplificationRackType,AmplificationTubeID,AmplificationTubeType,
AmplificationTubePos,AmplificationBatchID,DetectionInstrumentID,DetectionStartDateTime,
DetectionEndDateTime,DetectionRackPos,DetectionRackID,DetectionRackType,
DetectionTubeID,DetectionTubeType,DetectionTubePos,DetectionBatchID,
IngredientCH1,IngredientCH2,IngredientCH3,IngredientCH4,
CTMElbowCH1,CTMElbowCH2,CTMElbowCH3,CTMElbowCH4,CTMRFICH1,CTMRFICH2,CTMRFICH3,
CTMRFICH4,CTMAFICH1,CTMAFICH2,CTMAFICH3,CTMAFICH4,CTMCalibCoeffa,CTMCalibCoeffb,
CTMCalibCoeffc,CTMCalibCoeffd,CASampleValue,QSCopy,CATarget1,CATarget2,
CATarget3,CATarget4,CATarget5,CATarget6,CAQS1,CAQS2,CAQS3,CAQS4,created,createdby)
values $values");
}elseif($machineType=="abbott"){
mysqlquery("insert into vl_results_abbott
(worksheetID, sampleLocation,sampleID,sampleType,assayName,
assayVersion,result,interpretation,flags,targetCycleNumber,icCycleNumber,
errorCodeDescription,assayCalibrationTime, reagentLotNumber,reagentLotExpirationDate,
controlLotNumber,controlExpirationDate, controlRange,calibratorLotNumber,
calibratorExpirationDate,calibratorLogConcentration, resultComment,targetMR,icMR,
created,createdby) values $values");
}
if(!empty($repeats)){
mysqlquery("insert into vl_logs_samplerepeats
(sampleID,oldWorksheetID,created,createdby)
values $repeats");
}
if(!empty($merged_values)){
mysqlquery("insert ignore into vl_results_merged
(machine,worksheetID,vlSampleID,resultAlphanumeric,
resultNumeric,suppressed,created,createdby)
values $merged_values ");
}
}
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:50，代码来源:tpl.worksheets.uploadresults.php
示例5:
?>
</select></td>
</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>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.samples.modify.deprecated.php
示例6: WHERE
<?php
$GLOBALS['vlDC'] = true;
include "conf.php";
$sql = " SELECT s.id AS s_id, lrCategory, lrEnvelopeNumber, lrNumericID, vlSampleID, formNumber \n\t FROM vl_samples AS s\n\t WHERE (formNumber LIKE '%{$q}%') \n\t LIMIT 10";
$res = mysqlquery($sql);
$str = "<table width=100%>";
$str .= "<tr><th>VL Testing #</th><th> Form Number</th><th>Location ID</th></tr>";
while ($row = mysqlfetcharray($res)) {
extract($row);
$link = "href=\"javascript:windPop('/sample_results/print/{$s_id}/')\"";
$l_smpl_id = "<a {$link}>{$vlSampleID}</a>";
$l_form = "<a {$link}>{$formNumber}</a>";
$l_locator = "<a {$link}>{$lrCategory}{$lrEnvelopeNumber}{$lrNumericID}</a>";
$str .= "<tr><td>{$l_smpl_id}</td><td>{$l_form}</td><td>{$l_locator}</td></tr>";
}
$str .= "</table>";
echo $str;
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:18，代码来源:index.sample_results.live_search.php
示例7: 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
示例8: monthname
?>
<tr>
<td><strong>Total Data Removals since March-2014: </strong></td>
</tr>
<tr>
<td><strong>Removals per Month: </strong></td>
</tr>
<tr>
<td><table width="100%" border="1" class="vl">
<tr bgcolor="#ECECFF">
<td width="74%"><strong>Month, Year</strong></td>
<td width="26%"><strong>Removals</strong></td>
</tr>
<?
$squery=0;
$squery=mysqlquery("select monthname(created) theMonth, year(created) theYear, count(*) stat from vl_logs_removals group by theMonth, theYear order by created");
if(mysqlnumrows($squery)) {
$sq=array();
$stotal=0;
$scount=1;
while($sq=mysqlfetcharray($squery)) {
if($scount%2) {
$scolor="#FFFFFF";
} else {
$scolor="#F4F4F4";
}
?>
<tr bgcolor="<?php
echo $scolor;
?>
">
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.statistics.removals.php
示例9: isDateInDB
function isDateInDB($date) {
$query=0;
$query=mysqlquery("select * from vl_calendar where eventDate='$date'");
if(mysqlnumrows($query)) {
return 1;
}
}
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:7，代码来源:class_calendar.php
示例10:
?>
">
<? } ?>
<input name="act" type="hidden" id="act" value="atbtreatmentphase">
<input name="option" type="hidden" id="option" value="<?php
echo $task;
?>
">
</td>
</tr>
</table>
</form>
<?
$query=0;
$query=mysqlquery("select * from vl_appendix_tbtreatmentphase order by position");
$num=0;
$num=mysqlnumrows($query);
if($num) {
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="vl">
<tr>
<td style="padding:5px 0px" align="center">
<div style="height: 200px; border: 1px solid #ccccff; overflow: auto">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="vl">
<tr>
<td class="vl_tdsub" width="1%"><strong>#</strong></td>
<td class="vl_tdsub" width="60%"><strong>Appendix</strong></td>
<td class="vl_tdsub" width="10%"><strong>Samples</strong></td>
<td class="vl_tdsub" width="29%"> </td>
</tr>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.appendix.tbtreatmentphase.php
示例11: while
<td style="padding:0px 0px 0px 5px"><select name="dispatchedDateYear" id="dispatchedDateYear" class="search">
<?
for($j=getFormattedDateYear($oldDispatchedDate?$oldDispatchedDate:$datetime);$j>=(getCurrentYear()-10);$j--) {
echo "<option value=\"$j\">$j</option>";
}
?>
</select></td>
</tr>
</table></td>
</tr>
<tr>
<td>To Facility (Destination) <font class="vl_red">*</font></td>
<td><select name="facilityID" id="facilityID" class="search">
<?
$query=0;
$query=mysqlquery("select * from vl_facilities where facility!='' order by facility");
if($facilityID) {
echo "<option value=\"$facilityID\" selected=\"selected\">".getDetailedTableInfo2("vl_facilities","id='$facilityID' limit 1","facility")."</option>";
} else {
echo "<option value=\"\" selected=\"selected\"></option>";
}
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
echo "<option value=\"$q[id]\">$q[facility]</option>";
}
}
?>
</select>
<script>
var z = dhtmlXComboFromSelect("facilityID");
z.enableFilteringMode(true);
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.results.dispatch.php
示例12: getDetailedTableInfo2
<input name="regionID" type="hidden" id="regionID" value="<?php
echo $regionID;
?>
">
<input name="option" type="hidden" id="option" value="<?php
echo $task;
?>
">
</td>
</tr>
</table>
</form>
<?
$query=0;
$query=mysqlquery("select * from vl_districts where regionID='$regionID' order by district");
$num=0;
$num=mysqlnumrows($query);
if($num) {
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="vl">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="vl_tdsub" style="padding-left:20px"><strong>Districts in <?php
echo getDetailedTableInfo2("vl_regions", "id='{$regionID}'", "region");
?>
Region</strong></td>
</tr>
</table>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.districts.php
示例13:
">
<? } ?>
<input name="act" type="hidden" id="act" value="permissions">
<input name="option" type="hidden" id="option" value="<?php
echo $task;
?>
">
</td>
</tr>
</table>
</form>
<? } ?>
<?
$query=0;
$query=mysqlquery("select * from vl_users order by names,email");
$num=0;
$num=mysqlnumrows($query);
if($num && $task=="add") {
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="vl">
<tr>
<td style="border-bottom:1px solid #cccccc; padding-bottom:10px">Select User Account</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="vl_tdsub" style="padding-left:16px" width="58%"><strong>Names</strong></td>
<td class="vl_tdsub" width="42%"><strong>Permissions</strong></td>
</tr>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.permissions.php
示例14: date
date(created)>='2015-12-27'
group by vlSampleID having num=1");
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
//get the id
$id=0;
$id=getDetailedTableInfo2("vl_results_override","sampleID='$q[vlSampleID]' and date(created)>='2015-12-27' order by created desc limit 1","id");
//log and remove record
logDataRemoval("delete from vl_results_override where id='$id'");
mysqlquery("delete from vl_results_override where id='$id'");
}
}
*/
//task 4: a procedure to override key abbott results
$query=0;
$query=mysqlquery("select sampleID, count(id) num, max(created) dateCreated from vl_results_abbott
where
result='3119 A no clot exit detected error was encountered by the Liquid Handler.' and
sampleID not in (select sampleID from vl_results_override)
group by sampleID having num>1 order by num desc");
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
//log result override
logResultOverride($q["sampleID"],getDetailedTableInfo2("vl_results_abbott","sampleID='$q[sampleID]' and created='$q[dateCreated]' limit 1","worksheetID"),$default_resultFailureNewSampleMessage);
}
}
//task 5: fix a result typo
mysqlquery("update vl_results_override set result='There is No Result Given. The Test Failed the Quality Control Criteria. We advise you send a new sample.' where result='There is No Result Given. The Test Failed the Quality Control Criteria. We advise you send a a new sample.'");
?>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:index.oneoffs.overrides.php
示例15: alterUserSetting
/**
* function to change a user's setting
* @param: $userID
* @param: $setting
* @param: $value
*/
function alterUserSetting($userID,$setting,$value) {
//globals
global $datetime,$trailSessionUser;
//does user have a setting account?
$query=0;
$query=mysqlquery("select * from vl_users_settings where userID='$userID'");
if(mysqlnumrows($query)) {
//log table change
logTableChange("vl_users_settings","$setting",getDetailedTableInfo2("vl_users_settings","userID='$userID'","id"),getDetailedTableInfo2("vl_users_settings","userID='$userID'","$setting"),$value);
//update
mysqlquery("update vl_users_settings set $setting='$value' where userID='$userID'");
} else {
//insert
mysqlquery("insert into vl_users_settings
(userID,$setting,created,createdby)
values
('$userID','$value','$datetime','$trailSessionUser')");
}
}
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:26，代码来源:functions.user.php
示例16: where
<td>
<table width="100%" border="0" class="vl">
<?
//pages
if(!$pg) {
$pg=1;
}
$offset=0;
$offset=($pg-1)*$rowsToDisplay;
//proceed with query
$query=0;
$query=mysqlquery("select * from vl_forms_clinicalrequest where (formNumber='$searchQuery' or refNumber='$searchQuery') order by created limit $offset, $rowsToDisplay");
$xquery=0;
$xquery=mysqlquery("select * from vl_forms_clinicalrequest where (formNumber='$searchQuery' or refNumber='$searchQuery') order by created");
//number pages
$numberPages=0;
$numberPages=ceil(mysqlnumrows($xquery)/$rowsToDisplay);
if(mysqlnumrows($query)) {
//how many pages are there?
if($numberPages>1) {
echo "<tr><td style=\"padding:0px 0px 10px 0px\" class=\"vls_grey\"><strong>Pages:</strong> ".displayPagesLinks("/generateforms/search/".vlEncrypt($searchQuery)."/",1,$numberPages,($pg?$pg:1),$default_radius)."</td></tr>";
}
?>
<tr>
<td style="padding:10px 0px 10px 0px" class="vls_grey"><strong><?php
echo mysqlnumrows($xquery);
?>
</strong> form<?php
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.generateforms.search.php
示例17: trim
}
}
//then progress to abbott machines
$query=0;
$query=mysqlquery("select distinct sampleID, worksheetID from vl_results_abbott
where
trim(result)='-1.00' or
trim(result)='3153 There is insufficient volume in the vessel to perform an aspirate or dispense operation.' or
trim(result)='3109 A no liquid detected error was encountered by the Liquid Handler.' or
trim(result)='A no liquid detected error was encountered by the Liquid Handler.' or
trim(result)='Unable to process result, instrument response is invalid.' or
trim(result)='3118 A clot limit passed error was encountered by the Liquid Handler.' or
trim(result)='3130 A less liquid than expected error was encountered by the Liquid Handler.' or
trim(result)='3131 A more liquid than expected error was encountered by the Liquid Handler.' or
trim(result)='3152 The specified submerge position for the requested liquid volume exceeds the calibrated Z bottom' or
trim(result)='4455 Unable to process result, instrument response is invalid.' or
trim(result)='A no liquid detected error was encountered by the Liquid Handler.' or
trim(result)='Failed Internal control cycle number is too high. Valid range is [18.48, 22.48].' or
trim(result)='Failed Failed Internal control cycle number is too high. Valid range is [18.48,' or
trim(result)='Failed Failed Internal control cycle number is too high. Valid range is [18.48, 2' or
trim(result)='OPEN' or
trim(result)='There is insufficient volume in the vessel to perform an aspirate or dispense operation.' or
trim(result)='Unable to process result, instrument response is invalid.' or
trim(substr(flags,1,47))='4442 Internal control cycle number is too high.' or
trim(result)='4459 Assay normalized fluorescence too high'");
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
$sampleArray[]=$q["sampleID"];
$worksheetArray[]=$q["worksheetID"];
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.worksheets.mark.samples.as.failed.php
示例18:
?>
">
<? } ?>
<input name="act" type="hidden" id="act" value="regions">
<input name="option" type="hidden" id="option" value="<?php
echo $task;
?>
">
</td>
</tr>
</table>
</form>
<?
$query=0;
$query=mysqlquery("select * from vl_regions order by region");
$num=0;
$num=mysqlnumrows($query);
if($num) {
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="vl">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="vl_tdsub" style="padding-left:20px"><strong>Region</strong></td>
</tr>
</table>
</td>
</tr>
<tr>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.regions.php
示例19: Number
<div style="height: 200px; border: 1px solid #ccccff; overflow: auto">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="vl">
<tr>
<td class="vl_tdsub" width="30%" style="padding-left:16px"><strong>ART Number</strong></td>
<td class="vl_tdsub" width="30%"><strong>Other ID</strong></td>
<td class="vl_tdsub" width="40%"><strong>Sample Form Number(s)</strong></td>
</tr>
<?
$count=0;
$q=array();
while($q=mysqlfetcharray($query)) {
$count+=1;
$samples=0;
$samples="";
$squery=0;
$squery=mysqlquery("select * from vl_samples where patientID='$q[id]'");
if(mysqlnumrows($squery)) {
while($sq=mysqlfetcharray($squery)) {
$samples.="$sq[formNumber] ";
}
}
?>
<tr>
<td class="<?php
echo $count < $num ? "vl_tdstandard" : "vl_tdnoborder";
?>
"><?php
echo $q["artNumber"] ? $q["artNumber"] : " ";
?>
</td>
<td class="<?php
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.samples.linkpatient.php
示例20: sendPlainEmail2Admins
function sendPlainEmail2Admins($from,$fromName,$subject,$title,$message) {
global $home_url;
global $mail;
global $user;
//query admins
$query=0;
$query=mysqlquery("select email from vl_admins");
$q=array();
while($q=mysqlfetcharray($query)) {
queMail($fromName,$from,$q["email"],$subject,$message,0);
}
}
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:13，代码来源:functions.email.php
注：本文中的mysqlquery函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论