Changeset 60101 for trunk/src/wp-admin/network/site-settings.php

Timestamp:

03/27/2025 12:34:47 PM (18 months ago)

Author:

SergeyBiryukov

Message:

Coding Standards: Remove a one-time $sql variable in Edit Site form.

This allows the $wpdb::prepare() call to be picked up correctly by PHPCS.

Follow-up to [28712].

Props aristath, poena, afercia, SergeyBiryukov.
See #63168.

File:

• trunk/src/wp-admin/network/site-settings.php (modified) (1 diff)

trunk/src/wp-admin/network/site-settings.php

@@ -122 +122 @@
                 <?php
                 $blog_prefix = $wpdb->get_blog_prefix( $id );
-                $sql         = "SELECT * FROM {$blog_prefix}options
-                        WHERE option_name NOT LIKE %s
-                        AND option_name NOT LIKE %s";
-                $query       = $wpdb->prepare(
-                        $sql,
-                        $wpdb->esc_like( '_' ) . '%',
-                        '%' . $wpdb->esc_like( 'user_roles' )
+                $options     = $wpdb->get_results(
+                        $wpdb->prepare(
+                                'SELECT * FROM %i
+                                WHERE option_name NOT LIKE %s
+                                AND option_name NOT LIKE %s',
+                                "{$blog_prefix}options",
+                                $wpdb->esc_like( '_' ) . '%',
+                                '%' . $wpdb->esc_like( 'user_roles' )
+                        )
                 );
-                $options     = $wpdb->get_results( $query );
 
                 foreach ( $options as $option ) {