protected function _getQuery() { if (!$this->_query) { $this->_conn = dbConnect::getConnection(); $this->_query = mysql_query($this->_sql, $this->_conn); if (!$this->_query) { print 'Error : ' . mysql_error() . ' ' . $this->_sql; } } return $this->_query; dbConnect::closeConnection(); }
<?php session_start(); if (!isset($_SESSION['myusername'])) { header("location:../Presentation/main_login.php"); } if ($_SESSION['editor'] == 0 && $_SESSION['allaccess'] == 0) { header("location:../Presentation/main_login.php"); } include_once "../DataAccess/dbConnect.php"; $db = dbConnect::getConnection(); $templateid = mysqli_real_escape_string($db, $_POST['CSSID']); $query = "UPDATE CSSTemplates SET ActiveState = 0 WHERE ActiveState = 1"; $result = mysqli_query($db, $query); $query = "UPDATE CSSTemplates SET ActiveState = 1 WHERE CSSTemplates_ID = '{$templateid}'"; $result = mysqli_query($db, $query); ?> <p>Successfully Activated <?php echo mysqli_affected_rows($db); ?> records.</p> <a href="../Presentation/manageTemplates.php">Back to Manage CSS Templates page</a>