File manager

File manager - Edit - /home/newsbmcs.com/public_html/play1/classes/Page.php

Back
<?php class Page { public $id = null; public $createdDate = null; public $slug = null; public $title = null; public $content = null; public $nl2br = 1; public $fields = ''; public $extra_fields = null; public function __construct( $data=array() ) { if ( isset( $data['id'] ) ) $this->id = (int) $data['id']; if ( isset( $data['createdDate'] ) ) $this->createdDate = (int) $data['createdDate']; if ( isset( $data['title'] ) ) $this->title = htmlspecialchars($data['title']); if ( isset( $data['content'] ) ) $this->content = $data['content']; if ( isset( $data['nl2br'] ) ) $this->nl2br = (int)$data['nl2br']; if ( isset($data['fields']) ) $this->fields = $data['fields']; if ( isset( $data['slug'] ) ) $this->slug = htmlspecialchars(strtolower(str_replace(' ', '-', $data["slug"]))); if(isset($data['extra_fields'])){ if(is_array($data['extra_fields'])){ $data['extra_fields'] = json_encode($data['extra_fields']); } $this->extra_fields = $data['extra_fields']; } } public function storeFormValues ( $params ) { // Store all the parameters $this->__construct( $params ); // Parse and store the publication date if ( isset($params['createdDate']) ) { $createdDate = explode ( '-', $params['createdDate'] ); if ( count($createdDate) == 3 ) { list ( $y, $m, $d ) = $createdDate; $this->createdDate = mktime ( 0, 0, 0, $m, $d, $y ); } } } public static function getById( $id ) { $conn = open_connection(); $sql = "SELECT , UNIX_TIMESTAMP(createdDate) AS createdDate FROM pages WHERE id = :id"; $st = $conn->prepare( $sql ); $st->bindValue( ":id", $id, PDO::PARAM_INT ); $st->execute(); $row = $st->fetch(); if ( $row ) return new Page( $row ); } public static function getBySlug( $slug ) { $conn = open_connection(); $sql = "SELECT , UNIX_TIMESTAMP(createdDate) AS createdDate FROM pages WHERE slug = :slug"; $st = $conn->prepare( $sql ); $st->bindValue( ":slug", $slug, PDO::PARAM_STR ); $st->execute(); $row = $st->fetch(); if ( $row ) return new Page( $row ); } public static function getList( $numRows=1000000 ) { $conn = open_connection(); $sql = "SELECT id, slug, title, fields, extra_fields, UNIX_TIMESTAMP(createdDate) AS createdDate FROM pages ORDER BY createdDate DESC LIMIT :numRows"; $st = $conn->prepare( $sql ); $st->bindValue( ":numRows", $numRows, PDO::PARAM_INT ); $st->execute(); $list = array(); while ( $row = $st->fetch() ) { $page = new Page( $row ); $list[] = $page; } $totalRows = $conn->query('SELECT count() FROM pages')->fetchColumn(); return ( array ( "results" => $list, "totalRows" => $totalRows ) ); } public static function getList2(int $amount = 1000, $sort = 'id DESC', int $page = 0, $count = true) { // Improvement for getList(), this function is work for pagination list // The $sort is disabled for now $conn = open_connection(); $sql = "SELECT id, createdDate, slug, title, fields, extra_fields FROM pages ORDER BY createdDate DESC LIMIT :amount OFFSET :page"; $st = $conn->prepare($sql); $st->bindValue( ":amount", $amount, PDO::PARAM_INT ); $st->bindValue( ":page", $page, PDO::PARAM_INT ); $st->execute(); $list = array(); while ($row = $st->fetch()) { $page = new Page($row); $page->createdDate = $row['createdDate']; // Fix bug $list[] = $page; } $totalRows = 0; if($count){ $totalRows = $conn->query('SELECT count() FROM pages')->fetchColumn(); } else { $totalRows = count($list); } $totalPages = 0; if (count($list)) { $totalPages = ceil($totalRows / $amount); } return (array( "results" => $list, "totalRows" => $totalRows, "totalPages" => $totalPages )); } public function getExtraField($key) { if($this->extra_fields != null){ $fields = json_decode($this->extra_fields, true); if(isset($fields[$key])){ return $fields[$key]; } } return null; } public function get_fields() { if($this->fields != ''){ return json_decode($this->fields, true); } else { return null; } } public function get_field($key) { if($this->fields != ''){ $fields = json_decode($this->fields, true); if(isset($fields[$key])){ return $fields[$key]; } else { return null; } } else { return null; } } public function insert() { if ( !is_null( $this->id ) ) trigger_error ( "Page::insert(): Attempt to insert an Page object that already has its ID property set (to $this->id).", E_USER_ERROR ); $conn = open_connection(); $sql = "INSERT INTO pages ( createdDate, title, content, nl2br, slug, extra_fields ) VALUES ( FROM_UNIXTIME(:createdDate), :title, :content, :nl2br, :slug, :extra_fields )"; $st = $conn->prepare ( $sql ); $st->bindValue( ":createdDate", $this->createdDate, PDO::PARAM_INT ); $st->bindValue( ":title", $this->title, PDO::PARAM_STR ); $st->bindValue( ":content", $this->content, PDO::PARAM_STR ); $st->bindValue( ":nl2br", $this->nl2br, PDO::PARAM_INT ); $st->bindValue( ":slug", esc_slug($this->slug), PDO::PARAM_STR ); $st->bindValue(":extra_fields", $this->extra_fields, PDO::PARAM_STR); $st->execute(); $this->id = $conn->lastInsertId(); } public function update() { if ( is_null( $this->id ) ) trigger_error ( "Page::update(): Attempt to update an Page object that does not have its ID property set.", E_USER_ERROR ); $conn = open_connection(); $sql = "UPDATE pages SET title=:title, content=:content, nl2br=:nl2br, slug=:slug, fields=:fields, extra_fields=:extra_fields WHERE id = :id"; $st = $conn->prepare ( $sql ); $st->bindValue( ":title", $this->title, PDO::PARAM_STR ); $st->bindValue( ":content", $this->content, PDO::PARAM_STR ); $st->bindValue( ":nl2br", $this->nl2br, PDO::PARAM_INT ); $st->bindValue( ":slug", $this->slug, PDO::PARAM_STR ); $st->bindValue( ":fields", $this->fields, PDO::PARAM_STR ); $st->bindValue(":extra_fields", $this->extra_fields, PDO::PARAM_STR); $st->bindValue( ":id", $this->id, PDO::PARAM_INT ); $st->execute(); } public function delete() { if ( is_null( $this->id ) ) trigger_error ( "Page::delete(): Attempt to delete an Page object that does not have its ID property set.", E_USER_ERROR ); $conn = open_connection(); $st = $conn->prepare ( "DELETE FROM pages WHERE id = :id LIMIT 1" ); $st->bindValue( ":id", $this->id, PDO::PARAM_INT ); $st->execute(); } } ?>

| ver. 1.4 | Github | . | PHP 8.2.28 | Generation time: 0.02 | proxy | phpinfo | Settings