prefix . "wpsp_class"; $teacher_table = $wpdb->prefix . "wpsp_teacher"; $teacher_data = $wpdb->get_results("select wp_usr_id,CONCAT_WS(' ', first_name, middle_name, last_name ) AS full_name from $teacher_table order by tid"); $classname = $classnumber = $classcapacity = $classlocation = $classstartingdate = $classendingdate = $teacherid = ''; if (isset($_GET['id'])) { $classid = intval($_GET['id']); //$wpsp_classes = $wpdb->get_results("select * from $ctable where cid='" . esc_sql($classid) . "'"); $wpsp_classes = $wpdb->get_results($wpdb->prepare("SELECT * FROM $ctable WHERE cid = %d",$classid)); foreach ($wpsp_classes as $wpsp_editclass){ $classname = $wpsp_editclass->c_name; $classnumber = $wpsp_editclass->c_numb; $classcapacity = $wpsp_editclass->c_capacity; $classlocation = $wpsp_editclass->c_loc; $classstartingdate1 = $wpsp_editclass->c_sdate; $classstartingdate = date("m/d/Y", strtotime($classstartingdate1)); $classendingdate1 = $wpsp_editclass->c_edate; $classendingdate = date("m/d/Y", strtotime($classendingdate1)); $teacherid = $wpsp_editclass->teacher_id; if ($wpsp_editclass->c_fee_type != ''){ $c_fee_type = $wpsp_editclass->c_fee_type; } } } $formname = isset($_GET['id']) ? 'ClassEditForm' : 'ClassAddForm'; $buttonname = isset($_GET['id']) ? 'Update' : 'Submit'; $propayment = wpsp_check_pro_version('pay_WooCommerce'); $propayment = !$propayment['status'] ? 'notinstalled' : 'installed'; ?>