<?php
include 'class_db.php';
class PAGES
{
public static function create_page($conn, $PAGE_TITLE, $PROJECT_ID)
{
$query = "INSERT INTO `cms`.`pages` (`PAGE_ID`, `PAGE_TITLE`, `PROJECT_ID`, `STATUS`) VALUES (NULL, '{$PAGE_TITLE}', '{$PROJECT_ID}', '1');";
$result = $conn->query($query);
//$conn->insert_id;
return $result;
}
public static function update_page($conn, $PAGE_TITLE, $PROJECT_ID, $PAGE_ID)
{
$query = "UPDATE `cms`.`pages` \n\t\t\t\t\t\tSET `PAGE_TITLE`\t=\t'{$PAGE_TITLE}',\n\t\t\t\t\t\t\t`PROJECT_ID`\t= \t'{$PROJECT_ID}',\n\t\t\t\t\t\t\t`STATUS`\t=\t'1'\n\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t`PAGE_ID` \t=\t{$PAGE_ID}";
$result = $conn->query($query);
return $result;
}
}
//endofclass
$con = new database();
$conn = $con->connection();
$page = new PAGES();
$PAGE_TITLE = 'title';
$PROJECT_ID = '1';
if ($page->create_page($conn, $PAGE_TITLE, $PROJECT_ID)) {
echo 'Page created';
}
return true;
} else {
return false;
}
}
public static function update_table_columns($conn, $COLUMN_ID, $ELEMENT_ID)
{
$query = "UPDATE `cms`.`table_columns` \n\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t`ELEMENT_ID`\t\t= \t{$ELEMENT_ID}\n\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t`COLUMN_ID` \t\t=\t{$COLUMN_ID}";
$result = $conn->query($query);
return $result;
}
}
//endofclass
$con = new database();
$conn = $con->connection();
$page = new PAGES();
$PAGE_TITLE = 'ADSF';
$PROJECT_ID = '1';
if ($_POST['next_dropdown'] == 'Goto') {
if ($_POST['pageId'] != NULL || $_POST['pageId'] != "") {
if ($_POST['goto_dropdown'] != 'Select one...') {
$page->update_page_goto($conn, $_POST['pageId'], $_POST['goto_dropdown']);
}
echo 'page togo set';
exit;
}
}
if ($_POST['next_dropdown'] == 'input') {
$total = $_POST['elementCount'];
$count = 0;
$i = 1;
