public static function getActiveCSS() { $db = dbConnect::getReadOnly(); $query = "SELECT * FROM CSSTemplates WHERE ActiveState=1;"; $results = mysqli_query($db, $query); $row = mysqli_fetch_assoc($results); $activeCSSTemplate = new self($row); dbConnect::closeConnection($db); return $activeCSSTemplate; }
public function execute($sql) { $exe = mysql_query($sql, $this->_connAccess->getConnection()); if (!$exe) { exit('Error : ' . mysql_error() . ':' . $sql); } else { return $exe; dbConnect::closeConnection(); } }
public static function getContentArea() { $db = dbConnect::getReadOnly(); $query = "SELECT * FROM ContentAreas;"; $results = mysqli_query($db, $query); while ($row = mysqli_fetch_assoc($results)) { $contentAreas[] = new self($row); } //end while dbConnect::closeConnection($db); return $contentAreas; }
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(); }
public static function getAllPages($_alias) { $db = dbConnect::getReadOnly(); $query = "SELECT * FROM SitePages;"; $result = mysqli_query($db, $query); while ($row = mysqli_fetch_assoc($result)) { $pages[] = new self($row); } //end while dbConnect::closeConnection($db); return $pages; }
public static function getArticle($_area, $_page) { $db = dbConnect::getReadOnly(); $query = "SELECT * FROM Articles WHERE (Page='{$_page}' OR AllPages=1) AND ContentArea = '{$_area}';"; $result = mysqli_query($db, $query); while ($row = mysqli_fetch_assoc($result)) { $articleArray[] = new self($row); } //end while dbConnect::closeConnection($db); return $articleArray; }
<html> <head> <h1>Content Area Created:</h1> </head> <body> <?php include_once "../DataAccess/dbConnect.php"; $db = dbConnect::getContentAreaConnection(); $name = mysqli_real_escape_string($db, $_POST['Name']); $alias = mysqli_real_escape_string($db, $_POST['Alias']); $order = mysqli_real_escape_string($db, $_POST['Order']); $description = mysqli_real_escape_string($db, $_POST['Description']); $query = "INSERT INTO ContentAreas (Name, Alias, ContentAreas.Order, Description, CreatedBy) "; $query .= "VALUES ('{$name}', '{$alias}', '{$order}', '{$description}', 1)"; $result = mysqli_query($db, $query); if (!$result) { die('Unable to insert Content Area into CMS Database.'); } ?> <p>Successfully Inserted <?php echo mysqli_affected_rows($db); ?> record.</p> <?php dbConnect::closeConnection($db); ?> <a href="../Presentation/manageContentAreas.php">Back to Manage Content Areas page</a> </body> </html>