Portions created by the Initial Developer are Copyright (C) 2008-2012 the Initial Developer. All Rights Reserved. Contributor(s): Mark J Crane */ require_once "root.php"; require_once "resources/require.php"; require_once "resources/check_auth.php"; if (permission_exists('schema_edit')) { //access granted } else { echo "access denied"; exit; } require_once "resources/header.php"; require_once "resources/paging.php"; //get the http values $order_by = $_GET["order_by"]; $order = $_GET["order"]; //show the content echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

".$text['header-name_values']."
\n"; echo $text['description-name_values']." \n"; echo "

\n"; //$sql = "select * from v_schema_name_values "; //$sql .= "where domain_uuid = '$domain_uuid' "; //$sql .= "and schema_field_uuid = '$schema_field_uuid' "; //if (strlen($order_by)> 0) { $sql .= "order by $order_by $order "; } //$prep_statement = $db->prepare(check_sql($sql)); //$prep_statement->execute(); //$result = $prep_statement->fetchAll(PDO::FETCH_NAMED); //$num_rows = count($result); //unset ($prep_statement, $result, $sql); //$rows_per_page = 10; //$param = ""; //$page = $_GET['page']; //if (strlen($page) == 0) { $page = 0; $_GET['page'] = 0; } //list($paging_controls, $rows_per_page, $var_3) = paging($num_rows, $param, $rows_per_page); //$offset = $rows_per_page * $page; $sql = "select * from v_schema_name_values "; $sql .= "where domain_uuid = '$domain_uuid' "; $sql .= "and schema_field_uuid = '$schema_field_uuid' "; if (strlen($order_by)> 0) { $sql .= "order by $order_by $order "; } //$sql .= " limit $rows_per_page offset $offset "; $prep_statement = $db->prepare(check_sql($sql)); $prep_statement->execute(); $result = $prep_statement->fetchAll(PDO::FETCH_NAMED); $result_count = count($result); unset ($prep_statement, $sql); $c = 0; $row_style["0"] = "row_style0"; $row_style["1"] = "row_style1"; echo "\n"; echo "\n"; echo th_order_by('data_types_name', $text['label-name_value_name'], $order_by, $order); echo th_order_by('data_types_value', $text['label-name_value_value'], $order_by, $order); echo "\n"; echo "\n"; if ($result_count > 0) { foreach($result as $row) { echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo "\n"; $c = ($c==0) ? 1 : 0; } //end foreach unset($sql, $result, $row_count); } //end if results echo "\n"; echo "\n"; echo "\n"; echo "

\n"; echo " $v_link_label_add\n"; echo "
".$row[data_types_name]."	".$row[data_types_value]."	\n"; echo " $v_link_label_edit\n"; echo " $v_link_label_delete\n"; echo "
\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; //echo " \n"; echo " \n"; echo " \n"; echo "     $paging_controls \n"; echo " $v_link_label_add\n"; echo " \n"; echo "

"; echo "

"; echo ""; //show the footer require_once "resources/footer.php"; ?>