本文整理汇总了PHP中database1::selectNow方法的典型用法代码示例。如果您正苦于以下问题:PHP database1::selectNow方法的具体用法?PHP database1::selectNow怎么用?PHP database1::selectNow使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类database1
的用法示例。
在下文中一共展示了database1::selectNow方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1:
<?php
include "../../../myDatabase1.php";
$reportNo = $_GET['reportNo'];
$ro = new database1();
echo $ro->selectNow("radioReportList", "title", "reportNo", $reportNo);
echo "<Br><Br>";
echo $ro->selectNow("radioReportList", "report", "reportNo", $reportNo);
示例2:
$chargesCode = $_GET['chargesCode'];
$description = $_GET['description'];
$sellingPrice = $_GET['sellingPrice'];
$discount = $_GET['discount'];
$timeCharge = $_GET['timeCharge'];
$room = $_GET['room'];
$chargeBy = $_GET['chargeBy'];
$service = $_GET['service'];
$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$inventoryFrom = $_GET['inventoryFrom'];
$ro = new database1();
if ($ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < 1) {
$ro->getBack("Sorry, Out of Stock");
}
echo "\n<style type='text/css'>\n.qty {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight:25px;\n\twidth: 100px;\n\tpadding:4px 4px 4px 10px;\n}\n\n</style>\n\n";
//addCharges.php
echo "<br><Br><Br>";
echo "<form method='get' action='http://" . $ro->getMyUrl() . "/COCONUT/availableSupplies/phicCovered.php'>";
echo "<center><div style='border:1px solid #000000; width:400px; height:100px;\t'>";
echo "<br><table border=0 cellpadding=0 cellspacing=0>";
echo "<tr>";
echo "<td><font size=4>Quantity:</font></td>";
echo "<td><input type=text class='qty' name='quantity' value='1'></td>";
echo "</tr>";
echo "<tr><td> </td></tr>";
echo "<tr>";
echo "<td><input type='button' class='button' value=' Back '\nonClick='javascript: history.go(-1)' style='border:1px solid #000000; background-color:transparent;'></td>";
示例3:
$ro = new database1();
?>
<script type="text/javascript" src="/ckeditor/ckeditor.js"></script>
<?php
echo "\n<style type='text/css'>\n\n.txtArea {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: auto;\n\twidth:900px;\n\tpadding:4px 4px 4px 5px;\n\tfont-size:20px;\n}\n\n</style>\n";
$ro->getPatientProfile($registrationNo);
$ro->coconutFormStart("get", "radioReport_update.php");
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("itemNo", $itemNo);
echo "<table border=0 width='160%'>";
echo "<tr>";
echo "<td><b>Name:</b> " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</td>";
echo "<td><b>Date:</b> " . $ro->selectNow("radioSavedReport", "date", "itemNo", $itemNo) . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Age/Sex</b> " . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "</td>";
echo "<td>Physician: <b>" . $ro->selectNow("radioSavedReport", "physician", "itemNo", $itemNo) . "</b></td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Room:</b> " . $ro->getRegistrationDetails_room() . "</td>";
echo "<td>Examination: <b>{$description}</b></td>";
echo "</tr>";
echo "</table>";
echo "<textarea id='report' name='radioReport' class='txtArea'>";
echo $ro->doubleSelectNow("radioSavedReport", "radioReport", "registrationNo", $registrationNo, "itemNo", $itemNo);
echo "</textarea>";
echo "<br><br>";
$ro->coconutButton("edit");
示例4: date
<?php
include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$physician = $_GET['physician'];
$radioReport = $_GET['radioReport'];
$radtech = $_GET['radtech'];
$ro = new database1();
if (isset($_GET['approved'])) {
$ro->radioReportInsert($registrationNo, $itemNo, date("Y-m-d"), $physician, $radioReport, "Mendero Medical Center", "Consolacion,Cebu", $ro->getSynapseTime(), "yes", date("Y-m-d"), $ro->getSynapseTime(), $physician, $radtech);
} else {
$ro->radioReportInsert($registrationNo, $itemNo, date("Y-m-d"), $physician, $radioReport, "Mendero Medical Center", "Consolacion,Cebu", $ro->getSynapseTime(), "", "", "", "", $radtech);
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/radiologyReport/radioReport_output.php?itemNo={$itemNo}®istrationNo={$registrationNo}&description=" . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . "");
示例5: count
<?php
include "../../../myDatabase1.php";
$packageNo = $_GET['packageNo'];
$countz = count($packageNo);
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
for ($x = 0; $x < $countz; $x++) {
$packageIncluded = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "packageIncluded_description", "packageNo", $packageNo[$x]));
//addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room)
if ($packageIncluded[2] != "MEDICINE" || $packageIncluded[2] != "PROFESSIONAL FEE") {
$services = "Examination";
} else {
if ($packageIncluded[2] == "MEDICINE") {
$services = "Medication";
} else {
$services = "PROFESSIONAL FEE";
}
}
$ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], "0.00", "0.00", "0.00", "0.00", "0.00", "0.00", $ro->getSynapseTime(), date("M_d_Y"), $username, $services, $packageIncluded[2], "Cash", "0.00", "package", $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
}
echo "\n<script type='text/javascript'>\nwindow.parent.location.reload();\n</script>\n\n";
示例6: hospitalPackage
<?php
include "../packageControl.php";
include "../../../myDatabase1.php";
$packageName = $_GET['packageName'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$package = new hospitalPackage();
$ro = new database1();
/*
$ro->getBatchNo();
$myFile = $ro->getReportInformation("homeRoot")."/COCONUT/trackingNo/batchNo.dat";
$fh = fopen($myFile, 'r');
$batchNo = fread($fh, 100);
fclose($fh);
*/
$batchNo = $ro->selectNow("trackingNo", "value", "name", "batchNo");
echo "<center><font size=2 color=red>UNCHECK means the medicine/supplies is not available in the pharmacy</font>";
echo "<Br><Br>";
$package->showAddedPackage_onPatient($packageName, $registrationNo, $username, $batchNo);
示例7: count
<?php
include "../../../myDatabase1.php";
$packageNo = $_GET['packageNo'];
$countz = count($packageNo);
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$batchNo = $_GET['batchNo'];
$unitcost = $_GET['unitcost'];
$Added = $_GET['Added'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
for ($x = 0; $x < $countz; $x++) {
$packageIncluded = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "packageIncluded_description", "packageNo", $packageNo[$x]));
//addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room)
$sellingPrice;
if ($packageIncluded[2] == "LABORATORY" || $packageIncluded[2] == "RADIOLOGY" || $packageIncluded[2] == "ECG" || $packageIncluded[2] == "OR/DR/ER/ Fee" || $packageIncluded[2] == "REHAB") {
$services = "Examination";
$chargesPrice = $ro->selectNow("availableCharges", "PRIVATE", "chargesCode", $packageIncluded[1]);
$ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $chargesPrice, "0.00", $chargesPrice, $chargesPrice, "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "PHARMACY", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
} else {
if ($packageIncluded[2] == "MEDICINE") {
$services = "Medication";
$medPrice = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "Added", "packageNo", $packageNo[$x]));
$ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $medPrice[1], "0.00", $medPrice[1], $medPrice[1], "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "PHARMACY", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
} else {
if ($packageIncluded[2] == "SUPPLIES") {
$services = "Others";
$supPrice = $ro->selectNow("hospitalPackage", "unitcost", "packageNo", $packageNo[$x]);
$ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $supPrice, "0.00", $supPrice, $supPrice, "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "PHARMACY", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
} else {
示例8:
a.document.close();
a.focus();
a.print();
a.close();
}
</script>
<a href="#" onClick="printF('printData')" style="text-decoration:none; color:black;"><font color=red>PRINT</font></a>
<div id='printData'>
<?php
echo "<center><a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/radiologyReport/radioReport_output_doctor.php?registrationNo={$registrationNo}&itemNo={$itemNo}&description={$description}'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/mendero.png' width='40%;' height='20%'></a></center>";
echo "<br>";
echo "<table border=0 width='100%;'>";
echo "<Tr>";
echo "<td><b>NAME:</b> " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</td>";
echo "<tD align='left'><b>DATE:</b> " . $ro->selectNow("radioSavedReport", "date", "itemNo", $itemNo) . "</tD>";
echo "</tr>";
echo "<tr>";
echo "<td><b>PATIENT NO:</b> " . $ro->getRegistrationDetails_patientNo() . "</td>";
echo "<td><b>AGE:</b> " . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>PERFORMED: </b> " . $ro->selectNow("radioSavedReport", "performed", "itemNo", $itemNo) . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td><B>PROCEDURE:</b> " . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . "</td>";
echo "</tr>";
echo "</table>";
echo "</center>";
echo "<font size=4>" . $ro->selectNow("radioSavedReport", "radioReport", "itemNo", $itemNo) . "</font>";
echo "<br><br><br><br>";
示例9: count
<?php
include "../../../myDatabase1.php";
$itemNo = $_GET['itemNo'];
$count = count($itemNo);
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$type = $_GET['type'];
$ro = new database1();
for ($x = 0; $x < $count; $x++) {
//echo "<br>".$itemNo[$x];
if ($type == "PhilHealth") {
$ro->getPatientChargesToEdit($itemNo[$x]);
if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "MEDICINE" || $ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "SUPPLIES") {
$newPrice = $ro->getInventoryPrice($ro->patientCharges_chargesCode()) + $ro->getInventoryPrice($ro->patientCharges_chargesCode()) * 0.25;
} else {
$newPrice = $ro->selectNow("availableCharges", "OPD", "chargesCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x])) + $ro->selectNow("availableCharges", "OPD", "chargesCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x])) * 0.25;
}
//phic Price
//$newTotal = ($newPrice * $ro->patientCharges_quantity());
} else {
if ($type == "CASH") {
$ro->getPatientChargesToEdit($itemNo[$x]);
if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "MEDICINE" || $ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "SUPPLIES") {
$newPrice = $ro->getInventoryPrice($ro->patientCharges_chargesCode());
//phic Price
} else {
$newPrice = $ro->selectNow("availableCharges", "OPD", "chargesCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x]));
}
///$newTotal = ($newPrice * $ro->patientCharges_quantity());
} else {
示例10: date
<?php
include "../../../myDatabase1.php";
$username = $_GET['username'];
$itemNo = $_GET['itemNo'];
$registrationNo = $_GET['registrationNo'];
$ro = new database1();
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "cashPaid", $ro->doubleSelectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo, "registrationNo", $registrationNo));
// kuhain ang total price at ilagay sa cashPaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "cashUnpaid", "0");
// gwen 0 ang cashUnpaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "status", "PAID");
// tagged as PAID
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "datePaid", date("M_d_Y"));
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "timePaid", $ro->getSynapseTime());
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "paidBy", $username);
// gwen 0 ang cashUnpaid cols
$newQty = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) - $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo);
$ro->editNow("inventory", "inventoryCode", $ro->doubleSelectNow("patientCharges", "chargesCode", "itemNo", $itemNo, "registrationNo", $registrationNo), "quantity", $newQty);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "departmentStatus", "dispensedBy_" . $username);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "departmentTime", $ro->getSynapseTime());
示例11: date
<?php
include "../../../myDatabase1.php";
$paymentNo = $_GET['paymentNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
$ro->addVoidPayment($registrationNo . "_" . $ro->getPatientRecord_completeName(), "IPD_DELETE_" . $ro->selectNow("patientPayment", "paymentFor", "paymentNo", $paymentNo), $ro->selectNow("patientPayment", "amountPaid", "paymentNo", $paymentNo), $ro->getSynapseTime(), date("Y-m-d"), $username);
$ro->deleteNow("patientPayment", "paymentNo", $paymentNo);
echo "\n\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/viewPayment.php?username={$username}®istrationNo={$registrationNo}'\n</script>\n\n";
示例12:
echo "<tr>";
echo "<td><b>AGE: </b>" . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "</td>";
echo "<td></td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>PROCEDURE:</b> {$description}</td>";
echo "<td></td>";
echo "</tr>";
echo "<tr>";
echo "<td></td>";
echo "</tr>";
echo "<tr>";
echo "<td></td>";
echo "</tr>";
echo "</table>";
$text = $ro->selectNow("radioReportList", "report", "title", $report);
//$breaks = array("<br>","<br/>","<b>","</b>");
//$text1 = str_ireplace($breaks, "\r\n",$text);
echo "<textarea id='report' name='radioReport'>";
echo $text;
echo "</textarea>";
echo "<br>";
echo "<input type='checkbox' name='approved'><font color=red>Approved</font>";
echo "<bR><br>";
$ro->coconutButton("Proceed");
$ro->coconutFormStop();
echo "</div></div>";
?>
<script type="text/javascript" src="http://<?php
echo $ro->getMyUrl();
示例13:
$description = $_GET['description'];
$sellingPrice = $_GET['sellingPrice'];
$timeCharge = $_GET['timeCharge'];
$chargeBy = $_GET['chargeBy'];
$service = $_GET['service'];
$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$discount = $_GET['discount'];
$inventoryFrom = $_GET['inventoryFrom'];
$room = $_GET['room'];
$quantity = $_GET['quantity'];
$ro = new database1();
$ro->getPHIClimit_setter($ro->selectNow("registrationDetails", "casetype", "registrationNo", $registrationNo));
$ro->getPatientProfile($registrationNo);
// kunin ang data ng patient
//$totalPrice = $sellingPrice * $quantity; //kunin ang total price
//selectNow($table,$cols,$identifier,$identifierData)
//$ro->selectNow("inventory","phic","inventoryCode",$chargesCode); // ttgnan kung cover ba ng philhealth ung medicine
if ($quantity == 0) {
$ro->getBack("Zero is not Allowed");
} else {
//number_format($ro->getCurrentPHIC_check($registrationNo,"MEDICINE") - $ro->getPHIClimit_medicine(),2)
$remainingLimit = $ro->getPHIClimit_medicine() - $ro->getCurrentPHIC_check($registrationNo, "MEDICINE");
if ($ro->getPatientRecord_phic() == "YES") {
//cover at pasok pa sa phic limit ng meds
$totalPrice = $sellingPrice * $quantity;
//phic price
if ($remainingLimit >= $totalPrice) {
示例14: header
<?php
include "../../myDatabase1.php";
$password = $_POST['password'];
$comment = $_POST['comment'];
$ro = new database1();
if ($ro->selectNow("registeredUser", "username", "password", $password) != "") {
$username = $ro->selectNow("registeredUser", "username", "password", $password);
header("Location: /COCONUT/Homepage/addComment.php?username={$username}&comment={$comment}");
} else {
echo "<script type='text/javascript'>\nalert('Incorrect Password');\nhistory.back();\n</script>";
}
示例15: header
<?php
include "../myDatabase1.php";
$patientNo = $_GET['patientNo'];
$date = $_GET['date'];
$ro = new database1();
if ($ro->selectNow("reportHeading", "information", "reportName", "stopDoubleRegistration") == "Activate") {
if ($ro->checkingStop($patientNo, date("Y-m-d")) == "") {
header("Location:http://" . $ro->getMyUrl() . "/Registration/newRecord_again.php?patientNo={$patientNo}");
} else {
header("Location:http://" . $ro->getMyUrl() . "/Registration/stopRegistration.php");
}
} else {
header("Location:http://" . $ro->getMyUrl() . "/Registration/newRecord_again.php?patientNo={$patientNo}");
}