Changeset 60101

Timestamp:

03/27/2025 12:34:47 PM (5 weeks 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 ) {