Wp do sql query from function

<?php
// 1st Method - Declaring $wpdb as global and using it to execute an SQL query statement that returns a PHP object
global $wpdb;
$results = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}options WHERE option_id = 1", OBJECT );

Source: developer.wordpress.org

Wp do sql query from function

<?php
// 2nd Method - Utilizing the $GLOBALS superglobal. Does not require global keyword ( but may not be best practice )
$results = $GLOBALS['wpdb']->get_results( "SELECT * FROM {$wpdb->prefix}options WHERE option_id = 1", OBJECT );

Source: developer.wordpress.org

Similar codes

0 vote299 views1 answer
Sqldf change user
SQL
0 vote335 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote383 views1 answer
Mssql last day of month
SQL
0 vote319 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
-1 vote325 views1 answer
Search all database tables for a value sqlserver
SQL
1 vote310 views1 answer
Oracle list constraints
SQL
0 vote316 views1 answer
Sqlite3 pragma foreign keys
SQL
1 vote262 views1 answer
How to run sql script
SQL
1 vote322 views2 answers
List tables sqlalchemy
SQL
2 votes328 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL