PHP database::deleteNow方法代碼示例

<?php

include "../../myDatabase.php";
$ro = new database();
$ro->deleteNow("ipdCensus", "id", $_POST['id']);
//header("Location: addToCensus.php?registrationNo=$_GET[registrationNo]");

<?php

include "../../myDatabase.php";
$verificationNo = $_POST['verificationNo'];
$ro = new database();
$ro->deleteNow("inventoryManager", "verificationNo", $verificationNo);

<?php

include "../../../myDatabase.php";
$date = $_GET['date'];
$shift = $_GET['shift'];
$attrNo = $_GET['attrNo'];
$ro = new database();
$dateIndividual = preg_split("/\\-/", $date);
$year = $dateIndividual[0];
$month = $dateIndividual[1];
$day = $dateIndividual[2];
$ro->deleteNow("dailyCashiersAttr", "attrNo", $attrNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Cashier/cashierReport/dailyCashiersReport.php?month={$month}&day={$day}&year={$year}&shift={$shift}");

<?php

include "../../../myDatabase.php";
$username = $_GET['username'];
$supplierName = $_GET['supplierName'];
$supplierCode = $_GET['supplierCode'];
$ro = new database();
$ro->deleteNow("supplier", "supplierCode", $supplierCode);
echo "\n<script type='text/javascript'>\nalert('{$supplierName} is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/supplier.php?username={$username}';\n</script>\n\n";

<?php

include "../../myDatabase.php";
$valuesNo = $_GET['valuesNo'];
$labNo = $_GET['labNo'];
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$description = $_GET['description'];
$pathologist = $_GET['pathologist'];
$medTech = $_GET['medTech'];
$receivedMonth = $_GET['receivedMonth'];
$receivedDay = $_GET['receivedDay'];
$receivedYear = $_GET['receivedYear'];
$releasedMonth = $_GET['releasedMonth'];
$releasedDay = $_GET['releasedDay'];
$releasedYear = $_GET['releasedYear'];
$branch = $_GET['branch'];
$ro = new database();
$ro->deleteNow("laboratoryResultsValue", "valuesNo", $valuesNo);
echo "\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/Results/editResultValue.php?labNoz={$labNo}&registrationNo={$registrationNo}&itemNo={$itemNo}&description={$description}&pathologist={$pathologist}&medTech={$medTech}&receivedMonth={$receivedMonth}&receivedDay={$receivedDay}&receivedYear={$receivedYear}&releasedMonth={$releasedMonth}&releasedDay={$releasedDay}&releasedYear={$releasedYear}&branch={$branch}'\n</script>\n\n";

<?php

include "../../../myDatabase.php";
$username = $_GET['username'];
$companyNo = $_GET['companyNo'];
$companyName = $_GET['companyName'];
$ro = new database();
$ro->deleteNow("Company", "companyNo", $companyNo);
echo "\n<script type='text/javascript'>\nalert('{$companyName} is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/company.php?username={$username}';\n</script>\n\n";

<?php

include "../../../myDatabase.php";
$icdNo = $_GET['icdNo'];
$icdCode = $_GET['icdCode'];
$ro = new database();
$ro->deleteNow("patientICD", "icdNo", $icdNo);
echo "\n\n<script type='text/javascript'>\nalert('{$icdCode} is now Deleted');\n</script>\n\n";

<?php

include "../../../myDatabase.php";
$username = $_GET['username'];
$serviceNo = $_GET['serviceNo'];
$serviceName = $_GET['serviceName'];
$specialization = $_GET['specialization'];
$ro = new database();
$ro->deleteNow("DoctorService", "serviceNo", $serviceNo);
echo "\n\n<script type='text/javascript'>\nalert('The {$serviceName} in {$specialization} is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/doctorService.php?username={$username}';\n</script>\n\n";

<?php

include "../../myDatabase.php";
$labNo = $_GET['labNo'];
$description = $_GET['description'];
$ro = new database();
$ro->deleteNow("laboratoryResults", "labNo", $labNo);
$ro->deleteNow("laboratoryResultsValue", "labNo", $labNo);
echo "\n\n<script type='text/javascript'>\nalert('{$description} Results is now Deleted');\n</script>\n\n";

<?php

include "../../myDatabase.php";
$noteNo = $_GET['noteNo'];
$noteType = $_GET['noteType'];
$registrationNo = $_GET['registrationNo'];
$ro = new database();
$ro->deleteNow("patientNotes", "noteNo", $noteNo);
echo "\n\n<script type='text/javascript'>\nalert('Successfully Deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/patientNotes/viewNote.php?noteType={$noteType}&registrationNo={$registrationNo}&username=';\n</script>\n\n";

<?php

include "../../../myDatabase.php";
$patientNo = $_GET['patientNo'];
$lastName = $_GET['lastName'];
$firstName = $_GET['firstName'];
$middleName = $_GET['middleName'];
$username = $_GET['username'];
$show = $_GET['show'];
$desc = $_GET['desc'];
$ro = new database();
$ro->deleteNow("patientRecord", "patientNo", $patientNo);
$ro->deleteNow("registrationDetails", "patientNo", $patientNo);
echo "\n<script type='text/javascript'>\nalert('All Records of {$lastName} {$firstName} {$middleName} is now totally deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/patientRecord.php?username={$username}&show={$show}&desc={$desc}';\n</script>\n\n";

<?php

include "../../../myDatabase.php";
$reconcileNo = $_GET['reconcileNo'];
$registrationNo = $_GET['registrationNo'];
$ro = new database();
$ro->deleteNow("phicReconcile", "reconcileNo", $reconcileNo);
echo "\n<script language='javascript' type='text/javascript'>\nfunction closeWindow() {\nwindow.open('','_parent','');\nwindow.close();\n}\n</script> \n";
echo "<Br><Br><Br>";
echo "<a href='javascript:closeWindow();' style='text-decoration:none; color:red;'>CLOSE</a>";

<?php

include "../../myDatabase1.php";
$packageNo = $_GET['packageNo'];
$packageName = $_GET['packageName'];
$ro = new database();
$ro->deleteNow("hospitalPackage", "packageNo", $packageNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/hospitalPackage/showAddedPackage_update.php?packageName={$packageName}");

<?php

include "../../myDatabase.php";
$radioNo = $_GET['radioNo'];
$description = $_GET['description'];
$ro = new database();
$ro->deleteNow("radiologyResults", "radioNo", $radioNo);
echo "\n\n<script type='text/javascript'>\nalert('{$description} Results is now Deleted');\n</script>\n\n";

<?php

include "../../../myDatabase.php";
$limitNo = $_GET['limitNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database();
$ro->deleteNow("patientCreditLimit", "limitNo", $limitNo);
echo "<script type='text/javascript' >";
echo "window.location='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/creditLimit/viewCreditLimit.php?username={$username}&registrationNo={$registrationNo}' ";
echo "</script>";