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

37 votes179 views3 answers
Duplicate records in sql
SQL
1 vote199 views1 answer
T-sql disable system versioning
SQL
0 vote182 views1 answer
List all indexes postgres
SQL
0 vote166 views1 answer
Sql server alter table column nullable
SQL
1 vote168 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote273 views1 answer
Sql alchemy escape ; in insert statement
SQL
4 votes185 views4 answers
Pl sql output
SQL
4 votes164 views3 answers
Mysql update with join
SQL
2 votes178 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote231 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL