本文整理汇总了PHP中database::selectNow方法的典型用法代码示例。如果您正苦于以下问题：PHP database::selectNow方法的具体用法？PHP database::selectNow怎么用？PHP database::selectNow使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类database的用法示例。
在下文中一共展示了database::selectNow方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1:
//echo "<font size=4><b>".$ro->getReportInformation("hmoSOA_name")."</b></font><br>";
//echo "<font size=2>".$ro->getReportInformation("hmoSOA_address")."</font><br>";
//echo "<font size=2>".$ro->getRegistrationDetails_branch()."</font><br>";
echo "<table border=0>";
echo "<tr>";
echo "<td><font class='labelz'><b>Name:</b></font></td><td><font size=2>" . $ro->getPatientRecord_completeName() . "</font></td>";
echo "<td> </td>";
echo "<Td><font class='labelz'><b>Registration#:</b></font></td>";
echo "<td><font size=2>" . $ro->getRegistrationDetails_registrationNo() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<Td><font class='labelz'><B>Age:</b></td>";
echo "<Td><font size=2>" . $ro->getPatientRecord_age() . " yrs Old</font></td>";
echo "<Td> </td>";
echo "<td><font class='labelz'><b> Senior:</b></font></td>";
echo "<td><font size=2>" . $ro->getPatientRecord_senior() . "</font></td>";
echo "</tr>";
echo "<tr>";
echo "<Td><font class='labelz'><b>Company:</b></font></td>";
echo "<td><font size=2>" . $ro->getRegistrationDetails_company() . "</font></tD>";
echo "<td><font class='labelz'>Diagnosis:</font></td>";
echo "<tD><font class='labelz'>" . $ro->soap_assessmentz() . " " . $ro->selectNow("registrationDetails", "finalDiagnosis", "registrationNo", $registrationNo) . "</font></tD>";
echo "</tr>";
if ($ro->getRegistrationDetails_type() == "IPD") {
$ro->chargesForSOA_ipd($registrationNo, $show, "", "");
} else {
$ro->chargesForSOA($registrationNo, $show, "", "");
}
echo "</table>";
echo "<br>";
echo "</div>";示例2: database
$inventoryCode = $_GET['inventoryCode'];
$username = $_GET['username'];
$ro = new database();
?>
<link rel="stylesheet" type="text/css" href="http://<?php
echo $ro->getMyUrl();
?>
/COCONUT/myCSS/coconutCSS.css" />
<?php
$timezone = "Asia/Manila";
date_default_timezone_set($timezone);
$currentQTY = $ro->getCurrentQTY($inventoryCode) - $issuedQTY;
$expiration = preg_split("/\\_/", $ro->selectNow("inventory", "expiration", "inventoryCode", $inventoryCode));
echo "<form method='get' action='receivingRequestDetails1.php' >";
echo "<input type=hidden name='currentQTY' value='{$currentQTY}'>";
echo "<input type=hidden name='verificationNo' value='{$verificationNo}'>";
echo "<input type=hidden name='inventoryCode' value='{$inventoryCode}'>";
echo "<input type=hidden name='unitcost' value='" . $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode) . "'>";
//$_GET['unitcost']
echo "<input type=hidden name='generic' value='" . $ro->selectNow("inventory", "genericName", "inventoryCode", $inventoryCode) . "'>";
//$_GET['generic']
echo "<input type=hidden name='date' value='" . date("M_d_Y") . "'>";
//$_GET['date']
echo "<input type=hidden name='username' value='{$username}'>";
// $_GET['addedBy']
echo "<input type=hidden name='month' value='" . $expiration[0] . "'>";
// $_GET['month']
echo "<input type=hidden name='day' value='" . $expiration[1] . "'>";示例3: parseInt
<head>
<meta charset="UTF-8">
<title></title>
<script src="../js/open.js"></script>
<script src="../js/jquery.jstepper.min.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<script>
$(document).ready(function(){
<?php
foreach ($ro4->search_inventory_inventoryCode() as $inventoryCode) {
?>
var qty = "<?php
echo $ro->selectNow('inventory', 'quantity', 'inventoryCode', $inventoryCode);
?>
";
var qty1 = parseInt(qty);
$('#chargeQTY<?php
echo $inventoryCode;
?>
').jStepper({
minValue:1,
maxValue:qty1
});
$("#chargeBtn<?php
echo $inventoryCode;
?>示例4: database
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
$inventoryCode = $_POST['inventoryCode'];
$requesitionNo = $_POST['requesitionNo'];
$requestQTY = $_POST['requestQTY'];
$module = $_POST['module'];
$ro = new database();
$ro4 = new database4();
$stockCardNo = $ro->selectNow("inventory", "stockCardNo", "inventoryCode", $inventoryCode);
$description = $ro->selectNow("inventory", "description", "inventoryCode", $inventoryCode);
$genericName = $ro->selectNow("inventory", "genericName", "inventoryCode", $inventoryCode);
$qty = $requestQTY;
$inventoryType = $ro->selectNow("inventory", "inventoryType", "inventoryCode", $inventoryCode);
$requestToDept = "Stockroom";
$requestingDept = $module;
$requestingUser = $ro->selectNow("registeredUser", "username", "employeeID", $_SESSION['employeeID']);
$dateRequested = date("Y-m-d");
$timeRequested = date("H:i:s");
$status = "requesting";
$batchNo = $requesitionNo;
$request = array("inventoryCode" => $inventoryCode, "stockCardNo" => $stockCardNo, "description" => $description, "genericName" => $genericName, "quantity" => $qty, "inventoryType" => $inventoryType, "requestTo_department" => $requestToDept, "requestingDepartment" => $requestingDept, "requestingUser" => $requestingUser, "dateRequested" => $dateRequested, "timeRequested" => $timeRequested, "status" => $status, "batchNo" => $batchNo);
$ro4->insertNow("inventoryManager", $request);示例5: foreach
<script src="../js/open.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<link rel="stylesheet" href="../myCSS/tooltipster.css"></link>
<link rel="stylesheet" href="../myCSS/tooltipster-noir.css"></link>
<script>
$(document).ready(function(){
<?php
if ($ro4->search_invoice_siNo() != "") {
?>
<?php
foreach ($ro4->search_invoice_siNo() as $siNo) {
?>
<?php
$invoiceNo = $ro->selectNow("salesInvoice", "invoiceNo", "siNo", $siNo);
?>
$(".details").tooltipster({
content: $('<span>Loading....</span>'),
position: 'right',
theme: 'tooltipster-noir',
contentAsHTML:true,
functionBefore:function(origin,continueTooltip) {
continueTooltip();
if( origin.data('ajax') !== 'cached' ){
$.ajax({
type:'POST',
url:'invoice-details.php',
data:{'siNo':<?php
echo $siNo;
?>示例6: database
<?php
include "../myDatabase.php";
include "updater.php";
$itemNo = $_GET['itemNo'];
$ro = new database();
$u = new updater();
for ($x = 0; $x < count($itemNo); $x++) {
$registrationNo = $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo[$x]);
$itemNo1 = $itemNo[$x];
$shift = $ro->selectNow("patientCharges", "reportShift", "itemNo", $itemNo[$x]);
$description = "OPD";
$cashPaid = $ro->selectNow("patientCharges", "cashPaid", "itemNo", $itemNo[$x]);
$orNo = $ro->selectNow("patientCharges", "orNO", "itemNo", $itemNo[$x]);
$type = "OPD";
$paidBy = $ro->selectNow("patientCharges", "paidBy", "itemNo", $itemNo[$x]);
$timePaid = $ro->selectNow("patientCharges", "timePaid", "itemNo", $itemNo[$x]);
$datePaid = $ro->selectNow("patientCharges", "datePaid", "itemNo", $itemNo[$x]);
$paidVia = $ro->selectNow("patientCharges", "paidVia", "itemNo", $itemNo[$x]);
$u->transferCollection($registrationNo, $itemNo1, $shift, $description, $cashPaid, $orNo, $type, $paidBy, $timePaid, $datePaid, $paidVia);
}示例7: strtoupper
if ($row['firstName'] == "N/A") {
} else {
echo "<Tr id='rowz'>";
$ro->censusRegistered_patient += 1;
$ro->coconutTableData("<span class='style4'>" . $row['lastName'] . " " . $row['firstName'] . " " . $row['middleName'] . "</span>");
$ro->coconutTableData("<span class='style4'>" . $row['Age'] . "</span>");
$ro->coconutTableData("<span class='style4'>" . strtoupper($row['Gender']) . "</span>");
//$ro->coconutTableData("<span class='style4'>".$ro->selectNow("Doctors","Specialization1","Name",$ro->getAttendingDoc($row['registrationNo'],"ATTENDING"))."</span>");
if ($row['phic'] == "YES") {
$ro->coconutTableData("<span class='style4'>NH</span>");
} else {
$ro->coconutTableData("<span class='style4'>NN</span>");
}
$ro->coconutTableData("<span class='style4'>" . $row['Company'] . "</span>");
$ro->coconutTableData("<span class='style4'>" . $ro->getAttendingDoc($row['registrationNo'], "ATTENDING") . "</span>");
$ro->coconutTableData("<span class='style4'>" . ($type = $ro->selectNow("registrationDetails", "room", "registrationNo", $row['registrationNo']) . "</span>"));
$ro->coconutTableData("<span class='style4'>" . $row['timeRegistered'] . "@" . $row['dateRegistered'] . "</span>");
$ro->coconutTableData("<span class='style4'>" . $row['registeredBy'] . "</span>");
$ro->coconutTableData("<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/Census/registrationCensusDelete.php?username={$username}®istrationNo={$row['registrationNo']}&fromMonth={$fromMonth}&fromDay={$fromDay}&fromYear={$fromYear}&toMonth={$toMonth}&toDay={$toDay}&toYear={$toYear}&type={$type}&dept={$dept}'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/delete.jpeg'></a>");
echo "</tr>";
}
}
$ro->coconutTableData("<span class='style2'>TOTAL PATIENT</span>");
$ro->coconutTableData("<span class='style2'>" . $ro->censusRegistered_patient . "</span>");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableStop();示例8: database
<?php
include "myDatabase.php";
$endingNo = $_GET['endingNo'];
$ro = new database();
foreach ($endingNo as $endingNo) {
$inventoryCode = $ro->selectNow("endingInventory", "inventoryCode", "endingNo", $endingNo);
$unitcost = $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode);
$ro->editNow("endingInventory", "endingNo", $endingNo, "unitcost", round($unitcost, 2));
echo $inventoryCode;
}示例9: SUM
for ($c = 1; $c <= $opdnum; $c++) {
//For C
$rnopc = "rop" . $c;
$selectrdc = $_POST[$rnopc];
if ($selectrdc != "") {
//If C
$csql = mysql_query("SELECT SUM(sellingPrice*quantity) AS creditqsp, SUM(pc.discount) AS totcdiscount, SUM(pc.total) AS totctotal, SUM(pc.discount+pc.cashUnpaid+pc.cashPaid+pc.cashPaidFromBalance+pc.phic+pc.company+pc.amountPaidFromCreditCard) AS othertot FROM patientCharges pc, registrationDetails rd WHERE pc.registrationNo=rd.registrationNo AND rd.type='OPD' AND pc.status NOT LIKE 'DELETED_%%%%' AND pc.title='{$title}' AND rd.registrationNo='{$selectrdc}' ORDER BY pc.dateCharge,pc.timeCharge");
//$csql=mysql_query("SELECT pc.sellingPrice, pc.quantity, pc.discount, pc.total, pc.discount, pc.cashUnpaid, pc.cashPaid, pc.cashPaidFromBalance, pc.phic, pc.company, pc.amountPaidFromCreditCard FROM patientCharges pc, registrationDetails rd WHERE pc.registrationNo=rd.registrationNo AND rd.type='OPD' AND pc.status NOT LIKE 'DELETED_%%%%' AND pc.title='$title' AND rd.registrationNo='$selectrdc' ORDER BY pc.dateCharge,pc.timeCharge");
while ($cfetch = mysql_fetch_array($csql)) {
$totcdiscount = $cfetch['totcdiscount'];
$totctotal = $cfetch['totctotal'];
$othertot = $cfetch['othertot'];
$creditqsp = $cfetch['creditqsp'];
$totalall += $creditqsp;
if ($creditqsp > 0) {
$patientNo = $cuz->selectNow("registrationDetails", "patientNo", "registrationNo", $selectrdc);
$lastName = $cuz->selectNow("patientRecord", "lastName", "patientNo", $patientNo);
$firstName = $cuz->selectNow("patientRecord", "firstName", "patientNo", $patientNo);
$middleName = $cuz->selectNow("patientRecord", "middleName", "patientNo", $patientNo);
$dateRegistered = $cuz->selectNow("registrationDetails", "dateRegistered", "registrationNo", $selectrdc);
$name = $lastName . ", " . $firstName . " " . $middleName;
echo "\n <tr>\n <form name='Submit' method='post' action='../COCONUT/currentPatient/patientInterface1.php' target='_blank'>\n <input type='hidden' name='username' value='{$username}' />\n <input type='hidden' name='registrationNo' value='{$selectrdc}' />\n <td class='table1Bottom1Right'><div align='left'><input type='submit' name='Submit' class='button03' value='" . strtoupper($name) . "' /></div></td>\n </form>\n <td class='table1Bottom1Right'><div align='center' class='arial14black'> " . date("M d, Y", strtotime($dateRegistered)) . " </div></td>\n <td class='table1Bottom'><a href='../COCONUT/patientProfile/SOAoption/newSOA/newDetailed.php?registrationNo={$selectrdc}&username={$username}&show=try' class='astyle' target='_blank'><div align='right' class='arial14black'> " . number_format($creditqsp, 2) . " </div></a></td>\n </tr>\n";
}
}
}
//If C
}
//For C
echo "\n <tr>\n <td class='table1Top2Bottom1Right' colspan='2'><div align='right' class='arial14blackbold'> TOTAL </div></td>\n <td class='table1Top2Bottom'><div align='right' class='arial14blackbold'> " . number_format($totalall, 2) . " </div></td>\n </tr>\n </table></td>\n </tr>\n</table>\n</div>\n";
?>
</body>示例10:
echo "<th class='header'>Service</th>";
echo "<th class='header'>PHIC</th>";
echo "<th class='header'>Insurance</th>";
echo "<th class='header'>Attending</th>";
echo "<th class='header'>Registered</th>";
echo "<th class='header'>Registered By</th>";
echo "</tr>";
while ($row = mysqli_fetch_array($result)) {
if ($row['firstName'] == "N/A") {
} else {
echo "<Tr id='rowz'>";
$ro->censusRegistered_patient += 1;
echo "<td>" . $row['lastName'] . " " . $row['firstName'] . " " . $row['middleName'] . "</td>";
echo "<td>" . $row['Age'] . "</td>";
echo "<td>" . $row['Gender'] . "</td>";
echo "<td>" . $ro->selectNow("Doctors", "Specialization1", "Name", $ro->getAttendingDoc($row['registrationNo'], "ATTENDING")) . "</td>";
if ($row['phic'] == "YES") {
echo "<td>NH</td>";
} else {
echo "<td>NN</td>";
}
echo "<td>" . $row['Company'] . "</td>";
echo "<td>" . $ro->getAttendingDoc($row['registrationNo'], "ATTENDING") . "</td>";
echo "<td>" . $row['timeRegistered'] . "@" . $row['dateRegistered'] . "</td>";
echo "<td>" . $row['registeredBy'] . "</td>";
echo "</tr>";
}
}
echo "<tr>";
echo "<td>Total Patient</td>";
echo "<td>" . $ro->censusRegistered_patient . "</td>";示例11: database
<?php
include "../../../myDatabase.php";
$requestNo = $_GET['requestNo'];
$ro = new database();
$requestNo = mysql_real_escape_string(strip_tags($requestNo));
echo "\n<style type='text/css'>\ntr:hover { background-color:yellow; color:black;}\na { text-decoration:none; color:black; }\n</style>";
echo "Request#:" . $requestNo;
echo "<br>";
$ro->coconutTableStart();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Description</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "description", "requestNo", $requestNo));
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>QTY</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "qty", "requestNo", $requestNo));
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Price</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "price", "requestNo", $requestNo));
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Total</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "total", "requestNo", $requestNo));
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Request</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "time", "requestNo", $requestNo) . " @ " . $ro->selectNow("admin2request", "date", "requestNo", $requestNo));
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Request By</b>");示例12: database
include "../../../myDatabase.php";
$cuz = new database();
mysql_connect($cuz->myHost(), $cuz->getUser(), $cuz->getPass());
mysql_select_db($cuz->getDB());
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$fromMonth = $_GET['fromMonth'];
$fromDay = $_GET['fromDay'];
$fromYear = $_GET['fromYear'];
$toMonth = $_GET['toMonth'];
$toDay = $_GET['toDay'];
$toYear = $_GET['toYear'];
$type = $_GET['type'];
$dept = $_GET['dept'];
$uname = $_POST['uname'];
$delpass = $_POST['delpass'];
$asql = mysql_query("SELECT * FROM registeredUser WHERE username='{$uname}' AND password='{$delpass}'");
$acount = mysql_num_rows($asql);
$dateRegistered = $cuz->selectNow("registrationDetails", "dateRegistered", "registrationNo", $registrationNo);
if ($acount != 0) {
$date = date("Y-m-d");
$time = date("H:i:s");
$delete = "DELETED_" . $uname . "[" . $date . "@" . $time . "]_" . $dateRegistered;
//$ro->deleteNow("registrationDetails","registrationNo",$registrationNo);
$cuz->EditNow("registrationDetails", "registrationNo", $registrationNo, "dateRegistered", $delete);
echo "<center><Br><br><Br><br><font color=red size=5>Successfully Deleted</font>";
echo "<META HTTP-EQUIV='Refresh'CONTENT='3;URL=registrationCensus.php?username={$username}&fromMonth={$fromMonth}&fromDay={$fromDay}&fromYear={$fromYear}&toMonth={$toMonth}&toDay={$toDay}&toYear={$toYear}&type={$type}&dept={$dept}'>";
} else {
echo "<center><Br><br><Br><br><font color=red size=5>You are not authorized to delete the Patient.</font>";
echo "<META HTTP-EQUIV='Refresh'CONTENT='3;URL=registrationCensus.php?username={$username}&fromMonth={$fromMonth}&fromDay={$fromDay}&fromYear={$fromYear}&toMonth={$toMonth}&toDay={$toDay}&toYear={$toYear}&type={$type}&dept={$dept}'>";
}示例13: SetMsg
var charges = 'Search Charges';
function SetMsg (txt,active) {
if (txt == null) return;
if (active) {
if (txt.value == charges) txt.value = '';
} else {
if (txt.value == '') txt.value = charges;
}
}
window.onload=function() { SetMsg(document.getElementById('charges', false)); }
</script>
<?php
echo "<body onload='DisplayTime();'>";
echo "<form name='addCharge'>";
echo " <input type=text name='availableCharges' id='charges' style=' \n\tbackground:#FFFFFF no-repeat 4px 4px;\n\tpadding:4px 4px 4px 2px;\n\tborder:1px solid #CCCCCC;\n\twidth:400px;\n\theight:25px;' class='txtBox'\n\tonfocus='SetMsg(this, true);'\n \tonblur='SetMsg(this,false);'\n\tonkeyup='showResult();' \n\tvalue='Search Charges'\n>";
echo "<p id='curTime'></p>";
echo "<input type=hidden name='packageNo' value='{$packageNo}'>";
echo "<input type=hidden name='inventoryLocation' value='" . $ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $desc[1]) . "'>";
echo "</form>";
echo "<div id='livesearch'></div>";
echo "</body>";示例14:
?>
<tr>
<td>
<h5>
<?php
echo $stockCardNo;
?>
</h5>
</td>
<?php
if ($inventoryType == "medicine") {
?>
<td>
<h5>
<?php
echo $ro->selectNow("inventoryStockCard", "genericName", "stockCardNo", $stockCardNo);
?>
</h5>
</td>
<?php
}
?>
<td>
<h5>
<?php
echo $ro->selectNow("inventoryStockCard", "description", "stockCardNo", $stockCardNo);
?>
</h5>
</td>
<td>示例15: database
<?php
require_once '../authentication.php';
include "../../myDatabase.php";
include "../../myDatabase4.php";
$ro = new database();
$ro4 = new database4();
$username = $ro->selectNow('registeredUser', 'username', 'employeeID', $_SESSION['employeeID']);
$module = $ro->selectNow('registeredUser', 'module', 'employeeID', $_SESSION['employeeID']);
$ro->showPatientHistory($ro->doubleSelectNow('patientRecord', 'patientNo', 'completeName', $_POST['patientSearch'], "statusz", ""));
?>
<html>
<head>
<title>PATIENT PROFILE</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="http://<?php
echo $ro->getMyUrl();
?>
/COCONUT/flow/rickyCSS1.css" />
<script type="text/javascript" src="http://<?php
echo $ro->getMyUrl();
?>
/jquery.js"></script>
<script type="text/javascript" src="http://<?php
echo $ro->getMyUrl();
?>
/jquery.autocomplete.js"></script>