prefix . 'aimslms_course_orders'; $enrollments_table = $wpdb->prefix . 'aimslms_course_enrollments'; // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- $orders_table is derived from $wpdb->prefix, not user input. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Custom table, no WP API alternative. $order = $wpdb->get_row( $wpdb->prepare( "SELECT transaction_id FROM $orders_table WHERE user_id = %d AND order_status = %s ORDER BY created_at DESC LIMIT 1", $user_id, 'completed' ) ); // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared if ( ! $order || empty( $order->transaction_id ) ) { return false; } // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- $enrollments_table is derived from $wpdb->prefix, not user input. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Custom table, no WP API alternative. $enrollment_exists = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $enrollments_table WHERE user_id = %d AND transaction_id = %s", $user_id, $order->transaction_id ) ); // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared return ( $enrollment_exists > 0 ); } }