prefix . 'als_forms'; $submissions_table = $wpdb->prefix . 'als_form_submissions'; $total_forms = $wpdb->get_var("SELECT COUNT(*) FROM $forms_table"); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Table name is not user input, safe for admin context $total_submissions = $wpdb->get_var("SELECT COUNT(*) FROM $submissions_table"); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Table name is not user input, safe for admin context $top_forms = $wpdb->get_results(" SELECT f.id, f.name, COUNT(s.id) as submissions_count FROM $forms_table f LEFT JOIN $submissions_table s ON f.id = s.form_id GROUP BY f.id ORDER BY submissions_count DESC LIMIT 5 "); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Table name is not user input, safe for admin context $recent_submissions = $wpdb->get_results(" SELECT s.*, f.name as form_name FROM $submissions_table s LEFT JOIN $forms_table f ON s.form_id = f.id ORDER BY s.submitted_at DESC LIMIT 5 "); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Table name is not user input, safe for admin context ?>

is_paying() ) : ?>

⭐

Unlock all premium features with ALS Forms PRO!
Get advanced layouts, integrations, priority support, and more.
Upgrade to PRO

📝

📥

#
	name); ?>	submissions_count); ?>	`[als_form id="id); ?>"]`

#
	form_name); ?>	submitted_at); ?>	submission_data), true)); // phpcs:ignore WordPress.PHP.DevelopmentFunctions.error_log_print_r -- Only for admin/debug display, output is escaped ?>

is_paying() ) : ?>

🚀