<?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'; }
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; while (true) { if ($total == $count) { exit; } if (isset($_POST['lable_' . $i])) { $column_id = $_POST['field_' . $i]; $element_id = $_POST['lable_' . $i]; $page->update_table_columns($conn, $column_id, $element_id); $count++; } $i++; } echo 'element link with table columns'; exit; } if (!$page->check_page_exist($conn, $PAGE_TITLE, $PROJECT_ID)) { echo 'Page created' . $page->create_page($conn, $PAGE_TITLE, $PROJECT_ID); } else { echo 'page exist'; }