function courses_page() { global $wpdb; $table_name = $wpdb->prefix . "lms_instances"; echo '<div class="wrap">'; if (isset($_POST['action'])) { $course_id = (int) $_POST["course_id"]; $duration = get_post_meta($course_id, 'Duration', true); if (empty($duration)) { echo "<div class='error'><p><strong>" . __('Error:', 'warp_lms') . "</strong> " . __('There is no duration defined for that course', 'warp_lms') . "</p></div>"; } else { $wpdb->query($wpdb->prepare("INSERT INTO {$table_name} (start_date, end_date, course_id) VALUES ('%s','%s' + INTERVAL %d DAY, %d)", $_POST['start_date'], $_POST['start_date'], $duration - 1, $_POST['course_id'])); echo "<div class='updated'><p>" . __('Course added successfully', 'warp_lms') . "</p></div>"; } } list_courses(); echo "<h2>" . __('Add course', 'warp_lms') . "</h2>"; require 'add_course.php'; echo '</div>'; }
function render_body() { dom::h3('', 'Raw SQL'); dom::push_form('lists.php'); dom::textarea("sql"); dom::br(); dom::hidden('action', 'sql'); dom::submit(); dom::pop(); list_instructors(); list_sections(); list_books(); list_courses(); }
<?php print list_courses();