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

3 votes153 views1 answer
Oracle cannot access v$session
SQL
7 votes126 views1 answer
Forge server hosting
SQL
0 vote133 views1 answer
Oracle list of long running queries
SQL
0 vote130 views1 answer
Update having mysql
SQL
0 vote136 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote144 views1 answer
Datatables server side filter where clause
SQL
0 vote140 views1 answer
Normalization in database 2nd normal form
SQL
0 vote143 views1 answer
Copying query result to excel
SQL
0 vote197 views1 answer
Mysql readable output
SQL
0 vote145 views1 answer
Sqlalchemy one column of two has to be not null
SQL