prefix . "amader_rsvp"; $charset_collate = $wpdb->get_charset_collate(); $sql = "CREATE TABLE IF NOT EXISTS $table ( id INT AUTO_INCREMENT, first_name varchar(20), last_name varchar(20), rsvp_phone varchar(20), rsvp_email varchar(50), rsvp_attending varchar(15), rsvp_kids_menus varchar(15), rsvp_vegetarian_menus varchar(20), invite_code varchar(20), PRIMARY KEY (id) )$charset_collate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); } register_activation_hook(__FILE__,'amader_rsvp_plugin_activation'); /************************************/ /* Create admin page for rsvp */ /************************************/ function amader_rsvp_admin_page() { global $team_page; add_menu_page('Amader RSVP', 'Amader RSVP', 'edit_posts', 'amader-rsvp', 'rsvp_page_handler', 'dashicons-groups', 6); } add_action('admin_menu', 'amader_rsvp_admin_page'); /************************************/ /* Contents for rsvp admin page */ /************************************/ function rsvp_page_handler() { ?>
prefix . "amader_rsvp"; $rsvp_datas = $wpdb->get_results("SELECT * FROM $dbtable"); if ($rsvp_datas == true): ?>

#	Full Name	Phone Number	Email Address	# Persons	# Kids menus	# Veg. menus	Invitaton Code
	first_name)." ".esc_textarea($rsvp_data->last_name); ?>	rsvp_phone)?>	rsvp_email)?>	rsvp_attending)?>	rsvp_kids_menus)?>	rsvp_vegetarian_menus)?>	invite_code)?>
#	Full Name	Phone Number	Email Address	# Persons	# Kids menus	# Veg. menus	Invitaton Code

Sorry, no RSVP found in the database.
Please use [amader_rsvp] in any page to show RSVP form in your website.

'; endif; } include_once ('src/rsvp-main.php');