public function getAverageSalary() { // I am using javascript to validate on the client side, but I am validating on the server side too just in case if (empty($_GET["name"])) { echo "Search string is required"; return false; } else { $name = test_input(cleanGet($_GET)); //echo $name; //exit; //$name = test_input($_GET["name"]); if (preg_match("/^[a-zA-Z ]*\$/", $name)) { echo "The search string is O.K. Look here for the results <br>"; //exit; } else { echo "Model1.php says Only letters and white space allowed"; exit; } } // again, I could have used curl to get the JSON data, but just keeping it simple $this->response = file_get_contents('https://data.cityofboston.gov/resource/4swk-wcg8.json'); $this->response = json_decode($this->response); // now, this just loops through the returned object foreach ($this->response as $num => &$values) { // gets the object properties $thevals = get_object_vars($values); // assign property values to variables $searchstring = $name; $mystring1 = $thevals['title']; $mystring2 = $thevals['title']; $pos1 = stripos($mystring2, $searchstring); // Note our use of ===. Simply == would not work as expected // because the positional issues of the 0th (first) character per api documentation. if ($pos1 !== false) { echo "Found '{$searchstring}' in '{$mystring2}' ==> \$" . $thevals['total_earnings'] . "<br>"; $totalrows++; $sum += $thevals['total_earnings']; } } //calculate the average salary if ($totalrows > 0) { $average = $sum / $totalrows; // report back earnings information as required echo "<br>The Grand Total Salary for the " . $searchstring . " positions-> is : " . money_format('%i', $sum) . "<br>"; echo "The total rows is : " . $totalrows . "<br>"; echo "The Average salary for the " . $searchstring . " position based on Total Earnings is Grand Total Salary: " . money_format('%i', $sum) . " divided by total number of records " . $totalrows . " = " . money_format('%i', $average) . "<br>"; return 1; } else { // no data found, the program will return to the start page, but inform the user. The message may be visible on a slower system. echo "Sorry no data found for: " . $searchstring . "<br>"; return 0; } }
editWebsiteMenuDeleteItem($mitemid, $siteid); } else { demoMsg(); } } elseif (isset($_GET['medit'])) { $mitemid = cleanGet($_GET['medit']); editMenuNameEditForm($siteid, $mitemid); $showmenu = false; } elseif (isset($_GET['up'])) { $mitemid = cleanGet($_GET['up']); editWebsiteMenuOrder($siteid, $mitemid, 'up'); } elseif (isset($_GET['down'])) { $mitemid = cleanGet($_GET['down']); editWebsiteMenuOrder($siteid, $mitemid, 'down'); } elseif (isset($_GET['addpage']) && isset($_POST['page_title']) && strlen($_POST['page_title']) > 1) { $page_title = cleanGet($_POST['page_title']); if (isActive($userid)) { if (maxSitePages($siteid) == false) { addPage($siteid, $page_title); } else { sysMsg(MSG00119); } } else { demoMsg(); } } elseif (isset($_GET['changetitle']) && isset($_POST['old_page_id'])) { $pageid = cleanPost($_POST['old_page_id']); $title = cleanPost($_POST['new_page_title']); if (isActive($userid)) { changePageTitle($pageid, $title); } else {
*** Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *** *** *** *** See COPYRIGHT.php for more information. *** *** See LICENSE.php for more information. *** *** *** *** www.joomlaxtc.com *** *** *** ************************************************************************************ ***********************************************************************************/ // This program Builds CSS style cascade define('_XTCFRAMEWORK', 1); require 'XTC.php'; $templateParameters = xtcLoadParams(); // Get params for this template $group = cleanGet('group'); $file = basename(cleanGet('file')); if ($group && isset($templateParameters->group->{$group})) { $params = $templateParameters->group->{$group}; $file .= '.css'; } else { $params = $templateParameters; } $imgpath = $xtc->templateUrl . 'images'; header('Content-type: text/css'); if ($xtc->CSScompression) { ob_start(); ob_implicit_flush(0); } if (is_readable($xtc->templatePath . '/css/' . $file)) { require $xtc->templatePath . '/css/' . $file; }
function regHiddenRepeat($varname, $default = '') { $val = cleanGet($varname, $default, false); regHidden($varname, $default); }
// * GNU General Public License for more details. * // * * // * You should have received a copy of the GNU General Public License * // * along with this program. If not, see <http://www.gnu.org/licenses/>. * // * * // ************************************************************************* session_start(); if (!isset($_SESSION['userid'])) { header("Location: index.php"); } include_once 'functions/functions.php'; include_once 'functions/preview_functions.php'; $userid = checkSession(); $siteid = checkSiteId(); //BEGIN PREVIEW if ($siteid != 0) { if (isset($_GET['preview']) && is_numeric($_GET['preview']) && $_GET['preview'] > '0') { $pwpage = cleanGet($_GET['preview']); } else { $pwpage = 0; } $_SESSION['website'] = $siteid; if ($pwpage > 0) { showWebsitePreview($siteid, $pwpage); } else { showWebsitePreview($siteid, NULL); } } else { giveWarning(); } //END PREVIEW
// * along with this program. If not, see <http://www.gnu.org/licenses/>. * // * * // ************************************************************************* session_start(); if (!isset($_SESSION['userid'])) { header("Location: index.php"); } include_once 'functions/functions.php'; include_once 'functions/page_functions.php'; $userid = checkSession(); $siteid = checkSiteId(); include_once 'admin_template/header.php'; //START PAGES if ($siteid != 0) { if (isset($_GET['pages']) && is_numeric($_GET['pages']) && $_GET['pages'] > '0') { $pageid = cleanGet($_GET['pages']); if (pageBelongsTo($pageid, $siteid) == false) { $pageid = NULL; } elseif (isset($_POST['TextAreaData'])) { $page = array(); $page['id'] = cleanPost($_POST['id']); $page['content'] = $_POST['TextAreaData']; if (!isContactPage($page['id'])) { if (isActive($userid)) { savePage($page); // $_POST['TextAreaData'] = NULL; // $page['content'] = NULL; } else { demoMsg(); } }
if (!isset($_SESSION['userid'])) { header("Location: index.php"); } if (isset($_GET['items_per_page'])) { if (is_numeric($_GET['items_per_page'])) { $_SESSION['items_per_page'] = $_GET['items_per_page']; } } include_once 'functions/functions.php'; include_once 'functions/template_functions.php'; $userid = checkSession(); $siteid = checkSiteId(); include_once 'admin_template/header.php'; if ($siteid != 0) { if (isset($_GET['action'])) { $taction = cleanGet($_GET['action']); if ($taction == 'save' && isset($_POST['website_template'])) { $template = cleanPost($_POST['website_template']); if (isActive($userid)) { saveWebsiteTemplate($siteid, $template); } else { demoMsg(); } } } if (isset($_GET['tview']) && is_numeric($_GET['tview'])) { $view = $_GET['tview']; } else { $view = 0; } $_SESSION['website'] = $siteid;
function cleanPost($post_data) { if (!$post_data == NULL) { return cleanGet($post_data); } else { return ''; } }
function xtcLoadParams($style = 0) { // Load raw params*.ini file and returns param object (also set on $GLOBALS) // public parameters on URL or cookie will override template parameters $xtc =& $GLOBALS['xtc']; if (empty($style)) { $app = JFactory::getApplication(); $template = $app->getTemplate(true); if (!isset($template->id)) { $db = JFactory::getDbo(); $query = $db->getQuery(true)->select('id')->from('#__template_styles')->where('client_id=0 AND home=1'); $db->setQuery($query); $template->id = $db->loadResult(); } $style = $template->id; } // Get cookie variables array $cookieName = $xtc->template . 'Template'; $cookie = array(); if ($xtc->publicParams) { // there are public parameters, cookie them! if (isset($_COOKIE[$cookieName])) { $cookie = unserialize(base64_decode($_COOKIE[$cookieName])); } if (!$cookie) { $cookie = array(); } foreach ($xtc->publicParams as $parm) { $value = cleanGet($parm); if ($value) { // We have a URL override $cookie[$parm] = $value; } } if (!empty($cookie) || $xtc->clearCookie) { // Save/clear cookie if not empty $lifespan = $xtc->clearCookie ? time() - 3600 : time() + $xtc->cookieLifespan; setcookie($cookieName, base64_encode(serialize($cookie)), $lifespan, '/'); /* expire in 1 year */ } } // Build parameter object $obj = new stdClass(); $obj->group = new stdClass(); $obj->prefix = array(); $obj->groups = array(); // Parse parameters file $parameterFile = $xtc->templatePath . '/params_' . $style . '.ini'; if (!is_readable($parameterFile)) { $data = xtcMakeParams($style); } else { $data = file($parameterFile); } foreach ($data as $rec) { $rec = trim($rec); $pos = strpos($rec, '='); if ($pos === false) { continue; } $parm = substr($rec, 0, $pos); $value = stripcslashes(substr($rec, $pos + 1)); if (substr($parm, 0, 1) == '{') { // XTC-formed parm $pos = strpos($parm, '}'); $group = substr($parm, 1, $pos - 1); @(list($prefix, $group) = explode('+', $group)); $parm = substr($parm, $pos + 1); if (!isset($obj->group->{$group})) { $obj->group->{$group} = new stdClass(); $obj->prefix[$group] = $prefix; $obj->groups[] = $group; } } else { // No group $group = ''; } if (array_key_exists($parm, $cookie)) { //echo "override [$parm] [$value] [".$cookie[$parm]."]"; $value = $cookie[$parm]; // Override with value on cookie parm, if present } if ($group) { // It's from a group $obj->group->{$group}->{$parm} = $value; } else { $obj->{$parm} = $value; } //echo "parm: [$group][$parm][$value]<br>"; } // Update XTC object with style ID and XTC parameters $xtc->style = $style; if (isset($obj->CSSmode)) { $xtc->CSSmode = $obj->CSSmode; } // CSS mode: 1 = Single file, 2 = Separate files, 3 = Embedded in head if (isset($obj->CSScompression)) { $xtc->CSScompression = $obj->CSScompression; } // CSS compression 0 = off, 1 = on if (isset($obj->cookieLifespan)) { $xtc->cookieLifespan = $obj->cookieLifespan; } // Cookie lifespan in seconds if (isset($obj->clearCookie)) { $xtc->clearCookie = $obj->clearCookie; } // Clears cookie on every page load if (isset($obj->publicParams)) { $xtc->publicParams = array_map('trim', explode(',', $obj->publicParams)); } // Public parameters if (isset($obj->showComponents)) { $xtc->showComponents = explode('|', $obj->showComponents); } // Frontpage components $GLOBALS['templateParameters'] =& $obj; return $obj; }
function changePageTitle($pageid, $title) { $page = array(); $page['page_title'] = $title; $db = Database::obtain(); $db->update(TABLE_PAGES, $page, "id=" . $pageid . ""); $siteid = cleanGet($_GET['website']); $menu = getMenu($siteid); foreach ($menu as $id => $page) { if ($page['pageid'] == $pageid) { $menu[$id]['title'] = $title; } } saveWebsiteMenu($siteid, $menu); sysMsg(MSG00124); }