function HandleMoveNode() { define("CMD_MOVE_CATEGORY", <<<SQL \t\tUPDATE site_categories SET our_category_id = ? WHERE id = ? SQL ); define("CMD_MOVE_ITEM", <<<SQL \t\tUPDATE items SET our_category_id = ?, mdate = NOW() WHERE id = ? SQL ); global $db; $srcNodes = explode(",", $_REQUEST["srcNodes"]); foreach ($srcNodes as $nodeStr) { list($nodeId, $nodeType) = explode(":", $nodeStr); if ($nodeType == NODE_SITE_CATEGORY) { $res =& $db->query(CMD_MOVE_CATEGORY, array($_REQUEST["destNodeId"], $nodeId)); if (PEAR::isError($res)) { printError($res); exit; } } else { if ($nodeType == NODE_SITE_ITEM) { $res =& $db->query(CMD_MOVE_ITEM, array($_REQUEST["destNodeId"], $nodeId)); if (PEAR::isError($res)) { printError($res); exit; } } } } }
function do_page() { handleActions(); printError(); printAddCardSet(); printChangePasswordForm(); }
function retrieveOrder($resultT, $db) { $row = $resultT->FetchRow(); $name = $row['name']; $customerId = $row['customerId']; $phone = htmlentities($_GET['phone'], ENT_QUOTES); //BRIDGE TABLE $query1 = "select * from customerToOrder where customerId ='{$customerId}'"; $result1 = $db->Execute($query1); if (!$result1) { printError(); return; } //PIZZA ORDER TABLE $row1 = $result1->FetchRow(); $orderId = $row1['orderId']; $query2 = "select * from pizzaOrder where orderId ='{$orderId}'"; $result2 = $db->Execute($query2); if (!$result2) { printError(); return; } $row2 = $result2->FetchRow(); $toppings = $row2['toppingId']; $size = $row2['sizeId']; showOrderForm($phone, $name, $toppings, $size); }
function getTableFromStmt($stmt) { global $db; $results = $stmt->fetchAll(PDO::FETCH_ASSOC); if (count($results) == 0) { printError("Keine Einträge vorhanden"); return false; } echo '<table>'; echo '<thead>'; echo '<tr>'; foreach ($results[0] as $key => $val) { echo '<th>' . $key . '</th>'; } echo '</tr>'; echo '</thead>'; echo '<tbody>'; foreach ($results as $arr) { echo '<tr>'; foreach ($arr as $val) { echo '<td>' . $val . '</td>'; } echo '</tr>'; } echo '</tbody>'; echo '</table>'; }
function se_search($params, &$smarty) { $keyword = isset($params['keywords']) ? $params['keywords'] : 'null'; $modifytext = isset($params['modifytext']) ? $params['modifytext'] : true; $modifyscore = isset($params['modifyscore']) ? $params['modifyscore'] : true; /* library */ require dirname(__FILE__) . SLASH . 'include/lib.searchengine.php'; $result_search_engine = query_search_engine($keyword); if ($result_search_engine === false) { printError(); return; } $iScoreMax = $result_search_engine[0]['score']; foreach ($result_search_engine as &$elem) { if ($modifyscore) { $pourcent = intval($elem['score'] * 100 / $iScoreMax); $elem['score'] = $pourcent; } if ($modifytext) { $elem['texte'] = substr(strongText($elem['texte'], $keyword), 0, 400) . ' ...'; $elem['nom'] = strongText($elem['nom'], $keyword); } } $smarty->assign('RESULT_SEARCH_SIZE', sizeof($result_search_engine)); $smarty->assign('RESULT_SEARCH', $result_search_engine); //return true; }
public function indexAction() { $model = new SettingsModel(); $form = Call::form('Index'); $countrysList = $model->getCountryList(); if (isPost()) { if ($form->isValid(allPost()) and (isset($form->data["email"]) or isset($form->data["password"]) and isset($form->data["password1"]))) { if (Request::getParam('user')->password == md5($form->data['password'])) { $data = []; if ($form->data['password1'] != '') { $data['password'] = md5($form->data['password1']); } if (isset($form->data['email'])) { $data['email'] = $form->data["email"]; } if ($form->data['news'] == 1) { $data['newsletter'] = $form->data["news"]; } $model->setSettings(Request::getParam('user')->id, $data); redirect(url('settings')); } } else { $this->view->error = printError($form->error, 'INDEX_ERROR_'); } } $this->view->countrysList = $countrysList; $this->view->title = Lang::translate('INDEX_TITLE'); }
function do_page() { handleActions(); $player_series = Player::getSessionPlayer()->stewardsSeries(); if (count($player_series) == 0) { printNoSeries(); return; } if (isset($_POST['series'])) { $_GET['series'] = $_POST['series']; } if (!isset($_GET['series'])) { $_GET['series'] = $player_series[0]; } $active_series_name = $_GET['series']; if (count($player_series) > 1) { printStewardSelect($player_series, $active_series_name); } else { echo "<center> Managing {$active_series_name} </center>"; } $active_series = new Series($active_series_name); printError(); printSeriesForm($active_series); printLogoForm($active_series); printRecentEventsTable($active_series); printPointsForm($active_series); printStewardsForm($active_series); }
function HandleRemoveNode() { define("CMD_SEL_MOVED_SITECATEGORIES_IDS", <<<SQL \t\tSELECT id FROM site_categories WHERE our_category_id = ? SQL ); define("CMD_SEL_MOVED_ITEMS_IDS", <<<SQL \t\tSELECT id FROM items WHERE our_category_id = ? SQL ); define("CMD_DEL_OURSITE_CATEGORY", <<<SQL \t\tDELETE FROM our_categories WHERE id = ? SQL ); define("CMD_SEL_SUBCATEGORIES_IDS", <<<SQL \t\tSELECT id FROM our_categories WHERE parent_id = ? ORDER BY id SQL ); define("CMD_DEL_CATEGORY_FROMNEW", <<<SQL \t\tUPDATE site_categories SET our_category_id = 0 WHERE id = ? SQL ); define("CMD_DEL_ITEM_FROMNEW", <<<SQL \t\tUPDATE items SET our_category_id = 0 WHERE id = ? SQL ); global $db; $srcNodes = explode(",", $_REQUEST["destNodes"]); foreach ($srcNodes as $nodeStr) { list($nodeId, $nodeType) = explode(":", $nodeStr); // Удаление скопированного узла или элемента if (strlen($nodeType) > 0) { if ($nodeType == NODE_SITE_CATEGORY) { $res =& $db->query(CMD_DEL_CATEGORY_FROMNEW, array($nodeId)); if (PEAR::isError($res)) { printError($res); exit; } } else { if ($nodeType == NODE_SITE_ITEM) { $res =& $db->query(CMD_DEL_ITEM_FROMNEW, array($nodeId)); if (PEAR::isError($res)) { printError($res); exit; } } else { if ($nodeType == NODE_SITE_OURITEM) { $res =& $db->query("DELETE FROM our_items WHERE id = ?", array($nodeId)); if (PEAR::isError($res)) { printError($res); exit; } } } } } else { removeNodeWithChilds($nodeId); } } }
function HandleViewSite() { define("CMD_SEL_ITEMSCOUNT", <<<SQL \t\tSELECT count(*) FROM items \t\t\tWHERE category_id = ? AND our_category_id = 0 \t\t\tORDER BY status DESC, mdate DESC SQL ); define("CMD_SEL_SITECATEGORIES", <<<SQL \t\tSELECT * FROM site_categories \t\t\tWHERE site_id = ? AND our_category_id = 0 SQL ); global $db; $res =& $db->query(CMD_SEL_SITECATEGORIES, array($_REQUEST["siteId"])); if (PEAR::isError($res)) { printError($res); exit; } $categories = array(); while ($row = $res->fetchRow(DB_FETCHMODE_OBJECT)) { $catCount =& $db->getOne(CMD_SEL_ITEMSCOUNT, array($row->id)); if (PEAR::isError($catCount)) { $catCount = 0; } $state = null; if ((int) $catCount > 0) { $state = "collapsed"; } $customAttrs = array("siteId" => $_REQUEST["siteId"]); $categories[] = array("nodeId" => $row->id, "name" => $row->name, "state" => $state, "tp" => NODE_SITE_CATEGORY, "image" => getCategoryImageState($row), "customAttrs" => $customAttrs); } printTree($categories, true, true, "TreeCategories"); print "<span id=\"siteId\" siteIdNum=\"" . $_REQUEST["siteId"] . "\" style=\"display: none;\"></span>"; }
public function newEDT($data) { if (!$this->isPatient($data['pid']) || !checkFilled($data) || !verifyDate($data['dateperf']) || !checkNumber($data['cost']) || !checkNumber($data['duration']) || !checkNumber($data['pid'])) { return false; } // Verify the physicians mentioned are valid $a = new Admin(); $physicians = $a->getAllPhysicians(); $enames = explode(',', $data['enames']); foreach ($enames as $e) { if (!array_search(trim($e), $physicians)) { printError("A physician specified in the Physician Names field does not exist."); return false; } } $success = true; $pid = $data['pid']; unset($data['pid']); $newEDT = 0; if (!$this->dbh->insert('EDTRecords', $data)) { $success = false; } else { $result = $this->dbh->query('SELECT MAX(edtid) AS last FROM EDTRecords'); $newEDT = $result[0]['last']; // Could potentially be bad, if the ordering of insertions between users interferes } if (!$this->dbh->insert('PatientExaminations', array('pid' => $pid, 'edtid' => $newEDT))) { $success = false; } return $success; }
function HandleAddItem() { define("CMD_ADD_OURITEM", <<<SQL \t\tINSERT INTO our_items (name, our_category_id, art, mdate) \t\t\tVALUES (?, ?, ?, NOW()) SQL ); define("CMD_SEL_OURITEM_NEWID", <<<SQL \t\tSELECT id FROM our_items \t\t\tWHERE name = ? AND our_category_id = ? AND art = ? SQL ); global $db; $newItem = iconv("UTF-8", "windows-1251", urldecode($_REQUEST["itemName"])); $art = "art" . $_REQUEST["parentNodeId"] . "_" . time(); $res =& $db->query(CMD_ADD_OURITEM, array($newItem, $_REQUEST["parentNodeId"], $art)); if (PEAR::isError($res)) { printError($res); exit; } $newId =& $db->getOne(CMD_SEL_OURITEM_NEWID, array($newItem, $_REQUEST["parentNodeId"], $art)); if (PEAR::isError($newId)) { printError($newId); exit; } // ¬озвратить номер добавленой категории print trim($newId); }
function HandleAddNode() { define("CMD_ADD_OURSITE_CATEGORY", <<<SQL \t\tINSERT INTO our_categories (name, parent_id) VALUES (?, ?) SQL ); define("CMD_SEL_OURSITE_NEWCATEGORYID", <<<SQL \t\tSELECT id FROM our_categories WHERE name = ? AND parent_id = ? SQL ); global $db; $newCategory = iconv("UTF-8", "windows-1251", urldecode($_REQUEST["categName"])); $res =& $db->query(CMD_ADD_OURSITE_CATEGORY, array($newCategory, $_REQUEST["parentNodeId"])); if (PEAR::isError($res)) { printError($res); exit; } $newId =& $db->getOne(CMD_SEL_OURSITE_NEWCATEGORYID, array($newCategory, $_REQUEST["parentNodeId"])); if (PEAR::isError($newId)) { printError($newId); exit; } // ¬озвратить номер добавленой категории print trim($newId); }
function mysqlConnectDB($db) { $servername = "localhost"; $username = "******"; $password = "******"; $dbname = $db; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { printError(); } return $conn; }
function getParameter($name, array $argv) { $envName = 'GITLAB_' . preg_replace('/\\s|-/', '_', strtoupper($name)); if (isset($_ENV[$envName])) { return $_ENV[$envName]; } $pregName = preg_quote($name); array_shift($argv); foreach ($argv as $argument) { if (preg_match("/^--{$pregName}=(.+)/", $argument, $matches)) { return $matches[1]; } } printError("ERROR: Please provide the parameter --{$name} or set the environment variable {$envName}"); exit(1); }
function validateError() { if (isset($_GET["error"])) { $accion = $_GET["error"]; switch ($accion) { case 0: printError(0); break; case 1: printError(1); break; case 2: printError(2); break; default: break; } } }
function HandleItemFirstInfo() { global $db; if (!isset($_REQUEST["nodeType"])) { return; } if ($_REQUEST["nodeType"] != NODE_SITE_ITEM) { return; } // Вывод инфы для элемента источника $sql = "SELECT * FROM items WHERE id = ?"; $row =& $db->getRow($sql, array($_REQUEST["nodeId"]), DB_FETCHMODE_OBJECT); if (PEAR::isError($row)) { printError($row); exit; } $ITEM_ID = $_REQUEST["nodeId"]; $NOEDIT = true; $FIELDS = getViewFields($row->category_id); include "tpls/InfoItem.php"; }
function HandleSetStatus() { define("CMD_SET_STAT", <<<SQL \t\tUPDATE items SET status = ? WHERE id = ? SQL ); define("CMD_SET_STAT_OURITEM", <<<SQL \t\tUPDATE our_items SET status = ? WHERE id = ? SQL ); define("CMD_SET_STAT_OURCAT", <<<SQL \t\tUPDATE our_categories SET status = ? WHERE id = ? SQL ); global $db; require_once "../includes/JSON.php"; $json = new Services_JSON(); if (get_magic_quotes_gpc()) { $_REQUEST["nodes"] = stripslashes($_REQUEST["nodes"]); } $data = $json->decode($_REQUEST["nodes"]); $res = null; $maxIndex = sizeof($data) - 1; foreach ($data as $i => $node) { if ($node->tp == NODE_SITE_ITEM) { $res = $db->query(CMD_SET_STAT, array($maxIndex - $i, $node->id)); } else { if ($node->tp == NODE_SITE_OURITEM) { $res = $db->query(CMD_SET_STAT_OURITEM, array($maxIndex - $i, $node->id)); } else { $res = $db->query(CMD_SET_STAT_OURCAT, array($maxIndex - $i, $node->id)); } } if (PEAR::isError($res)) { printError($res); exit; } } }
function checkSystem() { global $messagem, $def; $language = array("pt", "es", "en", "fr"); $diretory = array("xml", "html", "ini"); if (!is_dir($def['SITE_PATH'])) { $cause = $message["invalid_dir"] . $def['SITE_PATH']; printError($cause, $message["check_def"]); return false; } foreach ($language as $lang) { foreach ($diretory as $dir) { $dir_path = $def['DATABASE_PATH'] . $dir . "/" . $lang . "/"; if (!is_writeable($dir_path)) { $cause = $message["invalid_perm"] . $dir_path; printError($cause, $message["check_perm"]); return false; } } } return true; }
function HandleExpand() { global $db; if ($_REQUEST["treeId"] == "TreeCategories") { $res =& $db->query(CMD_SEL_ITEMS, array($_REQUEST["nodeId"])); if (PEAR::isError($res)) { printErr($res); exit; } $items = array(); while ($row =& $res->fetchRow(DB_FETCHMODE_OBJECT)) { $customAttrs = array("categId" => $row->category_id); $items[] = array("nodeId" => $row->id, "name" => $row->art . " - " . $row->name, "state" => "item", "tp" => NODE_SITE_ITEM, "image" => getImageState($row), "customAttrs" => $customAttrs); } printTree($items, false); } else { if ($_REQUEST["treeId"] == "TreeOurSite") { $res =& $db->query(CMD_SEL_SUBCATEGORIES, array($_REQUEST["nodeId"])); if (PEAR::isError($res)) { printError($res); exit; } $categories = array(); while ($row =& $res->fetchRow(DB_FETCHMODE_OBJECT)) { $catCount = getItemsCount($row->id); $state = null; if ($catCount > 0) { $state = "collapsed"; } $imgState = $row->viewmode == true ? "pics/ourcategoryHidden.png" : "pics/ourcategory.png"; $categories[] = array("nodeId" => $row->id, "name" => $row->name, "state" => $state, "image" => $imgState); } addMovedItems($categories, $_REQUEST["nodeId"]); printTree($categories, false); } } }
$testClient->markReadyForPickup($orderId); printSuccess(); printTitle('mark-delivered'); $testClient->markDelivered($orderId); printSuccess(); printTitle('cancel'); $cancelOrderItems = [new \SlevomatZboziApi\Request\CancelOrderItem('787887454', 1), new \SlevomatZboziApi\Request\CancelOrderItem('7844544', 2)]; $testClient->cancelOrder($orderId, $cancelOrderItems, 'Duvod storna'); printSuccess(); } catch (\SlevomatZboziApi\Request\ConnectionErrorException $e) { printError(sprintf('%s %s', $e->getMessage(), $e->getPrevious()->getMessage())); //retry request } catch (\SlevomatZboziApi\Request\InvalidRequestException $e) { printError($e->getMessage(), 'red', 'REQUEST ERROR: '); //fix error } catch (\SlevomatZboziApi\ZboziApiException $e) { printError($e->getMessage()); //retry request } function printError($message, $color = 'orangered', $startWith = '') { echo sprintf('<br><b style="color: %s">%s%s</b><hr>', $color, $startWith, $message); } function printSuccess($additionalInfo = '') { echo sprintf('<br><b style="color: green"> OK%s</b><hr>', $additionalInfo); } function printTitle($title) { echo sprintf('<br><b style="background-color: darkslategray; color: white; padding: 5px">%s</b><br>', $title); }
function checkNumber($field) { if (!is_numeric($field)) { printError("Please ensure you input numbers in the appropriate fields (cost, patient ID, duration, etc)"); return false; } return true; }
if ($strSiteUrl != SITE_URL) { printFatalError(sprintf(_(' Site Url is: %s, while it should be %s. Please change it in the web site config file: %s'), SITE_URL, $strSiteUrl, $configFile->getRelativePath())); } echo "[ OK ]\n"; echo _('Checking url rewriting ....'); $oFile = new PFile(SITE_PATH . '.htaccess'); if (!is_file($oFile->path)) { echo "[ !!!! WARNING !!!! ]\n"; echo _('No .htaccess file has been found, you should rename the htaccess.txt file in .htaccess to active the url rewriting'); } else { //check the rewrite base match with the SITE_URL $strContent = file_get_contents($oFile->path); if (!preg_match('/(RewriteBase)([^\\n]*)/', $strContent, $tabMatch)) { printError('Can not find the rewritebase'); } else { $strBase = trim($tabMatch[2]); if ($strBase != SITE_URL) { printFatalError(sprintf(_('RewriteBase is: %s, while it should be %s. Please change it int the .htaccess file. '), $strBase, SITE_URL)); } } echo "[ OK ]"; } echo ' ############################################################################### Your installation seems to be good. You should now remove the ' . basename(__FILE__) . ' file to access your web site.
$response = $client ->track($request); if ($response -> HighestSeverity != 'FAILURE' && $response -> HighestSeverity != 'ERROR'){ if($response->HighestSeverity != 'SUCCESS'){ echo '<table border="1">'; echo '<tr><th>Track Reply</th><th> </th></tr>'; trackDetails($response->Notifications, ''); echo '</table>'; }else{ if ($response->CompletedTrackDetails->HighestSeverity != 'SUCCESS'){ echo '<table border="1">'; echo '<tr><th>Shipment Level Tracking Details</th><th> </th></tr>'; trackDetails($response->CompletedTrackDetails, ''); echo '</table>'; }else{ echo '<table border="1">'; echo '<tr><th>Package Level Tracking Details</th><th> </th></tr>'; trackDetails($response->CompletedTrackDetails->TrackDetails, ''); echo '</table>'; } } printSuccess($client, $response); }else{ printError($client, $response); } writeToLog($client); // Write to log file } catch (SoapFault $exception) { printFault($exception, $client); } ?>
#!/bin/php <?php /* * This file is part of fgrosse/gitlab-api. * * Copyright © Friedrich Große <*****@*****.**> * * For the full copyright and license information, please view the LICENSE * file that was distributed with this source code. */ use Gitlab\Client\GitlabGuzzleClient; use Gitlab\Client\HttpGitlabClient; include __DIR__ . '/../vendor/autoload.php'; include __DIR__ . '/cli_helper.php'; $baseUrl = getParameter('base-url', $argv); $token = getParameter('token', $argv); $project = getParameter('project', $argv); try { $guzzleClient = GitlabGuzzleClient::factory(['base_url' => $baseUrl, 'api_token' => $token]); $client = new HttpGitlabClient($guzzleClient); $mergeRequests = $client->listMergeRequests($project, $state = 'closed', $order = 'updated_at', $sort = 'asc', $page = 1, $perPage = 5); foreach ($mergeRequests as $mergeRequest) { echo $mergeRequest . PHP_EOL; } } catch (Exception $exception) { printError('An Exception of type ' . get_class($exception) . ' occurred:'); printError($exception->getMessage()); exit(1); }
/** * output error * * @param $message */ function _outputError($message) { printError($this->name, $message); }
require dirname(__FILE__) . '/include/html/menu.php'; require dirname(__FILE__) . '/include/html/form/installation.php'; } exit - 1; } // --------------- CONFIGURATION --------------- if (!isset($_GET['admin'])) { if (isset($error) && $error == true) { printError('Login error'); } require dirname(__FILE__) . '/include/html/menu.php'; require dirname(__FILE__) . '/include/html/form/configuration.php'; } else { if (!isset($_SESSION['admin_id'])) { if (isset($error) && $error == true) { printError('Login error'); } require dirname(__FILE__) . '/include/html/menu.php'; require dirname(__FILE__) . '/include/html/form/login.php'; } else { ?> <nav class="navbar navbar-default"> <p class="navbar-text">Signed as <?php echo $_SESSION['admin_id']; ?> / <a class="navbar-link" href="index.php?logout" title="Logout ?">logout ?</a> </p> </nav> <?php
} ?> </select> </div> <div class="small-3 large-3 columns"> <input type="number" name="menge" placeholder="Menge" /> </div> <div class="small-3 large-3 columns"> <input type="submit" name="erfassen" value="Bestellen" class="button postfix" /> </div> </div> </form> </div> </div> <?php if (isset($_POST['erfassen'])) { // Bestellung erfassen $sql = "call lieferantenbestellung(?, ?);"; $stmt = $db->prepare($sql); $stmt->bindValue(1, (int) $_POST['artikel'], PDO::PARAM_INT); $stmt->bindValue(2, (int) $_POST['menge'], PDO::PARAM_INT); $stmt->execute(); if (!$stmt) { printError("Die Prozedur 'lieferantenbestellung' besteht nicht!"); } else { printSuccess("Die Bestellung wurde erfasst!"); } } ?> </div> </div>
} print "<a href=\"ViewComment.php?comment_table={$comment_table}&storyId=" . $follow_row["story_id"] . "&commentId=" . $follow_row["id"] . "&filter={$filter}&display={$display}\">" . $follow_row["subject"] . "</a> by " . getUserName($follow_row["writer"], $link) . " on " . $follow_row["date"] . "<br>\n"; if ($follow_row["childs"] > 0) { display_follow_up($follow_row["id"], $level + 1, $display, $filter, $link, $comment_table); } } } $scriptName = "ViewStory.php"; include "PHPprinter.php"; $startTime = getMicroTime(); // Check parameters $storyId = $HTTP_POST_VARS['storyId']; if ($storyId == null) { $storyId = $HTTP_GET_VARS['storyId']; if ($storyId == null) { printError($scriptName, $startTime, "Viewing story", "You must provide a story identifier!<br>"); exit; } } getDatabaseLink($link); $result = mysql_query("SELECT * FROM stories WHERE id={$storyId}") or die("ERROR: Query failed"); if (mysql_num_rows($result) == 0) { $result = mysql_query("SELECT * FROM old_stories WHERE id={$storyId}") or die("ERROR: Query failed"); $comment_table = "old_comments"; } else { $comment_table = "comments"; } if (mysql_num_rows($result) == 0) { die("<h3>ERROR: Sorry, but this story does not exist.</h3><br>\n"); } $row = mysql_fetch_array($result);
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <body> <?php $scriptName = "ViewUserInfo.php"; include "PHPprinter.php"; $startTime = getMicroTime(); $userId = $HTTP_POST_VARS['userId']; if ($userId == null) { $userId = $HTTP_GET_VARS['userId']; if ($userId == null) { printError($scriptName, $startTime, "Viewing user information", "You must provide an item identifier!<br>"); exit; } } getDatabaseLink($link); begin($link); $userResult = mysql_query("SELECT * FROM users WHERE users.id={$userId}", $link) or die("ERROR: Query failed"); if (mysql_num_rows($userResult) == 0) { commit($link); die("<h3>ERROR: Sorry, but this user does not exist.</h3><br>\n"); } printHTMLheader("RUBiS: View user information"); // Get general information about the user $userRow = mysql_fetch_array($userResult); $firstname = $userRow["firstname"]; $lastname = $userRow["lastname"]; $nickname = $userRow["nickname"]; $email = $userRow["email"]; $creationDate = $userRow["creation_date"]; $rating = $userRow["rating"];
break; // Do nothing // Do nothing default: printError("Nothing was done..."); } // ================================================== // Special cases // Process an individual EDT } elseif (array_key_exists('processEDT', $_GET) && $_GET['processEDT']) { $b = new Billing(); $t = new Treatment(); if ($b->processEDT($_GET['processEDT'])) { header('Location: index.php?billing&success=b'); } else { printError("Failed to process EDT record."); } // For first run of this HMS (index.php) } elseif ($_SERVER['QUERY_STRING'] == 'insertEmployees') { $db = new Database(); if ($db->query("SELECT sin FROM Employees")) { echo "<p class='notice'>This employee already exists.</p>"; } else { $employee = array('ename' => 'Emp1', 'sin' => 1337, 'address' => '1 Hello Wrld.'); $job = array('jname' => 'OB', 'jtype' => 'C'); if ($db->insert('Employees', $employee)) { echo "<p class='success'>Employee inserted</p>"; } else { echo "<p class='error'>Could not insert employee</p>"; } if ($db->insert('Jobs', $job)) {